How do I use ODBC (or JDBC) Database Connection with Snowflake?

I'm suspecting it could be a version issue - we are currently running A2019.17 (7103).

The A360.21 release notes mention Snowflake ODBC support - is there another way to override the default port or workaround the JDBC URL bug?

Hi @Michael Conan​ ,

You can establish a connection with the Snowflake database using ODBC drivers. For more information about downloading the ODBC driver, see Snowflake using ODBC Driver

You can enter the connection string to connect to the database. For example, Driver={SnowflakeDSIIDriver};Server={account}.aws.snowflakecomputing.com;Database=DB_NAME;uid=username;pwd=password;

Checkout below article for more info,

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-using-database-connect-action.html/p>

Hi @Michael Conan​ ,

Can you check with your DBA/IT team internally on the ports or

I'd recommend opening a support ticket with AA using below link

https://apeople.automationanywhere.com/s/support/p>

Thanks, I've opened a ticket - I'd prefer not to go whitelisting new ports and manipulating firewalls on the database side. I would think AA should allow me to specify the port for connection but perhaps not.

Thanks @ChanduMohammad S​ - I have already tried this method and it does not work correctly for me.

Here is the full error message:

As I noted Snowflake uses port 443 by default and it appears AA is attempting to connect through Port 1433.

Welcome @Michael Conan​