Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Azure SQL connect to database show system tables not user created?

Somar
5 - Atom

Hi, i was able to connect to Azure SQL using ODBC. I use Power BI and when connected to same server,  i see the database - but not in Alterxy? I see Azure SQL system files but not the database/tables which i created.

 

 

PBI.JPG

 

alterxy.JPG

2 REPLIES 2
jdunkerley79
ACE Emeritus
ACE Emeritus

Try using the OleDB instead of the ODBC:

 

Azure OleDb.jpg

 

I can all the experience I would expect from the SQL design experience:

Azure OleDb 2.jpg

Somar
5 - Atom

Thanks @

 

I tried your recommendation, the connection was failing. I downloaded the ODBC Driver 13 for SQL Server and was succesful, now i can see the database. With the older ODBC driver i was not able to see the database.

Labels