Alteryx connectivity to mainframe (PCLink/AS400)

[Tid14]

Hi,

I need to upload the output files into Mainframe (PClink/AS400) using Alteryx. Is this possible?

[patrick_digan]

@Tid14 You can use Alteryx to write tables to the AS400 using an output tool and configuring it via an odbc connection. We use the iSeries driver, so my output tool would be something like this:

odbc:Driver={iSeries Access ODBC Driver};System=SYSTEM_NAME;Uid=USER_NAME;Pwd=PASSWORD;

You would obviously need to put in your SYSTEM_NAME, USER_NAME and PASSWORD. 

If you already have a DSN on you computer setup in you odbc connections, you could use that instead of the driver/system name

odbc:DSN=YOUR_DSN;UID=USER_NAME;PWD=PASSWORD

[MuralidharAreti]

Hi @patrick_digan, can you point me in the direction of this Series driver? I'm struggling to find one that works...