by SherlockTalent
Agile Data Integration in the Logistics Industry
For many businesses, building a functioning Data Warehouse requires expensive and time-consuming development to establish ETL and/or ODBC processes.
However, in their latest case study, Enzo Unified explains how JJ Taylor Companies, a beer distributor that delivers more than 26 million cases annually, opted for a more agile, data-centric approach. The decision freed up significant resources for JJ Taylor and allowed them to update and maintain their data with ease using SQL.
“Now data updates are completed instantly on-demand, rather than batched regularly,” explains Ricky Stefancik, Business Systems Lead for JJ Taylor. “However, the biggest ROI came from completely skipping an expensive ETL development project and the ongoing maintenance of an ETL-based data warehouse. Today, if there’s a change in the data source, we can update it quickly using Enzo.”
Top goals for JJ Taylor included:
- Automate Monthly Reporting
- Enable Real-Time Data Exploration and Analysis
- Avoid Lengthy ETL Development, and Build a more Flexible Data Environment
Because Enzo makes all data look like SQL, it has become one of the most nimble and flexible data management tools on the market. “Businesses need to shift from platform-centric architectures to data-centric integration models; it actually doesn’t matter where the data comes from anymore,” says Herve Roggero, Chief Business Kahuna of Blue Syntax Consulting, the parent company of Enzo Unified.
Check out the full Data Integration Case Study on the Enzo website.
For more information, please visit www.EnzoUnified.com or call us at Tel: 800-610-2521.
by SherlockTalent
Top Factors that Help Reduce Integration Platform TCO
As companies look for ways to improve operational efficiency, the need to integrate multiple systems and automate business processes can grow exponentially over the years. This in turn creates complexity, and as a result, increases the Total Cost of Ownership (TCO) of integration platforms.
Various integration platforms can have very different cost curves over the years. Choosing the platform that will provide the lower overall TCO can be a complex decision and involves many factors above the initial acquisition cost of the platform.
In their latest blog article, Enzo Unified takes a look at how to calculate and then evaluate TCO.
While complex TCO calculations can have many cost categories, such as KLO (Keep the Lights On), MSP (Managed Service Providers), and more, a strong integration platform TCO model will focus on two main categories: Platform and Integration.
Enzo’s detailed, step-by-step article dives into various cost drivers that are relevant when selecting an integration platform, and identifies the “Top Factors that Help Reduce Integration Platform TCO.”
For more information, please visit www.EnzoUnified.com or call us at Tel: 800-610-2521.
by SherlockTalent
Integrating Twitter with Slack and Salesforce
Monitoring customer feedback and comments on social media platforms can become critical for business reputation management and customer support. While existing platforms can provide turnkey social media monitoring, few can provide deep integration options within your existing technology landscape.
Using Enzo’s Data Sync, a built-in technology available as part of Enzo Server, this is fairly straightforward to accomplish.
The ability to process integration logic using SQL is the glue that makes this solution simple to build and continue to evolve over time. Enzo Data Sync is a Change Data Capture (CDC) technology that allows you to monitor virtually any source system, including Twitter, and forward events/changes to SQL Server.
Enzo Unified’s latest blog demonstrates how you can capture tweets and integrate with Slack and Salesforce using the Enzo platform, essentially creating a customer monitoring system using a SQL-driven implementation approach.
Get more information, including sample SQL code, in the article “Integrate Twitter with Slack and SalesForce.”
by SherlockTalent
This process for writing to CSV files or flat files from other data sources can be time-consuming and cumbersome, not only to start and maintain but also to makes changes in the future.
The way this is frequently achieved is by gathering the data that’s needed using a mixture of available tools, creating an SSIS or BCP package, and finally saving the data as a flat-file. Then, if you need to move that file somewhere else, you have to create a scheduler or PowerShell, or perhaps use another application.
What if you could run a single SQL command to save the data into a flat file, and in the same statement, you could store it to its final location?
Enzo Unified shows how this is possible – with just a few lines of SQL – in their overview video “How to Write to Flat Files Using SQL and Enzo.”
By the way, accessing data regardless of its location is just as easy using SQL and Enzo, so you can also reduce the time to gather the data as well. The Enzo CSV Video explains how.
For more information, please visit www.EnzoUnified.com or call us at Tel: 800-610-2521.
by SherlockTalent
Even before COVID-19, work from home (WFH) trending had increased 173% since 2005. In recent months, that trend has only accelerated. As a result, many organizations are working to build remote systems that allow business continuity through collaboration platforms, such as Slack, Microsoft Teams, Egnyte, Dropbox, Google Docs, and others. This effort can be achieved quite nimbly using SQL and Enzo Unified.
Beyond reading and writing messages via these platforms, the Enzo adapters allow you to perform many other functions. For Slack, in particular, this includes listing users, creating new channels, and providing support for Slack Slash Commands.
In their blog, “Slack Integration with SQL Server,” Enzo reveals how quickly integration can be achieved with the Slack platform and provides example SQL commands to help you get there. Many of these concepts can be applied to almost any data source using Enzo Unified. Find out more regarding collaboration software integrations on the Enzo website.
For more information, please visit www.EnzoUnified.com or call us at Tel: 800-610-2521.
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.
