CData Software - Knowledge Base
Recent Articles
-
Connect to Moosend Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Moosend in the Denodo Virtual DataPort Administrator.
-
Migrating data from Excel to Google BigQuery using CData SSIS Components.
Easily push Microsoft Excel to Google BigQuery using the CData SSIS Tasks for Excel and Google BigQuery.
-
Integrating Codex CLI with Asana 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 Apps with Live Planio Data Using the Low-Code Development Platform of Mendix
Connect Planio with Mendix to build apps using the CData API Driver for JDBC.
-
DataBind Controls to Clio Data in C++Builder
DataBind to Clio in C++Builder with standard components and controls.
-
Build Semantic Layer Views for Jira Assets Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Jira Assets.
-
How to Create Power BI Visual Reports with Real-Time BigQuery Data
Use CData Power BI Connectors to visualize Google BigQuery in Power BI.
-
Operational Reporting on eBay Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote eBay.
-
Operational Reporting on Harvest Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Harvest.
-
Analyze Microsoft Ads Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft Ads and visualize Microsoft Ads in SAP Analytics Cloud.
-
Automate BambooHR Data Replication to SAP HANA
Use CData Sync to customize and automate BambooHR replication to SAP HANA.
-
Build Zuora-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Zuora Data from Zoho Analytics and import live Zuora.
-
Design BIRT Reports on Azure Synapse Data
Provide current Azure Synapse to your embedded analytics.
-
Access Live ZendeskSell Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ZendeskSell into the statistical analysis tools available in SAS JMP. This article shows how to use ZendeskSell in the Graph Builder and Query Builder.
-
Natively Connect to Pipeline CRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Pipeline CRM. Leverage the native support for ODBC in PHP.
-
A PostgreSQL Interface for SAP HANA XS Advanced Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP HANA XS Advanced JDBC Driver to create a PostgreSQL entry-point for data access.
-
Gong Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Gong through CData Connect AI using different applications and tools.
-
Automate Zoho Inventory Data Replication to Couchbase
Use CData Sync to Customize and automate Zoho Inventory replication to Couchbase.
-
Operational Reporting on Tavily Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Tavily.
-
Connecting Pipedream with Presto Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Presto data in real time.
-
Connect to Cosmos DB Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Cosmos DB and the Script function in FileMaker Pro to connect to Cosmos DB and work with Azure Cosmos DB in your FileMaker application.
-
Visualize Snapchat Ads 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 Snapchat Ads into TIBCO Spotfire.
-
Build Charts with Mocean Data in Clear Analytics
Create dynamic charts and perform analytics based on Mocean in Clear Analytics.
-
Easily Integrate Chargebee Data in Lazarus Pascal IDE
Learn how to easily integrate live Chargebee in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Extend Google Sheets with Azure Table Data
Make calls to Azure Table from Google Apps Script via the API Server.
-
Use the CData Software ODBC Driver for Codat in MicroStrategy Desktop
Connect to Codat in MicroStrategy Desktop using the CData Software ODBC Driver for Codat.
-
Connect to Sage 300 Data in Aqua Data Studio
Access Sage 300 from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData ODBC Driver for PayPal from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for PayPal to connect to PayPal from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring PayPal in Excel.
-
Automated Continuous Hive Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Hive replication to PostgreSQL.
-
Use ChatGPT to Talk to Your Confluence 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 Atlassian Confluence for you.
-
Automated Continuous Hive Replication to Snowflake
Use CData Sync for automated, continuous, customizable Hive replication to Snowflake.
-
Explore Geographical Relationships in Gong Data with Power Map
Create data visualizations with Gong in Power Map.
-
Use the CData Software ODBC Driver for Pinecone in MicroStrategy Desktop
Connect to Pinecone in MicroStrategy Desktop using the CData Software ODBC Driver for Pinecone.
-
Build Klaviyo Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Klaviyo and build visualizations in Tableau Cloud.
-
Integrate Vimeo Data in Pentaho Data Integration
Build ETL pipelines based on Vimeo in the Pentaho Data Integration tool.
-
Connect to Insightly Data in CloverDX (formerly CloverETL)
Transfer Insightly using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous ZohoInvoice Replication to MySQL
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to MySQL.
-
Integrating Cursor CLI with Azure Data Catalog 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.
-
Using CData ODBC Drivers in Linux/Unix Environments
An introduction to and brief tutorial for configuring the CData Software ODBC Drivers in Unix/Linux environments.
-
How to Work with Hive Data in AWS Glue Jobs Using JDBC
Connect to Hive from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Apps with Live HubDB Data Using the Low-Code Development Platform of Mendix
Connect HubDB with Mendix to build apps using the CData JDBC Driver for HubDB.
-
Build a Simple VCL Application for Rebilly Data
How to build a simple VCL Application to view Rebilly in RAD Studio using the CData ODBC Driver for Rebilly.
-
Connect to MarkLogic Data as an External Source in Dremio
Use the CData JDBC Driver to connect to MarkLogic as an External Source in Dremio.
-
How to Easily Query Azure Data Catalog Data in OpenOffice Base
Connect to Azure Data Catalog data in OpenOffice Base using the CData ODBC Driver for Azure Data Catalog and generate reports with live data insights.
-
Automated Continuous CData Connect AI Replication to AlloyDB
Use CData Sync for automated, continuous, customizable CData Connect AI replication to AlloyDB.
-
Automated Continuous Cvent Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Cvent replication to AlloyDB.
-
Integrate LibreChat with Live Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Neo4J from within the chat interface.
-
Build AI/ML Models with Live HelloSign Data using Dataiku
Connect HelloSign Data with Dataiku using the CData API Driver for JDBC.
-
Create a Data Access Object for Stripe Data using JDBI
A brief overview of creating a SQL Object API for Stripe in JDBI.
-
Use the CData Software ODBC Driver for Asana in MicroStrategy Web
Connect to Asana in MicroStrategy Web using the CData Software ODBC Driver for Asana.
-
Analyze ServiceNow Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ServiceNow and visualize live ServiceNow in Infragistics Reveal.
-
Connect to Greenplum Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Pivotal GreenPlum in the Denodo Virtual DataPort Administrator.
-
Connect and Visualize Live ADP Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live ADP into the Databricks platform and create visualization dashboards with real-time ADP.
-
Connect to Ontraport Data in JRuby
Create a simple JRuby app with access to live Ontraport.
-
How to Work with Google Sheets Data in AWS Glue Jobs Using JDBC
Connect to Google Sheets from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live Salesloft Data in TIBCO Data Virtualization
Use the Salesloft Tibco DV Adapter to create a Salesloft data source in TIBCO Data Virtualization Studio and gain access to live Salesloft from your TDV Server.
-
Access Dynamics 365 Business Central Data from MySQL in PHP
Connect to Dynamics 365 Business Central through the standard MySQL libraries in PHP.
-
Migrating data from Azure Synapse to Databricks using CData SSIS Components.
Easily push Azure Synapse to Databricks using the CData SSIS Tasks for Azure Synapse and Databricks.
-
How to publish and share Workable Data dashboards with Tableau Server
The CData ODBC driver for Workable enables you integrate Workable into Tableau dashboards.
-
Getting Started with the CData Tableau Connector for ZendeskSell
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Replicate Highrise Data from PowerShell
Write a quick PowerShell script to query Highrise CRM. Use connectivity to the live data to replicate Highrise CRM to SQL Server.
-
Integrating Claude Code with SAP SuccessFactors Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAP SuccessFactors within assisted coding and automated development workflows.
-
Getting Started with the CData Tableau Connector for Basecamp
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Basecamp.
-
Analyze Google Calendar Data in Cognos Analytics
Use CData Connect AI to connect to Google Calendar Data from Cognos Analytics and analyze live Google Calendar.
-
Perform Batch Operations with Salesforce Pardot Data in Apache NiFi
Connect to Salesforce Pardot and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Migrating data from Bright Data to Databricks using CData SSIS Components.
Easily push Bright Data to Databricks using the CData SSIS Tasks for Bright Data and Databricks.
-
Connect Raisers Edge NXT Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Raisers Edge NXT using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect Amazon QuickSight to Google Directory Data
Create a connection to Google Directory in CData Connect AI and insert Google Directory into Amazon QuickSight SPICE to build interactive dashboards.
-
Visualize Hacker News 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 Hacker News into TIBCO Spotfire.
-
Provide OData Services of Okta Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Okta by developing a WCF Service Application.
-
Import and Visualize Azure Table Data in Power View
Create data visualizations based on Azure Table Storage in Excel.
-
Integrate Microsoft Exchange Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Microsoft Exchange and integrate live Microsoft Exchange into your Power Automate tasks.
-
Create Dashboards and Visualize Live DocuSign Data in Geckoboard
Use CData Connect AI to connect to live DocuSign and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Perform Batch Operations with SAS Data Sets Data in Apache NiFi
Connect to SAS Data Sets and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Deploy the ADO.NET Provider for Dynamics NAV on an SSRS Report Server
Connect to Microsoft Dynamics NAV 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.
-
How to use SQLAlchemy ORM to access Salesforce CRM Analytics Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Salesforce CRM Analytics.
-
Create Data Visualizations in Cognos BI with Landbot Data
Access Landbot as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect Certinia to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Certinia with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Unbounce from Asprova with CData Software ODBC Driver for Unbounce
This article shows how to connect faster to Unbounce data from Asprova.
-
Integrate Salesforce CRM Analytics Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Salesforce CRM Analytics from Informatica Cloud.
-
How to connect to Twilio Data with Squirrel SQL client
Connect to Twilio and execute queries in the Squirrel SQL Client.
-
Easily Integrate ClickUp Data in Lazarus Pascal IDE
Learn how to easily integrate live ClickUp in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Analyze SendInBlue Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SendInBlue with the CData JDBC Driver for SendInBlue.
-
Integrate with Monday.com Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Monday.com to a JSON file on disk.
-
Connecting Agentforce with ShipStation 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 ShipStation for you.
-
Integrate Real-Time Access to Salesforce in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Salesforce & Force.com in real time.
-
Connect to SAP Ariba Procurement Data in NetBeans
Connect to SAP Ariba Procurement in NetBeans with the data source configuration wizard.
-
How to Visualize Teamwork Data in Python with pandas
Use pandas and other modules to analyze and visualize live Teamwork in Python.
-
Integrate OData Services into Automated Tasks with Power Automate
Use CData Connect AI to connect to OData and integrate live OData into your Power Automate tasks.
-
How to integrate Metabase with NetSuite SuiteAnalytics Data
Use CData Connect AI to connect to live NetSuite SuiteAnalytics and create an interactive dashboard in Metabase from NetSuite SuiteAnalytics.
-
Access Yelp 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 Yelp.
-
Build AI/ML Models with Live Jira Data using Dataiku
Connect Jira Data with Dataiku using the CData JDBC Driver for Jira.
-
How to Access Live Contentful Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Contentful enables you to integrate Contentful into workflows built using Microsoft Power Automate Desktop.
-
Connect to Adobe Target Data in Ruby
Connect to Adobe Target in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Consume QuickBooks OData Feeds in SAP Lumira
Use the API Server to create data visualizations on QuickBooks feeds that reflect any changes in SAP Lumira.
-
Extend Google Sheets with ShipStation Data
Make calls to ShipStation from Google Apps Script via the API Server.
-
How to Access Raisers Edge NXT Data Using Entity Framework
This article shows how to access Raisers Edge NXT using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to DB2 Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for DB2 to connect to IBM DB2 and execute queries in PowerBuilder.
-
Use JayDeBeApi to access Elorus Data in Python
Use standard Python scripting and the development environment of your choice to access live Elorus.
-
Perform Batch Operations with Splunk Data in Apache NiFi
Connect to Splunk and perform batch operations in Apache NiFi using the CData Software JDBC Driver.