Hello,
I'm working on automation project and this is what I like to do.
Before connecting to any table, I like to DELETE/DROP tables may exist on the server. This is what I like to do.
- Run command tool
- Run BTEQ, logon to the server, username, password, set database and drop tables
I was able to run BTEQ by using RUN COMMAND tool in Alteryx. I'm able to connect to the server, l'm able to enter my logon id and then it asks me my password.... when I entered my password, I like to connect automatically to the database and drop the tables.
The RUN COMMAND stops after I enter the password, because it pops up BTEQ tool for my password.
So my question is:
1-How to continue after I enter my password?
2- It may ask my server name, user, password, and then send within RUN COMMAND TOOL - password should be masked and/or encrypted....
3-Best way all these steps should be auto... because everything starts after the tables DROPPED.
Any suggestions?
Albert