Getting Started with Simple Data Integrator (SDI): Direct Connection Setup

Simple Data Integrator (SDI) is a no-code ETL tool that helps connect and transfer data between databases and systems. This article explains how to set up a Direct Connection, using Oracle as an example. Direct Connection Setup in SDI This article walks you through how to configure a direct database connection in Simple Data Integrator (SDI), using Oracle as an example. 1. Open the Connection Settings Click the New Connection button to open the configuration dialog. 2. Fill in Connection Details No Field Description 1 Connection Name Enter any name for the connection. While SDI does not check for name duplication, it's recommended to use unique names for easier management. 2 Location Select Direct Connection. 3 Data Type Choose Oracle. 4 Connection Info Enter the Oracle connection details.More details: Oracle Connection Setup 5 Default Schema If specified, only tables and views under that schema will be listed in mapping settings. If left blank, all accessible schemas will be shown. 6 Test Connection Click the Test Connection button to verify the Oracle connection.On success, you'll see a message like below: Once the test passes, click Save to store the connection. Other Supported Databases You can set up connections to SQL Server, MySQL, PostgreSQL, DB2, and any ODBC-compliant databases using a similar procedure. Additional Resources

May 13, 2025 - 03:06
 0
Getting Started with Simple Data Integrator (SDI): Direct Connection Setup

Simple Data Integrator (SDI) is a no-code ETL tool that helps connect and transfer data between databases and systems.
This article explains how to set up a Direct Connection, using Oracle as an example.

Direct Connection Setup in SDI

This article walks you through how to configure a direct database connection in Simple Data Integrator (SDI), using Oracle as an example.

Connection Overview

1. Open the Connection Settings

Click the New Connection button to open the configuration dialog.
New Connection

2. Fill in Connection Details

Connection Details

No Field Description
1 Connection Name Enter any name for the connection. While SDI does not check for name duplication, it's recommended to use unique names for easier management.
2 Location Select Direct Connection.
3 Data Type Choose Oracle.
4 Connection Info Enter the Oracle connection details.
More details: Oracle Connection Setup
5 Default Schema If specified, only tables and views under that schema will be listed in mapping settings. If left blank, all accessible schemas will be shown.
6 Test Connection Click the Test Connection button to verify the Oracle connection.
On success, you'll see a message like below:
Success

Once the test passes, click Save to store the connection.

Other Supported Databases

You can set up connections to SQL Server, MySQL, PostgreSQL, DB2, and any ODBC-compliant databases using a similar procedure.

Additional Resources