NetSuite

[Westley Bennett]

Hello,

I'm trying to figure out a way to connect to a NetSuite account via PL/SQL Developer, and I can't seem to find the path forward. I searched this forum for the word "NetSuite" and came up with no results. I've searched google for "NetSuite" using "site:allroundautomations.com" and got no results.

Does the lack of results mean that it's not even POSSIBLE to access NetSuite via the PL/SQL Developer tool? NetSuite is owned by Oracle and uses an Oracle database, at least according to their SEC filing (SEC Filing Here):

So can anyone tell me if it's possible to access NetSuite through PL/SQL Developer in any way? I'm actually surprised that nobody yet has even talked about trying and failing or succeeding...

 

[Marco Kalter]

I'm not familiar with NetSuite, but if it uses an Oracle database then you can connect to that Oracle database if your Oracle client is configured accordingly.

 

[Westley Bennett]

That's promising. And how would I "configure my client correctly" to connect to a cloud-based database? Is there a guide somewhere?

 

[Marco Kalter]

You will need the following information for the NetSuite Oracle database:

* The server host name or ip address
* The name of the NetSuite Oracle database on this host
* The tcp port for the database (by default this is 1521)

With this information you can now use the Oracle Net Configuration Assistant utility on your PC to configure a service for this database.

 

[Westley Bennett]

Please let me know if I'm doing this correctly, or if I'm making a mistake, because I can't seem to get it to work:

But when I try with these settings, I get this:

I'm not sure what I'm doing wrong. Any assistance would be greatly appreciated.

 

[Westley Bennett]

I went ahead and accepted it to make it a DSN even though it failed to connect, and then I tried to configure it in PL SQL Developer anyways. Here's my settings there:

And here's the error I get when attempting the connection:

Not sure what's going wrong...

 

[Westley Bennett]

And here's the kicker. When I try to connect via NetSuite's native ODBC driver - it connects just fine, as you can see here:

This is the same DSN that I'm trying to use to connect to PL SQL Developer:

But it fails...

So I feel like I'm stuck right now, though I think I have everything in there right...

 

[Marco Kalter]

Is NetSuit64 really the name of an Oracle database on host odbcserver.netsuite.com? It seems like some other kind of service.

You will need a direct connection to an Oracle database.

 

[Ankit]

Accessing NetSuite via PL/SQL Developer can be challenging because NetSuite is a cloud-based ERP system and its database structure and connectivity might not be directly exposed or accessible through traditional tools like PL/SQL Developer. While NetSuite is indeed owned by Oracle, it operates as a separate cloud service, and the database architecture may not be directly comparable to traditional Oracle databases.

However, if you need to interact with NetSuite data programmatically, you should use NetSuite's SuiteTalk API, which is a web services-based API provided by NetSuite. This allows you to perform various operations like querying data, updating records, and more.

Here are the general steps you might take:

1. Understand SuiteTalk API:
Familiarize yourself with NetSuite's SuiteTalk API documentation to understand how to interact with NetSuite programmatically.

2. Use Appropriate Tools:
While PL/SQL Developer may not be the best tool for direct NetSuite access, you can use programming languages like Java, C#, or others to create applications that interact with the SuiteTalk API.

3. OAuth or Token-Based Authentication:
NetSuite typically uses OAuth or token-based authentication for API access. You will need to handle authentication securely in your application.

4. Develop Integration Logic:
Write code to interact with NetSuite API. Retrieve, update, or manipulate data based on your application's requirements.

5. Test Thoroughly:
Thoroughly test your integration logic with NetSuite's sandbox environment before attempting to access a production account.

While PL/SQL Developer might not be the tool of choice for direct NetSuite access, you can certainly build integrations and applications that interact with NetSuite using appropriate programming languages and tools. If you have specific questions about NetSuite integration or encounter issues, you may want to consult NetSuite's documentation or seek assistance from their support channels.

If you need more information on NetSuite Customer Login Center. NetSuit Login Click Here

 

[Gore]

And here's the kicker. When I try to connect via NetSuite's native ODBC driver - it connects just fine, as you can see here:

This is the same DSN that I'm trying to use to connect to PL SQL Developer:

But it fails...

So I feel like I'm stuck right now, though I think I have everything in there right...

The cause of this timeout message could be some firewall settings which forbids you to access some domains/ports in your network. Your request does not even reach the database server.

 

[Ankit]

Also Visit Ledger Labs provide NetSuite Services

 

[david Deuri]

Accessing NetSuite via PL/SQL Developer is not feasible because NetSuite is a cloud-based ERP with an abstracted database structure, unlike traditional Oracle databases. For programmatic interaction, the SuiteTalk API is the preferred method. It provides REST and SOAP endpoints for querying, updating, and managing data securely using OAuth or token-based authentication.

To proceed, familiarize yourself with the SuiteTalk API documentation, use a programming language like Java or Python for integration, and test thoroughly in a sandbox environment. While PL/SQL Developer isn't compatible, tools like the ODBC driver or ETL solutions can also help retrieve and process NetSuite data.
Let me know if you need further guidance with NetSuite development experts !