BIEE Connecting SQL Server Business data source (Linux environment)

Source: Internet
Author: User
Tags sql server driver

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
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.