Question is how to connect to AS400 from Toad for Data Analysts?
Follow steps below:
1. Select ODBC driver: Control Panel | Administrative Tools | Data Source (ODBC) | Click on ADD | Select IBM DB2 ODBC DRIVER - TACOM27 | Finish
2. Create connection to database DB2: Fill out Data Source Name | Add | Fill out user id/password | TCP/IP | fill out database information
3. Go to Toad for Data Analysts | File | New connection then select database alias select Connect.