Sorry, I may not have explained it properly.
I am essentially trying to access the mapd database through MicroStrategy, by using a JDBC HTTP connection. By adding the connection string, mentioned above, I should be able to connect and have access to the tables within the mapd database.
I have followed the http protocols to achieve such a connection (as mentioned here https://www.mapd.com/docs/latest/mapd-core-guide/jdbc/), but still no luck. So I am assuming it is because mapdql is not recognizing the following ‘SELECT’ statement:
SELECT DISTINCT TABLE_SCHEMA NAME_SPACE, TABLE_NAME TAB_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ‘#?Schema_Name?#’
If my jdbc connection string, mentioned above, is correct than I need to find a ‘SELECT’ statement that mapdql will recognize in order to have access to the database tables, just like when I am able to see a list of tables with mapql commands, like <\t>
Thank you for your help on this.