SQL Power Architect 1.0.8 Now Available!


SQL Power Architect 1.0.8

SQL Power Architect Community Edition 1.0.8 Now Available for Free Download

The World’s Favourite Open-Source Data Modeling Tool is Back!

SQL Power Software is proud to announce the release of SQL Power Architect 1.0.8. This new release features several enhancements and bug fixes, including:

  • Updated for Java 7 Compatibility
  • Added SQL Server 2012 support 3159
  • Improved PostgreSQL Forward Engineering 3157
  • Improved Pentaho Data Integration compatibility 15, 16
  • Improved user-friendly messaging 3146, 3168
  • More reliable copy + paste functionality 2979, 2895, 3144, 3145
  • Improved Print Dialog 3148
  • Misc. bug fixes 1985, 3150

SQL Power MatchMaker is now SQL Power DQguru

April 13th, 2009

SQL Power MatchMaker is now the SQL Power DQguru!

The world-famous Open Source Data Cleansing Tool formerly known as the SQL Power MatchMaker is now the SQL Power DQguru Data Cleansing & MDM Tool.

The name change to SQL Power DQguru reflects the natural evolution of this project, as it continues to grow from its origins as a focused de-duping tool into a full-featured Master Data Management Tool.

SQL Power DQguru 0.9.5

The latest release of SQL Power DQguru introduces several new features and enhancements, including a robust Address Validation/Correction interface, a Sort Words transformer, and an improved built-in SQL Query Tool.

Even though the name has changed, all of the SQL Power MatchMaker features are still there, including:

  • Highly intuitive and easy to use GUI, featuring a comprehensive match validation screen and an intuitive interface for transformation process development
  • Extensive support for transformation and matching functions, including concatenation, metaphone and other phonetic coding, word substitution, and merge rules
  • Assistance in building Cross-reference tables to link source system identifiers to target database identifiers
  • The ability to set the level of cleansing, from duplicate identification through to full removal of duplicate entries
  • Canada Post address verification and address correction options, with USPS address verification forthcoming

SQL Power DQguru gives developers the ability to fully support and automate their MDM functions, while providing end-users with a 360-degree view of their key dimensions (including customers, products, suppliers, business units).

And yes, SQL Power DQguru is still Open Source and free to download!

For a full list of features, and to download SQL Power DQguru, please click here.

Best of BI Open Source Code moved to GitHub

Best of BI Open Source Code Repository has moved to GitHub

Since Google Code has officially closed and been archived, all Best of BI Open-Source code repositories have been moved to GitHub.

This includes SQL Power Architect, SQL Power Wabit, SQL Power DQguru, and the SQL Power Library.

Note that there are several unofficial versions of SQL Power Architect floating around GitHub, but the only official SQL Power Architect code repository is available here.

If you have any questions about the new GitHub repository, please contact us.

Tenacity Award

Best Of BI Wins “Most Tenacious” Award at the Pentaho 2007 Global Partner Summit

Pentaho Global Partner Summit, Orlando FL

Jan 29, 2008 – Best Of BI was presented with the 2007 Most Tenacious Partner Award by the Pentaho Corporation (the commercial open source alternative for business intelligence) at Pentaho’s 2008 Global Partner Summit in Orlando, Florida.

Best Of BI was recognized for their tenacity in pursuing customer success, delivering authorized training classes, consulting services, and expertise in diverse and complex customer environments, and working closely with their customers to achieve high-value results. They continue to provide the technology, industry expertise, and BI implementation skills to deliver success, spanning a wide range of Business Intelligence deployments from embedded reporting and analytics to large-scale data warehouses, dashboards, and data mining.

“Best Of BI is honored to receive the 2007 Pentaho Tenacious Partner Award,” said Sam Selim, President and CEO of Best Of BI. “We’re very pleased to have overcome several challenges on this particular assignment. Our tenacity is in support of our mission to deliver successfully on all of our consulting assignments – We never fail and we strongly believe that neither should our customers! We truly appreciate Pentaho’s recognition of our efforts, and we are committed to continue to provide exceptional business intelligence consulting services to value-oriented clients throughout North America.”

Pentaho Partner awards recognize organizations that have worked closely with Pentaho throughout the year to deliver outstanding customer success, commercial results, and to help accelerate the adoption of best-in-class open source BI capabilities on a global basis. “On behalf of Pentaho, I want to thank and congratulate our 2007 Pentaho Partner Award winners,” said Erik Hoogerhuis, Vice President at Pentaho. “We had strong competition in each category, and these partners were the stand-out leaders. They represent the skills, attitudes and commitment to customer success that make Pentaho’s commercial open source model work.”