Skip to main content

NetSuite

NetSuite is a comprehensive cloud-based Enterprise Resource Planning (ERP) suite known for its unified business management capabilities and real-time visibility. Trusted by thousands of organizations worldwide, NetSuite offers integrated financial management, CRM, e-commerce, and operational reporting in a single platform. As Oracle's cloud ERP solution, NetSuite continues to innovate and provide new features to meet the complex demands of growing businesses.

Timbr + NetSuite Logo

Integrating NetSuite with Timbr allows you to leverage Timbr's semantic graph capabilities while maintaining NetSuite's comprehensive business management features. This integration enables advanced features like semantic querying, data virtualization, and integrated data management, providing powerful insights and efficiencies across your entire business operations.

Getting Started with NetSuite​

If you haven't yet set up a NetSuite account or connection, follow the steps provided in the links below to set up and connect to NetSuite:

To enable Timbr to connect to your NetSuite datasource, you need to configure the appropriate authentication credentials and access tokens. For detailed information on NetSuite API connections and authentication methods, refer to the NetSuite Developer Documentation.

Connecting Timbr to NetSuite in the Timbr Platform​

Once you've set up your NetSuite account and have the necessary authentication credentials, it's time to connect Timbr to NetSuite. Follow the steps below for a detailed tutorial on connecting Timbr to NetSuite:

  1. Navigate to Manage Datasources: From the Timbr interface, click on the Manage tab and select Datasources.

  2. Add New Datasource: On the top right, click the Add New Datasource button. Alternatively, you can click the big add button beneath the knowledge graphs and datasources tabs.

Add new datasource

  1. Fill in Connection Details: A pop-up window will appear where you need to provide the relevant connection details to connect NetSuite to Timbr.

There are two options in Timbr to enter the connection information: Simple or JDBC Url.

On the top right of the pop-up window , the toggle can be switched from Simple to JDBC Url in order to connect the datasource using the relevant JDBC URL.

tabs

Simple Tab Connection Configuration​

  1. Select Simple Tab: Ensure the Simple tab is selected.

  2. Fill in the Following Details:

    • Database Type: Select NetSuite.
    • Datasource Name: Enter a name for your datasource.
    • Description: Provide a description of the datasource (Optional).
    • Hostname / IP: The hostname or IP address of the NetSuite instance.
    • Port: Default port for the NetSuite cloud is 1708.
    • Username: Enter your NetSuite username.
    • Password: Enter your NetSuite password.
    • Additional Parameters: By default the most common additional parameters area already in place ServerDataSource=NetSuite2.com;encrypted=1;CustomProperties=(AccountID=[account_id];RoleID=[role_id])
      • encrypted=1 - Usuallty the connection is encrypted for security reasons.
      • CustomProperties=(AccountID=[account_id];RoleID=[role_id]) - Change the [account_id] with your NetSuite Account ID and [role_id] with the Role ID associated with the account.
      • Add any additional connection parameters using ; as separator.

JDBC URL Tab Configuration​

  1. Select JDBC URL Tab: Ensure the JDBC URL tab is selected.

  2. Fill in the Following Details:

    • Database Type: Select NetSuite.
    • Datasource Name: Enter a name for your datasource.
    • Description: Provide a description of the datasource (Optional).
    • Username: Enter your NetSuite username.
    • Password: Enter your NetSuite password.
    • JDBC URL: Enter the JDBC connection URL (e.g., jdbc:ns://<hostname>:1708;ServerDataSource=NetSuite2.com;encrypted=1;CustomProperties=(AccountID=<account_id>;RoleID=<role_id>)).

jdbc tab

Save and Test Connection​

  1. After entering the details, click the Save button to save the information, connecting the NetSuite datasource to the Timbr environment.
  2. Once saved, on the top right, click the Test connection button to verify the datasource's connectivity, ensuring it is active and responsive.

For a comprehensive guide on connecting Timbr to various datasources, refer to the detailed documentation: