Configure RDS SQL Server Connection

talendstar — Sat, 16 Nov 2024 00:30:07 GMT

Hi there,

I am trying to setup RDS SQL Server connection using JDBC but not having much luck. It seems like Talend Studio doesnt have RDS SQL Server Connector in 7.1 version.

I get following error:

Exception in component tDBConnection_1 (rdstest)

java.lang.RuntimeException: Driver Class should not be empty, please set it

What should the Driver Class be set to? I have also attached a screenshot of the JDBC component settings.

Thanks

Re: Configure RDS SQL Server Connection

Anonymous — Thu, 04 Mar 2021 07:44:36 GMT

Hello,

For Driver Class, please enter the class name for the specified driver between double quotation marks. For example, for the RedshiftJDBC41-1.1.13.1013.jar driver, the name to be entered is com.amazon.redshift.jdbc41.Driver.

For more information, please refer to this online documentation about: TalendHelpCenter: tJDBCConnection

Here is a tMSSqlConnection component in talend which opens a connection to a Microsoft SQL Server database or a Microsoft Azure SQL database.

Best regards

Sabrina

topic Configure RDS SQL Server Connection in Talend Studio

Configure RDS SQL Server Connection

Re: Configure RDS SQL Server Connection