I have been extracting data from SVA_DELAY table in a CSV file daily and importing the file into SAS DB using ETL. I want to automate this process. Is there any ETL tool or any other process I could follow to reduce the manual work?
Table structure/schema in SAS is the same as on Appian Cloud db.
I tried to use SAS ETL or SSIS but since Appian is a cloud service and on the web, I am not able to create a connection between the two databases.
I have been extracting data from SVA_DELAY table in a CSV file daily and importing the file into SAS DB using ETL. I want to automate this process. Is there any ETL tool or any other process I could follow to reduce the manual work?
Table structure/schema in SAS is the same as on Appian Cloud db.
I tried to use SAS ETL or SSIS but since Appian is a cloud service and on the web, I am not able to create a connection between the two databases.
0 Votes
0 Comments
Login or Sign up to post a comment