Skip to Content
0
Jan 13, 2013 at 12:19 PM

Monitoring issue with MSSQL database

36 Views

I decided to move existing monitoring from java tables to real Audit DB and faces one issue - it does not work.

What I did:

1. Created tables in the Db. Loaded only dimension tables, no fact tables, because historical data are not of big importance for us at the moment.

2. Modified sqlsrv.sbo file which was available here: %Install Dir of SAP BO%\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\odbc

by adding the alias entry

<DataBase Active="Yes" Name="MS SQL Server 2012">

<Aliases>

<Alias>MS SQL Server</Alias>

</Aliases>

<Libraries>

<Library>dbd_wmssql</Library>

<Library>dbd_mssql</Library>

</Libraries>

<Parameter Name="Extensions">sqlsrv2012,sqlsrv,odbc</Parameter>

<Parameter Name="CharSet Table" Platform="Unix">datadirect</Parameter>

<Parameter Name="Driver Name">SQL (Server|Native Client)</Parameter>

<Parameter Name="SSO Available" Platform="MSWindows">True</Parameter>

</DataBase>

</DataBases>

3. In CMC->Application switched monitoring from Embedded database to Audit and nothing happens, no data are being inserted to fact tables, but auditing works as a charm.

What am I missing here?

SAP BI; 4.0 with Sp05

DB: MSSQL 2012

OS; Win2012