ADO.NET table
This includes Db2Table, OracleTable, SqlServerTable, SnowflakeTable.
Overview
DB2 (Formerly Db2 for LUW) is a relational database that delivers advanced data management and analytics capabilities for transactional workloads. Oracle is a relational database management system developed by Oracle Corporation. MSSQL is a relational database provided by Microsoft. Snowflake a cloud-native data platform and Data Cloud that provides a single, unified service for data warehousing.
Destination tab
The following table outlines the mandatory and optional parameters you will find on the Destination tab (Image 1).
- Destination details
- Column Mapping
- Filter
The following parameters will help to define your data sync destination and how it functions.
| Parameter | Description | Example |
|---|---|---|
| Destination | Mandatory. Select your destination from the drop-down menu. | DB2 Table |
| Connection String | Mandatory. The encrypted Connection String used to connect to your DB2 database. The Connections UI will automatically encrypt this value for you. | You can find an example Connection String here. |
| Table | Mandatory. The name of the DB2 table that you want to sync your data to, including the schema. | dbo.employees |
| ID Column | Required for Delete Operations on AdoNet Targets. The name of the identity column that exists in the destination (or a single column that's guaranteed to be unique and automatically populated for every new record). | |
| ID Data Type | Required for Delete Operations on AdoNet Targets. The data type of the ID Column. Options for this field are (Text, Date, Number, Bool, Geography, Geometry, BigInt, Binary) | |
| Test Connection | You can use the "Test Connection" button to ensure that your credentials are properly configured to access your destination. If configured correctly, a "Connection Successful" pop-up will appear. If configured incorrectly, a "Connection Failed" pop-up will appear along with a link to the applicable error logs to help you troubleshoot. |
The Column Mapping section is where you define which source columns you want to sync to which destination columns. You can repeat the values for multiple columns.
| Parameter | Description | Example |
|---|---|---|
| Source Column | Mandatory. The name of your column as it appears in the source. | Name |
| Target Column | Mandatory. The name of your column as it appears in the destination. | Name |
You have the option to add a destination filter to your data sync. Please review the documentation here for more information on destination filters.
Next steps
- Define yourSync Actions.
- Add in your Post Sync Scripts, if required.
- Define your Permissions.
- If you are running a real-time sync, set up your Listener Config and enable it to begin your sync.
- If you are running a batch sync, click Jobs > Start a Job to begin your sync.