Oracle DB is a database management system designed to efficiently manage structured data, supporting both on-premise and cloud environments. The OracleDB/Grow integration facilitates data-driven insights, ERP functionality, and data transformation, enabling a better workflow management.
In this article, we will cover:
Connecting to Oracle DB
Here are the steps to connect your Oracle account to Grow
- From the Dashboard, select Data > Connections.
- Select the blue + Connect button.
- From the list of Connections, search and select Oracle.
- Click Connect to Oracle.
- In the pop-up window, add a Connection Nickname.
- Enter your Username and Password.
- Add your Host and Port.
- Host is the server you connect to in order to access the database. This is where the database is stored.
- Port is the connection to your database. It is pre-filled with 1521.
- Enter the Service Name (database name).
-
Select the Use ODBC option if your environment requires ODBC for database connectivity.
This option allows Grow to connect to your Oracle database using an OBDC driver.Before enabling this option, ensure the driver is properly installed and configured on your server.
- Click Connect to complete the process.
Understanding Data Warehouse
You can store the relevant data from your Oracle DB account in Grow using the Data Warehouse feature. Refer to Data Warehouse to know how.
The Data Warehouse feature comes with in-built table options for easier understanding of your data. The list of available tables depend on your data source.
Using Warehouse Tables
For Oracle DB, the tables available depend on the tables in the connected database. This means that you may see different tables available for different Oracle DB accounts.
However, there can only be the following types of table for Oracle DB:
- Other Tables
- Custom Tables
Understanding Sync Intervals
Grow provides you with two different sync options for your data.
Full Sync
Full sync intervals is 12 hours for Custom Tables and Other Tables.
Incremental Sync
Incremental sync is not supported for Custom Tables and Other Tables.
To learn more about sync intervals and how to adjust the default settings, please visit the Sync section of the Data Warehouse help article.
FAQs + Tips and Tricks
Why am I getting the error NJS - 518?
The error pops up due to any of the following reasons:
- Incorrect Service Name: The service name JDEDB might not match the one registered in the Oracle database. Check the correct service name in the tnsnames.ora file or database configuration.
- Listener Misconfiguration: The Oracle listener might not be properly configured for the mentioned service. Verify the listener.ora file on the Oracle server to ensure that the JDEDB service is correctly registered.
- Service Not Started: The service might not be running or registered with the listener. Use the lsnrctl status command on the Oracle server to confirm that the service is active.
- Network or Firewall Issues: Ensure that port 1521 is open and accessible from the server where your application is running. A firewall or network settings might be blocking access.
How to handle error NJS-138?
You get this error when trying to connect to unsupported database server version in Thin mode. In such cases, it is recommended to use the Oracle DB ODBC connector.
Why to use a read-only user to connect to Grow?
It is recommended to use a read-only user as Grow cannot add or affect data in your database. This also helps increase your database security.