Abacus - new data source

In the first list, select the database type of your Abacus ERP system. Underneath, enter the name of the server. If the port differs from the default port entered here (1583), you can change it accordingly. Enter the name of the database as well.

For the Authentication, the user name and the password can be entered here.

In Additional settings, the time zone can be changed according to the time zone of the database.

Once all connection parameters have been entered, the data source can be tested via the link, which is now active, to Test connection. To complete the configuration, click on OK.

If the connection to Abacus cannot be established, please check whether the connection parameters entered are correct.

Please note that drivers for Pervasive and DB2 databases are not included in the delivery package and must be manually prepared.

If you use a Pervasive system, you can download the drivers from

http://docs.intrexx.com/intrexx/version/7000/api/db/psqlv11.redirect.

Next, copy the files pvjdbc2.jar and pvjdbc2x.jar into the directory <intrexx>\lib.

On the Abacus server, the Abacus database must be enabled for JDBC access in the Pervasive Control Center. You can find the exact instructions for this here (in german only):

http://docs.intrexx.com/intrexx/version/7000/api/abacus/odbc-driver.redirect.

In Intrexx, when configuring the connection parameters, the name that is entered as the database name is that which has been defined in the Pervasive Control Center as the name.