ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

Easiest way to test access to all tables via input tool

Iggypop
8 - Asteroid

I am currently attempting to connect to a Sage Intact database via a third party driver C Data.

 

My goal is to test that I am able to actually see the data for each table that exists in the Sage Intact source. However, some tables, for whatever reason, show a permission error or say invalid object type. There are roughly couple hundred tables and for me to create couple hundred input's is just not a good idea.

 

 

Anyone have any good ideas as for the easiest and best way for me to do this? Preferably if you can show me? I was thinking a macro could do it, but honestly I wouldn't know how to do that.

Labels