Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
talendstar
Creator
Creator
‎2021-03-02 10:56 AM

Configure RDS SQL Server Connection

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

Labels (6)
Labels
545 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2021-03-04 02:44 AM

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

 

545 Views
0 Likes