Connect Tableau Server to OBIEE or Taleo - BI Connector Server Edition - Step-by-Step Installation Guide

Modified on Sat, 14 May 2022 at 07:12 AM

BI Connector - Server Edition allows you to connect Tableau Server/Tableau Online to OBIEE or Taleo (both Subject Areas & Reports) and create intuitive visualizations in minutes.


The following is a general tutorial for installing and configuring BI Connector Server Edition.


Pre-requisites 


 BI Connector Server Edition v4.2 and above has the following pre-requisites: 

  • OS: Windows Server with at least 2 cores and 8 GB memory (refer to Tableau Server recommendation).
  • Tableau: Tableau Server should be installed on the same machine as BI Connector Server Edition. In case, you're using Tableau Online, you must install the Tableau Bridge on the same machine in which you install the BI Connector Server Edition.
  • .NET 4.5 version or higher.  
  • To publish from Tableau Desktop to Tableau Server, the DSN Name in Tableau Desktop for BI Connector OBIEE Connection must match the DSN name in Tableau Server.
  • When Tableau Server is run as a Windows service, verify that Tableau Server is set up with "Run as User" in "Configure Tableau Server" application.  Refer to this Tableau article for more information.   
  • BI Connector's license should be registered with the same Windows User as Tableau Server's user. Please review this article for preventing issues when publishing worksheets to Tableau Server.    
  • Internet Access: Internet access for online license activation.  
          Note:  If you do not have internet access or if you have proxy/firewall blocking access, then please refer to How do I do an offline activation of BI Connector License.

Step 1 : Download


Download the latest version of BI Connector Server Edition from here. 


Step 2: Uninstall BI Connector 


If you have already installed any older versions of BI Connector Server Edition on your PC, uninstall it by following the below steps.

  1. Close Tableau Server if opened in the browser.
  2. Stop Tableau Server.
  3. Uninstall the existing BI Connector

              In your PC —> Go to Control Panel, Programs / Software, Uninstall BI Connector.


Step 3: Extract


Once the download is complete, 

  • Open  BIConnector-Server-Edition-x64-Tableau.exe  file which is a compressed file.  
  • Extract the file by double-clicking on it.  
  • The following 3 files will be extracted from the zip file.  
  1. BIConnector(ServerEdition)-setup-x64-Tableau(x.x.x.xxxx).exe
  2. BIConnector(ServerEdition)-Readmore-Tableau.txt
  3. BIConnector(ServerEdition)-TrialLicenseKey-Tableau.txt

Step 4: Installation


Double click on BIConnector-Server-Edition-x64-Tableau(x.x.x.xxxx).exe. You will see the BI Connector Installer screen as shown below. 


Click on Next in the screen below.  


In the following screen, review and (1) Accept the license agreement. Click (2) Next


In the next screen, note that BI Connector is installed in "C:\Program Files\BI Connector" folder by default. Click Install


BI Connector is now installed in your PC. Verify that Launch ODBC Administrator is checked. Click Finish.   


The ODBC Data Sources Administrator UI will open.


You are now ready to configure BI Connector.  


Step 5: License Activation

If this is the first time you have installed the BI Connector please follow the steps to activate license, if not continue to Step 6.


From the ODBC Data Source Administrator application, select the User DSN tab, click Add.  


























In the Create New Data Source UI, select (1) BI Connector Driver and click (2) Finish


























BI Connector Activate License UI will be displayed.   

  1. Enter your information such as Name, Organization Name, Email Address, Phone Number. 
  2. The default 30-day trial license key will be displayed.   
  3. Click Activate. BI Connector will connect to Licensing Server and try to activate your trial license. 


On successful activation, you will see the "Activation Successful" message. Click on Close. 


Next, you are now ready to configure the data source as described in Step 6.


 Step 6: DSN Configuration


Launch the ODBC Data Source Administrator application. 

Note: If ODBC Data Sources Administrator screen does not open automatically from the previous step, you can search in Windows Search box for "ODBC" and select ODBC Data Sources (64-bit) to launch this screen.  


Note:  You must create a System DSN. Do not create a User DSN because BI Connector Server Edition will not work as a Windows Service.  


In the Create a New Data Source UI for BI Connector, enter the following information.

  1. Give a name to your Data Source, e.g., Northwind SA.
  2. Give a description of the Data Source, e.,g Northwind Subject Area.
  3. Enter the Server Name for your OBIEE or Taleo instance in the Server Name field:
         Example for OBIEE: https://obiprod.biconnector.com
         Example for Taleo:  
    https://biconnector.taleo.net 
  4. Connecting to OBIEE server    
    • If your server URL starts with http:// and has a port number (e.g., 9704), then use that port number (e.g., 9704).   
    • If your server URL starts with https:// and does not have a port number, then port number is typically 443.  
    • If your server URL starts with https:// and has a port number (e.g., 9804), then use that port number (e.g., 9804).
  5. Connecting to Taleo server  For connecting to Taleo server please check "Single Sign-on" and choose "Taleo".
  6. If you have SSO (Single Sign-on) enabled to access OBIEE, then select the "Single Sign-on" checkbox, then select your Single Sign-on type from the list. (Please refer this article to configure Single Sign-on).
    Please note that supporting your SSO infrastructure might require Professional services engagement, please contact our support to get additional information.
  7. Enter your OBIEE or Taleo username in User Id field.
  8. Enter your OBIEE or Taleo password in Password field. For security reasons the password will not be stored and the user will have to authenticate every time a connection is made to the server. 
  9. Click on Test Connection to verify the connection. If the Test connection is successful, you will see the following window. Click OK in the Test Connection UI.

Configuration for accessing Subject Areas 

  1. Now select "Subject Areas" radio button.
  2. Select "Manage Subject Area List" option to select specific Subject Areas for access within Tableau/PBI/Qlik Sense. Please check this article for more information.
    If the list is empty then all the Subject Areas and its information will be loaded.
  3. Click on Save button to save the configuration. 
  4. The created DSN are now displayed within the ODBC Data Sources Administrator UI.

Configuration for accessing Reports  

  1. Now select "Reports" radio button.
  2. Select "Manage Reports List" to select specific Reports for access within Tableau/PBI/Qlik Sense. Please check this article for more information.
    Please note that if this list is empty, then no reports will be made available for access within Tableau/PBI/Qlik
  3. Click on Save button to save the configuration.  
  4. The created DSN are now displayed within the ODBC Data Sources Administrator UI.

Troubleshooting 


If the connection is not successful, you will see the following window. Please click OK.

Verify the URL, port, user id and password and click Test connection again. Even if the URL/port/userid/password are correct and you are still not able to successfully connect, the error could be due to network/SSO configurations such as WebAuth/SAML that might block all web service connections to the server. Please contact us at support@biconnector.com.  


Congratulations! You are now ready to connect from Tableau Server to OBIEE or Taleo. 


Now proceed to Step-by-Step User Guide for accessing Subject Areas from Tableau Server or Step-by-Step User Guide for accessing Reports from Tableau Server.