BLOGS & VIDEOS


Thought leadership, technical information, and helpful hints.





Enzo Data Sync Overview October 2020

Enzo Data Sync

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.



virtual,twilio,data,sync,intacct,twitter,slack,salesforce

Integrate Twitter with Slack and SalesForce October 2020

Code Sample
  
Enzo Data Sync

This blog shows you how to integrate Twitter with Slack and SalesForce for customer and reputation social media monitoring.



twitter,slack,salesforce

Top Factors that Help Reduce Integration Platform TCO September 2020

Strategy

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.



Read / Write Flat Files (CSV) using SQL Commands August 2020

Video

This video shows you how to execute SQL commands in SQL Server to read and write CSV files.

csv,flat file,sql server

Write Flat Files (CSV) Overview August 2020

Video

This video provides an overview of writing flat files (including CSV files) using SQL commands in Enzo.

csv,sql server

Explore, Import and Export CSV Files using SQL Commands July 2020

Overview

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.

csv,flat file,sql server

How to Export Data as a CSV using SQL July 2020

Code Sample

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.

csv,flat file,sharepoint,online,list

How to Import CSV Data into SQL Server July 2020

Code Sample

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.

csv,sql server,flat file



How to Read and Explore CSV Files from SQL Server July 2020

Code Sample

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.

csv,flat file,sql server,dropbox,sharepoint,online,list,ftp

Quickly Build a Data Warehouse with Enzo Data Sync July 2020

Enzo Data Sync

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.

twitter,excel,xls,sql server,data

Send Slack Alerts when SharePoint List Changes May 2020

Code Sample

Send a Slack message to an existing channel when a change has been detected in a SharePoint list

sharepoint,online,slack,list

Slack Integration with SQL Server April 2020

Code Sample

Integrate with Slack from SQL Server so you can read and write messages into a Channel (or as a direct message) using SQL commands.

slack,sql server

Calling Azure Cognitive Services from SQL Server March 2020

Code Sample

Call the Azure Cognitive Sentiment Analysis service to score customer feedback sentiment from SQL Server directly.

sql server,http

How Enzo Helps Solve the 5,000 Items Limitation in SharePoint Online November 2019

Video

This video shows you how Enzo eliminates the 5,000 Items limitation in SharePoint Online when querying large lists.

sharepoint,sql server,online,list

Simple Employee Onboarding Process Automation using SQL October 2019

Code Sample

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.

sharepoint,online,list,automation,sql

The Future of Data Integration: What Every CTO Should Be Aware Of August 2019

As corporations continue to adopt cloud computing and leveraging external platforms, the need to access disparate, disconnected and heterogeneous data has never been greater.

cloud

Improve Sharepoint Online Performance 10 times using an Edge Cache July 2019

See how Enzo's Edge Cache provides a 10x performance improvement for accessing SharePoint Online lists, improving application performance, reporting speed, and overall throughput.

sharepoint,online,list,performance,caching

Beating the 5000 item Sharepoint Online list restriction June 2019

Code Sample
External Content

In this article, I will show you how to easily beat the 5,000 list item restriction in SharePoint Online, regardless of the client programming language (JavaScript, PowerShell, Node.js and so on).


Hosted on C-SharpCorner.com:
sharepoint,online,list,5000