[neildog2004]

ok this is a realy large topic on so meny levels but im gona try to piont out wat im looking for. im trying to get any info i can about using ODBC with NS, the good and the bad. basicly im trying to push my company torwads buying it for these resons, (improved speed to the database, less limits to backups and imformation that can be backed up, mass uploads and downloads from excel could be easyer with excel connected to the ODBC driver, custom programs could be produced to automate passed prosseses that were repitisus and time consuming). anything else you could think of mensioning would be great. im mostly intrested in anythign anyone has to say about it and wat tools they use with it. benifits and features!!! thanks to all that contribute.
This is a cached copy. Click here to see the original post.

[shanondink]

RE: Everything Anyone ever wanted to know about ODBC and NS

Hi,

There is good, but I’ve been fighting issues and haven’t had a chance to really build anything useful just yet. I do have a cool VB.NET app that mirrors ODBC tables and puts the data into a MySQL database on my Linux server. But it is a work around until NS supplies a Linux driver and it will go away…. hopefully.It is pull only. i.e. You can’t modify NS data via ODBC. You can modify with XML Web Services and some folks pull from ODBC and modify with XML.
Only driver available is for Windows so us Linux/MAC guys are out of luck until enough of us request one that NS will pay Open Access Software for one.
There is no “last_modified_date” on the records . Currently if you want to mirror NS data and keep that mirror “up-to-date” you have to redump the table periodically. Issue 111391 is supposed to add these fields (I hope) and the issue says it is due in October.
Dates do not contain time info. Every record shows “mm/dd/yyyy 12:00:00 AM”.
Can’t get at “Tracking Numbers”.
Have you priced it yet?

[jtannone]

RE: Everything Anyone ever wanted to know about ODBC and NS

oracle driver works fine for jdbc, so do native oracle tools in general. It is just an oracle 10g connection after all, view/read only.

[shanondink]

RE: Everything Anyone ever wanted to know about ODBC and NS

Originally posted by jtannone

oracle driver works fine for jdbc, so do native oracle tools in general. It is just an oracle 10g connection after all, view/read only.

That is with the OLD driver and the ssl connection/forwarding right? I started building a server for this. Had all the oracle mess loaded and was going to start working on the rest, but then I read that the old driver was going away this year.

Is there something I don’t know?

I have Case # 473198 “Request Linux Driver for New ODBC Process” but it sat for ~1 month and when it was finally looked at, they didn’t seem to know what ERP was and said that I could use Firefox I guess I’ll wait another month for another reply.

Thanks,

Shanon

[mhuffman]

FYI, the enhancement req. for a Linux ODBC driver is #112864. Hasn’t received many requests yet though.

We will be phasing out the old Enterprise Reporting driver in the not too distant future. All users will be notified well in advance of the exact date to provide time to transition to the new ODBC driver. Any user who has purchased the old Enterprise Reporting module or the new ODBC module can turn on the new ODBC feature and download the new driver under the Home tab.

[clintm@cfh.ca]

RE: Everything Anyone ever wanted to know about ODBC and NS

I have been using ER for over a year with MS Access and Crystal Reports. I hear Putty will be no more!!!!! I haven’t played with it lately but it sure sounds like the upgrade is way better.

[jhalloran]

RE: Everything Anyone ever wanted to know about ODBC and NS

I have Putty set up on a few machines using the “old” ODBC connection, and everything has been working fine – one is an in-house CTI application, the other is a customized FedEx Cafe Station. Additionally, I use Crystal Reports to get the information I need from NetSuite because the built-in reporting tools are as sad as a number of NetSuite’s other “features.”

My question: in order to get the SSH connection working, do I need to have Professional Services load a new key for OpenSSL? Moreover, if I try to test the connectivity now, will it break the Putty-driven connection on everything else? As it stands now, on a test machine, the driver is giving me the error “HZ080:[OpenAccess][OpenRDA ODBC] RDA Error: Resource not available – Syntax error or access violation” when I try to authenticate. Am I missing something?

[shanondink]

RE: Everything Anyone ever wanted to know about ODBC and NS

Sorry, I can’t help with the error but…

I run the Old and New drivers on the same machine with no problem. Just make sure you load that the third party ssl program. It is a step up in simplicity when you don’t have to worry about putty.

On 2 of 3 machines I have it on, I did have a problem installing the actual new ODBC driver where it told me that it could not update 2 or 3 dll files. My scary and probably stupid solution was to rename the old dll files and run the installation again. I’ve been running like that now for about 3 months with no problems. I complained to somebody somewhere, but never heard back.

How do you like Crystal Reports? I hear a lot about it but I just can’t bring myself to start programing for .NET. I wrote one VB.net program which pulls the data over into a MySQL mirror so I can get at it with my Unix server. This program (or Netsuite) has a bug where it can only pull 10,000 records at a time and thats all I really want to do with Window$ programming. Can Crystal Reports work stand-alone pretty good? I guess I’ve got to just break down and try the demo sometime.

Have fun,

Shanon

[ivan.parra]

RE: Everything Anyone ever wanted to know about ODBC and NS

Shanon is right. The only possibly overlap between the old driver and new driver may be the SSL package. Some machines already have the necessary SSL package and will not require the openSSL installation. What you can do is first install the ODBC driver and see if you can connect. If it it fails to access NetSuite, then install the ssl package.

The new driver no longer needs a new key. You should be able to install OpenSSL + NetSuite Driver and connect.

The 10,000 row limit is an intentional limit NetSuite enforces on the OpenAccess driver. It is done so that queries that return millions of rows can render faster. For example, in Crystal, you only see a few hundred rows at one time. The remainder is buffered away in memory and the disk. If it takes 30 seconds for NetSuite to send 1 million rows to Crystal, every time the report runs, instead of waiting the full 30 seconds to send the 1 million rows, the report renders in 3 seconds because we send 10,000 rows and Crystal can render that data immediately. This functionality works for Crystal, Aquodatastudio, and most Microsoft products.

Shanon, if you feel this 10,000 row is a bug, please file a case and specify what software you are using and what query is being executed.

Thanks-

Ivan

[Author]

Posts