Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

mark_costa
Contributor

App.GetDatabases and Hub.GetDatabasesFromConnectionString methods not working for CUSTOM data source

Good day everyone,

I have three connections setup in Qlik Sense:
2 x for Microsoft SQL Server and 1 x for Oracle - those are not ODBC or OLE DB connections but the specific ones provided by Qlik Sense during the Create new connection wizardThose connections are working properly in Qlik Sense Apps.

In QMC those connection Types are displayed as QvOdbcConnectorPackage.exe and the connection strings are like CUSTOM CONNECT TO .... bla bla

I have a .NET app that uses the App.GetDatabases Method to list the Databases from Qlik Sense Connections and this method works pretty well for OLE DB and ODBC connections but it is not working at all with the three connections that I have listed above. The method is not returning any error, it just doesn't list the databases.

I have also tried the Hub.GetDatabasesFromConnectionString Method but this is also not working.

According to the API documentation, both methods are supposed to work with OLE DB, ODBC and CUSTOM data sources.

Can anybody here help me to solve this problem?

@yko sorry about summoning you but I think you may have the answer.

 

Thank you,

Mark Costa

2 Replies
Employee
Employee

Re: App.GetDatabases and Hub.GetDatabasesFromConnectionString methods not working for CUSTOM data so

Sorry, I don't know much about data connectors, so I can't help you much here. But the two SDK methods you refer to map directly to these calls in the Engine API:

https://help.qlik.com/en-US/sense-developer/February2019/APIs/EngineAPI/services-Doc-GetDatabases.ht...

https://help.qlik.com/en-US/sense-developer/February2019/APIs/EngineAPI/services-Global-GetDatabases...

The second one of those pages has a link to this page:

https://help.qlik.com/en-US/sense-developer/February2019/Subsystems/EngineAPI/Content/Sense_EngineAP...

I don't know if that helps you or not though...

Highlighted
mark_costa
Contributor

Re: App.GetDatabases and Hub.GetDatabasesFromConnectionString methods not working for CUSTOM data so

Thank you Yko.

I already have used the Qlik Sense Dev Hub to try those Engine API calls and I got exactly the same result.
I'm starting to think that Qlik Sense doesn't use its API to handle the custom connections, maybe it is something else outside of it.

 

Regards,

Mark Costa