Connecting to Exasol Database

Help Data Service
1

Does anyone know the syntax of the connection string needed for connecting to an Exasol database?

Thanks

2

If you can make a Azure Active Directory authentication with exasol acting as a database then u can simply try with Microsoft server connection
In connect activity you can try to configure the connection from connection wizard

Refer this for steps

@Hibb

3

Thanks, Palaniyappan. I’ll give it a try.

1 Like
4

Our Exasol database is on-prem, so I’m assuming authentication to the Azure Active Directory isn’t necessary, and I can use ODBC.

5

Well that works either provided bing on prem @Hibb
U can simply connect that as a database server with windows authentication or server credentials

Hope now it’s clarified