I work in an enterprise that uses Active Directory to manage database access. When I connect to MS SQL with Alteryx, I can use a string like:
odbc: Driver={SQL Server};Server=XXXX;Trusted_Connection=yes;
When I connect to Oracle using a 32 bit OCI, the string looks like:
32bit:oci:USER/__encryptedPW__@HOST.XXX
This is problematic because my password must be changed every two months according to company policy. I have to update any workflow that uses the Oracle connection. It would be grand if I could use AD for Oracle and for any Alteryx connection the way I can for MS SQL in the first instance.