Problem with connecting apache Phoenix via JDBC

Five Stars

Problem with connecting apache Phoenix via JDBC

Hi.
I am now trying to connect to Apache Phoenix (CDH) via JDBC in talend (Window 10).
I choose "General JDBC", use the client driver of the matching version and input the below url:
jdbc: phoenix:<ip>:2181
I have also created the mapping xml file.
Talend says "connection successful" but there is noting when I retrieve schema.
But with the same configuration, I can connect to the database correctly with SQuirreL SQL Client.
Has anyone successfully connected to phoenix in talend? What is the correct configuration?
Thank you!

Moderator

Re: Problem with connecting apache Phoenix via JDBC

Hello,

Here exists a new feature jira issue:https://jira.talendforge.org/browse/TBD-4704.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.