'Oracle Client' cannot be selected as source in IDT

building semantic layer
1

In Information Design Tool I want to insert a new relational connection that connects to an Oracle Database.
The ‘New Relational Connection’-wizard guides me to the ‘Database Middleware Driver Selection’-screen where I can choose a database driver. All drivers can be selected except ‘Oracle 12 (Oracle Client)’ which is the one I need.

The driver is shown but cannot be selected. The wizard also shows the message “Invalid XML file format.” Also see attached screenshot.

Has anyone an idea why this happens?
I am using Information Design Tool 4.2, Build: 14.2.4.2410, Version: 4.2 Support Pack 4.
oracleclient_cannot_be_selected_v2.png

Tim Janssen (BOB member since 2004-09-10)

2

I have found the cause and solution for the issue I wrote about in my previous post. The XML-file ‘Oracle.sbo’ turned out to be incomplete.
Oracle.sbo can be found in the BO Enterprise installation folder at (…)\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\oracle\

For a reason unknown, after a Windows server reboot, it was missing following Library Platform tags between and :

<DataBase Active="Yes" Name="Oracle 12">
            <Libraries>
                <Library Platform="MSWindows">dbd_oci</Library>
                <Library Platform="Unix">dbd_oci12</Library>
                <Library Platform="Unix">dbd_oci11</Library>
            </Libraries>
            <Parameter Name="Extensions">oracle12,oracle</Parameter>
            <Parameter Name="SSO Available" Platform="MSWindows">True</Parameter>
            <Parameter Name="Driver Capabilities">Query,Procedures,Cancel</Parameter>
</DataBase>

After having added the -tags and restarted Server Intelligence Agent, the Oracle Client can be selected as source in IDT and is working OK.

Tim Janssen (BOB member since 2004-09-10)