Analytics

Analytics with Incorta using 3rd Party Tools

Incorta Analytics

Incorta provides a comprehensive platform for data Acquisition, Data Enrichment, and Data Visualization.

It can be a one-stop for all your data needs, but it can also be combined with other BI Visualization tools to enhance the experience even further. Incorta provides a Postgres connection to connect other 3rd party Visualization tools like Power BI, and Tableau.

Incorta Analytics Service exposes all tenants in an Incorta cluster as separate databases via the SQL Interface (SQLi) using the PostgreSQL protocol. Now you can connect using PostgresSQL and run SQL statements to retrieve data.

Some considerations are

  • Create an Incorta Business schema that comprises all the required columns from your Data Schemas. One of the advantages of a Business Schema is that it can combine multiple Data Schemas and present the data in a Business-centric usable format. Its best practice to have all calculations be done on Incorta so that the 3rd part tool does not need to do any post-processing after it retrieves the data from Incorta for visualization.
  • Make sure that this new business schema includes all needed Tables/Data as this will avoid the need for creating joins in the 3rd party Visualization tool.
  • Set the base table for a business schema view. You can use the Business Schema Designer to set the base table for a business schema view only. This will enable a default query path for attribute-only queries, where one of the attributes is from the current business schema view.
  • Do not set Aggregations in Incorta Business schema as the 3rd party tools can do this on their end after it pulls the data from Incorta.
  • Do not create Incorta Views in Business Schema. (An Incorta View operates independently from other runtime business views, even when in the same business schema. An insight on a dashboard that queries an Incorta View is an applicable insight only for filterable columns from the Incorta View.)
  • Create Folders in Business Schema to organize Business Views for each subject area to be consumed by the 3rd party visualization tool. This will allow you to keep the business schemas created specifically for 3rd party visualization tools separate from other business schemas created for analysis within Incorta Analysis and Insights.
  • Enable Column labels in CMC. Enabling the Column labels instead of Column names will enable 3rd party tools to display the Column labels and not the Column names. This is useful when the column names are not very easy to understand and having the column label will let the 3rd party visualization tool user know the column better.

Recommended steps for setting permissions

  1. Set up your Incorta business views/folders/schemas and define your row-level security as appropriate.
  2. Enable SQL App in CMC
  3. Set up your service account user in both Incorta and the third-party visualization tool.
    • Set up service account user in Incorta
    • Set up service account user in third party tool
  4. Set up the connection in the third-party tool.
    1. Set up connection for PostgresSQL compliant visualization tool
  5. Share only the business schema(s) that the tool should have access to with the service account user.
  6. Validate that Incorta data is available and successfully pulls into the tool

Below is an example of connecting from DBVisualizer using PostgresSQL Driver.

  • I have the following “OnlineStore” Data Schema in my “default” tenant. There is a Business Schema “Online_Store” that is based on the Data Schema “OnlineStore”. Both Data Schema and Business schema are available for querying using PostgresSQL connection

 

Incorta can be used to extract and store data while you use any 3rd party enterprise reporting tool to report by connecting to Incorta.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Jogesh Idukkaparakkal

Jogesh Idukkaparakkal is a Solution Architect in the BI Practice. He has 17+ years of experience in various BI Technologies, ETL, and Cloud Platforms. He was part of Oracle's Oracle BI Applications Engineering Team with in-depth expertise in Supply Chain, Order Management, and Procurement & Spend.

More from this Author

Subscribe to the Weekly Blog Digest:

Sign Up
Follow Us
TwitterLinkedinFacebookYoutubeInstagram