It sounds like you have "*" in the Table Selection field. There are too many tables in a typical Adagio setup for ODBC to handle. Choose a single table to load, such as AR92ACST for that AR Customer master.

Only load tables you need to use in the ODBC connection.

The Data Dictionary Exporter will give you the ODBC names of all the tables used in Adagio.