locked
Can i consume dimensional data from Sybase ? If yes how to do it ? RRS feed

  • Question

  • We are currently pulling data for MDS into SQL Server database from a Oracle database using OLEDB provider. Now there is one more source which is a dimensional database from Sybase. 
    Saturday, May 2, 2015 4:03 PM

Answers

  • Use SSIS

    http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc20155.1600/doc/html/adh1362398398324.html

    will help you..

    Need:-  Sybase ASE client 12.5.4 and custom installed the Sybase OLEDB driver. 

     you want to use ODBC connection for sybase source, 

    Here "Choose A Data Source" dialogue, select .NET Providers For ODBC, in the connection string place this one with your values.

    Driver={SYBASE ASE ODBC Driver};na=servername,serverport;uid=userid;pwd=password

    And, there are different connection string for sybase based on version I guess. check with
    www.connectionstrings.com, if there are any issues with connection string.

    Sunday, May 3, 2015 10:04 AM
    Answerer