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
-
Query Box as a MySQL Database in Node.js
Execute MySQL queries against Box from Node.js.
-
DataBind Controls to Cosmos DB in Delphi
DataBind to Azure Cosmos DB in Delphi with standard data access components and controls.
-
How to use SQLAlchemy ORM to access Jira in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Atlassian Jira.
-
Automate DocuSign Replication to Couchbase
Use CData Sync to Customize and automate DocuSign replication to Couchbase.
-
Validate TaxJar with QuerySurge
Access and validate TaxJar in QuerySurge using the CData JDBC Driver.
-
Import Real-Time Splunk via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Splunk in ColdFusion.
-
Automated Continuous PayPal Replication to MySQL
Use CData Sync for automated, continuous, customizable PayPal replication to MySQL.
-
Import Real-Time HDFS via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Apache HDFS in ColdFusion.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Microsoft SQL Server to Power BI dashboards. Simply drag and drop Microsoft SQL Server into data visuals on the Power BI canvas.
-
How to connect to Printify with Squirrel SQL client
Connect to Printify and execute queries in the Squirrel SQL Client.
-
How to update XML from Excel
This article explains how to transfer data from Excel to XML using the Excel Add-In for XML.
-
Automate Phoenix Replication to Couchbase
Use CData Sync to Customize and automate Apache Phoenix replication to Couchbase.
-
Connect to Invoiced as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Invoiced.
-
Create Power BI Reports on Real-Time Basecamp
Use the CData ODBC Driver for Basecamp to visualize Basecamp in Power BI Desktop.
-
Automated Continuous Facebook Replication to SingleStore
Use CData Sync for automated, continuous, customizable Facebook replication to SingleStore.
-
Build Data Flows from Google Directory to SQL Server using SSIS
Easily back up Google Directory to SQL Server using the SSIS components for Google Directory.
-
A PostgreSQL Interface for Pipedrive using the CData ODBC Driver
Use the SQL Gateway and Pipedrive ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous LinkedIn Ads Replication to SingleStore
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to SingleStore.
-
Build Data Flows from Exact Online to SQL Server using SSIS
Easily back up Exact Online to SQL Server using the SSIS components for Exact Online.
-
Create LinkedIn Ads-Connected Visualizations in Klipfolio
Use CData Connect Cloud to connect to LinkedIn Ads from Klipfolio and build custom visualizations using live LinkedIn Ads.
-
Build a Singer.io Tap for SAP Concur With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP Concur data using
-
Edit and Search External NetSuite Objects in Salesforce Connect
Use CData Connect Cloud to securely provide OData feeds of NetSuite CRM & ERP to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create NetSuite objects that you can access from apps and the dashboard.
-
Build Visualizations of FHIR in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of FHIR in Birst.
-
Use the CData Software ODBC Driver for Gmail in MicroStrategy
Connect to Gmail in MicroStrategy Developer using the CData Software ODBC Driver for Gmail.
-
Publish Crystal Reports on Oracle HCM Cloud
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Oracle HCM Cloud.
-
Connect to Active Directory in DBArtisan
Use wizards in DBArtisan to configure Active Directory as a data source.
-
Connect to EnterpriseDB in Ruby
Connect to EnterpriseDB in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automate MailChimp Replication to Azure Data Lake
Use CData Sync to customize and automate MailChimp replication to Azure Data Lake.
-
How to Work with FTP in ETL Validator JDBC
Connect to FTP from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Dynamics CRM from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Dynamics CRM from PowerBuilder using the Dynamics CRM JDBC Driver.
-
Visualize Live Google Spanner of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Spanner using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to eBay Analytics from a Connection Pool in JBoss
Integrate eBay Analytics into Java servlets: Use the Management Console in JBoss to install the eBay Analytics JDBC Driver.
-
Building Dynamic Web Pages with BambooHR Using AngularJS
Create single-page applications with live connectivity to BambooHR using the CData API Server.
-
Access Live Procore in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for Procore to create a Procore source in TIBCO Data Virtualization Studio and gain access to live Procore from your TDV Server.
-
Automated Continuous DB2 Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable DB2 replication to Google Cloud SQL.
-
Connect to Sybase IQ in Google Apps Script via SQL Gateway
Use the ODBC Driver for Sybase IQ and the SQL Gateway to access Sybase IQ from Google Apps Script.
-
Easily Integrate Azure DevOps in Lazarus Pascal IDE
Learn how to easily integrate live Azure DevOps in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Build an ETL App for Greenplum in Python with CData
Create ETL applications and real-time data pipelines for Pivotal GreenPlum in Python with petl.
-
Connect and Query Live Paylocity Data in Databricks with CData Connect Cloud
Use CData Connect Cloud to integrate live Paylocity into Databricks
-
Use the CData Software JDBC Driver for Zuora in MicroStrategy Web
Connect to Zuora in MicroStrategy Web using the CData Software JDBC Driver for Zuora.
-
Connect to Azure Synapse in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Natively Connect to Google Campaign Manager 360 in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Campaign Manager 360. Leverage the native support for ODBC in PHP.
-
Access Live Cosmos DB in Excel 365 Online (Excel for the web)
Connect to Azure Cosmos DB from Excel 365 Online (Excel for the web) with CData Connect Cloud.
-
Access QuickBooks from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live QuickBooks Desktop from HeidiSQL.
-
Connect to GitHub in NetBeans
Connect to GitHub in NetBeans with the data source configuration wizard.
-
Work with Facebook Ads in FoxPro
Load Facebook Ads into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Azure Table as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live Azure Table Storage.
-
Extract, Transform, and Load Printful in Informatica PowerCenter
Create a simple Workflow for Printful in Informatica PowerCenter.
-
Visualize Live Kintone in Power BI (via CData Connect Cloud)
Use the CData Power BI Connector and CData Connect Cloud to integrate live Kintone into custom reports in Power BI.
-
Create Datasets from Acumatica in Domo Workbench and Build Visualizations of Acumatica in Domo
Use the CData Software ODBC Driver for Acumatica to create datasets from Acumatica ERP in Domo Workbench and then build visualizations in the Domo service.
-
Extend Google Sheets with Slack
Make calls to the API Server from Google Apps Script.
-
Connect ADP to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ADP using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData ODBC Driver for Sage 200 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Sage 200 to connect to Sage 200 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Sage 200 in Excel.
-
Build Apps with Live Jira Service Management Using the Low-Code Development Platform of Mendix
-
