Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OAC Dataset feeding back into an Oracle table (Tableau access workaround)

Received Response
311
Views
21
Comments

Summary:

OAC Dataset feeding back into an Oracle table (Tableau access workaround)

Content (required):

Much of our company is heavily vested in Tableau. We are in the process of retiring a SQL Server data warehouse and rebuilding in OADW. However, our "system of record" logic and our security reside in the RPD. Since Tableau doesn't connect directly to an OAC PRD Presentation layer, Tableau can, however, connect to an Oracle table in an Oracle database.

If we create a custom Dataset, add it to a Dataflow to be scheduled to run on an iterative basis, is there an automated way to grab the OAC Dataset and push it to a custom table in OADW? As there is a way for Tableau to connect to OADW, this would solve our problem.

Version (include the version you are using, if applicable):

6.3

Code Snippet (add any code snippets that support your topic, if applicable):

https://www.oracle.com/a/ocom/docs/database/adw-connection-instructions-tableau-desktop.pdf

«13

Answers

  • Tableau can connect via JDBC and the OAC RPD can be accessed via JDBC Connection



  • Robert Corrieri-281169
    Robert Corrieri-281169 Rank 6 - Analytics Lead

    Hi Wayne,

    Thanks for the quick response. I found the YouTube video you linked to regarding this on the exact same question, but this doesn't explain how Tableau connects directly do it. I only see a demo for a SQL client tool.

  • Can Tableau connect to data sources via JDBC?

    If so then create the JDBC Connection to the Presentation layer as the documentation shows in the link shows.

  • Joshua C. Stewart
    Joshua C. Stewart Rank 5 - Community Champion

    Aside from Wayne's point - as part of the Dataflow 'Save Data' object - there is an option to save to a database table...


  • Joshua C. Stewart
    Joshua C. Stewart Rank 5 - Community Champion

    Additionally, if you're interested in doing a full migration of your SQL Server environment to Oracle Autonomous Database, you should consider leveraging Relational Junction.

  • Robert Corrieri-281169
    Robert Corrieri-281169 Rank 6 - Analytics Lead

    HI Joshua,

    I was just trying the Dataflow to a Database Connection. I am receiving an error of invalid table. I am assuming a table must be created in OADW first, as this method does not create the table for you? Have you done this before? Just wondering what the change management steps are (i.e. - Adding new fields to the table, etc).

    Thanks,

    Rob

  • It should create the table on the fly.

    Does the ID have correct permissions.

  • Robert Corrieri-281169
    Robert Corrieri-281169 Rank 6 - Analytics Lead

    Hi Wayne,

    I will check. Thanks for the tip. Will post back with my results.

  • Robert Corrieri-281169
    Robert Corrieri-281169 Rank 6 - Analytics Lead

    Hello again,

    I successfully was able to create the table on the fly in OADW. However, Tableau does not have a connector directly to OADW tables. Our OADW connection credentials utilize the Wallet file. Tableau does not recognize a wallet file. Any suggestions here?

  • Joshua C. Stewart
    Joshua C. Stewart Rank 5 - Community Champion

    Would need more insight to the error message you're receiving - chances are you need to configure your TNS_ADMIN environment variable.