CData Software - Knowledge Base
Recent Articles
-
Feed EnterpriseDB Data into FineReport
How to set EnterpriseDB data as a JDBC data source in FineReport.
-
A PostgreSQL Interface for LinkedIn Data (MySQL Remoting via JDBC)
Use the Remoting features of the LinkedIn JDBC Driver to create a PostgreSQL entry-point for data access.
-
Easily Integrate Tavily Data in Lazarus Pascal IDE
Learn how to easily integrate live Tavily data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live ADP Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live ADP data from your Excel spreadsheets.
-
Connect to CampaignMonitor Data as an External Source in Dremio
Use the CData JDBC Driver to connect to CampaignMonitor as an External Source in Dremio.
-
Access Live MailerLite Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to MailerLite data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Live Kintone Data in TIBCO Data Virtualization
Use the Kintone Tibco DV Adapter to create a Kintone data data source in TIBCO Data Virtualization Studio and gain access to live Kintone data from your TDV Server.
-
Build Voice Agents in ElevenLabs with access to Live Pipedrive Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Pipedrive data.
-
How to Work with Demio Data in AWS Glue Jobs Using JDBC
Connect to Demio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use JayDeBeApi to access Tally Data in Python
Use standard Python scripting and the development environment of your choice to access live Tally data.
-
Use the CData Software JDBC Driver for Adobe Experience Manager in MicroStrategy
Connect to Adobe Experience Manager data in MicroStrategy Developer using the CData Software JDBC Driver for Adobe Experience Manager.
-
How to work with ZarMoney Data in Apache Spark using SQL
Access and process ZarMoney Data in Apache Spark using the CData Software JDBC Driver.
-
A PostgreSQL Interface for Webex Data using the CData ODBC Driver
Use the SQL Gateway and Webex ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create a Data Access Object for Exa Data using JDBI
A brief overview of creating a SQL Object API for Exa data in JDBI.
-
Automated Continuous SAS xpt Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAS xpt replication to AlloyDB.
-
Use Claude to Talk to Your ShipEngine 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 ShipEngine data for you.
-
Migrating data from Act-On to Snowflake using CData SSIS Components.
Easily push Act-On data to Snowflake using the CData SSIS Tasks for Act-On and Snowflake.
-
Back Up Sentry data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Sentry data data.
-
Build Dashboards with Amazon Marketplace Data in DBxtra
Create dynamic dashboards and perform analytics based on Amazon Marketplace data in DBxtra.
-
Build Paymo Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Paymo data and build visualizations in Tableau Cloud.
-
ETL Cassandra in Oracle Data Integrator
This article shows how to transfer Cassandra data into a data warehouse using Oracle Data Integrator.
-
How to Connect to Live Sybase Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Sybase data for you.
-
How to Connect to Live Reckon Accounts Hosted Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Reckon Accounts Hosted data securely in real time.
-
How to import Brex Data into Apache Solr
Use the CData Software JDBC Driver for Brex in Data Import Handler and create an automated import of Brex data to Apache Solr Enterprise Search platform.
-
Consume Freshdesk OData Feeds in PowerBuilder
This article demonstrates how to consume Freshdesk data as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous Microsoft Ads Replication to MongoDB
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to MongoDB.
-
Work with Live AfterShip Data in Power Query
Use CData Connect AI to connect to AfterShip data and work with live AfterShip data in Microsoft Power Query.
-
Use Databricks Agent Bricks to Talk to Your SAP Ariba Source Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP Ariba Source data for you.
-
Build an OLAP Cube in SSAS from Foursquare Data
Establish a connection to Foursquare data data from SQL Server Analysis Services, and use the Foursquare Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize ShipStation Data in TIBCO Spotfire through ADO.NET
Integrate ShipStation data into dashboards in TIBCO Spotfire.
-
Use the CData Software ODBC Driver for Redshift in SAS for Real-Time Reporting and Analytics
Connect to real-time Redshift data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Redshift.
-
Connect to and Query ZeroBounce Data in QlikView over ODBC
Create data visualizations with ZeroBounce data in QlikView.
-
Access Live Freshservice Data in AWS Lambda
Connect to live Freshservice data in AWS Lambda using the CData JDBC Driver.
-
Connect to Copper Data in CloverDX (formerly CloverETL)
Transfer Copper data using the visual workflow in the CloverDX data integration tool.
-
Connect Salesforce to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Salesforce with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Trae with Live Vault CRM Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Vault CRM data from within the AI-powered IDE.
-
Access Onfleet Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Onfleet data from your Oracle system.
-
Query NASA Data in DataGrip
Create a Data Source for NASA in DataGrip and use SQL to query live NASA data.
-
Migrating data from OData to Google BigQuery using CData SSIS Components.
Easily push OData services to Google BigQuery using the CData SSIS Tasks for OData and Google BigQuery.
-
Integrating Kiro with TigerGraph 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.
-
Work with Zoho Recruit Data in FoxPro
Load Zoho Recruit data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live IBM Informix Data in AWS Lambda (with IntelliJ IDEA)
Connect to live IBM Informix data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Voice Agents in ElevenLabs with access to Live DB2 Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live DB2 data.
-
Create Dynamic Google Sheets Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Sheets to Infragistics XamDataGrid to build dynamic grids.
-
How to Easily Query Close Data in OpenOffice Base
Connect to Close data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build Apps with Live Teamgate Data Using the Low-Code Development Platform of Mendix
Connect Teamgate data with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous SparkPost Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SparkPost data replication to OneLake in Microsoft Fabric.
-
Connect to Live Impala Data in MicroStrategy through CData Connect AI
Create a live connection to Impala Data in CData Connect AI and connect to your Impala data from MicroStrategy.
-
Build Data Flows from SQL Server to SAP Ariba Source through SSIS
Easily push SQL Server data to SAP Ariba Source using the CData SSIS Tasks for SAP Ariba Source.
-
Use the CData Software JDBC Driver for Pipeliner CRM in MicroStrategy
Connect to Pipeliner CRM data in MicroStrategy Developer using the CData Software JDBC Driver for Pipeliner CRM.
-
Analyze Hive Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Hive from Power Pivot. You will use the Table Import Wizard to load Hive data. You can visually build the import query or use any SQL supported by the driver.
-
Create Google Calendar Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Calendar from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to FormSite Data in Jaspersoft Studio
Execute SQL to remote FormSite data in Jaspersoft Studio.
-
Using the CData Software ODBC Driver for Cohere in PyCharm
Connect to Cohere as an ODBC data source in PyCharm using the CData Software ODBC Driver for Cohere.
-
Integrate Dify with Live Databricks Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Databricks data.
-
How to Connect to & Open SQL Analysis Services Data in Microsoft Excel
This article uses the CData ODBC driver for SQL Analysis Services to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use JayDeBeApi to access Facebook Ads Data in Python
Use standard Python scripting and the development environment of your choice to access live Facebook Ads data.
-
Use the CData Software ODBC Driver for Sage Cloud Accounting in SAS for Real-Time Reporting and Analytics
Connect to real-time Sage Cloud Accounting data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Sage Cloud Accounting.
-
Explore Geographical Relationships in Zoho CRM Data with Power Map
Create data visualizations with Zoho CRM data in Power Map.
-
RabbitMQ Reporting in OBIEE with the RabbitMQ JDBC Driver
Deploy the RabbitMQ JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Easily Integrate Amplitude Data in Lazarus Pascal IDE
Learn how to easily integrate live Amplitude data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Informatica Mappings From/To a JDBC Data Source for Email
Create Email data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Access Live Jodoo Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Jodoo enables you to integrate Jodoo data into workflows built using Microsoft Power Automate Desktop.
-
Build Asana-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Asana data and build web apps with connectivity to live Asana data.
-
How to Connect to Live Yelp Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Yelp data for you.
-
Bind Live Kintone Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Kintone data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Extract, Transform, and Load Google Search Results in Informatica PowerCenter
Create a simple Workflow for Google Search results in Informatica PowerCenter.
-
Automated Continuous GetResponse Replication to Databricks
Use CData Sync for automated, continuous, customizable GetResponse replication to Databricks.
-
Access Live Calendly Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Calendly data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Bannerbear Reporting in OBIEE with the Bannerbear JDBC Driver
Deploy the Bannerbear JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Zoho CRM-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Zoho CRM data.
-
Integrating GitHub Copilot with Act-On 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.
-
Build Visualizations of GitLab Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of GitLab data in Birst.
-
Visualize EmailOctopus Data in Tableau
The CData ODBC driver for EmailOctopus enables you integrate EmailOctopus data into Tableau dashboards.
-
How to Access Live TaxJar Data in Power Automate Desktop via ODBC
The CData ODBC Driver for TaxJar enables you to integrate TaxJar data into workflows built using Microsoft Power Automate Desktop.
-
Perform Batch Operations with Databricks Data in Apache NiFi
Connect to Databricks data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Query, Visualize, and Share live SAP Business Warehouse Data in Redash
Use CData Connect AI to connect to live SAP Business Warehouse data in Redash for querying, visualizing, and sharing.
-
How to Easily Query FHIR Data in OpenOffice Base
Connect to FHIR data in OpenOffice Base using the CData ODBC Driver for FHIR and generate reports with live data insights.
-
How to Connect DBeaver to Amazon S3 via a JDBC Driver
Manage Amazon S3 data with visual tools in DBeaver like the query browser.
-
Connect to SFTP Data in Aqua Data Studio
Access SFTP data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to connect to Pinecone Data from Spring Boot
Connect to Pinecone in a Spring Boot Application using the CData API Driver for JDBC
-
Integrating Antigravity CLI with Mouseflow data via CData CLI
Connect Mouseflow data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating Kiro with Mocean 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 Dynamic PolarTeamPro Grids Using the Infragistics XamDataGrid
Learn how you can connect PolarTeamPro to Infragistics XamDataGrid to build dynamic grids.
-
Visualize SAP Hybris C4C 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 SAP Hybris C4C data into TIBCO Spotfire.
-
Publish Crystal Reports on XML Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date XML data.
-
Publish Reports with SAP Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP data.
-
How to integrate Google Search with Apache Airflow
Access and process Google Search results in Apache Airflow using the CData JDBC Driver.
-
Integrating Claude Code with Google Search Results via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Search results within assisted coding and automated development workflows.
-
How to Connect to Live HubDB Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your HubDB data through natural language.
-
Connect to HelloSign Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time HelloSign data using standard SQL.
-
Integrating OpenCode with Shippo 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.
-
Object-Relational Mapping (ORM) with Workday 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 Workday data into a Java-based ORM framework, Hibernate.
-
Getting Started with the CData JDBC Driver for IBM Cloud Object Storage
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for IBM Cloud Object Storage.
-
Build a Singer.io Tap for Aweber With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Aweber data using the CData Python Connector.
-
Use the CData ODBC Driver for Foursquare in Microsoft Power Query
You can use the CData Foursquare ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Foursquare data into Microsoft Power Query.
-
Connect to SAP Concur Data in Aqua Data Studio
Access SAP Concur data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Link SAP Business Warehouse with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP Business Warehouse data in Filemaker Pro for Mac or Windows.
-
Connecting GenSpark with DocuSign Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to DocuSign data without any replication or custom integration required.
-
Rapidly Develop Clio-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 Clio.