Linked Server connection to Netsuite

• JohnG69

  Hall of Fame

  Points: 3114

  More actions

  May 31, 2012 at 6:32 am

  #269655

  Hi all,

  I'm having an issue to create a linked server connection to netsuite on the cloud.

  They supplied me with an ODBC driver.

  With the ODBC, I was able to connect with Excel but I can't figure out how to to get the linked server working working...

  My Excel data connection resembles this:

  DSN=NetSuite.com;UID=mylogin;SDSN=NetSuite.com;HST=odbcserver.netsuite.com;PRT=1708

  Can anyone help?

  Thanks

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  September 25, 2012 at 8:14 am

  #1541890

  I can suggest an alternative for you to check. It is for SQL Server Integration Services. The latest version of COZYROC SSIS+[/url] library includes NetSuite adapters. You can both read and write from/to NetSuite service. The pricing starts at $399.95/Year. Programming skills are not required.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  September 25, 2012 at 8:24 am

  #1541897

  jghali (5/31/2012)

  ---

  Hi all,

  I'm having an issue to create a linked server connection to netsuite on the cloud.

  They supplied me with an ODBC driver.

  With the ODBC, I was able to connect with Excel but I can't figure out how to to get the linked server working working...

  My Excel data connection resembles this:

  DSN=NetSuite.com;UID=mylogin;SDSN=NetSuite.com;HST=odbcserver.netsuite.com;PRT=1708

  Can anyone help?

  Thanks

  Please dont cross post.

  Replies here please http://www.sqlservercentral.com/Forums/Topic1309881-1044-1.aspx