Business Object local ODBC connections and server ODBC connections
Applies to: SAP BusinessObjects
Author: Sergiu Iatco
Created on: 27 August 2013
The article explains mainly what to expect when creating a local project which uses local ODBC connection and what is required to make a published to Repository universe to extract data.
Assume local PC operating system is:
/wp-content/uploads/2013/08/image002_268561.jpg
/wp-content/uploads/2013/08/image004_268640.jpg
/wp-content/uploads/2013/08/image006_268641.jpg
Create ODBC connections:
Find location
C:\Windows\SysWOW64\odbcad32.exe
Find location
C:\Windows\system32\odbcad32.exe
Create shortcut
/wp-content/uploads/2013/08/image008_268646.jpg
Create shortcut
/wp-content/uploads/2013/08/image010_268648.jpg
/wp-content/uploads/2013/08/image012_268655.jpg /wp-content/uploads/2013/08/image014_268656.jpg
Run shortcut odbc WOW64
Create ODBC connection
/wp-content/uploads/2013/08/image016_268664.jpg
Run shortcut odbc system32
Create ODBC connection
/wp-content/uploads/2013/08/image016_268664.jpg
Run shortcut odbc WOW64
Create ODBC connection
/wp-content/uploads/2013/08/image020_268675.jpg
You notice that _u32 is available. Thus ODBCs in User DSN are common.
Run shortcut odbc system32
Create ODBC connection
/wp-content/uploads/2013/08/image022_268674.jpg
You notice that _u64 is available. Thus ODBCs in User DSN are common.
Run shortcut odbc WOW64
Create ODBC connection
/wp-content/uploads/2013/08/image024_268671.jpg
Run shortcut odbc system32
Create ODBC connection
/wp-content/uploads/2013/08/image026_268672.jpg
Simulate creation of Relational Connection with Generic ODBC Drivers
/wp-content/uploads/2013/08/image028_268676.jpg
You may notice available ODBC connections in Data Source Name

/wp-content/uploads/2013/08/image030_268677.jpg /wp-content/uploads/2013/08/image032_268678.jpg
s32 is missing /wp-content/uploads/2013/08/image034_268679.jpg

In Information Design Tool when you create a Relational Connection directly in Repository you will notice that ODBC _s32 is missing, but all other ODBC connections: _s64, _u64, _u32 can be used on local PC and they will extract data. Using Relational connection you can build the other components Data Foundation and Business layer. As long as you run reports on your on local PC you may use any of those available ODBC connections. However if you intend to publish a project to Repository to make it available over network then you have to consider one very important thing, you have to use only ODBC _s64. When you publish the project to repository ODBC connection is not published, you have to define ODBC _s64 on sever exactly as on local PC with “odbc WOW64”. Use a Remote Desktop Connection to connect to server.
If in Web Intelligence Application in query panel you get error WIS10901 then you have to define on server ODBC connection _s64 with “odbc system32”.
/wp-content/uploads/2013/08/image036_268680.jpg
Assume server operating system is:
/wp-content/uploads/2013/08/image038_268681.jpg
/wp-content/uploads/2013/08/image040_268682.jpg
/wp-content/uploads/2013/08/image042_268683.jpg
Since server operating system is Windows Server the ODBC have to work in same manner on server.
Install on server Information Design Tool client in order to confirm this.
You have to connect remotely to server and create all ODBC connections and then in IDT you have to create Relational Connections, Data Foundation and Business layer to extract data.
At first glance, working remotely on server as on local PC does not make to much sense.
What make sense? Probably makes sense followings:
  1. To use a connection from server with data located on server
  2. To test a connection created locally and published to Repository
Mainly the scope of local project is to finally publish it to repository and make it available over network. As where specified above to achieve this you have to define an ODBC _s64 on local PC and then using a Remote Desktop Connection to define exactly ODBC _s64 on server.
The second very important thing to consider is that WIA uses server ODBC and WIRC uses local ODBC.
Web Intelligence Rich Client (WIRC) running as an application
/wp-content/uploads/2013/08/image044_268684.jpg
Web Intelligence Application (WIA) running in Internet Explorer
/wp-content/uploads/2013/08/image046_268688.jpg
In order to confirm this create an ODBC _se64 (see below).
On server (Windows Server, 64 bit)
On local PC (Windows 7, 64 bit)
/wp-content/uploads/2013/08/image048_268689.jpg
/wp-content/uploads/2013/08/image050_268690.jpg
/wp-content/uploads/2013/08/image052_268694.jpg
/wp-content/uploads/2013/08/image054_268695.jpg
/wp-content/uploads/2013/08/image056_268696.jpg /wp-content/uploads/2013/08/image058_268697.jpg
Create Repository Relational Connection, Data Foundation and Business Layer:
/wp-content/uploads/2013/08/image060_268698.jpg
Publish Business Layer to Repository:
Create report bob in WIA
and
Run WIA from local PC
Run WIRC from local PC with same report bob created in WIA
/wp-content/uploads/2013/08/image064_268699.jpg /wp-content/uploads/2013/08/image066_268700.jpg
/wp-content/uploads/2013/08/image068_268701.jpg /wp-content/uploads/2013/08/image070_268702.jpg
Data from report confirms that WIA uses server ODBC and WIRC uses local ODBC.
In above case C:\ location has been used to point out which ODBC is used when running WIRC (local ODBC) or WIA (server ODBC). Of course, it is obvious that instead of C:\ location on local PC and C:\ location on server you may use also unique network location, for instance \\serv\data\bob.xls. Note that file bob.xls is locked for modification for some time (15 min) even after the report has been closed. However if you use *.mdb file instead of *.xls you may modify it any time.
Returning to the idea of IDT client on server, one may conclude that working directly on server you have to configure the ODBC only on server and after publishing the universe, reports can be created with WIA on server or local (local PC). Working with local WIRC requires local ODBC configuration, which may be accessed (tested) with local IDT.
If the source is Microsoft SQL Server you may use OLE DP Providers instead of ODBC driver, thus avoiding all consequences of local and server requirements. Creating Relational Connection with Microsoft OLE DB Providers could require additional installation.
/wp-content/uploads/2013/08/2013_08_27_134751_268718.jpg
  
SQLEXPR_x86_ENU.exe 110.4 MB or SQLEXPR_x64_ENU.exe 122.4 MB
One may found documentation with tough explanations of how BOB, ODBC, applications and operating systems interact. However, the idea of article is to answer with print screens of how mainly ODBC works when defining local connection and then publishing that to server to access reports over the network.
Related content
To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Comments are closed.