You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2012-09-17 18:47:56

MicheleGuchez
Member
10 posts

MicheleGuchez said:

Talend Data QUality & MS SQL SERVER 2012

Tags: [mssql]

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,

Offline

#2 2012-09-19 16:16:59

scorreia
Talend Team


scorreia said:

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.


Thank you for your support,
Sebastiao Correia.

Offline

#3 2012-09-20 07:12:51

MicheleGuchez
Member
10 posts

MicheleGuchez said:

Re: Talend Data QUality & MS SQL SERVER 2012

Hi,

thx for the answer.

Offline

#4 2014-01-15 23:31:24

opticalscan
Member
12 posts

opticalscan said:

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?

Offline

#5 2014-01-15 23:33:55

opticalscan
Member
12 posts

opticalscan said:

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

Offline

#6 2014-01-16 12:31:46

scorreia
Talend Team


scorreia said:

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/TalendP … +Databases


Thank you for your support,
Sebastiao Correia.

Offline

#7 2014-01-18 00:30:58

opticalscan
Member
12 posts

opticalscan said:

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

Offline

#8 2014-01-20 22:48:17

opticalscan
Member
12 posts

opticalscan said:

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.

Offline

#9 2014-01-31 10:38:17

scorreia
Talend Team


scorreia said:

Re: Talend Data QUality & MS SQL SERVER 2012

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


Thank you for your support,
Sebastiao Correia.

Offline

#10 2014-12-13 15:58:18

arthurh
Talend Team


arthurh said:

Re: Talend Data QUality & MS SQL SERVER 2012

Since scorreia's reply of 16Jan2014 that "The DQ portal cannot currently run with SQL Server [meaning MS 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.

Offline

#11 2016-01-07 19:37:23

elio_bn
Member
1 post

elio_bn said:

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.<init>(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

Last edited by elio_bn (2016-01-07 19:43:41)

Offline

#12 2016-01-11 07:09:55

xdshi
Talend Team


xdshi said:

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: TalendHelpCenter:Supported+systems+databases+and+business+applications+by+Talend+components and TalendHelpCenter:Supported+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


What we can do is to make sure that Talend will be your best choice!

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy