biee11g default installation of MSSQLSERVER data-driven, do not need to reinstall on the server side, the configuration process is mainly based on the ODBC implementation, this article mainly describes the client for the Windows Server-side Linux system configuration process. 1, the client first configures the ODBC data source in the client, can enter the ODBCAD32 directly in the operation, opens the Configuration Interface-System DNS---Adds the choice SQL Server the related driver, generally chooses the wire protocol type drive, Configure SQL Server database connection information, test if the connection is successful, and save the exit. Note that the ODBC data source name is logged at this time and it is best not to change it once it is determined. Because if the change, the server side also to make changes. Open Administrator Tools, select Import Metadata, select the configured SQL Server ODBC data source, and the other processes are fully consistent with Oracle operations. 2, the service side of the server to do nothing but also in the Linux environment to add an ODBC data source, so that biee at the time of operation according to the ODBC name can match to the corresponding database connection.
operation on the server side because the BIEE already has its own data source for SQL Server, the configuration is relatively straightforward. A total of two steps:
A, modify the environment variables, user.sh oracle_instance/bifoundation/oraclebiapplication/coreapplication/setup/user.sh The goal of this step is to add the SQL Server driver to the startup environment variable by opening the user.sh file above and adding the following at the bottom: #SQLServer Parameters
#---------------------------------------ld_library_path=/user/local/oracle_bi1/common/odbc/merant/5.3/lib:$ Ld_ Library_pathexport Ld_library_path Add complete save and Exit B, modify ODBC configuration file, odbc.sh, same path as user.sh: oracle_instance/bifoundation/ The Oraclebiapplication/coreapplication/setup/odbc.ini is configured according to SQL Server configuration, with the sample Oracle Official sample:
[ sqlserver_db]Driver= /usr/oracle_bi1/common/odbc/merant/5.3/lib64/armsss23.soDescription=datadirect 5.1 sql Server Wire protocoladdress= 111.111.111.111,1433Alternateservers=ansinpw=yesconnectionretrycount=0connectionretrydelay=3database= Dbschema_nameLoadbalancing=0 logonid= password=Quoteid=noreportcodepageconversionerrors=0
Be sure to modify the contents of the yellow shaded area above, where the sqlserver_db inside the brackets is the name of the ODBC data source and needs to be consistent with the name in the RPD