CData Software - Knowledge Base
Recent Articles
-
How to connect Amazon QuickSight to Google Cloud Storage Data
Create a connection to Google Cloud Storage in CData Connect AI and insert Google Cloud Storage into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to FreshBooks Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live FreshBooks.
-
Query Teamwork Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Teamwork and perform CRUD operations on Teamwork from Node.js.
-
Connect to Adobe Commerce Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Adobe Commerce Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Impala Data from PowerBuilder via JDBC
This article demonstrates how to access Apache Impala from PowerBuilder using the Impala JDBC Driver.
-
Connect to Google Contacts Data in DBeaver
Use the CData ODBC Driver to connect to Google Contacts in DBeaver.
-
Build Pipelines with Live Amazon S3 Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Amazon S3 from Google Cloud Data Fusion, enabling the integration of live Amazon S3 into the building and management of effective data pipelines.
-
Integrating Dataiku with Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Avalara AvaTax.
-
Integrating Kiro CLI with VWO Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Create Sage 200-Connected Dashboards in Grafana
Connect to Sage 200 Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Sage 200.
-
Rapidly Develop Cloudant-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Cloudant.
-
Provide OData Services of Deel Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Deel by developing a WCF Service Application.
-
Work with ConstantContact Data in FoxPro
Load ConstantContact into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Multiple ShipEngine Accounts via the CData Sync CLI
Replicate multiple ShipEngine accounts to one or many databases.
-
Integrating Cursor CLI with OnePageCrm Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Connect to CloudConvert Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time CloudConvert using standard SQL.
-
Connect to Reckon Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Reckon and the SQL Gateway to access Reckon from Google Apps Script.
-
Publish Omnisend-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Omnisend.
-
Create Reports with SparkPost Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SparkPost.
-
Use the CData ODBC Driver for Mailgun in Microsoft Power Query
You can use the CData Mailgun ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Mailgun into Microsoft Power Query.
-
Design BIRT Reports on Sendwithus Data
Provide current Sendwithus to your embedded analytics.
-
Build Certinia-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Certinia Data and create custom apps in Mendix.
-
Access Autopilot Data from MySQL in PHP
Connect to Autopilot through the standard MySQL libraries in PHP.
-
Integrating OpenCode Terminal with Moosend Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Tally Reporting in OBIEE with the Tally JDBC Driver
Deploy the Tally JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous SAP Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAP replication to MongoDB.
-
Extend Google Sheets with Exa Data
Make calls to Exa from Google Apps Script via the API Server.
-
Validate Tickspot Data with QuerySurge
Access and validate Tickspot in QuerySurge using the CData JDBC Driver.
-
How to Connect the Power BI Service to Elasticsearch: Complete Guide
Connect to the CData Software Power BI Connector for Elasticsearch from PowerBI.com to provide real-time Elasticsearch across the organization.
-
Use Dash to Build to Web Apps on Recurly Data
Create Python applications that use pandas and Dash to build Recurly-connected web apps.
-
Access Xero Data from MySQL in PHP
Connect to Xero through the standard MySQL libraries in PHP.
-
Access Live SAP Concur Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Concur from your Excel spreadsheets.
-
Create Dynamic ChartMogul Grids Using the Infragistics XamDataGrid
Learn how you can connect ChartMogul to Infragistics XamDataGrid to build dynamic grids.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Foursquare
Provide connectivity to Foursquare through an SAP BusinessObjects universe.
-
How to Access Live Freshservice Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Freshservice from the Cline extension in Visual Studio Code.
-
Easily Integrate ScrapingBee Data in Lazarus Pascal IDE
Learn how to easily integrate live ScrapingBee in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData ODBC Driver for iContact
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for iContact.
-
Query ZarMoney Data in ColdFusion
Write standard ColdFusion data access code to connect to ZarMoney.
-
LINQ to ShipStation Data
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 ShipStation Data Provider.
-
Connect AdRoll to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live AdRoll using the CData Python MCP Server.
-
Enable the Invoiced JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Invoiced.
-
A PostgreSQL Interface for Epicor Kinetic Data (MySQL Remoting via JDBC)
Use the Remoting features of the Epicor Kinetic JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Informatica Mappings From/To a JDBC Data Source for Cloudant
Create Cloudant data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData Software JDBC Driver for Adobe Commerce in MicroStrategy Web
Connect to Adobe Commerce in MicroStrategy Web using the CData Software JDBC Driver for Adobe Commerce.
-
Integrating Cursor CLI with Salesforce Marketing Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Getting Started with the CData SSIS Components for Shortcut
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Shortcut.
-
Integrating ServiceNow Data in Talend Cloud Data Management Platform
Connect ServiceNow Data with Talend Cloud Data Management Platform using the CData JDBC Driver for ServiceNow.
-
Bidirectional Access to Excel Online Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Excel Online in Filemaker Pro for Mac or Windows.
-
How to Connect to Microsoft Teams Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft Teams. Leverage the pyodbc module for ODBC in Python.
-
Operational Reporting on Slack Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Slack.
-
Automate Raisers Edge NXT Data Replication to Azure Synapse
Use CData Sync to customize and automate Raisers Edge NXT replication to Azure Synapse.
-
Build Bullhorn CRM-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Bullhorn CRM to explore live Bullhorn CRM Data in Claude Code to assist with building Bullhorn CRM-powered applications.
-
Enable the Telegram JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Telegram.
-
Automate Pinterest Data Replication to Couchbase
Use CData Sync to Customize and automate Pinterest replication to Couchbase.
-
Use Claude to Talk to Your Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Oracle HCM Cloud for you.
-
Build Semantic Layer Views for Google Ad Manager Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Ad Manager.
-
Rapidly Develop iContact-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by iContact.
-
How to Connect to Google Ad Manager Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Ad Manager. Leverage the pyodbc module for ODBC in Python.
-
Migrating data from Landbot to Google BigQuery using CData SSIS Components.
Easily push Landbot to Google BigQuery using the CData SSIS Tasks for Landbot and Google BigQuery.
-
Connect to Microsoft Planner Data from AWS Glue
Use CData Connect AI to gain access to live Microsoft Planner from your AWS Glue jobs.
-
Integrating LlamaIndex with DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on IBM DB2 in real time.
-
How to publish and share Tavily Data dashboards with Tableau Server
The CData ODBC driver for Tavily enables you integrate Tavily into Tableau dashboards.
-
Use Claude to Talk to Your Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Azure Synapse for you.
-
How to Visualize Act CRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live Act CRM in Python.
-
Use the CData Software ODBC Driver for Google Forms in MicroStrategy Web
Connect to Google Forms in MicroStrategy Web using the CData Software ODBC Driver for Google Forms.
-
Connect Excel Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft Excel using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Edit and Search Printify External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Printify to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Printify objects that you can access from apps and the dashboard.
-
Create Apps from Basecamp Data in Qlik Sense Cloud
Use CData Connect AI to connect to Basecamp Data and build apps from live Basecamp in Qlik Sense Cloud.
-
Connect to AdRoll Data in CloverDX (formerly CloverETL)
Transfer AdRoll using the visual workflow in the CloverDX data integration tool.
-
Create Dashboards and Visualize Live Cvent Data in Geckoboard
Use CData Connect AI to connect to live Cvent and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Dotmailer Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Dotmailer replication to OneLake in Microsoft Fabric.
-
Getting Started with the CData Tableau Connector for AdRoll
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Insightly Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Insightly replication to Google BigQuery.
-
Integrating GitHub Copilot CLI with SAP SuccessFactors via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Connect FormSite Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your FormSite using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Microsoft Dataverse-Connected Business Apps in AppSheet
Connect to Microsoft Dataverse Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft Dataverse (CDS).
-
Build Box-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Box.
-
Connect to Power BI XMLA Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Power BI XMLA in the Denodo Virtual DataPort Administrator.
-
Design BIRT Reports on MongoDB Data
Provide current MongoDB to your embedded analytics.
-
Build Automated AlloyDB-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google AlloyDB and build automated workflows in Zapier.
-
Stream WooCommerce Data into Apache Kafka Topics
Access and stream WooCommerce in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Consume Oracle HCM Cloud OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Oracle HCM Cloud feeds that reflect any changes in SAP Lumira.
-
Integrate with Float Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Float to a JSON file on disk.
-
Build Data Flows from Spotify to SQL Server using SSIS
Easily back up Spotify to SQL Server using the SSIS components for Spotify.
-
Object-Relational Mapping (ORM) with SAP HANA XS Advanced Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SAP HANA XS Advanced into a Java-based ORM framework, Hibernate.
-
Use the CData API Server to Access Guru Data in Microsoft PowerPivot
Use the CData API Server to connect to live Guru in the Power Pivot business intelligence tool.
-
Create SSAS Tabular Models from Bitbucket Data
How to build a SQL Server Analysis Service Tabular Model from Bitbucket using CData drivers.
-
Getting Started with the CData JDBC Driver for Sage Intacct
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Sage Intacct.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed MongoDB to Power BI dashboards. Simply drag and drop MongoDB into data visuals on the Power BI canvas.
-
How to create Visio diagrams from Slack Data
Automatically update Slack with the changes you make to Visio master shapes.
-
Automated Continuous Yelp Replication to SQL Server
Use CData Sync for automated, continuous, customizable Yelp replication to SQL Server.
-
Access Live Jira Data in Coginiti Pro
Connect to and query live Atlassian Jira from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use Dash to Build to Web Apps on Oracle Eloqua Data
Create Python applications that use pandas and Dash to build Oracle Eloqua-connected web apps.
-
Build Square-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Square Data and create custom apps in Bubble.
-
Automated Continuous Zoho Projects Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Zoho Projects replication to IBM DB2.
-
Publish Crystal Reports on LeadDesk Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date LeadDesk.
-
Visualize Live MongoDB Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live MongoDB into custom reports in Power BI.
-
Connect to SAP BusinessObjects BI Data from a Connection Pool in Jetty
The SAP BusinessObjects BI JDBC Driver supports connection pooling: This article shows how to connect faster to SAP BusinessObjects BI from Web apps in Jetty.
-
Viewing Missive Data in RAD Studio Data Explorer
How to view Missive in RAD Studio Data Explorer using the CData ODBC Driver for Missive.
-
DataBind Charts to Bannerbear Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Bannerbear 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.