#Tableau desktop and tableau prep install#
#Tableau desktop and tableau prep password#

Step 6: Once the Schema is selected, the list of tables present in the schema will be displayed under the Tables pane. Step 5: Click on Schema drop-down list to view the list of Subject Areas. Click on the Database drop-down list to connect to the required database. Step 4: BI Connector will now connect Tableau Prep Builder to OBIEE Subject Areas.

#Tableau desktop and tableau prep password#

Step 3: Enter the username and password and click on Sign In. Step 2: Select the DSN configured for connecting to OBIEE Subject Areas (e.g., OBIEE SA Connector) that you configured using BI Connector in ODBC Data Source Administrator UI. Select Other Databases(ODBC) from the list of Connectors. This could result in an expensive query in OBIEE and you will hear back immediately from your OBIEE admins.Ĭonnecting from Tableau Prep Builder to OBIEE Subject Areas Do not create a flow by querying the entire fact table without any filters.This will result in errors both in Tableau Prep and OBIEE.

Do not combine tables from different star schemas in the same flow.As you get proficient with the BI Connector and OBIEE data model, you can add more tables to your report. By being selective, you can avoid mistakes such as combining unrelated star schemas. Select only one fact table and one or two dimensions. Do not select a large number of tables (facts and dimensions) for your first few flows.

Use filters when appropriate to limit the data being queried by Tableau Prep in OBIEE.

Note down the Subject Area, Fact table & required measures, Dimension tables & required columns.

As the first step, create a similar report in OBIEE in your Dev/Test/Production environment and view the results.

For your first preparation, choose a simple flow with one or two measures coming from one Fact table and one or two dimension columns coming from one or more Dimension tables.

#Tableau desktop and tableau prep install#

The following is a general tutorial for connecting from Tableau to OBIEE using BI Connector Desktop Edition.įollow the Step-by-Step Installation Guide for BI Connector Desktop Edition to install and configure BI Connector on your PC.įollow these few simple mantras to quickly become an Expert in the preparation of the OBIEE data using Tableau Prep and BI Connector. Modified on: Wed, 31 Jul, 2019 at 5:12 AM Solution home Tableau Prep + OBIEE User Guides Connect Tableau Prep Builder to OBIEE Subject Areas - BI connector Desktop Edition - Step-by-Step User Guide