One Star

Run jobs and publish/export results of analysis in Talend Open Studio

Hi,
I am evaluating Talend Open Studio for Data Quality as a tool for data profiling. My team has a couple of requirements which it seems Talend Open Studio for Data Quality does not have as a feature. One, can analyses be run on a scheduled basis (think cron) or can they only be run interactively thru the GUI. Second, can the results be exported/published to a report format outside of Talend Open Studio for Data Quality such as in HTML or PDF?
Thank you for any feedback.

  • Data Quality
16 REPLIES
Community Manager

Re: Run jobs and publish/export results of analysis in Talend Open Studio

Hi
You can generate a report for each analysis and export the report in HTML, PDF, XML or XLS file. Right click on the analysis and select 'New report' option to generate a report.
The Talend Enterprise Data Quality allows you to export the report script and execute it out of Talend studio, it is a batch file and can be scheduled to run at specified times. This feature is not available in community version Talend Open Studio for Data Quality.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Run jobs and publish/export results of analysis in Talend Open Studio

Instead of generating a report, is it possible to write the data quality analysis results to a database?
Community Manager

Re: Run jobs and publish/export results of analysis in Talend Open Studio

Instead of generating a report, is it possible to write the data quality analysis results to a database?

Hi
It does not support the output to database yet, it generates a record with file type html, xml, xsl, and pdf. You can store the record file into database with a DI job.
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Employee

Re: Run jobs and publish/export results of analysis in Talend Open Studio

@LMitre, the results are written in a database that is configured in the preference page "Talend>Profiling>Reporting".
This database is documented in the TDQ Studio User guide, in the PDM appendix.
This database acts as a datamart onto which you may plug any BI tool.
Actually, the TDQ solution comes with the DQ Portal which is preconfigured to access this database.
The DQ Portal is a BI platform that allows you to share your reports, create new reports, schedule them, write ad hoc queries on the data mart....
One Star

Re: Run jobs and publish/export results of analysis in Talend Open Studio

Thanks very much @scorreia. I believe the DQ Portal is not part of the community version though yes? For my research project, we are unable to pay any subscription fees at this time. I need to be able to generate reports w/o Talend's GUI interface and then either export the reports or save the results somewhere so another application can access them.
If this is somehow possible through Talend, I'd very much appreciate the guidance. But it sounds like at this time, we can no longer consider this tool.
Employee

Re: Run jobs and publish/export results of analysis in Talend Open Studio

Yes, the DQ portal and the historization of the analyses is not part of the community edition.
The analysis and their results are stored in xml file. You may want to parse them but I agree that it's not convenient.
One Star

Re: Run jobs and publish/export results of analysis in Talend Open Studio

"The analysis and their results are stored in xml file." <=== This occurs in the community version?
If the file structure doesn't change often, then it's at least a possibility to parse. If you answer yes to the question above, then we might still be able to consider Talend for our work. Thanks very much @scorreia!
Employee

Re: Run jobs and publish/export results of analysis in Talend Open Studio

yes, the analyses are stored in xml file (file extension .ana) in the community version.
I hope this helps.
One Star

Re: Run jobs and publish/export results of analysis in Talend Open Studio

Found the .ana files. Can continue to consider Talend. Thanks very much!
One Star

Re: Run jobs and publish/export results of analysis in Talend Open Studio

Hi,
I have create analysis report in Talend Open Studio for Data Quality as a tool for data profiling. My team has a requirements to export analysis report or publish analysis result report as a snapshot outside of Talend Open Studio for Data Quality such as in HTML or PDF? How can i do that please help.
Community Manager

Re: Run jobs and publish/export results of analysis in Talend Open Studio

The reporting feature is available wiht our subscription products, see the matrix: http://www.talend.com/products/data-quality (scroll down to the comparison matrix)
But I suppose this could be possible to plug some reporting tool to TOS for DQ but not sure about this.
Elisa
One Star

Re: Run jobs and publish/export results of analysis in Talend Open Studio

Dear Shong,
I'm using Talend Open Studo for Data Quality (v5.6.1) and I can't manage to export my Analysis results.
For  exemple I have 5 graphics and I want to export them for exemple in a pdf document (or word, html etc.). 
I do not have the  option "New report" when I right click on my analysis (on profiling). I only have 'Open', 'Run', 'Delete', 'Duplicate', 'Ask tasks', 'Import items', 'Export items'.
Is this really possible with TOS for DQ or should I use another product ?
Best Regards,
Agnès.
Community Manager

Re: Run jobs and publish/export results of analysis in Talend Open Studio

Hi Agnes
As we said in previous posts, generating a report in a PDF ( or word, excel) format is only available in Talend Enterprise subscription products, this feature does not exist in TOS for DQ. 
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Run jobs and publish/export results of analysis in Talend Open Studio

yes, the analyses are stored in xml file (file extension .ana) in the community version.
I hope this helps.

Hi, I'm trying to find the above mentioned file. Where is it stored?
One Star

Re: Run jobs and publish/export results of analysis in Talend Open Studio

Hello Everyone,
I am new to talend but find the DQ tool easy to use. I am eventuating Talend for Data Quality use.
We have Netezza setup and I am successfully able to connect to Netezza database but some how the connection is not showing all tables in schema or entire schema. When I am accessing Netezza DB using other DB tools I can see everything. Does any one encounter to similar kind of issue? Or do i need to do any configuration changes to see all data objects.
Moderator

Re: Run jobs and publish/export results of analysis in Talend Open Studio

Hi rahulsharma,
I have replied to your another topic:https://www.talendforge.org/forum/viewtopic.php?id=55927. Could you please take a look at it?
Best regards
Sabrina
Don't forget to give kudos when a reply from a Community member is helpful and click Accept the solution when you think you're good with it.