Common Questions about BI Connector

Commonly asked questions re: BI Connector

How to connect with OAS (Oracle Analytics Server) using BI Connector?
To configure BI Connector with OAS please follow the below steps to configure your OAS DSN for BI Connector. 1. Launch the "ODBC Data Source Adminis...
Mon, 19 Oct, 2020 at 5:57 AM
Does BI Connector work with Oracle BICS / Oracle Analytics Cloud (OAC) / Oracle Analytics Server (OAS) / Oracle Autonomous Analytics Cloud (OAAC)?
Yes.  BI Connector works with Oracle BICS / Oracle Analytics Cloud (OAC) / Oracle Analytics Server (OAS) / Oracle Autonomous Analytics Cloud (OAAC).  When y...
Mon, 19 Oct, 2020 at 5:53 AM
How to configure Subject Area list ?
With BI Connector v4.2, a new feature for improving the performance is added to support the loading of selected list of Subject Area information. This feat...
Wed, 27 Mar, 2019 at 5:42 AM
What are the best practices for Tableau-Power BI-Qlik to OBIEE ODBC DSNs?
BI Connector recommends the following approach when it comes to OBIEE ODBC DSNs for Tableau, Power BI and Qlik visualization. Tableau Server - Power BI ...
Wed, 26 Jun, 2019 at 3:00 PM
How to add Reports/Subject Areas in WhereExclusion list?
When getting the column's metadata, for performance improvement we are adding 'WHERE 1=2' in the SQL query. Some specific OBIEE environment h...
Thu, 18 Jul, 2019 at 1:11 PM
Where is the BI Connector.config file located?
The following steps will navigate you to the BI Connector.config file. Step 1: Go to the directory where BI Connector is installed, typically:  C:/Progr...
Mon, 6 Jan, 2020 at 7:12 AM
How to configure HTTP Proxy for BI Connector ?
The following article shows how to configure HTTP proxy server for BI Connector. Configuration of HTTP Proxy for BI Connector versions 4.3.3 and above: ...
Fri, 19 Jul, 2019 at 2:02 AM
Why can't I see the OBIEE presentation layer folder structure and hierarchical columns in Power BI or Tableau or Qlik?
BI Connector uses web service APIs to connect Tableau/Power BI/Qlik to OBIEE.   OBIEE web service API does not provide details on the folder structur...
Mon, 12 Aug, 2019 at 10:32 PM
How to use Duo two-step authentication with BI Connector?
BI Connector's SSO integration module enables users to login to OBIEE from Tableau/Power BI/Qlik using their SSO username/password.  If you have co...
Mon, 16 Dec, 2019 at 6:27 AM
BI Connector Configuration With Command Line Interface (CLI)
BI Connector supports configuration with Command Line Interface(CLI). With the CLI commands, now you can execute a range of actions from managing data sourc...
Thu, 7 Jan, 2021 at 9:37 PM