Mainframe file to Vertica Table Load
Hi All, I have a requirement for loading mainframe files into vertica tables. Currently vertica doesnt support connectivity to mainframes and we are pulling the files from Mainframe server to Linux and loadind to Vertica tables using COPY command. What i am looking at is , is there any UDLs present in Vertica to pull data directly from Mainframe files and to load into vertica tables by avoiding data transfer between Mainframe and Linux. Challenge what we are facing here is the files in Mainframes are huge and it take enormous amount of time and space to moving data from Mainframe to Linux and then load from Linux to Vertica using COPY. Any suggestions/idea would be helpful to me.