2 Replies Latest reply on Jan 3, 2013 8:48 PM by Iosif T

    BIP reports

      How to add the Sql server data source to BIP in the OBIEE11g .we are already installed the Sqlserver ODBC driver to the server .
      we are trying in this follwing way .

      I ahve given all the fileds port name as 1433.

      But still it is showing an error.
      Pleas help me how to achieve this .


      Edited by: 970613 on Jan 1, 2013 4:05 AM
        • 1. Re: BIP reports
          I'm able to connect with no issues for both 'Microsoft SQL Server 2005 and 2008'

          from BIP->Administration>JDBC>Add Data Source

          I dont think you need ODBC for this since this based on JDBC.

          Just in case make sure you have sqljdbc.jar file in \FMW\Oracle_BI1\jdbc\lib
          FYI: sqljdbc.jar is existing at DAC folder in my local but not in above location

          If helps pls mark
          • 2. Re: BIP reports
            Iosif T
            You can use any of the data source type offered by the app.
            JDBC or JNDI or FIle or OLAP
            There is no ODBC type (the BIP is a Java application and don't regularly use ODBC drivers, except if you use JDBC-ODBC bridge for some databases!)

            As for JDBC, it is the hyperion used for MSSQL server, with the most complete (with named instance and specific port) syntax as follows


            It works for 2005 and 2008 (and 2012 ? not tested yet)