none
Connect SQL SERVER 2008 to UNIDATA

    Question

  • Hello everybody
    I need your help please, Somebody know how connect SQL SERVER TO UNIDATA, I mean I need create one connection to Unidata and then download data to SQL SERVER 2008, I have a ODBC DRIVER UNIDATA IBM cretaed. Please Help ME 
    Wednesday, August 28, 2013 7:23 PM

Answers

  • Hi,

    The simplest one is using SQL Server import-export wizard: http://technet.microsoft.com/en-us/library/ms141209.aspx

    For more advanced configuration, you can use SSIS. Here is link for SSIS example, this one for Oracle to SQL Server but the basic steps are the same.

    http://www.microsoft.com/rus/download.aspx?file=/SQL2008/white_papers/OracleSSIS.docx


    Regards,
    Christian HL
    Microsoft Online Community Support


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    • Marked as answer by Erick Angeles Monday, September 02, 2013 1:41 PM
    Monday, September 02, 2013 8:47 AM
  • Hi Erick,

    I have been searching for a driver to help me import the data in a Unidata DB (e.g. Excalibur) into my MS SQL Server 2012 but I am unable to locate one. I might missing something very obvious. Would you be able to point me to any such ODBC driver that would do my job. I am working relatively smaller DBs and am looking for any cheap solution.

    Thank you very much with anticipations.

    • Marked as answer by Erick Angeles Wednesday, November 20, 2013 3:47 PM
    Saturday, November 09, 2013 12:28 AM

All replies

  • Hi Erick,
     
    Thank you for your question. 
     
    I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 
     
    Thank you for your understanding and support.


    Allen Li
    TechNet Community Support

    Monday, September 02, 2013 8:30 AM
    Moderator
  • Hi,

    The simplest one is using SQL Server import-export wizard: http://technet.microsoft.com/en-us/library/ms141209.aspx

    For more advanced configuration, you can use SSIS. Here is link for SSIS example, this one for Oracle to SQL Server but the basic steps are the same.

    http://www.microsoft.com/rus/download.aspx?file=/SQL2008/white_papers/OracleSSIS.docx


    Regards,
    Christian HL
    Microsoft Online Community Support


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    • Marked as answer by Erick Angeles Monday, September 02, 2013 1:41 PM
    Monday, September 02, 2013 8:47 AM

  • Hey thaks for your help and so, which data source I choose for IBM UNIDATA ODBC Driver?
    Monday, September 02, 2013 1:40 PM
  • Hi Erick,

    I have been searching for a driver to help me import the data in a Unidata DB (e.g. Excalibur) into my MS SQL Server 2012 but I am unable to locate one. I might missing something very obvious. Would you be able to point me to any such ODBC driver that would do my job. I am working relatively smaller DBs and am looking for any cheap solution.

    Thank you very much with anticipations.

    • Marked as answer by Erick Angeles Wednesday, November 20, 2013 3:47 PM
    Saturday, November 09, 2013 12:28 AM
  • Hi Renascence

    Well, if you need import from UNIDATA to SQL it's very easy just you need to create a linked server of SQL Server it's the way easily, I don't know if you want this. If is this please tell me and I could help you. 

    Oh I forget it: you need Unidata ODBC Driver 

    Wednesday, November 20, 2013 3:53 PM