How to connect Automation Engine to a PostgreSQL database using a JDBC connection?
Copy the .jar file to bg_data_custom_v010/dat/dbase (create dbase folder if it does not exist).
.jar file will be included in daily backup if available and in bg_data_Custom_v010 folder
In Driver File, select the network path where the jar file is located file://aeservernamehere/bg_data_custom_v010/dat/dbase/postgresql-42.1.3.jar
If there are spaces in the file path, replace them with %20
Specify the database username and a password if needed. URL: jdbc:postgresql://postgressqlserver/database?user=user&password=password
Accept the disclaimer: "I agree".
Click Test Connection to confirm connection is successful.
How to add an Access user to the database?
27 Jul 2017
Note: This is an anonymous survey. If you need help from Esko Support, register a Support Case here.