CData Software - Knowledge Base
Recent Articles
-
Using the CData Software ODBC Driver for eBay in PyCharm
Connect to eBay as an ODBC data source in PyCharm using the CData Software ODBC Driver for eBay.
-
Working with Cloudant Data in LINQPad
Execute LINQ queries to IBM Cloudant in LINQPad.
-
Analyze Zendesk Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Zendesk and visualize live Zendesk in Infragistics Reveal.
-
Build MVC Applications with Connectivity to Cohere Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Cohere from an ASP.NET MVC application.
-
Moving Data from MailChimp to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live MailChimp data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Visualize YouTube Analytics Data in TIBCO Spotfire through ADO.NET
Integrate YouTube Analytics into dashboards in TIBCO Spotfire.
-
How to Access Microsoft Exchange Data Using Entity Framework
This article shows how to access Microsoft Exchange using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Dashboards with ConvertAPI Data in Dundas BI
Create dynamic dashboards and perform analytics based on ConvertAPI in Dundas BI.
-
Use JayDeBeApi to access Elasticsearch Data in Python
Use standard Python scripting and the development environment of your choice to access live Elasticsearch.
-
Access Live Salesforce Marketing Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Salesforce Marketing Cloud from your Excel spreadsheets.
-
Write a Simple Go Application to work with Testmonitor Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Testmonitor.
-
SQL Analysis Services Reporting in OBIEE with the SQL Analysis Services JDBC Driver
Deploy the SQL Analysis Services JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating GitHub Copilot CLI with Apify 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.
-
Integrating LlamaIndex with ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on ADP in real time.
-
Automated Continuous Greenhouse Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Greenhouse replication to PostgreSQL.
-
Use the CData Software JDBC Driver for Unbounce in MicroStrategy
Connect to Unbounce in MicroStrategy Developer using the CData Software JDBC Driver for Unbounce.
-
Replicate Confluence Data to Multiple Databases via the CData Sync CLI
Replicate Atlassian Confluence to disparate databases with a single configuration.
-
Connect to PingOne Data in HULFT Integrate
Connect to PingOne as a JDBC data source in HULFT Integrate
-
Connect to SAS xpt from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAS XPORT, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate Live Google Cloud Storage Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Replicate Bullhorn CRM Data to Multiple Databases
Replicate Bullhorn CRM to disparate databases with a point-and-click configuration.
-
Automated Continuous Zoho Projects Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Zoho Projects replication to PostgreSQL.
-
Create SAP Ariba Source-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP Ariba Source Data from OutSystems and build custom enterprise apps using live SAP Ariba Source.
-
Integrate SAP Business Warehouse Data in the Pentaho Report Designer
Publish reports based on SAP Business Warehouse in the Pentaho BI tool.
-
Back Up Microsoft Office 365 to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Office 365. In this article, we will employ an SSIS workflow to populate a database with Microsoft Office 365 data.
-
Connect to ClickTime Data in Jaspersoft Studio
Execute SQL to remote ClickTime in Jaspersoft Studio.
-
Getting Started with the CData JDBC Driver for Vimeo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Vimeo.
-
Build SAP HANA-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SAP HANA to explore live SAP HANA Data in GitHub Copilot to assist with building SAP HANA-powered applications.
-
Build Certinia-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Certinia Data and create custom apps in Bubble.
-
Integrate Salesforce Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Salesforce & Force.com from Informatica Cloud.
-
Visualize Live Gong Data in the Power BI Service
Use CData Connect AI to connect to live Gong and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automate Mouseflow Data Replication to Azure Synapse
Use CData Sync to customize and automate Mouseflow replication to Azure Synapse.
-
Build Facebook Ads-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Facebook Ads Data and create custom apps in Bubble.
-
Integrate Avro Data into Power Automate Desktop using CData Connect
CData Connect for Avro Data enables you to integrate Apache Avro into workflows built using Microsoft Power Automate Desktop.
-
Connect to BigQuery Data from HeidiSQL
Use CData Connect AI to connect to and query live Google BigQuery from HeidiSQL.
-
Using the CData Software ODBC Driver for Zoho Inventory in PyCharm
Connect to Zoho Inventory as an ODBC data source in PyCharm using the CData Software ODBC Driver for Zoho Inventory.
-
Connect to PostgreSQL Data from AWS Glue
Use CData Connect AI to gain access to live PostgreSQL from your AWS Glue jobs.
-
How to connect and process Monday.com from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Monday.com.
-
Connect to ZohoExpense Data in Jaspersoft Studio
Execute SQL to remote ZohoExpense in Jaspersoft Studio.
-
Load Oracle Financials Cloud Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Oracle Financials Cloud to a database.
-
How to Access Live Placid Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Placid enables you to integrate Placid into workflows built using Microsoft Power Automate Desktop.
-
Stream Datadog Data into Apache Kafka Topics
Access and stream Datadog in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Charts with Azure Data Catalog Data in Clear Analytics
Create dynamic charts and perform analytics based on Azure Data Catalog in Clear Analytics.
-
Deploy the ADO.NET Provider for Pushbullet on an SSRS Report Server
Connect to Pushbullet 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.
-
Beeminder Reporting in OBIEE with the Beeminder JDBC Driver
Deploy the Beeminder JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Prepare, Blend, and Analyze SpaceX Data in Alteryx Designer (ODBC)
Build workflows to access live SpaceX for self-service data analytics.
-
Use the CData SSIS Components to Insert New or Update Existing Splunk Records from SQL Server
Easily push SQL Server data to Splunk using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Splunk or update existing records with data from a SQL Server database.
-
Getting Started with the CData Connect AI Python SDK for Sybase IQ
Install the CData Connect AI Python SDK to read and write live Sybase IQ with standard DB-API 2.0 Python code.
-
Use the CData ODBC Driver for ZohoPeople in Microsoft Power Query
You can use the CData ZohoPeople ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ZohoPeople into Microsoft Power Query.
-
How to Connect the Power BI Service to Qualaroo: Complete Guide
Connect to the CData Software Power BI Connector for Qualaroo from PowerBI.com to provide real-time Qualaroo across the organization.
-
Connect to Square Data in RapidMiner
Integrate Square with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Klaviyo 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 Klaviyo.
-
Integrate Theia IDE with Live LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Back Up ChartMogul 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 ChartMogul data.
-
Getting Started with the CData ODBC Driver for Beeminder
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Beeminder.
-
Connect to Zoho CRM Data from PowerBuilder via JDBC
This article demonstrates how to access Zoho CRM from PowerBuilder using the Zoho CRM JDBC Driver.
-
Build AgileCRM-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to AgileCRM and build web apps with connectivity to live AgileCRM.
-
Publish Crystal Reports on Elorus Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Elorus.
-
Viewing Coinbase Data in RAD Studio Data Explorer
How to view Coinbase in RAD Studio Data Explorer using the CData ODBC Driver for Coinbase.
-
LINQ to Google Forms 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 Google Forms Data Provider.
-
Connect to and Query PivotalTracker Data in QlikView over ODBC
Create data visualizations with PivotalTracker in QlikView.
-
Connect to Jira Assets Data from Crystal Reports
Use CData Connect AI to connect to and report on live Jira Assets from Crystal Reports.
-
Enable the ZarMoney JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ZarMoney.
-
Publish Crystal Reports on Microsoft Entra ID Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Entra ID.
-
Automated Continuous Azure Synapse Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Amazon S3.
-
Build Apps with Live Sybase Data Using the Low-Code Development Platform of Mendix
Connect Sybase with Mendix to build apps using the CData JDBC Driver for Sybase.
-
Access Live SAS xpt Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SAS xpt data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use ChatGPT to Talk to Your Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Pivotal GreenPlum for you.
-
Create Informatica Mappings From/To a JDBC Data Source for Brex
Create Brex data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to create DocuSign federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for DocuSign in MySQL .
-
Connect to Discord Data from a Connection Pool in Jetty
The Discord JDBC Driver supports connection pooling: This article shows how to connect faster to Discord from Web apps in Jetty.
-
Access Live Salesforce Marketing Data in TIBCO Data Virtualization
Use the Salesforce Marketing Tibco DV Adapter to create a Salesforce Marketing Cloud data source in TIBCO Data Virtualization Studio and gain access to live Salesforce Marketing Cloud from your TDV Server.
-
Automated Continuous JSON Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable JSON replication to Google Cloud SQL.
-
How to connect PolyBase to Workday
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Workday.
-
Integrate Cursor with Live JSON Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live JSON from within the editor.
-
Connecting Agentforce with Highrise 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 Highrise CRM for you.
-
Analyze Facebook Ads Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Facebook Ads and visualize Facebook Ads in SAP Analytics Cloud.
-
Add Freshservice Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Freshservice with the Informatica Enterprise Data Catalog to classify and organize data.
-
Excel Spreadsheet Automation on Coda Data with the QUERY Formula
Pull data from Coda, automate spreadsheets, and more with the QUERY formula.
-
Creating Outreach.io-Connected Applications in Unqork
You can use CData Connect AI to feed Outreach.io to Unqork and build custom business apps.
-
Access Pipeline CRM 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 Pipeline CRM.
-
Automated Continuous Sugar CRM Replication to MongoDB
Use CData Sync for automated, continuous, customizable Sugar CRM replication to MongoDB.
-
How to import Oracle Financials Cloud Data into Apache Solr
Use the CData Software JDBC Driver for Oracle Financials Cloud in Data Import Handler and create an automated import of Oracle Financials Cloud to Apache Solr Enterprise Search platform.
-
How to Connect the Power BI Service to HDFS: Complete Guide
Connect to the CData Software Power BI Connector for HDFS from PowerBI.com to provide real-time Apache HDFS across the organization.
-
Visualize Zoho Projects Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Zoho Projects.
-
Automated Continuous Float Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Float replication to IBM DB2.
-
Enable the Mocean JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Mocean.
-
Connect SAP HANA to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP HANA with IBM WebSphere for seamless data integration and connectivity.
-
Getting Started with the CData ADO.NET Provider for Splunk
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Splunk.
-
How to Build an ETL App for PostgreSQL Data in Python with CData
Create ETL applications and real-time data pipelines for PostgreSQL in Python with petl.
-
Automated Continuous Elasticsearch Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Azure SQL Database.
-
Automated Continuous Jira Assets Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Jira Assets replication to Apache Kafka.
-
Connect to Klaviyo Data in JRuby
Create a simple JRuby app with access to live Klaviyo.
-
Build Data Flows from Parallel to SQL Server using SSIS
Easily back up Parallel to SQL Server using the SSIS components for Parallel.
-
Connect to and Query Hacker News Data in QlikView over ODBC
Create data visualizations with Hacker News in QlikView.
-
How to Create Power BI Visual Reports with Real-Time Zoho Projects Data
Use CData Power BI Connectors to visualize Zoho Projects in Power BI.
-
Connect to and Query Webex Data in QlikView over ODBC
Create data visualizations with Webex in QlikView.
-
Prepare, Blend, and Analyze Testmonitor Data in Alteryx Designer (ODBC)
Build workflows to access live Testmonitor for self-service data analytics.
-
Connect to Real-Time CouchDB Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for CouchDB and Dataflow to import and use Apache CouchDB in Power Apps.
-
Integrating SuiteCRM Data in Talend Cloud Data Management Platform
Connect SuiteCRM Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SuiteCRM.