We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Odbc Generic connection to get the table names using SQL (elastic ODBC connection)

Giridharan
7 - Meteor

I'm trying to get a list of table names from the ODBC Generic host using a DSN connection. (elastic ODBC connection)

I have tried this earlier using the information schema query on SQL with different hosts. But one particular host doesn't have an information schema.

 

1- I need an SQL query on this DSN ( Odbc Generic host) that allows me to get the table names

 

or

 

2- any other method that gets tables and later uses some other tool to get the table names. 

 

(I've attached a picture of the connection as well as the error when I tried using the information schema query -but hiding the content)

1 REPLY 1
gabrielvilella
14 - Magnetar

I would try contacting the IT team responsible for maintaining this database server to see what is the correct configuration under the ODBC manager area in Windows.