Hello,
Current State: We run a long list of queries in AS400 at period close. After running each individual query in AS400 for a specified date range, we use an Excel workbook to import our query data from AS400 into three workbook tabs. These tabs share the same connection string but have different command texts.
At period close, one of my analysts logs into AS400 to run each query from the long list sequentially. Most queries require updates to the date field to pull records for the appropriate period, while a few do not need any updates before running. All queries must be run before proceeding to the next step: refreshing the Excel workbook that has data connections linked to AS400.
My main objective is to transform this query-running process using Alteryx, which would generate my 'Input Data.'
Current Alteryx Workflow: My 'Input Data' tool is currently configured to an IBM DB2 ODBC data source using my AS400 credentials. I'm using the SQL queries shown in the previously mentioned Excel workbook. The issue with this approach is that it still requires a user to physically log into AS400 and run each query from the long list.
Attachment File: My attachment file contains two tabs:
- AS400 Queries & Manual Inputs: Shows the AS400 Queries, AS400 Query Library, AS400 Fields (we manually update with inputs), Input Values, and Input Description.
- Excel WB SQL Queries: Provides the connection string, command text, and select columns we use in our Excel workbook.
Any suggestions or recommendations on how to approach this?
