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
-
Use the CData Software JDBC Driver for xBase in MicroStrategy
Connect to xBase in MicroStrategy Developer using the CData Software JDBC Driver for xBase.
-
Use CData Connect Cloud to Access LinkedIn Ads in Microsoft Power Pivot
Use CData Connect Cloud to connect to live LinkedIn Ads in the Power Pivot business intelligence tool.
-
Connect to Act CRM in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Act CRM and connect to Act CRM in Akorbi Digital RunMyProcess.
-
Work with Facebook in FoxPro
Load Facebook into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Impala-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache Impala.
-
Build Dashboards with Tableau CRM Analytics in DBxtra
Create dynamic dashboards and perform analytics based on Tableau CRM Analytics in DBxtra.
-
Automated Continuous Amazon DynamoDB Replication to SQLite
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to SQLite.
-
Use the CData Software ODBC Driver for SAS xpt in SAS for Real-Time Reporting and Analytics
Connect to real-time SAS XPORT in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAS xpt.
-
Integrate Real-Time Access to SurveyMonkey in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SurveyMonkey in real time.
-
Visualize Live Dynamics GP in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Dynamics GP.
-
Build Automated Workflows with Live QuickBooks Online in Workato
Use CData Connect Cloud to connect to live QuickBooks Online and build automated workflows in Workato.
-
How to connect to GraphQL in DBVisualizer
Integrate GraphQL with visual data analysis tools and data connection wizards in DBVisualizer
-
How to import Oracle Service Cloud into Apache Solr
Use the CData Software JDBC Driver for Oracle Service Cloud in Data Import Handler and create an automated import of Oracle Service Cloud to Apache Solr Enterprise Search platform.
-
Use JayDeBeApi to access Drift in Python
Use standard Python scripting and the development environment of your choice to access live Drift.
-
Analyze BigCommerce in Infragistics Reveal
Use CData Connect Cloud to create on OData API on top of BigCommerce and visualize live BigCommerce in Infragistics Reveal.
-
LINQ to LDAP Objects
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the LDAP Data Provider.
-
Bidirectional Access to SAP ByDesign from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP Business ByDesign in Filemaker Pro for Mac or Windows.
-
Visualize Amazon DynamoDB from Tableau
Use the Tableau Desktop business intelligence tool to connect to Amazon DynamoDB.
-
Add Klipfolio to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Klipfolio with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access SAP Netweaver Gateway as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP Netweaver Gateway from your Oracle system.
-
Author and Share Power BI Reports on Real-Time Invoiced
Use the CData ODBC Driver for Invoiced to visualize Invoiced in Power BI Desktop and then upload to the Power BI service.
-
Outreach.io Reporting in OBIEE with the Outreach.io JDBC Driver
Deploy the Outreach.io JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Clio in RazorSQL
Connect to Clio from wizards and query Clio from the GUI in the RazorSQL database management tool.
-
Create Data Visualizations in Cognos BI with SQL Analysis Services
Access SQL Analysis Services as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Datasets from Epicor Kinetic in Domo Workbench and Build Visualizations of Epicor Kinetic in Domo
Use the CData Software ODBC Driver for Epicor Kinetic to create datasets from Epicor Kinetic in Domo Workbench and then build visualizations in the Domo service.
-
Visualize Google Spanner in TIBCO Spotfire through OData
Integrate Google Spanner into dashboards in TIBCO Spotfire.
-
Query Airtable through ODBC in Node.js
Use node-odbc to execute SQL queries against Airtable from Node.js.
-
Publish Twilio-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Twilio.
-
Automate Google Sheets Replication to Azure Synapse
Use CData Sync to customize and automate Google Sheets replication to Azure Synapse.
-
Stream Printful into Apache Kafka Topics
Access and stream Printful in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous CData Connect Cloud Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable CData Connect Cloud replication to PostgreSQL.
-
Import SendGrid into FileMaker Pro
Create reports that integrate SendGrid in Filemaker Pro.
-
Access Zoho CRM from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Zoho CRM from HeidiSQL.
-
Build Dynamics 365 Visualizations in Tableau Cloud
Use CData Connect Cloud to connect to live Microsoft Dynamics 365 and build visualizations in Tableau Cloud.
-
Connect to Epicor Kinetic from PowerBuilder via ADO.NET
This article demonstrates how to access Epicor Kinetic from Appeon PowerBuilder using the CData ADO.NET Provider for Epicor Kinetic.
-
Connect to DB2 in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Analyze GitHub in Infragistics Reveal
Use CData Connect Cloud to create on OData API on top of GitHub and visualize live GitHub in Infragistics Reveal.
-
Import Real-Time Airtable via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Airtable in ColdFusion.
-
Access Adobe Commerce from MySQL in Amazon QuickSight
Connect to Adobe Commerce and build visualizations of Adobe Commerce using a MySQL Connection in Amazon QuickSight.
-
How to load Microsoft Dataverse data into Elasticsearch via Logstash
Introducing a simple method to load Microsoft Dataverse data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Edit and Search External Tableau CRM Analytics Objects in Salesforce Connect
Use CData Connect Cloud to securely provide OData feeds of Tableau CRM Analytics to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Tableau CRM Analytics objects that you can access from apps and the dashboard.
-
Connect to Salesforce in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Salesforce and connect to Salesforce & Force.com in Akorbi Digital RunMyProcess.
-
Bidirectional Access to JotForm from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate JotForm in Filemaker Pro for Mac or Windows.
-
Connect to Facebook in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Visualize Live Spark in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Apache Spark SQL.
-
Connect to Unbounce from PowerBuilder via JDBC
This article demonstrates how to access Unbounce from PowerBuilder using the Unbounce JDBC Driver.
-
Automate Sage Intacct Replication to Couchbase
Use CData Sync to Customize and automate Sage Intacct replication to Couchbase.
-
How to Create Power BI Visual Reports with Real-Time Amazon DynamoDB
Use CData Power BI Connectors to visualize Amazon DynamoDB in Power BI.
-
Connect to Google Contacts in HULFT Integrate
Connect to Google Contacts as a JDBC data source in HULFT Integrate
-
Connect to LinkedIn in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Query Blackbaud FE NXT as a MySQL Database in Node.js
Execute MySQL queries against Blackbaud FE NXT from Node.js.
-
Connect to Paylocity from a Connection Pool in JBoss
Integrate Paylocity into Java servlets: Use the Management Console in JBoss to install the Paylocity JDBC Driver.
-
Connect to Neo4J in RapidMiner
Integrate Neo4J with standard components and data source configuration wizards in RapidMiner Studio.
-
Easily Integrate Jira Assets in Lazarus Pascal IDE
Learn how to easily integrate live Jira Assets in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live LinkedIn in AWS Lambda
Connect to live LinkedIn in AWS Lambda using the CData JDBC Driver.
-
Connect to Oracle in Jaspersoft Studio
Execute SQL to remote Oracle Database in Jaspersoft Studio.
-
Creating Twilio-Connected Applications in Unqork
You can use CData Connect Cloud to feed Twilio to Unqork and build custom business apps.
-
Access Live Calendly in Coginiti Pro
Connect to and query live Calendly from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Manage Amazon DynamoDB in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Amazon DynamoDB.
-
How to Visualize Slack Data in Python with pandas
Use pandas and other modules to analyze and visualize live Slack in Python.
-
How to Query Live LinkedIn Ads Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live LinkedIn Ads data in natural language using Python.
-
How to Build an ETL App for Redis in Python with CData
Create ETL applications and real-time data pipelines for Redis in Python with petl.
-
Integrate Zuora with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Zuora with External Services.
-
Create Reports with Act CRM in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Act CRM.
-
How to connect to Salesforce Pardot from Spring Boot
Connect to Salesforce Pardot in a Spring Boot Application using CData JDBC Salesforce Pardot Driver
-
Establish a Live Connection with HarperDB using Tableau Bridge
The CData ODBC Driver for HarperDB enables you to integrate live HarperDB into Tableau Cloud dashboards using the Tableau Bridge.
-
Author and Share Power BI Reports on Real-Time Zendesk
Use the CData ODBC Driver for Zendesk to visualize Zendesk in Power BI Desktop and then upload to the Power BI service.
-
Integrate Sage Cloud Accounting into Automated Tasks with Power Automate
Use CData Connect Cloud to connect to Sage Business Cloud Accounting and integrate live Sage Business Cloud Accounting into your Power Automate tasks.
-
Build Data Flows from SQL Server to eBay through SSIS
Easily push SQL Server data to eBay using the CData SSIS Tasks for eBay.
-
Connect to Google Contacts from PowerBuilder via JDBC
This article demonstrates how to access Google Contacts from PowerBuilder using the Google Contacts JDBC Driver.
-
Connect to Cvent from a Connection Pool in Jetty
The Cvent JDBC Driver supports connection pooling: This article shows how to connect faster to Cvent from Web apps in Jetty.
-
Connect to Redis in DBArtisan
Use wizards in DBArtisan to configure Redis as a data source.
-
Connect to Cloudant in RazorSQL
Connect to Cloudant from wizards and query IBM Cloudant from the GUI in the RazorSQL database management tool.
-
Automate HCL Domino Replication to Azure Synapse
Use CData Sync to customize and automate HCL Domino replication to Azure Synapse.
-
Visualize Live Sage 300 in the Power BI Service
Use CData Software Connect Server to create a virtual SQL Server database for Sage 300 and create custom reports in the Power BI Service.
-
Access Square 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 Square.
-
Automated Continuous SAP Netweaver Gateway Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to OneLake in Microsoft Fabric.
-
Manage Office 365 in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Office 365.
-
Connect to Shippo as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Shippo.
-
Manage ConstantContact in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ConstantContact.
-
Integrate Cosmos DB in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Azure Cosmos DB from Informatica Cloud.
-
Analyze Avalara AvaTax in Cognos Analytics
Use CData Connect Cloud to connect to Avalara AvaTax from Cognos Analytics and analyze live Avalara AvaTax.
-
Connect to Zoho CRM in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoho CRM and the SQL Gateway to access Zoho CRM from Google Apps Script.
-
How to Query Oracle Sales in MySQL Workbench
Execute MySQL queries against live Oracle Sales from MySQL Workbench.
-
Create Informatica Mappings From/To a JDBC Data Source for Shopify
Create Shopify data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build QuickBooks-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live QuickBooks Desktop.
-
Create Impala-Connected Visualizations in Klipfolio
Use CData Connect Cloud to connect to Impala from Klipfolio and build custom visualizations using live Apache Impala.
-
Import and Visualize Adobe Analytics in Power View
Create data visualizations based on Adobe Analytics in Excel.
-
How to Access Live Cvent in Power Automate Desktop via ODBC
The CData ODBC Driver for Cvent enables you to integrate Cvent into workflows built using Microsoft Power Automate Desktop.
-
Using the CData Software ODBC Driver for Dynamics NAV in PyCharm
Connect to Dynamics NAV as an ODBC data source in PyCharm using the CData Software ODBC Driver for Dynamics NAV.
-
Automated Continuous Salesloft Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Salesloft replication to Amazon Redshift.
-
Build Azure Data Lake Storage-Connected Apps in Choreo
Use CData Connect Cloud to connect to Azure Data Lake Storage from Choreo and build custom apps using live Azure Data Lake Storage.
-
DataBind Charts to Amazon DynamoDB
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Amazon DynamoDB from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build Spark Visualizations in Tableau Desktop
Use CData Connect Cloud to connect to live Apache Spark SQL and build visualizations in Tableau.
-
Analyze SAP Ariba Procurement in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP Ariba Procurement with the CData JDBC Driver for SAP Ariba Procurement.
-
Create Informatica Mappings From/To an ODBC Data Source for Klaviyo
Create an ODBC connection to Klaviyo in Informatica and browse and transfer Klaviyo.
-
Replicate QuickBooks to Multiple Databases
Replicate QuickBooks Desktop to disparate databases with a point-and-click configuration.
-
Connect to Amazon Athena in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Live MariaDB in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to MariaDB from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Create Power BI Visual Reports with Real-Time Authorize.Net
Use CData Power BI Connectors to visualize Authorize.Net in Power BI.