Is there a connector to be able to pull data from Generic Jdbc or a HBASe database?

dalmazan
dalmazan Member
in Archive

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

  • quinnj
    quinnj Contributor

    @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/

  • kshah008
    kshah008 Contributor

    @dalmazan, did quinnj's reply help answer your question?

Categories