CData Software - Knowledge Base
Recent Articles
-
How to connect SharePoint with FHIR Data through external lists
Provide FHIR data to SharePoint users as an external list.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Avro
Provide connectivity to Avro data through an SAP BusinessObjects universe.
-
How to integrate Hubstaff with Apache Airflow
Access and process Hubstaff data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous FreeAgent Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable FreeAgent replication to Google Cloud SQL.
-
Process & Analyze Omnisend Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Omnisend Data.
-
Automated Continuous Wistia Replication to Vertica
Use CData Sync for automated, continuous, customizable Wistia replication to Vertica.
-
Query Live Microsoft OneDrive Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Microsoft OneDrive data directly from the development environment.
-
Connect to Exa 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 Exa data.
-
Load MailerSend Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load MailerSend data to a database.
-
Access Live CapsuleCRM 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 CapsuleCRM data through MCP integration.
-
Connect to FTP Data from AWS Glue
Use CData Connect AI to gain access to live FTP data from your AWS Glue jobs.
-
Use Dash to Build Web Apps on Power BI XMLA Data via CData Connect AI
Build interactive Dash web apps on live Power BI XMLA data using pandas and the CData Connect AI Python SDK.
-
How to Connect to & Open Front Data in Microsoft Excel
This article uses the CData ODBC driver for Front to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Migrating data from Unbounce to Databricks using CData SSIS Components.
Easily push Unbounce data to Databricks using the CData SSIS Tasks for Unbounce and Databricks.
-
How to Connect to Live Wistia 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 Wistia data for you.
-
Access Live Egnyte Data in Coginiti Pro
Connect to and query live Egnyte data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating Cursor with Salesforce 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.
-
Access Live Microsoft OneDrive Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft OneDrive data from your Google Sheets.
-
Create Dynamic HubSpot Grids Using the Infragistics XamDataGrid
Learn how you can connect HubSpot to Infragistics XamDataGrid to build dynamic grids.
-
Use Agno to Talk to Your Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Zoho Books data for you.
-
Access Live Bannerbear Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Bannerbear data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Natively Connect to Avaza Data in PHP
The CData ODBC driver for Avaza enables you to create PHP applications with connectivity to Avaza data. Leverage the native support for ODBC in PHP.
-
Analyze Box Data in Looker
Use CData Connect AI to connect to Box Data from Looker and build custom apps using live Box data.
-
Getting Started with the CData Excel Add-In for Campaigner
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Campaigner.
-
Back Up SuiteCRM data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SuiteCRM. In this article, we will employ an SSIS workflow to populate a database with SuiteCRM data data.
-
Build an OLAP Cube in SSAS from Acumatica Data
Establish a connection to Acumatica data data from SQL Server Analysis Services, and use the Acumatica Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Informatica Mappings From/To an ODBC Data Source for Freshsales
Create an ODBC connection to Freshsales in Informatica and browse and transfer Freshsales data.
-
DataBind Charts to Codat Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Codat 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.
-
Create Datasets from Google Search in Domo Workbench and Build Visualizations of Google Search Results in Domo
Use the CData Software ODBC Driver for Google Search to create datasets from Google Search results in Domo Workbench and then build visualizations in the Domo service.
-
Visualize Live Twitter Ads Data in the Power BI Service
Use CData Connect AI to connect to live Twitter Ads data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Use a Microsoft Access Database to Update Cloudant Data in Real Time
Update Cloudant data by creating a linked table in Microsoft Access with the CData Cloudant ODBC Driver.
-
Import Real-Time Omnisend Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Omnisend data in ColdFusion.
-
Provide OData Services of MariaDB Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for MariaDB data by developing a WCF Service Application.
-
Getting Started with the CData Python Connector for SAP Hybris C4C
Learn to install and license the CData Python Connector and configure a connection to live SAP Hybris C4C data.
-
How to Access HBase Data Using Entity Framework
This article shows how to access HBase data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Building Dynamic Web Pages with Microsoft Ads Data Using AngularJS
Create single-page applications with live connectivity to Microsoft Ads using the CData API Server.
-
How to Use a Microsoft Access Database to Update Wave Financial Data in Real Time
Update Wave Financial data by creating a linked table in Microsoft Access with the CData Wave Financial ODBC Driver.
-
Query Reckon Accounts Hosted Data as a SQL Server Database in Node.js
Execute SQL Server queries against Reckon Accounts Hosted data from Node.js.
-
Integrating Boomi Agentstudio with MailerLite Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to MailerLite data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Getting Started with the CData Power BI Connector for Humanity
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Getting Started with the CData Tableau Connector for Vercel
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create Reports from QuickBooks Data in Looker Studio
Use CData Connect AI to gain access to live QuickBooks data and create custom reports in Looker Studio.
-
Object-Relational Mapping (ORM) with BigQuery 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 BigQuery data into a Java-based ORM framework, Hibernate.
-
Integrating Antigravity CLI with Cvent data via CData CLI
Connect Cvent data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData SSIS Components for Cloudant
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Cloudant.
-
Replicate Multiple Pipeline CRM Accounts via the CData Sync CLI
Replicate multiple Pipeline CRM accounts to one or many databases.
-
Connect to Live SageHR Data in MicroStrategy through CData Connect AI
Create a live connection to SageHR Data in CData Connect AI and connect to your SageHR data from MicroStrategy.
-
Import Real-Time Zoho Projects Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zoho Projects data in ColdFusion.
-
Automated Continuous Webex Replication to Snowflake
Use CData Sync for automated, continuous, customizable Webex replication to Snowflake.
-
How to publish and share YouTube Analytics Data dashboards with Tableau Server
The CData ODBC driver for YouTube Analytics enables you integrate YouTube Analytics data into Tableau dashboards.
-
Build MVC Applications with Connectivity to Contentful Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Contentful from an ASP.NET MVC application.
-
Connect to Couchbase Data from Crystal Reports
Use CData Connect AI to connect to and report on live Couchbase data from Crystal Reports.
-
Explore Geographical Relationships in Office 365 Data with Power Map
Create data visualizations with Office 365 data in Power Map.
-
LINQ to Zoho CRM 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 Zoho CRM Data Provider.
-
Easily Integrate Mailgun Data in Lazarus Pascal IDE
Learn how to easily integrate live Mailgun data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Certinia Data from PowerBuilder via JDBC
This article demonstrates how to access Certinia data from PowerBuilder using the Certinia JDBC Driver.
-
Automated Continuous LightSpeedRetail Replication to AlloyDB
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to AlloyDB.
-
How to Connect to Live Google Search Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Search results securely in real time.
-
Extract, Transform, and Load Email Data in Informatica PowerCenter
Create a simple Workflow for Email data in Informatica PowerCenter.
-
Visualize Microsoft Ads Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft Ads data.
-
Integrating Gumloop with Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Sugar CRM data within automated workflows.
-
Create JSON Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time JSON data access from reports, embedded analytics, and more.
-
Connect to RabbitMQ Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for RabbitMQ to connect to RabbitMQ data and execute queries in PowerBuilder.
-
Automated Continuous Salesforce Marketing Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to IBM DB2.
-
Seamlessly Bring Redis Data into Retool Using CData Connect AI
Integrate Redis data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Visualize Vault CRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live Vault CRM data in Python.
-
Analyze Shopify Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Shopify data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Voice Agents in ElevenLabs with access to Live SAP Concur Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP Concur data.
-
Interact with Live Discord Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Discord data.
-
Operational Reporting on Redshift Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Redshift data.
-
Publish Crystal Reports on Timely Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Timely data.
-
Query TaxJar Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume TaxJar entities in PHP by modeling them as objects.
-
Create Dashboards and Visualize Live Smartsheet Data in Geckoboard
Use CData Connect AI to connect to live Smartsheet data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Getting Started with the CData ADO.NET Provider for ZohoPeople
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automate Kintone Data Replication to SAP HANA
Use CData Sync to customize and automate Kintone data replication to SAP HANA.
-
How to connect Amazon QuickSight to ZohoDesk Data
Create a connection to ZohoDesk data in CData Connect AI and insert ZohoDesk data into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Oracle Service Cloud Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to delimited files (CSV/TSV).
-
Access Live Teamwork Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Teamwork data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous SAP ByDesign Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Google BigQuery.
-
Create Data Visualizations in Cognos BI with Qualaroo Data
Access Qualaroo data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Agents in Relevance AI with Access to Live Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zoho Creator data within intelligent agent workflows.
-
Visualize Miro Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Miro data into TIBCO Spotfire.
-
Automated Continuous Highrise Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Highrise replication to Apache Cassandra.
-
How to import Azure Data Catalog Data into Apache Solr
Use the CData Software JDBC Driver for Azure Data Catalog in Data Import Handler and create an automated import of Azure Data Catalog data to Apache Solr Enterprise Search platform.
-
Integrating LangGraph with ServiceDesk Plus Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on ServiceDesk Plus data within automated workflows.
-
Automate Deel Data Replication to Azure Synapse
Use CData Sync to customize and automate Deel data replication to Azure Synapse.
-
How to Connect to Live LinkedIn Ads 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 LinkedIn Ads data for you.
-
Natively Connect to Browserless Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Browserless data. Leverage the native support for ODBC in PHP.
-
Manage Cosmos DB Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Cosmos DB.
-
Using the CData Software ODBC Driver for Drip in PyCharm
Connect to Drip as an ODBC data source in PyCharm using the CData Software ODBC Driver for Drip.
-
Connect to Planio 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 Planio and work with Planio data in your FileMaker application.
-
Automated Continuous SuiteCRM Replication to SQLite
Use CData Sync for automated, continuous, customizable SuiteCRM replication to SQLite.
-
How to Query Planio Data in MySQL Workbench
Execute MySQL queries against live Planio data from MySQL Workbench.
-
Visualize Live RSS Feeds in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live RSS feeds.
-
DataBind Controls to Stripe Data in C++Builder
DataBind to Stripe data in C++Builder with standard components and controls.
-
Integrating OpenCode with Planio 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.
-
Use Azure AI Foundry to Talk to Your Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Oracle data for you.
-
Interact with Live HCL Domino Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live HCL Domino data.
-
Perform Batch Operations with JDBC-ODBC Bridge Data in Apache NiFi
Connect to JDBC-ODBC Bridge data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Adobe Analytics from Asprova with CData Software ODBC Driver for Adobe Analytics
This article shows how to connect faster to Adobe Analytics data from Asprova.