SAP Knowledge Base Article - Preview

2444091 - How-to: Is it possible to create relational connection and then universe without database middleware installed or configured in local machine in Information Design Tool

Symptom

  • Error occurs when create local relational connection in Information Design Tool when database middleware is not installed or configured in local machine
    • Native Client:  DBDriver failed to load : <driver dll path> (The specified module could not be found.
      Example for Oracle: DBDriver failed to load : C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\drivers\lib32\dbd_ctlib16.dll (The specified module could not be found.
    • JDBC:  <JDBC Driver path>
      Example for MS SQL Server:  com.microsoft.sqlserver.jdbc.SQLServerDriver
    • ODBC:  [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
  • Besides installing database middleware in local machine, is it possible to create relational connection and then universe by leveraging server-side connectivity?
  • Is it possible to create relational connection and then universe without database middleware installed or configured in local machine?

Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform (BI) 4.x
  • Information Design Tool (IDT)

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2

Keywords

BI4, 4.x, 4.0, 4.1, 4.2, BO, IDT, conection, universe, IDT, driver, middleware, test, connectivity, repository, retrieve, local, server, shortcut, cnx, cns, secured, BiSL , KBA , BI-BIP-IDT , Information design tool , BI-BIP-SL , Semantic Layer , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.