CData Software - Knowledge Base
Recent Articles
-
Visualize Live Dynamics 365 Business Central Data in the Power BI Service
Use CData Connect AI to connect to live Dynamics 365 Business Central data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Data Flows from FHIR to SQL Server using SSIS
Easily back up FHIR data to SQL Server using the SSIS components for FHIR.
-
Integrate Theia IDE with Live Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Email data from within the development environment.
-
Automated Continuous Impala Replication to Vertica
Use CData Sync for automated, continuous, customizable Impala replication to Vertica.
-
Design BIRT Reports on Adobe Target Data
Provide current Adobe Target data to your embedded analytics.
-
Connect Rootly to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Rootly data using the CData Python MCP Server.
-
Analyze Bannerbear Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Bannerbear data in Microsoft R Open.
-
Automate Marketo Data Replication to Azure Data Lake
Use CData Sync to customize and automate Marketo data replication to Azure Data Lake.
-
Natively Connect to Google Directory Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Directory data. Leverage the native support for ODBC in PHP.
-
Integrate Goose with Live MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live MySQL data from within the local AI agent.
-
Integrate Theia IDE with Live IBM Informix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live IBM Informix data from within the development environment.
-
Use Claude to Talk to Your SurveyMonkey 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 SurveyMonkey data for you.
-
Getting Started with the CData ODBC Driver for SingleStore
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SingleStore.
-
Publish Reports with BigQuery Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date BigQuery data.
-
DataBind Charts to Microsoft Ads Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Ads data 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.
-
Integrate with Live Twitter Ads Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Twitter Ads from the MuleSoft Anypoint Platform to integrate live Twitter Ads data into custom reports and dashboards.
-
Use JayDeBeApi to access Aircall Data in Python
Use standard Python scripting and the development environment of your choice to access live Aircall data.
-
Connect to Samanage Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Samanage data using standard SQL.
-
Build Dashboards with Codat Data in Dundas BI
Create dynamic dashboards and perform analytics based on Codat data in Dundas BI.
-
Connect and Query Live CockroachDB Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live CockroachDB data into Databricks and enable direct, live querying and analysis without replication.
-
How to Connect to & Open Exa Data in Microsoft Excel
This article uses the CData ODBC driver for Exa to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Square-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Square data and build Square-connected web apps with Axios.
-
Connect to Perigon Data in Jaspersoft Studio
Execute SQL to remote Perigon data in Jaspersoft Studio.
-
Load QuickBooks Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load QuickBooks data to a database.
-
Getting Started with the CData Python Connector for Deel
Learn to install and license the CData Python Connector and configure a connection to live Deel data.
-
Create SAP HANA XS Advanced Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP HANA XS Advanced data access from reports, embedded analytics, and more.
-
Automated FreshBooks Data Replication to Teradata
Use CData Sync to Customize and automate FreshBooks data replication to Teradata.
-
Build Data Flows from Invoiced to SQL Server using SSIS
Easily back up Invoiced data to SQL Server using the SSIS components for Invoiced.
-
Connect to SAP HANA Data in DBArtisan
Use wizards in DBArtisan to configure SAP HANA data as a data source.
-
Build Twitter Ads-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Twitter Ads data and build Twitter Ads-connected web apps with Axios.
-
Connect to TigerGraph Data from a Connection Pool in Jetty
The TigerGraph JDBC Driver supports connection pooling: This article shows how to connect faster to TigerGraph data from Web apps in Jetty.
-
Automated Continuous SAP ByDesign Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Oracle.
-
DataBind Controls to Hive Data in Delphi
DataBind to Hive data in Delphi with standard data access components and controls.
-
Connect to ConvertKit Data from a Connection Pool in Jetty
The ConvertKit JDBC Driver supports connection pooling: This article shows how to connect faster to ConvertKit data from Web apps in Jetty.
-
How to connect to ConvertKit Data from Spring Boot
Connect to ConvertKit in a Spring Boot Application using the CData API Driver for JDBC
-
Feed Copper Data into FineReport
How to set Copper data as a JDBC data source in FineReport.
-
How to Query Live Google Forms Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Forms data data in natural language using Python.
-
Bind Live Sage Intacct Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Sage Intacct data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Creating Tavily-Connected Applications in Unqork
You can use CData Connect AI to feed Tavily data to Unqork and build custom business apps.
-
Import Real-Time OpenWeatherMap Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use OpenWeatherMap data in ColdFusion.
-
ETL Excel Online in Oracle Data Integrator
This article shows how to transfer Excel Online data into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData Power BI Connector for LaunchDarkly
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Use Biml to Build SSIS Tasks to Replicate JobNimbus Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate JobNimbus data to SQL Server.
-
Analyze eBay Analytics Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for eBay Analytics from Power Pivot. You will use the Table Import Wizard to load eBay Analytics data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Paymo Data in RazorSQL
Connect to Paymo from wizards and query Paymo data from the GUI in the RazorSQL database management tool.
-
Connect OneNote Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your OneNote data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Visualize Live Spark Data in the Power BI Service
Use CData Connect AI to connect to live Spark data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Access Keap Data Using Entity Framework
This article shows how to access Keap data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData ODBC Driver for Zoho Creator in Microsoft Power Query
You can use the CData Zoho Creator ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Zoho Creator data into Microsoft Power Query.
-
Integrate Real-Time Access to Presto in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Presto data in real time.
-
Getting Started with the CData ADO.NET Provider for Bitbucket
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Bitbucket.
-
Access Live Trello Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Trello data through MCP integration.
-
How to Access Bugsnag Data Using Entity Framework
This article shows how to access Bugsnag data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build SAP Business One Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Business One data and build visualizations in Tableau Cloud.
-
Build Visualizations of Highrise Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Highrise data in Birst.
-
Access Mailjet Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Mailjet data from HeidiSQL.
-
Object-Relational Mapping (ORM) with Stripe 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 Stripe data into a Java-based ORM framework, Hibernate.
-
Connect to Real-Time Gumroad Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Gumroad data in Power Apps.
-
How to use SQLAlchemy ORM to access Scrapfly Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Scrapfly data.
-
Build Automated Workflows with Live Cassandra Data in Workato
Use CData Connect AI to connect to live Cassandra data and build automated workflows in Workato.
-
How to Build an ETL App for Azure Data Catalog Data in Python with CData Connect AI
Extract and transform live Azure Data Catalog data in Python with petl and the CData Connect AI Python SDK.
-
Build Guru-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Guru data without replication.
-
Access Live Anaplan Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Anaplan data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous MYOB AccountRight Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to PostgreSQL.
-
A PostgreSQL Interface for Klipfolio Data (MySQL Remoting via JDBC)
Use the Remoting features of the Klipfolio JDBC Driver to create a PostgreSQL entry-point for data access.
-
ETL Odoo in Oracle Data Integrator
This article shows how to transfer Odoo data into a data warehouse using Oracle Data Integrator.
-
Use Microsoft Copilot Studio to talk to your Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Amazon S3 data for you.
-
Automated Continuous PabblySubscriptions Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Google BigQuery.
-
Automated Continuous Yelp Replication to MongoDB
Use CData Sync for automated, continuous, customizable Yelp replication to MongoDB.
-
Replicate CapsuleCRM Data to Multiple Databases via the CData Sync CLI
Replicate CapsuleCRM data to disparate databases with a single configuration.
-
Build a PostgreSQL Interface for IBM Informix Data using the CData JDBC Driver
Use the Remoting features of the IBM Informix JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Microsoft Entra ID Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Microsoft Entra ID from Power Pivot. You will use the Table Import Wizard to load Microsoft Entra ID data. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Bugsnag Data in TIBCO Spotfire through ADO.NET
Integrate Bugsnag data into dashboards in TIBCO Spotfire.
-
Use CData Connect AI to Access Marketo Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Marketo data in the Power Pivot business intelligence tool.
-
Integrate Theia IDE with Live Sage 300 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Sage 300 data from within the development environment.
-
Integrate Amazon Marketplace Data in the Pentaho Report Designer
Publish reports based on Amazon Marketplace data in the Pentaho BI tool.
-
How to update Google Contacts from Excel
This article explains how to transfer data from Excel to Google Contacts using the Excel Add-In for Google Contacts.
-
Use the CData Software ODBC Driver for SAP Ariba Procurement in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP Ariba Procurement data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP Ariba Procurement.
-
Connect to SAS xpt Data in Ruby
Connect to SAS xpt data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build a PostgreSQL Interface for Google Search Results using the CData JDBC Driver
Use the Remoting features of the Google Search JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live SAP SuccessFactors 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 SuccessFactors data for you.
-
How to connect to Billsby Data in DBVisualizer
Integrate Billsby data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Redshift-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Redshift Data and create custom apps in Mendix.
-
Choosing the Best Method to Connect Sage Cloud Accounting to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sage Cloud Accounting data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to create an RPA flow for Google Ad Manager Data in UiPath Studio
Use the Google Ad Manager ODBC Driver to create workflows that access real-time Google Ad Manager data without any coding.
-
Replicate GetResponse Data in Heroku for Use in Salesforce Connect
Replicate GetResponse data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Semantic Layer Views for Elorus Data in APOS Live Data Gateway
Use the CData Connector for Elorus in APOS Live Data Gateway to build Semantic Layer Views for Elorus data.
-
Connect to Mocean Data in Ruby
Connect to Mocean data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Analyze Mode Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Mode data in Microsoft R Open.
-
Validate BigQuery Data with QuerySurge
Access and validate BigQuery data in QuerySurge using the CData JDBC Driver.
-
Build Apps with Live Nethunt Data Using the Low-Code Development Platform of Mendix
Connect Nethunt data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to SAP Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP in FileMaker Pro to connect to SAP and work with SAP data in your FileMaker applications.
-
Integrate Google's Vertex AI Agent with Live Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Zuora data within intelligent workflows.
-
Import Real-Time OnePageCrm Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use OnePageCrm data in ColdFusion.
-
Build Data Flows from SQL Server to SuiteCRM through SSIS
Easily push SQL Server data to SuiteCRM using the CData SSIS Tasks for SuiteCRM.
-
Integrate with Live Act CRM Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Act CRM from the MuleSoft Anypoint Platform to integrate live Act CRM data into custom reports and dashboards.
-
Integrate PhantomBuster Data in Pentaho Data Integration
Build ETL pipelines based on PhantomBuster data in the Pentaho Data Integration tool.
-
Visualize Live PayPal Data in the Power BI Service
Use CData Connect AI to connect to live PayPal data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Informatica Mappings From/To a JDBC Data Source for LinkedIn
Create LinkedIn data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous PolarTeamPro Replication to Databricks
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to Databricks.