Thought leadership, technical information, and helpful hints.
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.
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.