topic GetDatabase and GetDatabaseTables from QLik sense engine api not working for sql server connection in Integration, Extension & APIs https://community.qlik.com/t5/Integration-Extension-APIs/GetDatabase-and-GetDatabaseTables-from-QLik-sense-engine-api-not/m-p/32879#M481 <HTML><HEAD></HEAD><BODY><P>In my Qlik sense desktop application, I've connected to a sql server (have tried both adding the database field and leaving it blank). The app is able to get tables and load data.</P><P></P><P>Now I'm trying to get the names of databases and their tables from the connection using the Engine API, but an empty list is returned (using getdatabases method)</P><P></P><P>{</P><P>"handle": 1,</P><P>"method": "GetConnection",</P><P>"params": {</P><P>"qConnectionId": "7c7f33e0-b007-4b00-914c-65b0a064668c"</P><P>},</P><P>"outKey": -1,</P><P>"id": 4</P><P>}</P><P></P><P>Reply:</P><P></P><P>{</P><P>"jsonrpc": "2.0",</P><P>"id": 4,</P><P>"delta": true,</P><P>"result": {</P><P>"qConnection": {</P><P>"qId": "7c7f33e0-b007-4b00-914c-65b0a064668c",</P><P>"qName": "mynameis",</P><P>"qConnectionString": "CUSTOM CONNECT TO \"provider=QvOdbcConnectorPackage.exe;driver=mysql;host=sql12.freesqldatabase.com;port=3306;db=sql12243045;SSLMode=DISABLED;UseTrustStore=false;QueryTimeout=30;\"",</P><P>"qType": "QvOdbcConnectorPackage.exe",</P><P>"qModifiedDate": "6/15/2018 2:27:50 AM",</P><P>"qMeta": {},</P><P>"qLogOn": "LOG_ON_SERVICE_USER"</P><P>}</P><P></P><P>Get Databases:</P><P>{</P><P>"handle": 1,</P><P>"method": "GetDatabases",</P><P>"params": {</P><P>"qConnectionId": "7c7f33e0-b007-4b00-914c-65b0a064668c"</P><P>},</P><P>"outKey": -1,</P><P>"id": 5</P><P>}</P><P>{</P><P>"handle": 1,</P><P>"method": "GetDatabases",</P><P>"params": {</P><P>"qConnectionId": "7c7f33e0-b007-4b00-914c-65b0a064668c"</P><P>},</P><P>"outKey": -1,</P><P>"id": 5</P><P>}</P><P></P><P>Reply:</P><P>{</P><P>"jsonrpc": "2.0",</P><P>"id": 5,</P><P>"delta": true,</P><P>"result": {</P><P>"qDatabases": []</P><P>}</P><P>}</P><P></P><P>I know there are databases in the server;</P></BODY></HTML> Fri, 15 Jun 2018 10:06:13 GMT Anonymous 2018-06-15T10:06:13Z GetDatabase and GetDatabaseTables from QLik sense engine api not working for sql server connection https://community.qlik.com/t5/Integration-Extension-APIs/GetDatabase-and-GetDatabaseTables-from-QLik-sense-engine-api-not/m-p/32879#M481 <HTML><HEAD></HEAD><BODY><P>In my Qlik sense desktop application, I've connected to a sql server (have tried both adding the database field and leaving it blank). The app is able to get tables and load data.</P><P></P><P>Now I'm trying to get the names of databases and their tables from the connection using the Engine API, but an empty list is returned (using getdatabases method)</P><P></P><P>{</P><P>"handle": 1,</P><P>"method": "GetConnection",</P><P>"params": {</P><P>"qConnectionId": "7c7f33e0-b007-4b00-914c-65b0a064668c"</P><P>},</P><P>"outKey": -1,</P><P>"id": 4</P><P>}</P><P></P><P>Reply:</P><P></P><P>{</P><P>"jsonrpc": "2.0",</P><P>"id": 4,</P><P>"delta": true,</P><P>"result": {</P><P>"qConnection": {</P><P>"qId": "7c7f33e0-b007-4b00-914c-65b0a064668c",</P><P>"qName": "mynameis",</P><P>"qConnectionString": "CUSTOM CONNECT TO \"provider=QvOdbcConnectorPackage.exe;driver=mysql;host=sql12.freesqldatabase.com;port=3306;db=sql12243045;SSLMode=DISABLED;UseTrustStore=false;QueryTimeout=30;\"",</P><P>"qType": "QvOdbcConnectorPackage.exe",</P><P>"qModifiedDate": "6/15/2018 2:27:50 AM",</P><P>"qMeta": {},</P><P>"qLogOn": "LOG_ON_SERVICE_USER"</P><P>}</P><P></P><P>Get Databases:</P><P>{</P><P>"handle": 1,</P><P>"method": "GetDatabases",</P><P>"params": {</P><P>"qConnectionId": "7c7f33e0-b007-4b00-914c-65b0a064668c"</P><P>},</P><P>"outKey": -1,</P><P>"id": 5</P><P>}</P><P>{</P><P>"handle": 1,</P><P>"method": "GetDatabases",</P><P>"params": {</P><P>"qConnectionId": "7c7f33e0-b007-4b00-914c-65b0a064668c"</P><P>},</P><P>"outKey": -1,</P><P>"id": 5</P><P>}</P><P></P><P>Reply:</P><P>{</P><P>"jsonrpc": "2.0",</P><P>"id": 5,</P><P>"delta": true,</P><P>"result": {</P><P>"qDatabases": []</P><P>}</P><P>}</P><P></P><P>I know there are databases in the server;</P></BODY></HTML> Fri, 15 Jun 2018 10:06:13 GMT https://community.qlik.com/t5/Integration-Extension-APIs/GetDatabase-and-GetDatabaseTables-from-QLik-sense-engine-api-not/m-p/32879#M481 Anonymous 2018-06-15T10:06:13Z Re: GetDatabase and GetDatabaseTables from QLik sense engine api not working for sql server connecti https://community.qlik.com/t5/Integration-Extension-APIs/GetDatabase-and-GetDatabaseTables-from-QLik-sense-engine-api-not/m-p/1559290#M10211 <P>I'm having the same problem for any kind of CUSTOM connector (<STRONG>provider=QvOdbcConnectorPackage.exe</STRONG>).<BR />Do you have any news on that ?</P> Wed, 20 Mar 2019 21:12:53 GMT https://community.qlik.com/t5/Integration-Extension-APIs/GetDatabase-and-GetDatabaseTables-from-QLik-sense-engine-api-not/m-p/1559290#M10211 marksouzacosta 2019-03-20T21:12:53Z Re: GetDatabase and GetDatabaseTables from QLik sense engine api not working for sql server connecti https://community.qlik.com/t5/Integration-Extension-APIs/GetDatabase-and-GetDatabaseTables-from-QLik-sense-engine-api-not/m-p/1683701#M12473 <P>I'm facing the same issue. Any solution for it ?</P> Wed, 11 Mar 2020 11:12:43 GMT https://community.qlik.com/t5/Integration-Extension-APIs/GetDatabase-and-GetDatabaseTables-from-QLik-sense-engine-api-not/m-p/1683701#M12473 SriHarsha 2020-03-11T11:12:43Z Re: GetDatabase and GetDatabaseTables from QLik sense engine api not working for sql server connection https://community.qlik.com/t5/Integration-Extension-APIs/GetDatabase-and-GetDatabaseTables-from-QLik-sense-engine-api-not/m-p/2088264#M18730 <P>I am also facing this problem, please let me know if any solution found</P> Tue, 27 Jun 2023 12:29:39 GMT https://community.qlik.com/t5/Integration-Extension-APIs/GetDatabase-and-GetDatabaseTables-from-QLik-sense-engine-api-not/m-p/2088264#M18730 rdsharma 2023-06-27T12:29:39Z