Database
This page contains guide to keep database as a data target for the integration service.
Upon successfully configuring the Data Source and Data Operation, users proceed to the Data Target stage to specify the integration bridge's intended destination, defining the necessary details for seamless integration.
To configure database as a Data Target:
Step 1: Select Target Type
To begin, users need to select Database as their Target Type
Step 2: Select Storage Name
The user can select their preferred storage by choosing from the options listed under Select Storage Name.
Step 3: Version
Upon selecting the Storage Name, users will be presented with another dropdown menu to select the version.
Step 4: Host IP
The user needs to add the Host IP address associated with their database for establishing connection.
Step 5: Port Number
Enter the port number pertinent to the required database to establish a connection.
Step 6: Schema Name
Enter the schema name which contains the table where data is required to be inserted.
Step 7: Username
Enter the username linked to the database for authentication.
Step 8: Password
Input the associated password to access and authenticate the database.
Step 9: Order Set of Values (Tuple Key)
In tuple key, provide the key name that holds the tuple data.
Tuple key should be written inside square brackets enclosed within single quotes.
Example
['Tuple Key']
Step 10: Batch Size
The Batch Size within the target system defines the number of streaming records moved from the source, optimizing transfer efficiency for real-time processing. A recommended value of 1000 facilitates smoother data flow between systems.
Step 11: SQL Statement
Once the necessary information required above has been furnished, users can input their SQL query in the designated section, adhering to the provided instructions
SQL Statement to be passed with 3 double quotes:
"""Insert into table_name (column1,column2) values (?,?)""","column1","column2"