APIs require up-to-date and strong documentation, increased security levels, comprehensive testing, routine versioning, and high-reliability to be appropriately utilized. With the CData SSIS Data Flow components you can import and export data from various data sources. However, in some cases the type of operation you need does not fit the SSIS Source or the SSIS Destination model. The […]
The post Perform API Operations Using Stored Procedures in CData SSIS Components appeared first on SQLServerCentral.

Learn a bit about Azure Databricks in this article.
The post An Introduction to Azure Databricks appeared first on SQLServerCentral.

Tableau is a popular visualization tool used by organizations around the world. In this article Sanil Mhatre demonstrates sentiment analysis with Tableau and Oracle data.
The post Text Mining and Sentiment Analysis: Data Visualization in Tableau appeared first on SQLServerCentral.

Database professionals are spending 1/3 of their time on security tasks each day and say it’s their biggest professional challenge this year. Learn how 2500+ database professionals are reacting to these unprecedented demands in our third database monitoring insights report.
The post State of Database Monitoring Report 3 appeared first on SQLServerCentral.

During the development cycle, the mechanics of reliable delivery must not be allowed to dominate the design work. With script callbacks in Flyway Teams, many of the development tasks required during a database migration can happen automatically, producing reports, build scripts, code reviews, or documentation.
The post Scripting with Flyway Teams and PowerShell appeared first on SQLServerCentral.

In this article learn how to use PySpark scripts in Azure Databricks service to copy data between Cosmos DB containers.
The post Cosmos DB Data Migration Between Containers using Databricks and PySpark appeared first on SQLServerCentral.

I would like to share my recent experience with Azure Data Factory (ADF) where AutoResolveIntegrationRuntime become corrupted and how did I recover it. I still don't know how the Integration Runtime (IR) was corrupted. However, if it happens, then this article will help you to solve the issue. Problem In general, the ADF AutoResolveIntegrationRuntime should […]
The post How to Recover a Corrupted Azure Data Factory Integration Runtime appeared first on SQLServerCentral.

AWS Glue is an ETL service from Amazon that enables you to prepare and load your data for storage and analytics. With Glue Studio, you can create no-code and low-code ETL jobs that work with data through CData Glue Connectors. In this article, we walk through configuring the CData Glue Connector for Salesforce and creating and […]
The post CData AWS Glue Connector for Salesforce Deployment Guide appeared first on SQLServerCentral.