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
- 🔗 Simple Data Integrator (SDI): Seamless Data Integration in Just 3 Steps
- 🌐 SDI Official Site (English)
- 🔗 Oracle Connection Guide
- 🔗 SQL Server Connection Guide
- 🔗 MySQL Connection Guide
- 🔗 PostgreSQL Connection Guide
Whether you're integrating legacy systems or building a cloud data pipeline, SDI makes it easy to configure database connections without writing code. Try it out today!
Top comments (0)