Hi,
I've been tasked with creating a Business Objects universe against a CISCO IPCC SQL Server database (db_cra), and I have no knowledge of the database and how the system works. I also don't have access to the database outside of Crystal Reports. I can connect through CR with the instructions provided by CISCO and using an OLE DB (ADO) connection, and there's also a launchHRC executable that was added to the crw32.exe shortcut. The OLE DB (ADO) connection has Integrated Security checked, so I have no idea how I'm able to connect to the database and tables without being added to database security.
Business Objects does not have an option for creating an OLE DB (ADO) connection. I have no idea if it's even possible to connect to the database. Normally we have a default reporting user that's used to set up OLE DB and ODBC universe connections using SQL authentication.
And from what my colleague in Japan told me, it's not possible to add users to the db_cra database security.
If there's any information that you could provide it would be greatly appreciated I'm really lost with this one so any help or advice would be great.
Thank you!!
Kevin V.