Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Dynamically create JDBC connection


Dynamically create JDBC connection

New Contributor

I would like to know if it's possible to dynamically generate a JDBC connection. Our use case is that we have a SQL server that contains a database that acts as multi-tenant configuration. It contains all the database names and connection string info for all tenants. Instead of having to create a DBCPConnectionPool controller service for each one of these, is there a way to dynamically generate a connection to query across all tenant connections?

Don't have an account?
Coming from Hortonworks? Activate your account here