Hi allWe are trying to connect Microsoft SQL server installed in Azure VM(IaaS) from Datastage using API.
Currently, we are using JDBC connector to connect to microsoft sql server(IaaS)using service account and its password. But, In new server, we have to reset the password every three months in Azure. Also, same service account is being used by other applications.
We have to create the change request to reflect the new password in the datastage PROD environment. Also, we are getting separated service account to use in Datastage.
To avoid the password reset or lock issue, we are planning use API to get the password for connecting to the DB.
API DB connection is working in Alteryx. Can you please let us know is it possible to connect and ways to do so in Datastage 18.104.22.168. Also, please let me know any other feasible solution for this problem, if the API connection is not possible.