### PostgreSQL Connection URLs for Linux and Windows

Source: https://docs.axway.com/bundle/MappingServices_36_UsersGuide_Datamapper_allOS_en_HTML5/page/Content/DML_UG/Preferences/connection_remote_database.htm

Specifies the JDBC URL patterns for connecting to PostgreSQL databases on both Linux and Windows operating systems. These URLs include parameters for SSL configuration and schema selection.

```sql
jdbc:postgresql://<Postgres_server ip>:5432/<database_name>?ssl=true&sslmode=verify-ca&sslrootcert=/<path_to_certificates>/server.crt&sslkey=/<path_to_certificates>/client.p12&sslpassword=<password>&currentSchema=<currentSchema_name>
```

```sql
jdbc:postgresql://<Postgres_server ip>:5432/<database_name>?ssl=true&sslmode=verify-ca&sslrootcert=C:\\<path_to_certificates>\\server.crt&sslkey=C:\\<path_to_certificates>\\client.p12&sslpassword=Axway123&currentSchema=<currentSchema_name>
```

--------------------------------

### Compound Conditions - Datamapper Validation Rule

Source: https://docs.axway.com/bundle/MappingServices_36_UsersGuide_Datamapper_allOS_en_HTML5/page/Content/DML_UG/Tasks/Bdocs/validation_rule_examples.htm

This Validation Rule combines multiple conditions using logical AND operators. All specified conditions across different nodes must be met for the Business Document to be accepted; otherwise, it is rejected.

```Datamapper
(!Port of Embarkation! = "Le Havre") and (!Port of Debarkation! = "Brest") and (!Dock Time! > 2)
```

--------------------------------

### MySQL Connector Driver and URL Template

Source: https://docs.axway.com/bundle/MappingServices_36_UsersGuide_Datamapper_allOS_en_HTML5/page/Content/DML_UG/Preferences/connection_remote_database.htm

Details the driver class and URL template required for connecting to MySQL databases when using a manually added custom driver named 'MySql'. This requires the mysql-connector-java-xxx.jar file to be available.

```java
com.mysql.cj.jdbc.Driver
```

```java
jdbc:mysql://<host>:<port>/<database>?useSSL=<trueOrFalse>
```

--------------------------------

### Check Node Value - Datamapper Validation Rule

Source: https://docs.axway.com/bundle/MappingServices_36_UsersGuide_Datamapper_allOS_en_HTML5/page/Content/DML_UG/Tasks/Bdocs/validation_rule_examples.htm

This Validation Rule checks if a specific node in a Business Document contains an exact string value. If the condition is not met, the document is rejected. Node names are enclosed in exclamation marks.

```Datamapper
!Port of Embarkation! = "Le Havre"
```