How to Configure/change database for Data stewardship console (DSC)

One Star

How to Configure/change database for Data stewardship console (DSC)

I installed DSQ (talend 5.2.5/Linux/64bit) couple months back to default setting and it installed #HSQL Database Engine 2.0.0, now I have to change the database so it can start writing to MS SQL Server instead of HSQL database,

I found from documentation that i can change the config in "" file
(Source -
1. I need to know do i need to create a blank/new database in SQL Server first.
2. Do i need to create any tables too ? by what name/(s) ? or they would be auto created as soon its configured?
3. please guide me what should i use in below settings for MS SQL Server:

tdsc.database.url=jdbc:hsqldb:<talend home folder>/dsc/tdsc_db
Please suggest.
Thanks !
Community Manager

Re: How to Configure/change database for Data stewardship console (DSC)


I'm afraid you've discovered a bug in our documentation.
If you look at the compatible databases section in the Prerequisite information:, it says that DSC only supports MySQL and HSQL (Table 1.9 - last table of the page).
However for some reason, we provide a different information in the page you refer to,
I have opened a documentation issue in our JIRA to fix the documentation accurately:
In the mean time we asked our QA to quickly test how possible this is to switch to SQL server.
This seems to work ok. But we didn't roll out the full testing scenarios on DSC for this database for obvious time reason (this is not in the scope), therefore we still can't support DSC on MSSQL.

Here are the configuration steps undertaken by our QA person:
1.create a new database named tdsc_db in SQL Server first.
2.manually config the jboss-4.2.2.GA/server/default/deploy/org.talend.datastewardship.war/WEB-INF/classes/


3.add jtds-1.2.2.jar and sqljdbc4-4.0.jar to jboss-4.2.2.GA/server/default/lib
4.start server.

So conclusion is it seems to work ok with the above settings but we cannot provide any support for it, for now.
Sorry about this, thanks for your understanding.

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality


Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.