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-05-23 21:44:35

darstar007
Guest

darstar007 said:

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.

#2 2012-06-03 11:32:21

shong
Talend Team


shong said:

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


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the global leader of open source data management and application integration solutions!

Offline

#3 2012-12-04 21:56:22

LMitre
Guest

LMitre said:

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?

#4 2012-12-05 04:51:24

shong
Talend Team


shong said:

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

LMitre wrote:

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


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the global leader of open source data management and application integration solutions!

Offline

#5 2012-12-07 10:47:36

scorreia
Talend Team


scorreia said:

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


Thank you for your support,
Sebastiao Correia.

Offline

#6 2012-12-10 21:09:53

LMitre
Guest

LMitre said:

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.

#7 2012-12-11 17:45:49

scorreia
Talend Team


scorreia said:

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.


Thank you for your support,
Sebastiao Correia.

Offline

#8 2012-12-11 21:10:24

LMitre
Guest

LMitre said:

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!

#9 2012-12-12 14:49:14

scorreia
Talend Team


scorreia said:

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.


Thank you for your support,
Sebastiao Correia.

Offline

#10 2012-12-12 20:32:15

LMitre
Guest

LMitre said:

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!

#11 2014-04-03 17:45:03

fusman
Member
1 post

fusman said:

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.

Offline

#12 2014-04-04 11:55:40

esabot
Talend Team


esabot said:

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


Follow Talend on Twitter, Linkedin and Facebook.

Offline

#13 2015-05-22 15:54:27

AgnèsFD
Guest

AgnèsFD said:

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.

#14 2015-05-25 03:40:26

shong
Talend Team


shong said:

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


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the global leader of open source data management and application integration solutions!

Offline

#15 2017-02-22 17:42:50

johlin
Member
1 post

johlin said:

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

  scorreia wrote:

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?

Offline

#16 2017-02-23 08:32:55

rahulsharma
Member
7 posts

rahulsharma said:

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.

Offline

#17 2017-02-24 08:21:36

xdshi
Talend Team


xdshi said:

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/viewt … p?id=55927. Could you please take a look at it?
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