In Linux, use BIEE to connect to the SQLServer business data source, bieesqlserver

In Linux, use BIEE to connect to the SQLServer business data source, bieesqlserver

1. Client

First, configure the odbc data source on the client. You can directly enter odbcad32 in the running state to open the configuration interface-System DNS-add
Select the relevant SQLserver driver. Generally, select the wire protocol driver, configure the sqlserver database connection information, test whether the connection is successful, and save and exit.
Note that the ODBC data source name should be recorded at this time, and it is recommended that you do not change the name once confirmed. If the modification is made, the server also needs to make the modification.
Open Administrator tools, select import metadata, and select the configured sqlserver odbc Data source. The other procedures are exactly the same as those in oracle.

2. Server

The server does nothing more than adding an ODBC data source in the linux environment, so that biee can match the corresponding database connection according to the ODBC name during running.
On the server side, the configuration is simple because biee already comes with the sqlserver data source. There are two steps:
A. Modify the environment variable, user. sh

ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup/user.sh

The purpose of this step is to add the sqlserver driver to the startup environment variable.
After opening the preceding user. sh file, add the following content at the bottom:

#SQLServer 2000 Parameters#---------------------------------------LD_LIBRARY_PATH=/user/local/Oracle_BI1/common/ODBC/Merant/5.3/lib:$ LD_LIBRARY_PATHexport LD_LIBRARY_PATH

Save and exit after adding
B. Modify the odbc configuration file odbc. sh. The path is the same as user. sh:

ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup/odbc.ini

Configure according to the sqlserver configuration method. For example, the oracle official example is as follows:

[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=0LogonID=Password=QuoteID=NoReportCodePageConversionErrors=0

You must modify the content of the yellow shadow area. The SQLSERVER_DB in brackets is the name of the odbc data source, which must be consistent with the name in rpd.