Integration - ERP search
The search functionality is used to search for records from the database configured through registered SQL scripts. When clicking on the item in my ERP Search Integration, the following screen will open:
Configuration
Section titled “Configuration”Responsible for connecting to the database used.
1 - Menu Help
Opens a text file with example connection strings for each bank implemented in the Synchronizer.
2 - Checkbox Database
Select the database to be configured. Today we have the FIREBIRD, POSTGRES, MYSQL, SQL SERVER, SYBASE and ORACLE databases implemented in the Synchronizer.
3 - Field Connection string with connection string bank dadosExemplos:
EXAMPLE POSTGRES CONNECTION url=jdbc:p[ostgresql://localhost:5432/teste](ostgresql://localhost:5432/teste) user=demander password=teste EXAMPLE FOR ORACLE CONNECTION url=jdbc:oracle:thin:@111.111.222.222:1521:dsv user=demander password=test EXAMPLE FOR FIREBIRD CONNECTION url=jdbc:firebirdsql:localhost/3050:C:\Banks\Test user=demander password=test EXAMPLE FOR MYSQL CONNECTION url=jdbc:mysql://localhost/desenvolvimento user=demander password=test EXAMPLE FOR SQL SERVER CONNECTION url=jdbc:sqlserver://127.0.0.1:1433;databaseName=BASE; user=demander password=test EXAMPLE FOR SYBASE CONNECTION url=jdbc:sybase:Tds:localhost:5000/EXAMPLE user=demander password=test
4 - Field User
User registered in the database.
5 - Field Password
Password of the user registered in the database.
When testing the connection, the success message is displayed or the corresponding error is displayed.
With the correct connection, SQL scripts can be created. Below is an example of creating a CITY SQL script:
