JuxtAPPose

Set of good tools

Commentaires : greatly minimizes the time in having to compare files that need to know what type of information it has and thus not have the same data that confuses and fills up space

Avantages :

I like being able to compare files in the same window and not having to be moving between windows that would take a lot of time and I could not validate the differences more truthfully and thus be able to export the differences to CSV files

Inconvénients :

The free offer that they allow does not have even 30% of the tools in total of all that it has, they should implement more to also take the safe step of buying all the complete software

Excellent tool to compare data from variety of sources

Commentaires : Using this program has helped my company to save a lot of time (and pain) on data validation activities pre and post deployments, as well as during conversion of the production database from one source to another.
Sure, there are many comparison tools out there, but I use this one every day and it definitely does the job for me. Great job, JuxtAPPose team!

Avantages :

JuxtAPPose is a tool that allows you to compare data by connecting and running the query from different sources (MS SQL, MySQL, Aurora, Oracle to name a few) or just loading it from flat files. All you have to do is define the key for comparison and click the start button! You can navigate with ease within the comparison result to see the details, and it could be saved for and retrieved when necessary. The program is quite intuitive because it marks any differences it finds with colors, making it visible right away. It also displays the comparison statistics.

Inconvénients :

I don't think there are really cons.. Sure, the tool may use some enhancements here and there, but nothing comes to mind that would prevent from using it...

My experience using Juxtappose

Avantages :

The ability to compare outputs from two different databases by running the scripts simultaneously is the feature I most adore in this software. By doing that, the app helps to reduce a lots of time and effort.

Inconvénients :

I find the layout and the colors used in the app a bit dull and old fashioned.

How could I live without it?

Avantages :

I really like the flexibility of this tool. It's possible to write your own queries within this software and compare their results directly. Also it's also very easy to ignore specific columns in the comparisons (without having to write a query).

Inconvénients :

It's probably not the most beautiful UI I have seen in my life (but it remains fairly intuitive though).

It is actually EASY

Avantages :

I do commonly need to analyse financial data of several publicly traded companies; to do this, we have to filter, compare and use formulas to understand what these figures mean and synthesize it in a conclusion. It gets more complex because most of the analysis have to be tailored for each project and programming a macro in Excel is not very useful in this case. I tried JuxtAPPose and found it very helpful. It is very intuitive, fast and actually easy to use.

Inconvénients :

The interface does not look modern (this is not a problem actually). If it had the export feature, it would be perfect.