Home Services Partners Company
Talend JDBC Connectivity to Oracle Service Cloud

Talend JDBC Connectivity to Oracle Service Cloud

April 12, 2016 0 Comments

Get real-time connectivity to Oracle Service Cloud data in Talend’s Open Studio for Data Integration tool with Progress DataDirect Cloud.

You need to connect to your data, and at Progress DataDirect, we just want make that happen. It shouldn’t matter where that data is or what you want to do with it. No matter the problem you face, we have a solution. When it comes to Oracle Service Cloud, for example, we have solutions for connecting to Oracle Service Cloud through ODBC, JDBC, or OData standards. With so many options for connectivity, I’d like to walk you through just one example of utilizing DataDirect’s real-time access to Oracle Service Cloud.  

We recently had a connectivity rumble where we sat down and created as many tutorials as possible to provide valuable, up-to-date resources for any problems our customers could have. In this tutorial, I am taking you through a step-by-step guide of integrating your Oracle Service Cloud data with one of the most popular open source ETL applications: Talend’s Open Studio for Data Integration. Once this tutorial is complete, you can even apply these same steps to accessing your other cloud sources through DataDirect Cloud!

Step 1:  Create Connection to Oracle Service Cloud

Log in to DataDirect Cloud and ensure that you have the Oracle Service Cloud data source created. (Note that the Data Source Name field will be important to remember later.)

Create Connection to Oracle Service Cloud

Data Source Name: The name you want to identify the source with

User ID: Oracle Service Cloud User ID

Password: Oracle Service Cloud Password

Oracle Service Cloud Login URL: The host name of the Oracle Service Cloud site to which you want to connect

Interface: The name of the Oracle Service Cloud interface to which you want to connect

Step 2:  Download the DataDirect Cloud JDBC Driver

Go to the Downloads link (on the left of the DataDirect Cloud website) and click on the Windows JDBC Driver.

Download the DataDirect Cloud JDBC Driver

Once the download is complete, run the installer (as an administrator if possible) to walk through the DataDirect Cloud JDBC driver installation.

Run the installer

Step 3: Create Your Oracle Service Cloud DB Connection within Talend

Launch Talend’s Open Studio and from within your Talend project right click on Db Connections and select Create Connection.

Create Your Oracle Service Cloud DB Connection within Talend

Step 4: Name the Database Connection

Name the Database ConnectionIn this section you can name your Database connection and fill out the Purpose and Description fields.

Step 5: Complete the Database Connection

Complete the provided fields as follows:
DB Type: General JDBC
JDBC URL: jdbc:datadirect:ddcloud:database=Your_DataDirectCloud_DataSource_Name

Note: The “database” value is your Data Source Name from Step 1.

Driver jar: Select a jar file and navigate to the ddcloud.jar file located in the DataDirect Cloud JDBC driver’s lib folder (The default installation path is: C:\Program Files\Progress\DataDirect\Cloud_for_JDBC_20)

Class Name: com.ddtek.jdbc.ddcloud.DDCloudDriver

User Name: Your DataDirect Cloud User ID

Password: Your DataDirect Cloud Password

Complete the Database Connection

Select Module

You can now click on the Check button to test your connection. Once successful you can click Finish!

Check and Finish

Step  6:  Create Your Talend Work Flow

Now that we have successfully connected to Oracle Service Cloud, we can retrieve the schema of the tables within Oracle Service Cloud that we want to utilize in our Talend Work Flow.

Create Your Talend Work Flow

From the Schema menu, we can keep the TABLE, VIEW, and SYNONYM options selected and click next.

Schema Menue

We will then select what objects we want and enter a name for this Schema.

Select Objects and name

Then we can review the column definitions of our choices and select Finish.

Review Definitions

We can now use one of the tables from our new Schema as a source in our work flow!

Workflow finished

Now it’s your turn to give it a try! And don’t forget that these same steps apply to all of the other data sources available in DataDirect Cloud, such as Eloqua, Marketo, Google Analytics, and more!

Troubleshooting

If you run into a message that states, “The current database does not support transactions”, just add the TransactionMode=ignore to your JDBC URL in the Database Connect setup. When set to 1 (Ignore), the data source does not support transactions and the driver always operates in auto-commit mode. Calls to set the driver to manual commit mode and to commit transactions are ignored. Calls to rollback a transaction cause the driver to return an error indicating that no transaction is started. Metadata indicates that the driver supports transactions and the ReadUncommitted transaction isolation level.

Lastly, if you receive an error message that states “Poor performing query”, please refer to our Knowledge Base article that address this issue and how to mitigate it: http://knowledgebase.progress.com/articles/Article/Oracle-Service-Cloud-error-Poor-performing-query 

All finished

At Progress DataDirect we pride ourselves in our customer service. That's why we had this connectivity tutorial rumble, to better equip you to go out and make a difference in your company and your world. Connect your application with enterprise level JDBC connectivity and booth performance, satisfy customers, and stay secure. Pick up a free trial today absolutely free.

Idaliz Baez

Idaliz is a Sales Engineer with Progress. After receiving her undergraduate degree from Duke University in Civil and Environmental Engineering, Idaliz Baez spent a year at NASA Goddard Space Flight Center gaining on-the-job experience before returning to Duke in pursuit of her Masters of Engineering Management degree. 

Read next How Hybrid Data Pipeline Transforms How Clouds Access Data
Comments
Comments are disabled in preview mode.