Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Business Intelligence Applications

SQL server configuration in obiee11g

Question

Views

Comments

4026497 Rank 1 - Community Starter

Jun 20, 2019 10:20AM in Oracle Business Intelligence Applications

I have created ODBC driver with SQL server native client 11.o and named it as DBDEV

and in ODBC.ini file gave below ,But services are not getting started. How can i configure sql server. Can anyone suggest

[DEVDB]

Driver=/OBIEE11gHOME/Oracle_BI1/bifoundation/server/bin/libnqsodbc64.so

Description=DEVDB

Address=IP,1433

AlternateServers=

AnsiNPW=Yes

ConnectionRetryCount=0

ConnectionRetryDelay=3

Database=DBDEV

LoadBalancing=0

LogonID=user

Password=user

QuoteID=No

ReportCodePageConversionErrors=0