Hi all,
I am trying to connect the MSSQL 2005 Database to the SAP BI system through RAC.During the creation of the source System(DB Connect) it placed an error as
DIA RSA1 BY G No shared library found for the database with ID SALMSSQL.
Can someone please let me know how we can comeup with this issue?Where we can download LIB_DBSL.SAR and the process to load it into theDIR_LIBRARY default path as we are using RAC connectivity.During the process of creation DB connect source system for MSS what we need to fill for the Connection Info option i.eConn. info MSSQL_SERVER= ? MSSQL_DBNAME= ?
System IP or the IP of Database and which Databasetable
There are more than one database in the SQL server so should I give only the relevant Database name which I will be using to extract?
Do we need to create views on the tables of SQL or we can directlr generate DS for those?
Please help me on this with steps to be taken.
DB Connection MSSQL
DBMS MSS
User Name sa
DB password /
Conn. info MSSQL_SERVER= ? MSSQL_DBNAME= ?
Connection Limit
Optimum Conns
Will reward points.
Thanks
D