BIEE connects to SQLServer business data source (Linux environment), bieesqlserver

BIEE connects to SQLServer business data source (Linux environment), bieesqlserver
By default, the mssqlserver data driver is installed on biee11g. You do not need to reinstall the server. The configuration process is mainly based on ODBC. This article describes how to configure the client as a windows server as a linux system. 1. The client first configures the odbc data source on the client. You can directly enter odbcad32 in the running state to open the configuration interface-System DNS-to add and select the SQLserver driver. Generally, the wire protocol driver is selected, 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. The operations performed by the server end are 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 by enabling the above user. sh file, add the following content at the bottom: # SQLServer 2000 Parameters

# Export LD_LIBRARY_PATH =/user/local/Oracle_BI1/common/ODBC/Merant/5.3/lib: $ LD_LIBRARY_PATHexport LD_LIBRARY_PATH after adding the file, save and Exit B, modify the odbc configuration file, odbc. sh, path and user. sh: ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup/odbc. ini is configured 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, 1433 AlternateServers = AnsiNPW = YesConnectionRetryCount = 0 ConnectionRetryDelay = 3 Database = dbschema_nameLoadBalancing = 0 LogonID = 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.

Tomcat7 cannot obtain the connection When configuring the SQLServer2005 data source.

The error is reported because there is no proper driver. Check whether the imported driver package is in conflict. Generally, if you need to import anything, do not import anything else, which may cause a conflict. If you are testing the method, we recommend that you create a project for testing.

How to export database data with BIEE

If biee is 10 Gb, You need to configure the database data source, that is, ODBC. You can select the configured ODBC to connect to the database. Biee 11G needs to configure a self-contained client to connect to the database during 11g installation. The difference between biee 11g and 10g is that a self-contained client is used as a bi server cluster, usually in C: \ Biee11g \ Oracle_BI1 \ network \ admin directory.