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
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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: 
Anonymous
Not applicable
‎2012-09-17 02:47 PM

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,

Labels (2)
Labels
735 Views
0 Likes
11 Replies
Sebastiao_Qlik
Employee
Employee
‎2012-09-19 12:16 PM

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.
595 Views
0 Likes
Anonymous
Not applicable
‎2012-09-20 03:12 AM
Author

Hi,
thx for the answer.
595 Views
0 Likes
Anonymous
Not applicable
‎2014-01-15 05:31 PM
Author

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?
595 Views
0 Likes
Anonymous
Not applicable
‎2014-01-15 05:33 PM
Author

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
595 Views
0 Likes
Sebastiao_Qlik
Employee
Employee
‎2014-01-16 06:31 AM

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...
595 Views
0 Likes
Anonymous
Not applicable
‎2014-01-17 06:30 PM
Author

how to run DQ portal ? I can't seem to access via http://localhost:8580 but can access my TAC via port 8080
595 Views
0 Likes
Anonymous
Not applicable
‎2014-01-20 04:48 PM
Author

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.
595 Views
0 Likes
Sebastiao_Qlik
Employee
Employee
‎2014-01-31 04:38 AM

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/
595 Views
0 Likes
Anonymous
Not applicable
‎2014-12-13 09:58 AM
Author

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.
595 Views
0 Likes