Hi,
Superset exploits SQLAlchemy to handle the database specifics. Both SQLAlchemy
and Superset are 100% Python thus a DBI module in addition to a Dialect module
need to be put in place. The various database vendors/developers provide a
SQLAlchemy Dialect module to handle the SQL syntax characteristics unique to
that database. Some databases provide their own DBI module while others use
the open source 'pyodbc' DBI module. You can check the SQLAlchemy documentation
to see what database dialects are included.
In Superset, when you create a datasource, you provide a SQLAlchemy URI which
looks something like this for PostgreSQL.
postgres://user:[email protected]/looker_test
The URI for the database we are creating looks like this:
ocientdb+pyodbc://looker:XXXXXXXXXX@OcientLkr
This says to use the 'ocientdb' Dialect combined with the 'pyodbc' DBI.
So if you are using a popular database like MSSQL, MySQL, Postgres etc. it is
fairly easy to connect Superset to a database.
Hank Calzaretta
[cid:41cb8884-83cc-48f2-821b-6a316afb51fa]
www.ocient.com<http://www.ocient.com>
630-957-8802
[email protected]
100 North Riverside Plaza, Suite 800
Chicago, IL 60606
________________________________
From: sunkara raja <[email protected]>
Sent: Thursday, July 26, 2018 6:26:24 AM
To: [email protected]
Subject: DWH combining with Superset
Hi,
I am new to BI tools, so i want to know how to integrate different Data
Bases for Visualization in Superset.
Do we have to build Data Ware House and use Superset or can we directly Use
Superset.
Thanks
