You can use Treasure Data JDBC with Informatica Cloud through the Informatica’s Secure Agent. You can setup a ‘Data Synchronization’ task that pulls records from a Treasure Data table into a different target destination of your choice.
Create the Informatica Cloud Account
First, create an Informatica Cloud account here.
Set up Informatica Cloud Secure Agent
Second, set up the Secure Agent on your computer.
Refer to the following documentation.
Set up the Treasure Data JDBC Connection
Third, install and configure the Treasure Data’s JDBC driver in Informatica Cloud. Refer to:
Download JDBC Driver
Download Treasure Data’s JDBC Driver.
Set up JDBC Driver
Configuration -> Connectors, and click
New. Configure the fields as follows.
- Type: JDBC
- Username: Your account email
- Password: Your account password
- Connection URL: jdbc:td://api.treasuredata.com/< YOUR_DATABASE_NAME >;useSSL=true;type=presto
- Schema: “public”
- JdbcDriver: com.treasuredata.jdbc.TreasureDataDriver
- JdbcDriverFolder: /path/to/download/directory/
Add a Synchronization Task
Finally, create a data synchronization task using Treasure Data. Navigate to
Apps > Data Synchronization and create a new Task. Then, complete the
Task Name and
Operation fields and click
Establish a connection so that Informatica Cloud can extract data from Treasure Data. You are setting up Treasure Data as a ‘Source’ through our JDBC driver.
Select the connection established in the previous steps. Then Informatica Cloud shows a list of tables under your database as ‘Source’ objects.
After you select the table name, Informatica Cloud shows a
Data Preview, which shows a few records from the target table.
Next, setup a target for the data synchronization. You can choose any of the supported connections.
|Because the Treasure Data JDBC driver does not support INSERT statements, you cannot use INSERT statements to write data into Treasure Data. INSERT statements cannot be used as a 'Target' of a 'Data Synchronization' task/schedule. This functionality is not supported.|
In the ‘Data Filters’ phase, you can specify how many records you want to process.
Also, data can be filtered by specifying filter conditions through the Web UI.
Finally, specify the ‘Field Mapping’ between Treasure Data and the target.
If you want the selected Treasure Data table to synchronize periodically, specify a schedule in the ‘Schedule’ tab.