Skip to Content
author's profile photo Former Member
Former Member

BI 4.1 SP 6 IDT connection to MS SQL 2014 SP2

Hello,

we use Business Objects 4.1 SP6.

How should I create the relational connection in IDT to connect to MS SQL 2014 SP2 server?

At the moment I use this type of connection.

Should I use generic ODBC datasource or Microsoft SQL Server 2014 ODBC Driver or Microsoft SQL Server 2014 OLE DB Driver.

Is it necessary to install SQL Server Native Client 12.0 or SQL Server Native Client 11.0?

Is it necessary to change the file sqlsrv.sbo?

In Semantic Layer Relationally Exposed DATA SOURCES document from SAP I can see that they support SQL Server Native Client 12.0.

But I can not find this for download.

Can anyone please tell me how to configure the connection in Multisource Universe in IDT to MS SQL 2014.

If possible with screenshots.

I tried with all combinations (ODBC, with native client and ole db) but our data federation server always stops with java exception.

I think BI 4.1 SP6 support connections to MS SQL 2014 SP2?

regards, Helmut

pastedImage_1.png (13.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Aug 23, 2016 at 09:49 AM

    Hi,

    JDBC and ODBC connections are supported to MS SQL 2014. Supported is the SQL Native Client 12.0. I alsways go for the ODBC connection.

    Please make sure that you created a 64 Bit connection on the server side and a 32 bit connectio on the client side where you run the IDT. Ideally both connections have the same name.

    Regards

    -Seb.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 23, 2016 at 09:53 AM

    Hi,

    JDBC and ODBC connections are supported to MS SQL 2014. Supported is the SQL Native Client 12.0. I alsways go for the ODBC connection.

    Please make sure that you created a 64 Bit connection on the server side and a 32 bit connectio on the client side where you run the IDT. Ideally both connections have the same name.

    Regards

    -Seb.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 23, 2016 at 02:36 PM

    Helmut,

    The PAM for BI 4.1 w/ SP06 also shows that you can use SQL Native Client 11 to connect to SQL 2014, see below

    Regards,

    Ajay


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.