This discussion is archived
2 Replies Latest reply: Jan 3, 2013 12:48 PM by 979832 RSS

BIP reports

973616 Newbie
Currently Being Moderated
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 .

jdbc:hyperion:sqlserver://[hostname]:[port];DatabaseName=[Databasename]
I ahve given all the fileds port name as 1433.

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


thanks
Kiran

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

    from BIP->Administration>JDBC>Add Data Source
    jdbc:hyperion:sqlserver://<mydatabaseHostname>:1433;DatabaseName=Mydatabase

    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
    979832 Newbie
    Currently Being Moderated
    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

    jdbc:hyperion:sqlserver://<server_Name>:<port>;InstanceName=<instance_name>;DatabaseName=<database_name>

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points