Introduction to Database Integration
Dattos offers a series of possibilities for integrating the platform with external systems. One of the key integration features is the ability to read and write information directly from databases.
Create or Edit Database Connectors
To create or edit a database connector:
Access the "Configuration" menu
Click on "General Settings"
Click on the "Database Connectors" option
Click the "New" button to create or select an option from the list and click "Edit"
Database Connector Registration
On the "Database Connectors" screen, you need to fill in some fields to register the connector:
Name:
Informs the name used to identify the connector on screens such as "Import Layouts" and "Export Layouts", among others.
Type:
Informs the type of database for integration.
The supported types are:
SQL Server
Oracle
PostgreSQL
MySQL
SAP Hana
Server:
Informs the address (URL/IP) of the database server.
Data Base:
Informs the name of the database where the database information will be exchanged.
Port:
Informs the database server connection port.
User
Username that will be used to authenticate (authorize) access to the database.
Password
User password that will be used to authenticate (authorize) access to the database.
When you finish registering the fields, use the "Test Connection" button to check if the Dattos platform was able to connect to the database.
Operations for Reading or Writing Information in Databases
Once the database connector is registered, it is possible to perform operations such as:
Reading information through an Import Layout
Writing information through an Export Layout