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

[annamalaimoorthy]

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 

<InDBConnection>
<ConnectionType>Oracle</ConnectionType>
<IsNative>True</IsNative>
<DbToAlteryx>
<Connection>oci:USERNAME/__EncPwd1__@servername.com:1622/xyzyp</Connection>
<DecryptionAllowed>False</DecryptionAllowed>
<Passwords>402A79028C800EA11B773FAE692F6AD770112CD7E1BEB</Passwords>
<FormatSpecificOptions>
<ForceSqlWcharSupport>False</ForceSqlWcharSupport>
<TableStyle>Quoted</TableStyle>
</FormatSpecificOptions>
<Type>OracleOCI</Type>
</DbToAlteryx>
<AlteryxToDb OutputDriverSelection="Specified">
<Connection>oci:BS_1615384/__EncPwd1__@servername.com:1622/xyzyp</Connection>
<DecryptionAllowed>False</DecryptionAllowed>
<Passwords>402A79028C800EA11B773FAE692F6AD770112CD7E1BEB</Passwords>
<FormatSpecificOptions>
<TransactionSize>10000</TransactionSize>
<TransactionMessages>False</TransactionMessages>
<TableStyle>Quoted</TableStyle>
</FormatSpecificOptions>
<Type>OracleOCI</Type>
</AlteryxToDb>
</InDBConnection>

Thanks 

Annamalai

[TrevorS]

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/t...)

Thank you very much!

TrevorS