Model Context Protocol (MCP) finally gives AI models a way to access the business data needed to make them really useful at work. CData MCP Servers have the depth and performance to make sure AI has access to all of the answers.
Try them now for free →
CData Software - Knowledge Base
Recent Articles
-
Load SAS Data Sets to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAS Data Sets to a database.
-
Choosing the Best Method to Connect Shopify to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Shopify from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Create Power BI Visual Reports with Real-Time Act-On
Use CData Power BI Connectors to visualize Act-On in Power BI.
-
Use the CData API Server to Access Unbounce in Microsoft PowerPivot
Use the CData API Server to connect to live Unbounce in the Power Pivot business intelligence tool.
-
Sage 200 Reporting in OBIEE with the Sage 200 JDBC Driver
Deploy the Sage 200 JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Bitbucket in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Bitbucket.
-
Prepare, Blend, and Analyze Microsoft Teams in Alteryx Designer (Connect Cloud)
Build workflows to access live Microsoft Teams for self-service data analytics.
-
Work with Azure Synapse in FoxPro
Load Azure Synapse into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Impala in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Impala and connect to Apache Impala in Akorbi Digital RunMyProcess.
-
Working with Zoho Projects in LINQPad
Execute LINQ queries to Zoho Projects in LINQPad.
-
Automated Continuous Amazon DynamoDB Replication to Vertica
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Vertica.
-
Automated Continuous Facebook Replication to Vertica
Use CData Sync for automated, continuous, customizable Facebook replication to Vertica.
-
Query BambooHR in DataGrip
Create a Data Source for BambooHR in DataGrip and use SQL to query live BambooHR.
-
Build an OLAP Cube in SSAS from BigQuery
Establish a connection to Google BigQuery data from SQL Server Analysis Services, and use the BigQuery Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Raisers Edge NXT Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Apache Kafka.
-
Import Dynamics 365 Business Central into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Dynamics 365 Business Central. In this article, you will use the OData format to import Dynamics 365 Business Central into Microsoft Power Query.
-
Replicate Oracle SCM to Multiple Databases via the CData Sync CLI
Replicate Oracle SCM to disparate databases with a single configuration.
-
Deploy the ADO.NET Provider for Salesforce Data Cloud on an SSRS Report Server
Connect to Salesforce Data Cloud from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to use SQLAlchemy ORM to access GitHub in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of GitHub.
-
Connect to Salesloft in DBeaver
Use the CData ODBC Driver to connect to Salesloft in DBeaver.
-
DataBind Controls to Salesforce Pardot in Delphi
DataBind to Salesforce Pardot in Delphi with standard data access components and controls.
-
Automate Excel Online Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Excel Online from PowerShell? This article demonstrates how to utilize the Excel Online Cmdlets for tasks like connecting to Microsoft Excel Online, automating operations, downloading data, and more.
-
Automated Continuous Pinterest Replication to SQLite
Use CData Sync for automated, continuous, customizable Pinterest replication to SQLite.
-
Automated Continuous Shopify Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Shopify replication to Google Cloud SQL.
-
Integrate Live Cloudant into Custom Business Apps Built in Power Apps
Use CData Connect Cloud to connect to IBM Cloudant and integrate live IBM Cloudant into apps built in Microsoft Power Apps.
-
Automated Continuous Presto Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Presto replication to AlloyDB.
-
Connect to Oracle Sales from PowerBuilder via JDBC
This article demonstrates how to access Oracle Sales from PowerBuilder using the Oracle Sales JDBC Driver.
-
Connect to SQL Server in HULFT Integrate
Connect to SQL Server as a JDBC data source in HULFT Integrate
-
Build a PostgreSQL Interface for Google Spanner using the CData JDBC Driver
Use the Remoting features of the Google Spanner JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect and process Google Ad Manager from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Ad Manager
-
Automated Continuous SAP HANA Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP HANA replication to Oracle.
-
Access Hive from MySQL in Amazon QuickSight
Connect to Hive and build visualizations of Apache Hive using a MySQL Connection in Amazon QuickSight.
-
Create SAP Hybris C4C Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Access Google Drive Using Entity Framework
This article shows how to access Google Drive using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze Splunk in Infragistics Reveal
Use the CData API Server to create an OData API on top of Splunk and visualize live Splunk in Ingragistics Reveal.
-
Connect to Snowflake in Claris FileMaker Pro
-
