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.
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.