Getting started with databases
SQL actions: INSERT,UPDATE,DELETE,MERGE,IFEXIST
Change replication with databases
Automatically create a destination table
Automatically create staging tables from any data source
Expose a database object or SQL query as an API endpoint
Read records from a database and execute the flow for each record
Execute any SQL outside of regular source-to-destination transformation
Execute SQL from JavaScript
Tips and tricks when working with databases

Getting started with databases

December 23, 2018 18:08
Updated

Etlworks Integrator works equally well with all relational and NoSQL databases, as long as there is a JDBC driver for the database, and the database can be accessed from the server that Integrator is running on.

Connecting to databases
Connecting to the temporary (staging) database
Testing the database connection
Browsing database objects
Executing SQL queries
The source is a relational database
The destination is a relational database
Execute any SQL

Comments

0 comments

Please sign in to leave a comment.

Articles in this section

Related articles