CData Software - Knowledge Base
Recent Articles
-
How to Access Google Campaign Manager 360 Data Using Entity Framework
This article shows how to access Google Campaign Manager 360 using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Publish Reports with Salesforce Data 360 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Salesforce Data 360.
-
How to Work with Amazon Marketplace Data in ETL Validator JDBC
Connect to Amazon Marketplace from ETL Validator jobs using the CData Software JDBC Driver.
-
Creating Airtable-Connected Applications in Unqork
You can use CData Connect AI to feed Airtable to Unqork and build custom business apps.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Gong
Provide connectivity to Gong through an SAP BusinessObjects universe.
-
How to Connect Asana Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Asana data in real time using natural language.
-
How to Connect to Live Dropbox Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Dropbox for you.
-
Integrating OpenCode Terminal with Exa 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.
-
How to Build an ETL App for ChartMogul Data in Python with CData
Create ETL applications and real-time data pipelines for ChartMogul in Python with petl.
-
Automate Xero Data Replication to Couchbase
Use CData Sync to Customize and automate Xero Accounting replication to Couchbase.
-
Create Cosmos DB-Connected Applications in Appsmith
Connect to Cosmos DB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Azure Cosmos DB.
-
Configure the CData JDBC Driver for Zoho Inventory in a Connection Pool in Tomcat
Connect to Zoho Inventory from a connection pool in Tomcat.
-
Build Apps with Live Placid Data Using the Low-Code Development Platform of Mendix
Connect Placid with Mendix to build apps using the CData API Driver for JDBC.
-
Build a Singer.io Tap for Jodoo With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Jodoo data using
-
Automate SingleStore Data Replication to Azure Synapse
Use CData Sync to customize and automate SingleStore replication to Azure Synapse.
-
Create Dynamic Billsby Grids Using the Infragistics XamDataGrid
Learn how you can connect Billsby to Infragistics XamDataGrid to build dynamic grids.
-
Feed CapsuleCRM Data into FineReport
How to set CapsuleCRM as a JDBC data source in FineReport.
-
Integrating OpenCode Terminal with MailChimp 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.
-
Moving Data from Wistia to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Wistia data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to integrate Metabase with Bullhorn CRM Data
Use CData Connect AI to connect to live Bullhorn CRM and create an interactive dashboard in Metabase from Bullhorn CRM.
-
Use Biml to Build SSIS Tasks to Replicate Dotmailer Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Dotmailer to SQL Server.
-
Work with SendGrid Data in FoxPro
Load SendGrid into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Facebook Ads Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Facebook Ads from HeidiSQL.
-
Moving Data from Databricks to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Databricks data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate with Oracle Eloqua Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Oracle Eloqua to a JSON file on disk.
-
How to Access Live Slack Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Slack enables you to integrate Slack into workflows built using Microsoft Power Automate Desktop.
-
Integrate Apollo with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Apollo with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Apollo.
-
Build a PostgreSQL Interface for SAP SuccessFactors LMS Data using the CData JDBC Driver
Use the Remoting features of the SAP SuccessFactors LMS JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Easily Query Dynamics NAV Data in OpenOffice Base
Connect to Dynamics NAV data in OpenOffice Base using the CData ODBC Driver for Dynamics NAV and generate reports with live data insights.
-
Use the CData ODBC Driver for Billsby in Microsoft Power Query
You can use the CData Billsby ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Billsby into Microsoft Power Query.
-
View Reports on Real-Time Calendly Data in Power BI Report Server
Use the CData ODBC Driver for Calendly to visualize Calendly in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Apps with Live Azure Table Data Using the Low-Code Development Platform of Mendix
Connect Azure Table Storage with Mendix to build apps using the CData JDBC Driver for Azure Table.
-
Build Google Ads Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Ads and build visualizations in Tableau.
-
Create a Data Access Object for Webflow Data using JDBI
A brief overview of creating a SQL Object API for Webflow in JDBI.
-
How to Connect to Live SAP ByDesign Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SAP Business ByDesign for you.
-
Connect Amplitude to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Amplitude using the CData Python MCP Server.
-
Integrate QuickBooks Data in the Pentaho Report Designer
Publish reports based on QuickBooks Desktop in the Pentaho BI tool.
-
How to work with Tavily Data in Apache Spark using SQL
Access and process Tavily Data in Apache Spark using the CData Software JDBC Driver.
-
Import Real-Time Moosend Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Moosend in ColdFusion.
-
Build Apps with Live Bitbucket Data Using the Low-Code Development Platform of Mendix
Connect Bitbucket with Mendix to build apps using the CData JDBC Driver for Bitbucket.
-
How to work with Slack Data in Apache Spark using SQL
Access and process Slack Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate with live MailChimp Data in Jitterbit
Use CData Connect AI to connect to and integrate live MailChimp in Jitterbit.
-
Automate Zoho CRM Data Replication to Azure Data Lake
Use CData Sync to customize and automate Zoho CRM replication to Azure Data Lake.
-
ETL Webflow in Oracle Data Integrator
This article shows how to transfer Webflow into a data warehouse using Oracle Data Integrator.
-
How to Query Autopilot Data in MySQL Workbench
Execute MySQL queries against live Autopilot from MySQL Workbench.
-
Deploy the ADO.NET Provider for Mailgun on an SSRS Report Server
Connect to Mailgun 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.
-
A PostgreSQL Interface for MYOB AccountRight Data using the CData ODBC Driver
Use the SQL Gateway and MYOB AccountRight ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build API Visualizations in Tableau Desktop
Use CData Connect AI to connect to live API and build visualizations in Tableau.
-
Connect to FreeAgent Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time FreeAgent using standard SQL.
-
How to create Visio diagrams from Office 365 Data
Automatically update Microsoft Office 365 with the changes you make to Visio master shapes.
-
Use Dash to Build to Web Apps on Pingdom Data
Create Python applications that use pandas and Dash to build Pingdom-connected web apps.
-
Use the CData Software ODBC Driver for Mailgun in SAS for Real-Time Reporting and Analytics
Connect to real-time Mailgun in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Mailgun.
-
Build a PostgreSQL Interface for ZarMoney Data using the CData JDBC Driver
Use the Remoting features of the ZarMoney JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Todoist Data 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 Todoist.
-
Getting Started with the CData JDBC Driver for Planio
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Planio.
-
Integrate Insightly with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Insightly with External Services.
-
Connect to Jira Assets Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Jira Assets in the Denodo Virtual DataPort Administrator.
-
Build Azure Synapse Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Azure Synapse and build visualizations in Tableau Cloud.
-
How to integrate MYOB AccountRight with Apache Airflow
Access and process MYOB AccountRight in Apache Airflow using the CData JDBC Driver.
-
Connect to Ontraport Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating Antigravity CLI with Microsoft Excel Online via CData CLI
Connect Microsoft Excel Online to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to HCL Domino Data as an External Source in Dremio
Use the CData JDBC Driver to connect to HCL Domino as an External Source in Dremio.
-
Visualize Live Tally Data in the Power BI Service
Use CData Connect AI to connect to live Tally ERP and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Certinia Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Certinia from HeidiSQL.
-
Visualize Accelo Data in Tableau
The CData ODBC driver for Accelo enables you integrate Accelo into Tableau dashboards.
-
Moving Data from Rebilly to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Rebilly data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Query Oracle Sales Data in DataGrip
Create a Data Source for Oracle Sales in DataGrip and use SQL to query live Oracle Sales.
-
Analyze Snapchat Ads Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Snapchat Ads and visualize live Snapchat Ads in Infragistics Reveal.
-
DataBind Snowflake Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Snowflake with the DevExpress Windows Forms and Web controls to provide Snowflake to a chart.
-
How to Connect to Live SAP Fieldglass Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SAP Fieldglass for you.
-
Connect to Real-Time SharePoint Excel Services Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SharePoint Excel Services and Dataflow to import and use SharePoint Excel Services in Power Apps.
-
DataBind Controls to Excel Online Data in Delphi
DataBind to Microsoft Excel Online in Delphi with standard data access components and controls.
-
Integrate Goose with Live SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP Hybris C4C from within the local AI agent.
-
Work with Tanda Data in FoxPro
Load Tanda into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate with Live DB2 Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to DB2 from the MuleSoft Anypoint Platform to integrate live IBM DB2 into custom reports and dashboards.
-
Migrating data from Raisers Edge NXT to Databricks using CData SSIS Components.
Easily push Raisers Edge NXT to Databricks using the CData SSIS Tasks for Raisers Edge NXT and Databricks.
-
Automated Continuous HelloSign Replication to Amazon S3
Use CData Sync for automated, continuous, customizable HelloSign replication to Amazon S3.
-
Automated Continuous Google Analytics Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Analytics replication to Google BigQuery.
-
Build Dashboards with Paddle Data in DBxtra
Create dynamic dashboards and perform analytics based on Paddle in DBxtra.
-
Connect to Google Drive from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Drive, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Customer.io Data in Ruby
Connect to Customer.io in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Data Flows from Google Search to SQL Server using SSIS
Easily back up Google Search to SQL Server using the SSIS components for Google Search.
-
Build Semantic Layer Views for MessageBird Data in APOS Live Data Gateway
Use the CData Connector for MessageBird in APOS Live Data Gateway to build Semantic Layer Views for MessageBird.
-
Build Dashboards with Oracle Sales Data in DBxtra
Create dynamic dashboards and perform analytics based on Oracle Sales in DBxtra.
-
Create Informatica Mappings From/To an ODBC Data Source for eBay
Create an ODBC connection to eBay in Informatica and browse and transfer eBay.
-
Use the CData Software JDBC Driver for Trello in MicroStrategy Web
Connect to Trello in MicroStrategy Web using the CData Software JDBC Driver for Trello.
-
Explore Geographical Relationships in Azure Table Data with Power Map
Create data visualizations with Azure Table Storage in Power Map.
-
Create Sage Cloud Accounting-Connected Nintex Workflows
Use CData Connect AI to connect to Sage Cloud Accounting Data from Nintex Workflow Cloud and build custom workflows using live Sage Business Cloud Accounting.
-
Edit and Search Facebook Ads External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Facebook Ads to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Facebook Ads objects that you can access from apps and the dashboard.
-
Extract, Transform, and Load Cohere Data in Informatica PowerCenter
Create a simple Workflow for Cohere in Informatica PowerCenter.
-
Connecting Agentforce with WordPress Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your WordPress for you.
-
How to Connect DBeaver to Accelo via a JDBC Driver
Manage Accelo with visual tools in DBeaver like the query browser.
-
Access Tavily Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Tavily from your Oracle system.
-
How to connect PolyBase to Bannerbear
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Bannerbear.
-
Connect to Salesforce Data in HULFT Integrate
Connect to Salesforce as a JDBC data source in HULFT Integrate
-
Connect to ConstantContact Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to ConstantContact and work with ConstantContact in your FileMaker application.
-
Visualize Live SpaceX Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SpaceX.
-
Build Microsoft Planner-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Planner and build web apps with connectivity to live Microsoft Planner.
-
Build a Singer.io Tap for Keap With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Keap data using
-
Connect to Foursquare Data in RazorSQL
Connect to Foursquare from wizards and query Foursquare from the GUI in the RazorSQL database management tool.