Post reply

Linked Server connection to Netsuite

  • 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

  • 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/

  • 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://qa.sqlservercentral.com/Forums/Topic1309881-1044-1.aspx

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply