Pavel Nejedly's dashboard

Pavel Nejedly replied on November 30, 2009 12:22 to the idea "It would be nice to read data directly from Excel." in Ataccama:

Hello Francesca,

Excel input interface, as well as many other features, including output interface in many formats can be found in our commercial product Ataccama DQ Center.
For DQ Analyzer we are thinking of releasing the Excel input interface in near future, maybe as a reward for some feedback on using DQ Analyzer.

What do you think about that ?

Pavel Nejedly posted an update in Ataccama on November 16, 2009 18:29:

Don't miss DQ Analyzer webinars!

Ataccama is hosting a series of webinars that show how to use DQ Analyzer efficiently and perform complex data quality analyses as well as introduce the other Ataccama products and how they help to improve data quality.

Be sure to register your place in the webinar slot today at http://www.ataccama.com/en/company/events.html.

Pavel Nejedly replied on November 09, 2009 23:28 to the update "DQ Analyzer Early Access 4 now available" in Ataccama:

Hi KJ,

the issue with File -> Open action is now fixed. Please download the final release and give it a try :)

Kind regards,

Pavel

Pavel Nejedly posted an update in Ataccama on November 09, 2009 23:08:

DQ Analyzer 6 final release is out!

Hi everybody,

we are proud to announce that the final release of DQ Analyzer 6 is now available for public download at http://www.ataccama.com/. We would like to thank all the people who participated in the EA program - their fruitful comments, ideas, and bug reports helped us to release a much more mature product, which wouldn't be possible without their help.

The final release is shipped with all the samples you know plus new, more business-oriented sample, which shows extracting e-mail addresses from primary systems and demonstrates advanced functionality available in DQ Analyzer. Be sure to watch the accompanying video at http://www.ataccama.com/tutorials/v6/DQAnalyzer/Emails.html.

Also check out DataQualityPro's tutorial for DQ Analyzer written by Dylan Jones at http://www.dataqualitypro.com/dqa-tutorial-1.

The final release of DQ Analyzer brings (compared to EA6) two notable changes: we now store database passwords in an encrypted form and the issues with File -> Open... action have been fixed. Other changes include improved context-sensitive help and performance improvements in SQL editor.

Happy DQ-Analyzing,

Ataccama DQ Analyzer team

Pavel Nejedly set one of Pavel Nejedly's replies as an official response to "DB user password stored in unencrypted form" in Ataccama

Pavel Nejedly replied on November 09, 2009 20:24 to the problem "DB user password stored in unencrypted form" in Ataccama:

Hi David,
thank you very much for pointing this out. In the final release, which is now available for download, we have implemented encryption for password information both in the UI settings and the runtime - so it shouldn't be possible to read the password just by looking to the configuration files.
Password encryption is automatically turned on for all newly created database connections. If you are reusing DQ Analyzer workspace with configured connections from EA6 or a former build, choosing "Edit connection" from the context menu of a particular database node in Explorer will encrypt the password for that connection as well.

Pavel Nejedly set one of Pavel Nejedly's replies as an official response to "First error in EA 5" in Ataccama

Pavel Nejedly set one of Pavel Nejedly's replies as an official response to "How to add new jdbc driver?" in Ataccama

Pavel Nejedly replied on November 06, 2009 00:57 to the question "How to add new jdbc driver?" in Ataccama:

Hi Jan,
database drivers are added through the UI by choosing Window -> Preferences and selecting Ataccama DQ Analyzer -> Database.

Then, double-click mySql driver entry and select the desired driver location. After confirming the dialog, the newly added driver can be used for creating new database connections.

Pavel Nejedly replied on November 03, 2009 02:20 to the update "DQ Analyzer Early Access 4 now available" in Ataccama:

Hi KJ,

thank you very much for the details. We were able to reproduce the problem and we will fix it in the next (final) release.

Based on our analysis, this error (or a similar one) should occur whenever File -> Open action is used: opening the file (such as profile or similar one) fails with an exception and some other subsequent actions may fail as well. The cause of the problem is that we overlooked that File -> Open a uses a slightly different mechanism for filename passing than we do.

Fortunately, there is a remedy to this problem: instead of using File -> Open, you can open the file directly from the Explorer view (expand my computers, etc.) - this should allow you to open your profiles and plans until we fix the problem with File -> Open.

Best regards,

Pavel

Pavel Nejedly set one of Pavel Nejedly's replies as an official response to "Creation of drill-down table fails on long field" in Ataccama

Pavel Nejedly replied on October 31, 2009 23:06 to the problem "Creation of drill-down table fails on long field" in Ataccama:

Hi Alberto,

thanks again for the report. In EA6 build, which is now available for download, we have fixed the problem by truncating the values stored for drill-through. The actual statistics (frequency analysis, extremes, etc.), are, however, based on data before the truncation. Please let us know if the new build works for you and this scenario.

Pavel Nejedly replied on October 31, 2009 22:57 to the idea "Show some working progress whilst engine is running" in Ataccama:

Hi Matthias and Marek,

thank you for the ideas. In the EA 6 build, we have added an experimental feature that prints the current status of the computation to the Console view every five seconds - so that you can see how is the profiling job doing. We would love to hear your feedback on that functionality.

Pavel

Pavel Nejedly posted an update in Ataccama on October 31, 2009 22:47:

DQ Analyzer Early Access 6 now available

The Early Access 6 build is now available for download from http://www.ataccama.com/ea/.

It introduces new features (most notably context-sensitive help and profiling progress reporting) and fixes a bug in drill-through for large columns.

Complete list of changes is available here.

Also note that the original licenses distributed in the EA program expired on 10/31/2009. You can download a new license directly from the download site.

Pavel Nejedly asked a question in Get Satisfaction on October 29, 2009 22:28:

How do I change the Contact/Invoice E-mail in company profile?

I would like to change the address to which the invoice is being sent. When I come to Admin -> Account Details and click change link behind the current address which allows me to edit the billing address - but not the e-mail.

Pavel Nejedly replied on October 29, 2009 22:09 to the update "DQ Analyzer Early Access 4 now available" in Ataccama:

Hello KJ,
looking at the screen showing HTML export, it seems that the sub-folder containing individual html files for the analyses is missing. This folder would be named Account and would reside in the same folder as Account.profile.html - i.e., its path would be "...\Ataccama\SFB\Account\Account". Is it possible that it was removed, or, that the file Account.profile.html was moved from its original location without this subfolder?
The other error seems to be more complex. Could you please provide us with the details of the error from the error log? You can show the details by double-clicking the particular error in the error log. The entries "Unhandled event loop exception" and "Problems occurred ... eclipse.jface" seem to be particularly interesting.

Pavel Nejedly replied on October 29, 2009 21:36 to the question "First error in EA 5" in Ataccama:

Hi KJ,
this error signals that the engine ran out of memory during the computation. This usually happens in case of tables that either contain a too many columns (normally, DQ analyzer can handle several hundreds of columns) or contain a large BLOB or CLOB columns (these are arbitrary-length data types used to store large binary or textual data, such as PDF files or structured XML documents). The name of your input table (ATTARCHIVE) suggests that this might be the case of such an archive table.
DQ Analyzer provides two ways of dealing with data that exceed the "expected" size. You can either set more memory for the engine (this is normally 256MB, but can be increased in Window -> Preferences under the node of Ataccama DQ Analyzer -> Launching) or you can filter out the large columns in the last step of "Create profile" wizard choosing "custom selection" and unchecking the problematic columns.



In case that this does not solve the issue, could you please provide us with some brief information about th table? The information (such as the column count and column types) can be obtained from the bottom Properties view when you select the table in Explorer.