Sunday, March 3, 2019

Connect to NetSuite ODBC using Oracle Database Link

Assuming you have already installed the NetSuite ODBC driver and the necessary Oracle Database Gateways, you can create a connection to your NetSuite account by issuing the following commands on the iSQL shell:

SQL> create public database link linkname connect to "" identified by "password" using 'dataSourceName';

This should return a response of:

Database link created.

After which, you can test connection by running a query against the database link like below:

SQL> select * from accounts@linkname;

1 comment: