This chapter describe how to configure an ODBC DSN to connect to the Oracle BI Server on Windows and UNIX platforms.
You use the Oracle BI Server ODBC driver to configure a DSN to connect to a set of clustered Oracle BI Servers through the Cluster Controllers, or to an individual Oracle BI Server. The DSN you configure can be used with any ODBC-compliant query and reporting tool. EDIT: @arify Do you know if the steps regarding exposing key fields in this page need to be done in order for an ODBC connection to the Oracle BI Server?
This chapter includes the following topics:
8.1 Overview of Integrating with Oracle Business Intelligence
You can connect to the Oracle BI Server with a wide variety of ODBC-compliant query and reporting tools, as well as other clients such as remote Administration Tool clients.
Note:
Oracle generally does not confirm or test third-party client tool compatibility with the Oracle BI Server ODBC interface. Check the Oracle BI EE certification document for any specific certification information on third-party tools and the Oracle BI Server ODBC interface. For more information about the certification document, see 'System Requirements and Certification'.
To connect with a remote client, you configure an ODBC DSN for the Oracle BI Server on the remote client computer, and then use that DSN to connect to a repository from the query tool.
Oracle BI Presentation Services clients also connect to the Oracle BI Server using an ODBC DSN. A default ODBC DSN for Presentation Services is created and configured for you during Oracle Business Intelligence installation.
Administration Tool clients on the same host as a Presentation Services instance can also use the default DSN to connect to the Oracle BI Server. Or, you can create a separate DSN for the Administration Tool to use.
The connection parameters for the Cluster Controller and the SSL parameters in the default DSN are centrally managed by Fusion Middleware Control. Do not update these parameters. If you attempt to manually update the centrally managed parameters, the values is overwritten the next time the system is started.
In addition, do not change the name of the centrally managed default DSN. The default DSN has a name similar to 'coreapplication_OHid_number,' where id_number is a number specific to an installed Oracle home.
This chapter explains how you can integrate with the Oracle BI Server as a data source using ODBC on both Windows and UNIX platforms.
8.2 About Integrating with the Oracle BI Server as a Data Source
Open Database Connectivity (ODBC) is an industry standard interface for connecting to databases. A Data Source Name (DSN) is used to store the information about connecting to a given database as a given database user over ODBC.
You use the Oracle BI Server ODBC driver to configure a DSN to connect to a set of clustered Oracle BI Servers through the Cluster Controllers, or to an individual Oracle BI Server. The DSN you configure can be used with any ODBC-compliant query and reporting tool.
The Presentation layer lets you configure the presentation of a business model to be consistent with the rules and conventions of your tools to take advantage of the analytical engine and data abstraction of the Oracle BI Server. This makes it much easier to include columns involving complex aggregation and calculation rules in queries and reports. Also, if your organization is currently using query and reporting tools, using the Oracle BI Server as a data source makes these tools more valuable and simplifies the work entailed when using them.
Note:
In a non-English environment, you can use a direct ODBC connection from a remote client to the Oracle BI Server. However, the translation and localization option that is provided with Oracle BI Presentation Services is not available. Instead, the translation and localization included in the Oracle BI Server metadata (the Oracle BI repository) is available. For example, if Presentation layer metadata objects are defined in French, they are displayed in French through a third-party application.
8.2.1 About Routing Requests to the Physical Layer
Oracle BI Server clients can create a dedicated physical connection to the Oracle BI Server over which all
SELECT queries are treated as SELECT_PHYSICAL queries. SELECT_PHYSICAL queries directly query objects in the Physical layer of the metadata repository, bypassing the Presentation layer and the Business Model and Mapping layer. To enable this direct connection for your ODBC client, select Route Requests To Physical Layer in the DSN configuration.
Note that you cannot have a single ODBC connection that sends queries to both the Presentation layer, and the Physical layer. Instead, you can create one regular connection that sends requests to the Presentation layer, and one connection that sends requests to the Physical layer.
See 'Syntax and Usage Notes for SELECT_PHYSICAL' in Oracle Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition for more information about
SELECT_PHYSICAL queries.
8.2.2 About Integrating with the Oracle BI Server Using JDBC
In addition to using ODBC, you can also integrate with the Oracle BI Server using JDBC. For full information, see the README.TXT file contained in the bijdbc.jar file. You can find the bijdbc.jar file in the following directory:
ORACLE_HOME/bifoundation/jdbc
8.3 ODBC Conformance Level
The Oracle BI Server supports the following ODBC calls from client applications:
Oracle Business Intelligence ODBC supports full scrollable cursors with static, dynamic, forward only, and key set driven cursors. Oracle Business Intelligence ODBC also supports asynchronous and synchronous processing and cancellation.
8.4 Configuring an ODBC DSN for the Oracle BI Server on Windows
This section explains how to create an ODBC DSN for the Oracle BI Server on Windows to enable remote client access. You use the Oracle BI Server DSN Configuration Wizard to set up an ODBC DSN that you can use to connect to a repository through the Oracle BI Server.
We have a website maintained by an old employee and it appears it's encoded by Zend Guard including all backups. I know a little about Zend Optimizer, but never considered it for source protection as I know in the end the bytecode will need to be decoded for the interpreter, and was sure people easily decode optimized files using some software. How to decode php files that encoded by zend encoder cable.
The Oracle BI Server ODBC driver (installed with the BI Admin Tool) is 32-bit or 64-bit, depending on the bitness of the BI Admin Tool installed. The 32-bit version of ODBC Data Source Administrator is located at C:WindowsSysWOW64odbcad32.exe, and the 64-bit version is located at C:Windowssystem32odbcad32.exe.
To create a DSN for the Oracle BI Server on Windows:
8.4.1 Configuring the ODBC DSN for Advanced SSL Settings
Follow the steps in this section to configure additional advanced settings for SSL.
Note: Do not change the SSL parameters of the centrally managed default DSN for Presentation Services.
To configure the Oracle BI Server DSN for advanced SSL settings:
After you complete these steps, copy the client certificate, client private key, and passphrase files (for example, client-cert.pem, client-key.pem, and clientpwd.txt) to the directory specified in the parameters. If you have set the CA Certificate File parameter, you must also copy the CA certificate file (for example cacert.pem) to the directory specified. If you have set the CA Certificate Directory parameter, copy the hash version of the CA certificate to the directory specified.
8.5 Configuring an ODBC DSN for the Oracle BI Server on Linux or UNIX
This section explains how to create an ODBC DSN for the Oracle BI Server on Linux or UNIX to enable remote client access.
On Linux and UNIX systems, the file odbc.ini contains the standard or clustered Oracle BI ODBC connection details that are used by Oracle BI Presentation Services and
nqcmd processes.
Do not change the DSN logical name, the Primary and Secondary Cluster Controller and Port parameters, or the SSL parameters for the centrally managed default DSN.
To create an ODBC DSN for the Oracle BI Server on Linux or UNIX:
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |