DEV Community: Research Institute of Cloud Computing Technology

Seamless No-Code Integration: Connecting Salesforce with RDBMS using SDI

Research Institute of Cloud Computing Technology — Sat, 02 May 2026 15:51:52 +0000

Introduction

In today’s data-driven business landscape, keeping your CRM and backend databases in sync is crucial. However, building custom integration pipelines between Salesforce and relational databases (RDBMS) often involves complex coding, manual API handling (including managing API limits), and ongoing maintenance.

In this article, I’ll introduce SDI (Simple Data Integrator) — a tool that simplifies connecting Salesforce with relational databases such as Oracle, PostgreSQL, MySQL,and Autonomous AI Database(SDB) with zero to minimal coding.

Why Use SDI for Salesforce Integration?

SDI removes much of the heavy lifting involved in data synchronization. It is especially useful for teams that want to avoid building and maintaining custom integration code.

With SDI, you can easily achieve:

Bi-directional Synchronization
Sync data both ways — not only pushing data into Salesforce but also retrieving updates back into your databases.
Smart Incremental Updates (Delta Sync)
Instead of transferring entire datasets every time, SDI supports incremental updates. It identifies and processes only the changes (inserts/updates), significantly reducing API usage and processing time.
Wide Database Support
Seamlessly connect Salesforce with Oracle Database, ADW, PostgreSQL, MySQL, and more.
No-Code Data Mapping
Use a graphical interface to map Salesforce objects to database tables without writing complex SQL or Apex code.

Key Feature: Bi-directional RDBMS Connectivity

One of the strongest features of SDI is that it allows you to interact with Salesforce data in a way similar to relational databases.

This enables several powerful use cases:

Data Consolidation Aggregate Salesforce customer data into Oracle ADW for advanced analytics and reporting.
Operational Automation Automatically update PostgreSQL inventory or order data when an Opportunity is closed in Salesforce.
Hybrid Cloud Strategy Keep on-premise Oracle databases and cloud-based Salesforce instances continuously aligned.

Example Use Case

For example, a retail company can:

Sync customer and sales data from Salesforce into Oracle ADW for analytics.
Automatically update order or inventory data in PostgreSQL.
Reflect those updates back into Salesforce in near real-time using incremental sync.

This eliminates manual data handling and ensures consistency across systems.

How to Get Started (Quick Guide)

Based on the official documentation, setting up integration with SDI is straightforward and can typically be completed in just a few minutes.

1. Establish the Salesforce Connection

Create a connection profile in SDI using:

Client ID
Client Secret
Security Token

SDI handles the OAuth 2.0 authentication flow automatically, saving you from manual token management.

2. Map Your Data

Use SDI’s visual mapping interface to define how fields correspond. No coding required — everything is done through the GUI.

3. Advanced Settings and Logic

For more complex scenarios, SDI provides advanced mapping options:

Upsert operations using external IDs to prevent duplicate records.
Filtering data using SOQL conditions to sync only necessary information.
Automatic data type conversion between RDBMS and Salesforce fields.

Resources (Official Documentation)

To dive deeper into the technical details, please refer to the official documentation.

📂 Setup & Connectivity

Salesforce Connection Guide Detailed steps for establishing a secure connection between SDI and Salesforce.

🔄 Data Mapping & Integration

Source Settings (Salesforce) How to configure Salesforce as a data source, including object selection and retrieval modes.
Target Settings (Salesforce) Guidelines for using Salesforce as a data destination for updates from your RDBMS.

⚙️ Advanced Configuration

Advanced Mapping for Salesforce Master upsert operations, external IDs, and complex field logic.

Try it for Free: Developer Edition

If you want to test these features in your own environment, you can start with the Developer Edition. It allows you to explore the full potential of SDI’s integration capabilities at no cost.

Visit the official website to get started:
SDI Official Website

Conclusion

Integrating Salesforce with your core databases doesn’t have to be complex or time-consuming.

SDI (Simple Data Integrator) provides a robust and scalable solution for bi-directional data integration across Oracle, ADW, PostgreSQL, and other databases — all with minimal coding and efficient incremental updates.

Discussion

Have you struggled with Salesforce integrations or managing API consumption before? What tools have you used to handle incremental data sync?

Feel free to share your thoughts in the comments below!

Getting Started with Simple Data Integrator (SDI):Scheduler Settings

Research Institute of Cloud Computing Technology — Tue, 13 May 2025 10:18:29 +0000

Introduction

Simple Data Integrator (SDI) comes with a built-in scheduler feature.

With the scheduler, you can automatically execute mapping tasks at scheduled intervals.

You can configure the scheduler with various execution timings, such as:

At a specific time every hour
At a specific time daily
At a specific time on specified days of the week
At a specific time on specified days of the month
At fixed time intervals (repeated execution)

File Trigger Support

In addition to time-based scheduling, file triggers are also supported.

File trigger means the task will be executed automatically when a file change is detected in a specified folder, such as:

🔹 When a new file is created

🔹 When an existing file is updated

🔹 When a file is deleted

This allows you to automatically start a task when a file arrives, making it ideal for batch jobs and integration with external systems.

How to Configure the Scheduler

Scenario

Here’s a scheduler setup example:

Run Employee data integration every day at 1:00 AM.
If the task fails, retry once after 5 minutes.

1. Click "New Scheduler" to open the scheduler settings screen.

2. Set Basic Scheduler Information

No	Item	Description
1	Scheduler Name	Enter any unique name for easy management (no duplicate check enforced).
2	Frequency	Select `Daily`
3	Period and Start Time	Set period: from today to 2099/12/31 Start time: `1:00:00` (HH:mm:ss format) For more on frequency settings, see this official doc
4	Active/Disable	Select `Active`
5	Task Execution method	Select `Parallel`
6	Retry	Select `Yes` Retry Count: `1` Retry Interval: `5 minutes`
7	Add Mapping Task	Open the mapping list and select your desired mapping

3. Select Target Mapping

No	Item	Description
8	Filter	Use keyword filter if you have many mappings
9	Select	Check the mappings to include in the schedule
10	Add	Click `Add` to include them as tasks to run

4. Check the Schedule

Click the View Schedule button.

No	Item	Description
12	Target Date	Select the date to view
13	Scheduled Tasks	Review the list of mapping tasks scheduled for that date

5. Save

Click Save to register the scheduler settings.

Tip: Click Execute Scheduler if you want to test it manually before saving.

That’s it!

References

Getting Started with Simple Data Integrator (SDI): Data Mapping Example (Oracle to SQL Server)

Research Institute of Cloud Computing Technology — Tue, 13 May 2025 09:12:44 +0000

Introduction

When integrating data between different databases, it's essential to configure mapping settings to align fields between source and target systems.

This article explains how to configure such mappings using Simple Data Integrator (SDI), with an example of data transfer from Oracle to SQL Server.

🔍 What is Simple Data Integrator (SDI)?

Simple Data Integrator (SDI) is a lightweight ETL tool that moves and manages data between systems securely and efficiently — no coding required. It works in on-premises, cloud, and hybrid environments.

System Architecture

Source (Oracle)

Schema: SDITEST

Table: EMP

PK	Column Name	Type
	EMP_ID	NUMBER
	EMP_NAME	VARCHAR2
	DEPT_CODE	VARCHAR2
	BIRTHDAY	DATE

Target (SQL Server)

Schema: sales

Table: EMP

PK	Column Name	Type
	EMP_CODE	numeric
	EMP_NAME	nvarchar
	DEPT_CODE	varchar
	BIRTHDAY	datetime

Setup Steps

1. Configure Connections

Set up connection settings for both the source and target databases.

For detailed instructions, refer to:

🔗 https://dev.to/ricct/getting-started-with-simple-data-integrator-sdi-direct-connection-setup-1350

Source Connection

Target Connection

2. Mapping Configuration

Step 1: Open Mapping Creation Screen

Click the New Mapping button.

Step 2: Select Source / Target

No	Field	Description
1	Mapping Name	Enter a unique name. e.g. `EMP`
2	Source Connection	Select `HRMS_ORACLE`
3	Source Table	Select `SDITEST.EMP`
4	Target Connection	Select `SALES_SYSTEM__SQLSERVER`
5	Target Table	Select `sales.EMP`
6	Load Columns	Click to fetch table structure

Step 3: Configure Column Mapping

No	Field	Description
7	Source Column	Select corresponding columns. e.g.: EMP_ID → EMP_CODE EMP_NAME → EMP_NAME BIRTHDAY → BIRTHDAY
8	Include in Mapping	Specify whether to include the column (we'll exclude `DEPT_CODE`)
9	Update Method	Select `Merge` 🔗 Details

3. Test Run

Click Execute Mapping to test the setup.

💡 Pro Tip:

Before running the mapping, use the Preview Data button to inspect source and target content.

After execution, verify the target data to confirm the transfer occurred as expected.

No	Field	Description
10	Status	If successful, save the config. If not, check logs.
11	Details Icon	View execution log details.

4. Save the Mapping

Click Save to store your configuration.

💡 Tip:

To automate regular transfers, register this mapping into a scheduler.

🔗 Scheduler Guide

Simple Data Integrator (SDI): Seamless Data Integration in Just 3 Steps

Research Institute of Cloud Computing Technology — Tue, 13 May 2025 05:50:56 +0000

Introduction

Tired of writing scripts for data integration?

Simple Data Integrator (SDI) lets you build ETL jobs in 3 steps — no code, no fuss.

✅ GUI-based

✅ Lightweight

✅ On-prem & cloud ready

What is SDI?

SDI is a no-code ETL tool for developers and integrators.

It supports:

Databases: Oracle, SQL Server, MySQL, PostgreSQL, etc.
Files: CSV, Excel, JSON, XML
Cloud & Protocols: SFTP, FTP, Azure, AWS, OCI
Web Integration: REST APIs, Web Services

Use SDI Gateway for secure cloud access — no VPN required.

3 Steps to Data Integration

Step 1: Define a Connection

Create a source and target connection to your systems (DBs, files, FTP, etc.)
👉 Example: SDI connection setup with Oracle

Step 2: Create a Mapping

Design the data flow by mapping fields between source and target. It only takes a few clicks — no scripts required.
👉 Example: SDI mapping setup integrating data from Oracle to SQL Server

Step 3: Set the Scheduler

Define when and how often your integration job should run. You can run it on demand or schedule it at regular intervals.

👉 Example: SDI scheduler setrings

Try it for Free

SDI offers a Developer Edition free of charge.

You can build and test integration jobs without any commercial license.

👉 Download the Developer Edition

Summary

With SDI, system integration doesn’t have to be painful. You can achieve robust, repeatable, and script-free data workflows in just three steps.

Whether you’re a data engineer, system integrator, or a developer tired of writing glue code, SDI can help streamline your operations.

🔗Simple Data Integrator (SDI) – The Lightweight Yet Powerful ETL Tool for All Your Data Integration Needs
🔗 Learn more: https://sdi.ricct.com/

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

Research Institute of Cloud Computing Technology — Tue, 13 May 2025 01:43:33 +0000

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!

Simple Data Integrator (SDI) – The Lightweight Yet Powerful ETL Tool for All Your Data Integration Needs

Research Institute of Cloud Computing Technology — Mon, 12 May 2025 05:24:20 +0000

If you're dealing with multiple databases, hybrid cloud systems, or frequent file transfers between systems, Simple Data Integrator (SDI) might be your new favorite tool.

✅ No complex setup. No VPN required. No code. Just data — integrated.

🔍 What is Simple Data Integrator (SDI)?

Simple Data Integrator (SDI) is a lightweight ETL (Extract, Transform, Load) tool that simplifies how you move and manage data between systems. Whether you're running on-prem, cloud, or hybrid environments, SDI provides a secure, efficient, and user-friendly way to integrate data — without writing any code.

🌐 Official website

⚙️ Key Features at a Glance

✅ Data Integration

Extract from DB tables, views, and SQL queries.
Import data from CSV, Excel, JSON, XML into databases.
Export to various file formats.
Execute SQL and stored procedures.
Integrate with Web APIs and Web Services.

✅ File & Cloud Support

File system, FTP/FTPS, SFTP, AWS S3, OCI Object Storage, GCP Cloud Storage, Azure Blob Storage.
No VPN needed: secure connections via SDI Gateway Service.

✅ Scheduler & Workflow

Time-based (hourly/daily/weekly/monthly) and event-based triggers (file changes).
Parallel or serial execution.
Retry on failure.
Notifications.

✅ Monitoring

Database availability checks.
Detect data irregularities, inconsistencies, or loss.

🌟 Why Developers Love SDI

1. 🧠 Simple by Design

Just 3 steps to build and run an integration job.
Intuitive UI: perfect for both beginners and pros.

2. ⚡ High Performance

Parallel processing, in-memory operations, and compression for high-speed transfers.

3. 🔐 Secure and Flexible

Works across on-prem, cloud, hybrid, and multi-cloud.
Secure communication without VPN via SDI Gateway.

4. 🛡️ High Availability

Cold and hot standby supported for mission-critical environments.

📦 Real-world Use Cases

🔄 Internal system integration: Link data between HR, CRM, and financial systems.
🌍 Multi-site data centralization: Aggregate data from global branches.
☁️ On-prem to cloud migration: Seamlessly move data across clouds (AWS, OCI, Azure).
📁 Automated file import/export: Schedule and monitor data movement with zero hassle.
🧭 Remote monitoring: Keep an eye on remote DBs without exposing them directly.

💬 Final Thoughts

If you’re looking for a practical, secure, and high-performance ETL tool with minimal setup and maximum flexibility, Simple Data Integrator (SDI) delivers.

Whether you’re a data engineer, system integrator, or a developer tired of building ad-hoc scripts — Simple Data Integrator offers a free Developer Edition that lets you build, test, and demo integration jobs at no cost.

Try it out and experience the power of SDI for yourself.

👉 Learn more or request a demo at https://sdi.ricct.com

#ETL #DataIntegration #NoCode #Cloud #DevTools #SDI #DataEngineering #APIintegration #SQL #OpenSource

DEV Community: Research Institute of Cloud Computing Technology

Seamless No-Code Integration: Connecting Salesforce with RDBMS using SDI

Introduction

Why Use SDI for Salesforce Integration?

Key Feature: Bi-directional RDBMS Connectivity

Example Use Case

How to Get Started (Quick Guide)

1. Establish the Salesforce Connection

2. Map Your Data

3. Advanced Settings and Logic

Resources (Official Documentation)

📂 Setup & Connectivity

🔄 Data Mapping & Integration

⚙️ Advanced Configuration

Try it for Free: Developer Edition

Conclusion

Discussion

Getting Started with Simple Data Integrator (SDI):Scheduler Settings

Introduction

File Trigger Support

How to Configure the Scheduler

Scenario

1. Click "New Scheduler" to open the scheduler settings screen.

2. Set Basic Scheduler Information

3. Select Target Mapping

4. Check the Schedule

5. Save

References

Getting Started with Simple Data Integrator (SDI): Data Mapping Example (Oracle to SQL Server)

Introduction

🔍 What is Simple Data Integrator (SDI)?

System Architecture

Source (Oracle)

Target (SQL Server)

Setup Steps

1. Configure Connections

2. Mapping Configuration

Step 1: Open Mapping Creation Screen

Step 2: Select Source / Target

Step 3: Configure Column Mapping

3. Test Run

4. Save the Mapping

Related Links

Simple Data Integrator (SDI): Seamless Data Integration in Just 3 Steps

Introduction

What is SDI?

3 Steps to Data Integration

Step 1: Define a Connection

Step 2: Create a Mapping

Step 3: Set the Scheduler

Try it for Free

Summary

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

Direct Connection Setup in SDI

1. Open the Connection Settings

2. Fill in Connection Details

Other Supported Databases

Additional Resources

Simple Data Integrator (SDI) – The Lightweight Yet Powerful ETL Tool for All Your Data Integration Needs

🔍 What is Simple Data Integrator (SDI)?

⚙️ Key Features at a Glance

✅ Data Integration

✅ File & Cloud Support

✅ Scheduler & Workflow

✅ Monitoring

🌟 Why Developers Love SDI

1. 🧠 Simple by Design

2. ⚡ High Performance

3. 🔐 Secure and Flexible

4. 🛡️ High Availability

📦 Real-world Use Cases

💬 Final Thoughts