One Star

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

Hello,
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 "tdsc-database.properties" file
(Source - https://help.talend.com/search/all?query=%2522Replacing+the+default+database%2522&content-lang=en)
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:

#database
tdsc.database.driverClassName=org.hsqldb.jdbcDriver
tdsc.database.url=jdbc:hsqldb:<talend home folder>/dsc/tdsc_db
tdsc.database.dialect=org.hibernate.dialect.HSQLDialect
tdsc.database.connectionProperties=
Please suggest.
Thanks !
1 REPLY
Community Manager

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

Hi

I'm afraid you've discovered a bug in our documentation.
If you look at the compatible databases section in the Prerequisite information: https://help.talend.com/search/all?query=Compatible+Databases&content-lang=en, 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, https://help.talend.com/search/all?query=%2522Replacing+the+default+database%2522&content-lang=en.
I have opened a documentation issue in our JIRA to fix the documentation accurately: https://jira.talendforge.org/browse/DOCT-2714
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/tdsc-database.properties:

tdsc.database.driverClassName=net.sourceforge.jtds.jdbc.Driver
tdsc.database.url=jdbc:jtds:sqlserver:/<YourIP>:1433/tdsc_db
tdsc.database.username=sa
tdsc.database.password=talend
tdsc.database.dialect=org.hibernate.dialect.SQLServerDialect
tdsc.database.connectionProperties=

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.
Elisa