Abacus - New data source

Integration module Create new Abacus data source

Database

Type

Select the database type of your Abacus ERP system.

Server

Enter the name of the server here.

Port

If the port differs from the default port entered here (1583), you can change it accordingly.

Database

Enter the name of the database here.

Authentication

User / Password

The username and the password for the authentication can be entered here.

Additional settings

Time zone

Select your desired time zone here.

Test connection

You can test the defined connection here.

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 provided manually. If you use a Pervasive system, you can download the drivers from

http://pervasive.com/database/home/products/psqlv13.aspx.

Next, copy the files "pvjdbc2.jar" and "pvjdbc2x.jar" into the installtion directory /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://classic.abacus.ch/downloads/support/dokumentationen/tools_dokumente/odbc-treiber/pervasive-odbc-konfiguration-ab-v2006-de.pdf.

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