[jyotin.lad]

Does anyone know how to connect and view the NetSuite data from within Microsoft SQL Server?

We’ve tried the following without success;

exec sp_addlinkedserver

@server=’NETCRM’,

@srvproduct=’NetSuite.com’,

@provider=’MSDASQL’,

@datasrc=’NetSuite.com’,

@provstr=’Database=NetSuite.com; Uid=xxx@xxx.com ;Pwd=xxx’

select * from NETCRM.dbo.Administrator.tasks

The ‘sp_addlinkedserver’ command executes successfully but we’ve noticed that you can enter invalid parameters and it will accept it. The connection string above was provided by NetSuite so it’s believed to be correct.

The ODBC connection has been successfully installed and tested. The data can be viewed via Excel, Perl and SQLDBX but just not through MS SQL Server.

We’ve tried this on various platforms (including MS Server 2003, MS Server 2008 R2 and Win7) with different versions of SQL Server (including 2005 and 2008) without success.
This is a cached copy. Click here to see the original post.

[savethepennies]

RE: Connecting/Viewing Netsuite Data from within Microsoft SQL Server

I am also trying to figure this out. Has anyone had luck with this? We keep finding limitations in our abilities to query the needed information through the ODBC and are hoping that we can still find a way to make it work.

[dnewnham]

RE: Connecting/Viewing Netsuite Data from within Microsoft SQL Server

Just a quick post to say I did manage to make a connection using MySQL import tools. I copied data from NS to SQL tables using the wizard. I can post my connection string later when I have a chance to dig it out if that might help?

[DBL]

Connection string would be good if you get time

Did you use the mySQL import tools to import into SQL Server (can you do that?) or mySQL? What versions were involved?

[dnewnham]

Hi, Yes I used the mySQL import tools. I used the .net Framework Data Provider for ODBC as the data source.

Connection string: Dsn=NetSuite.com;uid=odbc@transtank.com.au;passwor d=********;sdsn=NetSuite.com;hst=odbcserver.netsui te.com;prt=1708

You can then select the destination database from a combo box/drop down.

It’s then just a matter of selecting the role/table name if you wish to copy an entire table or you can also write a query to copy specific data.

THis worked perfectly for me the first time I copied a table. I tried to reproduce it today and got a bunch of data type mismatches so I’m not sure what has changed. No time to trouble shoot today I’m afraid.

mySQL 2008 by the way

[savethepennies]

I was able to get a linked server set up in SQL Server using the ODBC connection. Queries run but the performance suffers. Trying to run a query with a couple of joins is horrible. I’ve resorted to writing a utility that will take care of copying data locally to a sort of cache that can then be used by our reporting system and some in-house apps. That has brought query times back down to 8 minutes.

[julio.bonilla@eset.com]

Try creating the Linked Server Connection thru the GUI.

provider: Microsoft OLE DB Provider for ODBC Drivers

Product Name: Netsuite

Data Source: ODBCName

Provider String: dsn=netsuite.com

[Author]

Posts