One Star

Talend Data QUality & MS SQL SERVER 2012

Hi every body,
do you know when Talend Data QUality (Profiling) will support MS SQL SERVER 2012 ?
what is the difference between the connectors MS SQLSERVER & MS SQLSERVER 2005,2008 ? (if there are any)
Thx,

  • Data Quality
11 REPLIES
Employee

Re: Talend Data QUality & MS SQL SERVER 2012

Hi,
we have not worked on MS SQL SERVER 2012 yet, but the connection should work. Let us know if you have any problem.
About the difference between MS SQLSERVER & MS SQLSERVER 2005,2008, prefer MS SQLSERVER, as MS SQLSERVER 2005,2008 will be removed in the next version.
One Star

Re: Talend Data QUality & MS SQL SERVER 2012

Hi,
thx for the answer.
One Star

Re: Talend Data QUality & MS SQL SERVER 2012

How to install Data Quality Portal with SQL Server 2012? Is there or will there be any support or is the only alt route MySQL?
One Star

Re: Talend Data QUality & MS SQL SERVER 2012

Same question but with Data Stewardship... will I have to run two db's MS SQL Server for the data and MySQL for the Data Quality Portal and Data Stewardship on my windows 2012 server for this to work properly
Employee

Re: Talend Data QUality & MS SQL SERVER 2012

The DQ portal cannot currently run with SQL Server.
Feel free to ask for this feature in our bug tracker https://jira.talendforge.org
Same for the Data Stewardship Console.
https://help.talend.com/display/TalendPlatformUniversalInstallationandUpgradeGuide54EN/1.8+Compatibl...
One Star

Re: Talend Data QUality & MS SQL SERVER 2012

how to run DQ portal ? I can't seem to access via http://localhost:8580 but can access my TAC via port 8080
One Star

Re: Talend Data QUality & MS SQL SERVER 2012

Update:
I've got it to run manually and can access DQP webportal, but can't get it to run via services.. even thought it says DQP is running.
Any advise? maybe on how to create a batch that works properly. Not sure why it works manually.
Employee

Re: Talend Data QUality & MS SQL SERVER 2012

Have a look at https://help.talend.com/display/KB/How+to+set+up+HSQL+Db+as+a+Windows+Service
The DQ portal configuration database needs to be installed as a service as well.
This database location is under tdqp/apache-tomcat/database/
Employee

Re: Talend Data QUality & MS SQL SERVER 2012

Since scorreia's reply of 16Jan2014 that "The DQ portal cannot currently run with SQL Server ... Same for the Data Stewardship Console" this has changed with respect to DSC. The default is still the H2 embedded database, however, you have the possibility to make the console work with other databases, e.g., MySQL through the Install Wizard and Oracle or MS SQL Server by modifying WEB-INF\classes\tdsc-database.properties. Therefore, DSC can *currently* run with MS SQL Server. Can tdq_portal currently run with MS SQL Server? I find no similar statement or file. If not, do we have plans? A client is asking.
One Star

Re: Talend Data QUality & MS SQL SERVER 2012

Hello,
I have issue with the connection to ms sql server 2014, Is their a problem with this version of SQL server 2014?
Connection failure. You must change the Database Settings.
  java.lang.RuntimeException: java.sql.SQLException: Login failed for user 'elie'.
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1089)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:314)
      at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:272)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:2674)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:1)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
      at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      at java.lang.Thread.run(Thread.java:745)
  Caused by: java.sql.SQLException: Login failed for user 'elie'.
      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
      at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
      at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
      at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:632)
      at net.sourceforge.jtds.jdbc.JtdsConnection.(JtdsConnection.java:371)
      at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
      at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186)
      ... 9 more
Moderator

Re: Talend Data QUality & MS SQL SERVER 2012

Hi elio_bn,
So far, ms sql server 2014 is not list on supported DB version.
Please take a look at documents about: TalendHelpCenterSmiley Frustratedupported+systems+databases+and+business+applications+by+Talend+components and TalendHelpCenterSmiley Frustratedupported+databases+for+profiling+data.
From this error message, this is a login failure message.
Can you use  user 'elie' to connect your MSSql DB through client without using Talend tool successfully?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.