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

#dataengineering #etl #nocode

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.

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.