ENZO Case Study: How a Beer Distributor Automated Client Status Emails Using SQL and Enzo Unified

by SherlockTalent

The next step in the growth plan for Peerless Beverage Company, a New Jersey beer distributor, was to add more sophistication to their delivery processes, with a core initiative being automated updates on scheduled deliveries.

Unfortunately, previous ODBC and ETL integration efforts with platforms such as Sendinblue and Ring Central proved expensive and, ultimately, unsuccessful. Enzo Unified provided the solution.

“Once I realized Enzo had the capabilities, I knew that we could do it faster, with more flexibility, and at a fraction of the cost,” said Jesse Robbins, Director of Information Technology for Peerless.

Since Enzo already had developed several of the integration adapters needed, Jesse and his team were able to write at least 70% of the full solution inhouse using SQL. Enzo provided additional integration support with a few new adapters. Once available, it took just a few days to deploy a final solution and test.

Visit the Enzo Unified website to read the complete SQL Automation case study featuring Peerless Beverage.

For more information, please visit www.EnzoUnified.com or call us at Tel: 800-610-2521.

ENZO – “Techniques for Quickly Building a Data Warehouse”

by SherlockTalent

A number of challenges tend to slow down data warehouse projects for companies of all sizes, including data warehouses, data marts and smaller operational databases that use relational database stores.

Three main areas notoriously impede the ability to execute quickly on data warehouse projects:

• Data exploration and ingestion from hosted SaaS systems
• Initial data load and data refresh
• Near-time data ingestion

While ETL tools and ODBC drivers can be used together to solve some of these challenges, they usually require a significant amount of development time and domain-specific knowledge and can be hard to maintain over time. Fortunately, there are alternatives that are much easier and less expensive.

In the blog “Quickly Build a Data Warehouse with Enzo Data Sync,” Enzo Unified evaluates how each challenge noted above can be resolved using simple techniques available through modern data platform tools like Enzo Unified. Check out the full blog post here.

For more information, please visit www.EnzoUnified.com or call us at Tel: 800-610-2521.

ENZO – Explore, Import and Export CSV Files using SQL Commands – Part 1

by SherlockTalent

Part One of a Four-Part Series on Managing CSV Files with ENZO

Using flat files as a way to export data is useful when it needs to be copied, or imported into another system, and is commonly used as a way to exchange information between organizations. Flat files may be compressed and stored on remote cloud platforms (such as Dropbox, GoogleDrive, or even as an Azure Blob).

In most cases, exploring, importing, and exporting flat files, including CSV files is a convoluted process that involves a series of steps and multiple technologies. Depending on the task at hand, you may need to tap into Excel for discovery, PowerShell for command-line utilities, and integration platforms (such as SSIS) to perform scheduled operations.

However, there are ways to simplify the management of flat files, removing the need for more complex integration tools. In fact, if you know SQL, you can do it very easily.

Check out our latest blog post to discover more tips on Exploring, Importing, and Exporting CSV files using Enzo Unified.

For more information, please visit www.EnzoUnified.com or call us at Tel: 800-610-2521.

Know SQL? No Sweat! ENZO Lets You Sidestep Rigid ETL Tools and Connect to New Data Sources with Ease

by SherlockTalent

As the march toward cloud-based data platforms continues, there are very few options for companies that want a truly agile data connectivity approach. In fact, most companies are forced to undertake time-consuming and rigid development projects just to get different data sources integrated.

Enzo Unified is a data connectivity platform that allows businesses to integrate any data source effortlessly using SQL or REST commands. Enzo Unified provides “one version of the truth” and real-time access to data – whether the data resides on-premises, in the cloud, or within a data warehouse. To learn more and discover the simplicity and power of ENZO, read our latest blog on how to Explore, Import, and Export CSV Files using SQL Commands.

Enzo Unified provides access to the robust Enzo Adapter Marketplace where more than 50 adapters are available, including SharePoint, Slack, Salesforce, Google Drive, CSV, and more. A free Community Edition of Enzo is also available.

For more information, please visit www.EnzoUnified.com or call us at Tel: 800-610-2521.