OBIEE Online Training

Tuesday, December 21, 2010

OBIEE - DSN Details

Here you will find those, OracleBI\xmlp\XMLP\Admin\DataSource\jdbcdefaults.xml
<?xml version = '1.0' encoding = 'UTF-8'?>
<jdbcDefaultValues>
<defaultvalue name="ORACLE"
description="Oracle 9i/10g/11g"
driver="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@[host]:[port]:[sid]" />
<defaultvalue name="ORACLE_OLD"
description="Oracle 8/8i"
driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@[host]:[port]:[sid]" />



<defaultvalue name="ORACLE_BI"
description="Oracle BI Server"
driver="oracle.bi.jdbc.AnaJdbcDriver"
url="jdbc:oraclebi://[host]:[port]" />
<defaultvalue name="SQLSERVER2000"
description="Microsoft SQL Server 2000"
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://[host]:[port];databasename=[dbname]" />

<defaultvalue name="SQLSERVER2005"
description="Microsoft SQL Server 2005"
driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://[host]:[port];DatabaseName=[dbname]" />
1433

<defaultvalue name="IBMDB2UDB"
description="IBM DB2 Universal Database"
driver="hyperion.jdbc.db2.DB2Driver"
url="jdbc:hyperion:db2://[host]:[port];DatabaseName=[dbname]" />

<defaultvalue name="SYBASE"
description="Sybase Adaptive Server Enterprise"
driver="com.sybase.jdbc3.jdbc.SybDriver"
url="jdbc:sybase:Tds:[host]:[port]" />
<defaultvalue name="NCRTERADATA"
description="Teradata"
driver="com.ncr.teradata.TeraDriver"
url="jdbc:teradata://[DatabaseServerName]" />
<defaultvalue name="MYSQL"
description="MySQL"
driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://[host]:[port]/[database]" />
Example:
Connection String : jdbc:mysql://localhost:3306/saac
DB Driver Class: org.gjt.mm.mysql.Driver and user =root and password=root
<defaultvalue name="OTHER"
description="Other"
driver="com."
url="jdbc:" />
</jdbcDefaultValues>

No comments:

Post a Comment