integration - ERP shipping

The sending functionality is used to send records to the database configured through registered SQL scripts. When clicking on the item in my ERP shipping integration, the following screen will open:

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:

You will need to have a file in the Search folder with the data that will be sent to the ERP database, the

The image below exemplifies a sending script, as well as an example of a file to send.