on 08-05-2013 5:37 AM
Currently I am using SAP BusinessObjects Business Intelligence platform 4.0 SP4 on default database (DB2) on server AIXv 7.1.
There is a requirement to integrate with the another data source with database SQL
Can some one advise me how to integrate/create the connection to SQL database in this scenario
Hi,
you go via your Windows Client, open Information Designer Tool.
Create new connection to your SQL srv db.
Create a table foundation against the schema pointing to your connection.
Create a Business Layer ontop of the foundation.
Publish the content to the repository as a Universe.
Now you can report off it using your BI4 application.
Regards,
H
p.s. i've moved this thread to "semantic layer" forum. Please check out the Documents tab for 'how to' guides.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Henry
I have installed Information Design Tool in my local PC.
While testing the connection to MS SQL srv db I am getting below error
"OLE DB Provider CLSID not specified or erroneous"
SAP note:1204488 is recommending to install SQL native client.
Thanks for your help!
Hi,
Please publish your unsecured relational connection to repository,
Steps:
Right click on local (.cnx )connection --> Publish connection and create shortcut connection in your local project by accepting option
after creating secured connection, change the connection in data foundation from unsecured to secured connection(.cns) by going to connection tab in Data foundation.
save the Data foundation, now you can export the universe to repository.
Regards,
Ambreen
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.