Wanted to create an analytic app to update password in indbc file

Question

Dear Experts, I have a an .indbc file which I use for a file based In-Db connection. I have a requirement where, The password in the file needs to be changed once in a while. I am planning to build an Analytical app, which when ran, will prompt to enter the password, and when the password is enter it will generate the indbc connection for me. How do i achieve this ? I am mainly finding issues in encrypting the password and generating the .indbc file I attached a sample .indbc file with this. Any help in creation of this app shall be highly regarded. Thanks For example the below Oracle True oci:USERNAME/__EncPwd1__@servername.com:1622/xyzyp False 402A79028C800EA11B773FAE692F6AD770112CD7E1BEB False Quoted OracleOCI oci:BS_1615384/__EncPwd1__@servername.com:1622/xyzyp False 402A79028C800EA11B773FAE692F6AD770112CD7E1BEB 10000 False Quoted OracleOCI Thanks Annamalai connectionsample.txt

TrevorS · Answer

Hello @annamalaimoorthy 
Thank you for your contribution to the Community!

To help make it easier for others to assist, it would be helpful to get some additional information on your process. Here's what we recommend you include in your reply:

* What Alteryx Version are you using?
* Do you have a Workflow with sample data you can share?
* What about a Screenshot?
* What does the data look like? (Beginning data vs. Final Output)

Posting for Fastest Possible Solution (https://community.alteryx.com/t5/Alteryx-Community-Resources/Posting-for-Fastest-Possible-Solution/ta-p/178481)

Thank you very much!

TrevorS