Topic: save profile results to database
save profile results to database
Hi
I am generating profile for millions of records and i want to save profile results to a table in a database. So that i can go and view results sets when ever i want. As of now i am exporting the results to HTML or CSV which i am creating 100's of them. So it is very difficult to check the files for profile results. Is there any way that in future or next version of Data cleaner comes with save profiler results to table in database.
I am generating profile for millions of records and i want to save profile results to a table in a database. So that i can go and view results sets when ever i want. As of now i am exporting the results to HTML or CSV which i am creating 100's of them. So it is very difficult to check the files for profile results. Is there any way that in future or next version of Data cleaner comes with save profiler results to table in database.
Hi Krishna,
I have good and bad news for you on this :)
1) The (first) good news is that you should probably have a look at the batch runner for DataCleaner. It's the executable called "runjob.cmd" (windows) or "runjob.sh" (*nix). It will automatize the job of creating all your csv files. And it can be invoked by eg. scheduled tasks / cron which allows for scheduling etc.
Regarding future releases and improvements to this, there is a bad and a good news item:
2) DataCleaner 2.0 is coming up soon and it will break backwards compatibility (in order to allow an extensive slew of new functionality) and it does not include the functionality that you ask for.
3) But I think it's a very valid thing to ask for, so I will make sure to put it in the planning for a future version, probably 2.1.
I have good and bad news for you on this :)
1) The (first) good news is that you should probably have a look at the batch runner for DataCleaner. It's the executable called "runjob.cmd" (windows) or "runjob.sh" (*nix). It will automatize the job of creating all your csv files. And it can be invoked by eg. scheduled tasks / cron which allows for scheduling etc.
Regarding future releases and improvements to this, there is a bad and a good news item:
2) DataCleaner 2.0 is coming up soon and it will break backwards compatibility (in order to allow an extensive slew of new functionality) and it does not include the functionality that you ask for.
3) But I think it's a very valid thing to ask for, so I will make sure to put it in the planning for a future version, probably 2.1.
Thank you. I really appreciate for such a nice tool. I will be keep watching your updates and let you know if you get any new idea.
Does the DataCleaner 2.0 comes with graphs or still it will be considered for the next higher version? when is the Datacleaner 2.0 is being released? Is there any expected date?
Yes 2.0 will include graphs (for some things that is - but the important thing is that the framework now supports much more rich results so we can include charts, links and basically everything else in them.
Expect a beta release within the next weeks.
Expect a beta release within the next weeks.
How can save results of my analysis into datebase?
Hi maccornik,
That's a feature that is currently not available. We are considering it for an enterprise version of DataCleaner though ... And in general it should be possible to develop such a feature using the existing extension API...
Is that something your company could be interested in?
That's a feature that is currently not available. We are considering it for an enterprise version of DataCleaner though ... And in general it should be possible to develop such a feature using the existing extension API...
Is that something your company could be interested in?
Data Cleaner is a nice applications but I haven't found feature provided to export results of analysis. Is there any possibility to export it to xml, html or csv?
In the current state, the only option is to right-click tables and copy their contents to the clipboard. You can also run jobs from the command line, which will print tables in a tab-delimited format.
But a dedicated "export to Excel" functionality is not done yet. There's however nothing in the extension framework that prohibits it, actually the application was built for rendering results to multiple output formats already.
But a dedicated "export to Excel" functionality is not done yet. There's however nothing in the extension framework that prohibits it, actually the application was built for rendering results to multiple output formats already.
Could you tell me where can I find runjob.cmd file to export data to csv files? I can't find it in DataCleaner directory...
Hi Maccornik,
That's because runjob.cmd is no longer the name of the CL executable. Simply run "datacleaner.cmd -usage" or "datacleaner-console.exe -usage"
That's because runjob.cmd is no longer the name of the CL executable. Simply run "datacleaner.cmd -usage" or "datacleaner-console.exe -usage"
Log in by clicking the login link at the top of the screen
Go back to forum.
