Thought leadership, technical information, and helpful hints.
LAB: Replicate SQL Server from AWS into Azure SQL Database using DataZen
This lab shows you how to implement a simple, yet secured Change Data Capture (CDC) SQL Server database replication topology from AWS into Azure using Enzo DataZen as the technology platform, using a single DataZen instance in AWS. The lab takes about 30 minutes and assumes you have an AWS and an Azure account.
Overview of DataZen's Hybrid REST API, Database, File, and Messaging Data Ingestion and CDC Integration Engine.
DataZen allows you to integrate all your data in a single platform you can host on your Virtual Machines, or in the cloud. With DataZen, you can connect to hundreds of applications, HTTP REST API endpoints, CRM/ERP/HR platforms, relational databases, flat files (including Parquet files) and messaging hubs quickly without complex design surfaces. Finally, DataZen makes it easy to publish data to cloud Data Lakes, including AWS S3 and Azure ADLS / Blob storage so you can further leverage existing cloud-based ETL platforms seamlessly.
In this short video, I will show you how you can preview and import a set of flat files into SQL Server using DataZen.
Configure DataZen to import Social Media feeds (Twitter, Facebook/Meta, LinkedIn, YouTube, Pinterest...) into Azure as Parquet/XML/JSON files in Azure ADLS to query with a Azure Synapse database command.
This blog discusses various options to import data feeds from multiple Social Media platforms (such as YouTube, LinkedIn, Twitter, Facebook/Meta, Pinterest and more) into the Azure platform as Parquet files, so that you can query them directly using simple SQL commands with the Azure Synapse service. This guide is intended to provide a high level overview of how the overall solution works and outlines key considerations when access Social Media platforms.
Overview of key design principles used by DataZen that enable a flexible and fully decoupled replication architecture.
DataZen is a Change Data Capture (CDC) technology that allows organizations to copy, replicate, and exchange data from any source system into any target platform, even if those systems are hosted by different companies. This blog provides an overview of key design principles used by DataZen that enable a flexible and fully decoupled replication architecture.
This blog shows you how to copy Parquet files into a SQL Server database using ENZO DataZen.
In this blog we will show you how to detect and forward changes made to a MySQL table and forward them as events into an Azure Event Hub using ENZO DataZen.
Overview of Data Pipelines in DataZen with a focus on Data Masking and Hashing for lower environments on any database platform including SQL Server, Oracle, MySQL and Teradata.
This hands-on lab will show you step-by-step how you can import one or more multiple Parquet files into a SQL Server database using SQL commands from SQL Server Management Studio (SSMS).
Overview of secured Business to Business data sharing and ongoing replication using a loosely coupled, system agnostic, and eventually consistent architecture with DataZen.
How to subset a MySQL table by Year into SQL Server to improve report performance with DataZen.
How to replicate an Oracle table to a SQL Server database with DataZen.
How to replicate and combine data from any source system into a single relational database (SQL Server, AWS RDS SQL Server, or Azure SQL Database), with ongoing data synchronization.
This blog shows you how to integrate Twitter with Slack and SalesForce for customer and reputation social media monitoring.
In this article we are discussing methods of measuring integration projects complexity and the impact the level of complexity has on other factors such as maintenance costs and organizational flexibility.
This video shows you how to execute SQL commands in SQL Server to read and write CSV files.
This video provides an overview of writing flat files (including CSV files) using SQL commands in Enzo.
This blog post is the first in a four-part series that explores the complex topic of managing CSV files, including importing flat files into databases, exporting flat files from any source system, and exploring/discovering flat file content using SQL commands.
In this post we are discussing how to export data from virtually any system into a flat file (such as a CSV file), and store it directly into a drive, SharePoint Document, or cloud system.
In this post we are looking at ways to quickly import CSV data (flat files) into SQL Server and how to automatically create target tables when they don’t exist.
In this blog we will review in detail how you can easily read and explore flat files (CSV Files) using SQL commands, from SQL Server Management Studio (SSMS), regardless of where they are stored, without the need to import the data first.
In this article I will show you how Enzo’s Data Sync technology can drastically simplify data exploration, data loading, and data refresh without using ODBC drivers or ETL tools.
Send a Slack message to an existing channel when a change has been detected in a SharePoint list
Integrate with Slack from SQL Server so you can read and write messages into a Channel (or as a direct message) using SQL commands.
Call the Azure Cognitive Sentiment Analysis service to score customer feedback sentiment from SQL Server directly.
This video shows you how Enzo eliminates the 5,000 Items limitation in SharePoint Online when querying large lists.
Build powerful process automation using the power of the SQL language, and leverage Enzo to eliminate the complex API layers that usually stand in the way without using ODBC drivers.
As corporations continue to adopt cloud computing and leveraging external platforms, the need to access disparate, disconnected and heterogeneous data has never been greater.
See how Enzo's Edge Cache provides a 10x performance improvement for accessing SharePoint Online lists, improving application performance, reporting speed, and overall throughput.
© 2022 - Enzo Unified