Is there a connector to be able to pull data from Generic Jdbc or a HBASe database?
Hi,
We currently have all our data in mySQL and Salesforce. We are migrating our MySQL databases to Hadoop, which has Hbase as the database. All our current applications will be changed to use a Pheonix JDBC driver to connect.
However, we're not sure how to connect DOmo to this new Db. Can Domo connect using a generic driver, or does it have native support for HBase?
Thanks
Comments
-
@dalmazan, there are a few different options:
* We have a "Hadoop" connector, which really just connects to HDFS (HBase) and can pull in flat files/CSV. I believe the connector is in Alpha stage, so only Domo consultants/support can setup a connector instance
* It looks like there is an ODBC driver for HBase, which would allow you to set up an ODBC DSN to HBase and send SQL queries from Workbench to upload data: http://www.simba.com/drivers/hbase-odbc-jdbc/
1
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 469 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive