Integrating NetSuite Data in Talend Cloud Data Management Platform



Connect NetSuite Data with Talend Cloud Data Management Platform using the CData JDBC Driver for NetSuite.

Qlik's Talend Cloud Data Management Platform supports various data environments, enabling analytics for smarter decisions, operational data sharing, data and application modernization, and establishing data excellence for risk reduction. When paired with the CData JDBC Driver for NetSuite, you can improve data integration, quality, and governance for your NetSuite Data. This article shows how you can easily integrate to NetSuite using a CData JDBC Driver in Talend Cloud Data Management, and then view the data for simultaneous use in your workflow.

About NetSuite Data Integration

CData provides the easiest way to access and integrate live data from Oracle NetSuite. Customers use CData connectivity to:

  • Access all editions of NetSuite, including Standard, CRM, and OneWorld.
  • Connect with all versions of the SuiteTalk API (SOAP-based) and SuiteQL, which functions like SQL, enabling easier data querying and manipulation.
  • Access predefined and custom reports through support for Saved Searches.
  • Securely authenticate with Token-based and OAuth 2.0, ensuring compatibility and security for all use cases.
  • Use SQL stored procedures to perform functional actions like uploading or downloading files, attaching or detaching records or relationships, retrieving roles, getting extra table or column info, getting job results, and more.

Customers use CData solutions to access live NetSuite data from their preferred analytics tools, Power BI and Excel. They also use CData's solutions to integrate their NetSuite data into comprehensive databases and data warehouse using CData Sync directly or leveraging CData's compatibility with other applications like Azure Data Factory. CData also helps Oracle NetSuite customers easily write apps that can pull data from and push data to NetSuite, allowing organizations to integrate data from other sources with NetSuite.

For more information about our Oracle NetSuite solutions, read our blog: Drivers in Focus Part 2: Replicating and Consolidating ... NetSuite Accounting Data.


Getting Started


Prerequisites

Before connecting the CData JDBC Driver to view and work with your data in Talend Cloud Data Management Platform, make sure to download and install the latest version of Talend Studio on your system. Also, ensure that you have the required prerequisites.

  1. A Talend Cloud Data Management account with appropriate permissions.
  2. The CData JDBC Driver for NetSuite, which can be downloaded from the CData website.

Connect to NetSuite in Talend as a JDBC data source

Access Talend Data Management Cloud

  1. Run the Talend Cloud Data Management Platform installed on your local system and click on Other Login Mode.
  2. Click on Manage Connections. Set Repository to "Local" and enter the Name, Description and User E-mail in the respective spaces. Set the Workspace path and click on OK.
  3. Now, select the Create a new project radio button to add a new project name and click on Create.
  4. The new project should appear under the Select an existing project section. Click on Open. The Talend Cloud Data Management Platform workspace opens up.

Create a new connection

  1. In the navigation pane, locate and expand the Metadata dropdown. Right-click on Db Connections and select Create Connection.
  2. Search for and select 'JDBC' in the Find section of the Database Connection window. Then, click on Finish.
  3. Enter the Name, Purpose and Description of the new database in Talend where you need to load the NetSuite data. Click on Next.
  4. Generate a JDBC URL for connecting to NetSuite, beginning with jdbc:netsuite: followed by a series of semicolon-separated connection string properties.

    The User and Password properties, under the Authentication section, must be set to valid NetSuite user credentials. In addition, the AccountId must be set to the ID of a company account that can be used by the specified User. The RoleId can be optionally specified to log in the user with limited permissions.

    See the "Getting Started" chapter of the help documentation for more information on connecting to NetSuite.

    Built-in Connection String Designer

    For assistance in constructing the JDBC URL, use the connection string designer built into the NetSuite JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.

    java -jar cdata.jdbc.netsuite.jar

    Fill in the connection properties and copy the connection string to the clipboard.

    A typical JDBC URL is below:

    jdbc:netsuite:Account Id=XABC123456;Password=password;User=user;Role Id=3;Version=2013_1;
  5. Enter the JDBC URL copied from CData JDBC Driver for NetSuite in Edit new database.

  6. Click on the "(+) Add" button under Drivers. A 'newLine' will appear in the Drivers board. Click on (...) at the end of the new line, select the Install a new module radio button, and click on (...) to add the path to the JAR file, located in the 'lib' subfolder of the installation directory. Click on OK.
  7. Select the Driver Class as cdata.jdbc.netsuite (JAR file obtained from your installation directory given in the previous step).

Test the new connection

  1. Click on Check Connection. If the entered details are correct, a "Connection successful" confirmation prompt will appear. Click on "OK" and "Finish".
  2. Once the connection is established, right-click on the newly created connection and select Retrieve Schema. You can use the filters as well to retrieve the data as per your requirements. Click on Next.
  3. Expand the "CData" catalog in the Schema window and select the tables you want to import from the NetSuite schema. Click on Next.
  4. In the next step, select the columns you want to view from the table and click on Finish.
  5. All the selected tables from the NetSuite schema are now populated under the Table Schemas section of the JDBC connection.
  6. Right-click on any of the selected tables and click on Data Viewer to preview the data from the data source.

Get Started Today

Download a free, 30-day trial of the CData JDBC Driver for NetSuite and integrate NetSuite data into Talend Cloud Data Management Platform. Reach out to our Support Team if you have any questions.

Ready to get started?

Download a free trial of the NetSuite Driver to get started:

 Download Now

Learn more:

NetSuite Icon NetSuite JDBC Driver

Rapidly create and deploy powerful Java applications that integrate with NetSuite account data including Leads, Contacts, Opportunities, Accounts, and more!