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
-
Create Reports with SAP Business One in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Business One.
-
Connect to Google Contacts through External Services in Salesforce
Use CData Connect Cloud to securely connect Salesforce External Services with Google Contacts using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automated Continuous Typeform Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Typeform replication to AlloyDB.
-
Query, Visualize, and Share live API in Redash
Use CData Connect Cloud to connect to live API in Redash for querying, visualizing, and sharing.
-
Establish a Live Connection with Wave Financial using Tableau Bridge
The CData ODBC Driver for Wave Financial enables you to integrate live Wave Financial into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Power BI XMLA from Crystal Reports
Use CData Connect Cloud to connect to and report on live Power BI XMLA from Crystal Reports.
-
How to Work with Procore in AWS Glue Jobs Using JDBC
Connect to Procore from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous MailChimp Replication to AlloyDB
Use CData Sync for automated, continuous, customizable MailChimp replication to AlloyDB.
-
Validate JSON Services with QuerySurge
Access and validate JSON in QuerySurge using the CData JDBC Driver.
-
Choosing the Best Method to Connect Microsoft Teams to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Teams from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
DataBind Controls to Azure Data Lake Storage in Delphi
DataBind to Azure Data Lake Storage in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for QuickBooks Time in SAS for Real-Time Reporting and Analytics
Connect to real-time QuickBooks Time in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for QuickBooks Time.
-
Automated Continuous Presto Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Presto replication to Google Cloud SQL.
-
Publish Snowflake-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Snowflake.
-
Visualize ADP in Tableau
The CData ODBC driver for ADP enables you integrate ADP into Tableau dashboards.
-
How to Use a Microsoft Access Database to Update QuickBooks in Real Time
Update QuickBooks data by creating a linked table in Microsoft Access with the CData QuickBooks ODBC Driver.
-
LINQ to Jira
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 Jira Data Provider.
-
Build Acumatica-Connected Apps in Choreo
Use CData Connect Cloud to connect to Acumatica from Choreo and build custom apps using live Acumatica ERP.
-
Build Semantic Layer Views for eBay in APOS Live Data Gateway
Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for eBay.
-
LINQ to SAP HANA
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 SAP HANA Data Provider.
-
Integrate Acumatica in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Acumatica ERP from Informatica Cloud.
-
Connect to CockroachDB from a Connection Pool in Jetty
The CockroachDB JDBC Driver supports connection pooling: This article shows how to connect faster to CockroachDB from Web apps in Jetty.
-
Analyze Google Analytics with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Analytics from Power Pivot. You will use the Table Import Wizard to load Google Analytics. You can visually build the import query or use any SQL supported by the driver.
-
Build Data Flows from Dynamics NAV to SQL Server using SSIS
Easily back up Microsoft Dynamics NAV to SQL Server using the SSIS components for Dynamics NAV.
-
Explore Geographical Relationships in BambooHR with Power Map
Create data visualizations with BambooHR in Power Map.
-
Rapidly Develop HBase-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Connect to and Query Oracle Financials Cloud in QlikView over ODBC
Create data visualizations with Oracle Financials Cloud in QlikView.
-
Bind Live Google Contacts Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Contacts data
-
Creating Microsoft Dataverse-Connected Applications in Unqork
You can use CData Connect Cloud to feed Microsoft Dataverse (CDS) to Unqork and build custom business apps.
-
Automated Continuous Klaviyo Replication to Vertica
Use CData Sync for automated, continuous, customizable Klaviyo replication to Vertica.
-
Use the CData Software JDBC Driver for MongoDB in MicroStrategy Desktop
Connect to MongoDB in MicroStrategy Desktop using the CData Software JDBC Driver for MongoDB.
-
Rapidly Develop Acumatica-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Build WordPress-Connected Web Apps with Axios and CData Connect Cloud
Use CData Connect Cloud to connect to live WordPress and build WordPress-connected web apps with Axios.
-
Connect to Jira from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Jira to connect to Atlassian Jira and execute queries in PowerBuilder.
-
Automate Sage 200 Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Sage 200 and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Create Power BI XMLA-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to Power BI XMLA from OutSystems and build custom enterprise apps using live Power BI XMLA.
-
How to import Stripe into Apache Solr
Use the CData Software JDBC Driver for Stripe in Data Import Handler and create an automated import of Stripe to Apache Solr Enterprise Search platform.
-
Create Informatica Mappings From/To a JDBC Data Source for Box
Create Box data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Smaregi in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Smaregi from your Excel spreadsheets.
-
Validate xBase with QuerySurge
Access and validate xBase in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Hive Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Hive replication to Apache Kafka.
-
Stream YouTube Analytics into Apache Kafka Topics
Access and stream YouTube Analytics in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Work with Sybase IQ in AWS Glue Jobs Using JDBC
Connect to Sybase IQ from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Migrating data from HCL Domino to Snowflake using CData SSIS Components.
Easily push HCL Domino to Snowflake using the CData SSIS Tasks for HCL Domino and Snowflake.
-
Query Greenplum using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Greenplum entities in PHP by modeling them as objects.
-
Build a Singer.io Tap for Twilio With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Twilio data using
-
Connect to Sage Intacct in NetBeans
Connect to Sage Intacct in NetBeans with the data source configuration wizard.
-
Import Microsoft Planner into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Planner. In this article, you will use the OData format to import Microsoft Planner into Microsoft Power Query.
-
Model, Search, and Visualize Live Twitter in ThoughtSpot
Use CData Connect Cloud to connect to live Twitter for modeling, searching, and visualizing.
-
Build Dashboards with Adobe Target in Dundas BI
Create dynamic dashboards and perform analytics based on Adobe Target in Dundas BI.
-
DataBind Bullhorn CRM to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Bullhorn CRM with the DevExpress Windows Forms and Web controls to provide Bullhorn CRM to a chart.
-
How to create Bullhorn CRM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Bullhorn CRM in MySQL .
-
Use the CData Software JDBC Driver for SingleStore in MicroStrategy
Connect to SingleStore in MicroStrategy Developer using the CData Software JDBC Driver for SingleStore.
-
PowerShell Scripting to Replicate MarkLogic to MySQL
Write a simple PowerShell script to replicate MarkLogic to a MySQL database.
-
Integrate JDBC-ODBC Bridge with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate JDBC-ODBC Bridge with External Services.
-
Build Apps with Live Bing Ads in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live Bing Ads into the Adalo platform and build custom mobile and web applications with real-time Bing Ads.
-
How to create Gmail federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Gmail in MySQL .
-
How to connect SharePoint with Excel Online through external lists
Provide Microsoft Excel Online to SharePoint users as an external list.
-
Analyze Confluence in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Atlassian Confluence and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Email in the Pentaho Report Designer
Publish reports based on Email in the Pentaho BI tool.
-
Publish TaxJar-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live TaxJar.
-
Import Real-Time Azure Data Lake Storage via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Azure Data Lake Storage in ColdFusion.
-
ETL BigQuery in Oracle Data Integrator
This article shows how to transfer Google BigQuery into a data warehouse using Oracle Data Integrator.
-
Integrate Invoiced with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Invoiced with External Services.
-
DataBind Charts to SAP SuccessFactors
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP SuccessFactors 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.
-
How to use SQLAlchemy ORM to access Google Ad Manager in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Ad Manager.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Epicor Kinetic to Power BI dashboards. Simply drag and drop Epicor Kinetic into data visuals on the Power BI canvas.
-
How to Work with Xero in ETL Validator JDBC
Connect to Xero from ETL Validator jobs using the CData Software JDBC Driver.
-
Build a PostgreSQL Interface for Zoho Projects using the CData JDBC Driver
Use the Remoting features of the Zoho Projects JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Trello in SAS for Real-Time Reporting and Analytics
Connect to real-time Trello in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Trello.
-
How to connect to Parquet with Squirrel SQL client
Connect to Apache Parquet and execute queries in the Squirrel SQL Client.
-
Connect to Jira Assets in RapidMiner
Integrate Jira Assets with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Real-Time Access to Salesloft in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Salesloft in real time.
-
Query Avro through ODBC in Node.js
Use node-odbc to execute SQL queries against Apache Avro from Node.js.
-
Build Azure Active Directory Visualizations in Tableau Cloud
Use CData Connect Cloud to connect to live Azure Active Directory and build visualizations in Tableau Cloud.
-
Integrate with HCL Domino in JReport Designer
Create charts and reports based on HCL Domino in JReport Designer.
-
Perform Batch Operations with Exact Online in Apache NiFi
Connect to Exact Online and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrate Live OneNote into Blue Prism for Intelligent Robotic Process Automation (RPA)
-