CData Software - Knowledge Base
Recent Articles
-
How to connect to Sendwithus Data with Squirrel SQL client
Connect to Sendwithus data and execute queries in the Squirrel SQL Client.
-
Deploy the ADO.NET Provider for FormSite on an SSRS Report Server
Connect to FormSite data 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.
-
Integrate Oracle HCM Cloud with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Oracle HCM Cloud with External Services.
-
Visualize Harvest Data in Tableau
The CData ODBC driver for Harvest enables you integrate Harvest data into Tableau dashboards.
-
Process & Analyze Browserless Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Browserless Data.
-
Publish Reports with Gmail Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Gmail data.
-
Use Claude to Talk to Your IBM Informix 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 IBM Informix data for you.
-
Automated Continuous FormSite Replication to SQL Server
Use CData Sync for automated, continuous, customizable FormSite replication to SQL Server.
-
Create Instantly Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Instantly data access from reports, embedded analytics, and more.
-
Feed Auth0 Data into FineReport
How to set Auth0 data as a JDBC data source in FineReport.
-
Analyze LDAP Objects in Infragistics Reveal
Use CData Connect AI to create on OData API on top of LDAP objects and visualize live LDAP objects in Infragistics Reveal.
-
Connect to Salesforce Data in Ruby
Connect to Salesforce data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use Grok to Talk to Your SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SAS Data Sets data for you.
-
Access Live Beeminder Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Beeminder data into the statistical analysis tools available in SAS JMP. This article shows how to use Beeminder data in the Graph Builder and Query Builder.
-
Link Freshteam with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Freshteam data in Filemaker Pro for Mac or Windows.
-
Connect to HubSpot Data in Claris FileMaker Pro
Use the CData ODBC Driver for HubSpot in FileMaker Pro to connect to HubSpot and work with HubSpot data in your FileMaker applications.
-
Stream Figshare Data into Apache Kafka Topics
Access and stream Figshare data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Getting Started with the CData ODBC Driver for ZarMoney
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ZarMoney.
-
Integrating Sybase IQ Data in Talend Cloud Data Management Platform
Connect Sybase IQ Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Sybase IQ.
-
Write a Simple Go Application to work with Chargebee Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Chargebee data.
-
Create Informatica Mappings From/To a JDBC Data Source for ElevenLabs
Create ElevenLabs data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Shopify Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Shopify replication to Google BigQuery.
-
Connect to Invoiced Data in DBeaver
Use the CData ODBC Driver to connect to Invoiced data in DBeaver.
-
Integrate Zoho Books Data in the Pentaho Report Designer
Publish reports based on Zoho Books data in the Pentaho BI tool.
-
How to Work with NetSuite Data in AWS Glue Jobs Using JDBC
Connect to NetSuite from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Apps with Live Salesforce Pardot Data Using the Low-Code Development Platform of Mendix
Connect Salesforce Pardot data with Mendix to build apps using the CData JDBC Driver for Salesforce Pardot.
-
Integrate LibreChat with Live Aweber Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Aweber data from within the chat interface.
-
DataBind Webex Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Webex data to a chart.
-
Automated Continuous Wrike Replication to Snowflake
Use CData Sync for automated, continuous, customizable Wrike replication to Snowflake.
-
Natively Connect to ZeroBounce Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ZeroBounce data. Leverage the native support for ODBC in PHP.
-
Natively Connect to LightSpeedRetail Data in PHP
The CData ODBC driver for LightSpeedRetail enables you to create PHP applications with connectivity to LightSpeedRetail data. Leverage the native support for ODBC in PHP.
-
How to connect to Parallel Data from Spring Boot
Connect to Parallel in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate with TigerGraph Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy TigerGraph data to a JSON file on disk.
-
Visualize Exa Data in Tableau
The CData ODBC driver for Exa enables you integrate Exa data into Tableau dashboards.
-
Integrating LangChain with ServiceDesk Plus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on ServiceDesk Plus data within automated workflows.
-
Getting Started with the CData Excel Add-In for Snowflake
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Snowflake.
-
Integrating LangChain with Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Ad Manager data within automated workflows.
-
Configure the CData JDBC Driver for ADP in a Connection Pool in Tomcat
Connect to ADP data from a connection pool in Tomcat.
-
Visualize Live Auth0 Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Auth0 data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Migrating data from SuiteCRM to Google BigQuery using CData SSIS Components.
Easily push SuiteCRM data to Google BigQuery using the CData SSIS Tasks for SuiteCRM and Google BigQuery.
-
Access Live Workday Data in Coginiti Pro
Connect to and query live Workday data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to connect PolyBase to Printify
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Printify data.
-
Integrating Cursor with GetResponse 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 MVC Applications with Connectivity to Shortcut Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Shortcut from an ASP.NET MVC application.
-
Access Live Apify 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 Apify data through MCP integration.
-
How to Build an ETL App for Anaplan Data in Python with CData
Create ETL applications and real-time data pipelines for Anaplan data in Python with petl.
-
Query, Visualize, and Share live ServiceDesk Plus Data in Redash
Use CData Connect AI to connect to live ServiceDesk Plus data in Redash for querying, visualizing, and sharing.
-
Create Datasets from SAP in Domo Workbench and Build Visualizations of SAP Data in Domo
Use the CData Software ODBC Driver for SAP to create datasets from SAP data in Domo Workbench and then build visualizations in the Domo service.
-
Access Sage Intacct 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 Sage Intacct data.
-
Interact with Live Amazon Athena Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Amazon Athena data.
-
Automated Continuous CloudConvert Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable CloudConvert data replication to OneLake in Microsoft Fabric.
-
Integrate Cline with Live SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP SuccessFactors data from within your IDE.
-
Analyze Browserless Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Browserless data in Microsoft R Open.
-
Prepare, Blend, and Analyze Lakebase Data in Alteryx Designer (ODBC)
Build workflows to access live Lakebase data for self-service data analytics.
-
Use the CData ODBC Driver for Perplexity from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Perplexity to connect to Perplexity data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Perplexity data in Excel.
-
Integrating Gumloop with IBM Informix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on IBM Informix data within automated workflows.
-
Automate AfterShip Data Replication to SAP HANA
Use CData Sync to customize and automate AfterShip data replication to SAP HANA.
-
Model Pinterest Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Pinterest, enabling the direct import of real-time Pinterest data.
-
Connect to Sybase IQ Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Sybase IQ Data and connect to Sybase IQ data in Akorbi Digital RunMyProcess.
-
Build Sage 200-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sage 200 data.
-
Visualize Live Dynamics 365 Data in the Power BI Service
Use CData Connect AI to connect to live Dynamics 365 data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to publish and share BenchmarkEmail Data dashboards with Tableau Server
The CData ODBC driver for BenchmarkEmail enables you integrate BenchmarkEmail data into Tableau dashboards.
-
Getting Started with the CData JDBC Driver for LightSpeedRetail
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for LightSpeedRetail.
-
Automated Continuous Shopify Replication to Oracle
Use CData Sync for automated, continuous, customizable Shopify replication to Oracle.
-
Getting Started with the CData JDBC Driver for Pinterest
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Pinterest.
-
Connect to Workable Data in Ruby
Connect to Workable data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Provide OData Services of IBM Cloud Object Storage Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for IBM Cloud Object Storage data by developing a WCF Service Application.
-
Create a Data Access Object for Active Directory Data using JDBI
A brief overview of creating a SQL Object API for Active Directory data in JDBI.
-
Automated Continuous Oracle Service Cloud Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Google BigQuery.
-
Automated Continuous Bright Data Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Bright Data replication to Azure SQL Database.
-
Integrate Goose with Live SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SurveyMonkey data from within the local AI agent.
-
Consume Databricks OData Feeds in PowerBuilder
This article demonstrates how to consume Databricks data as OData feeds from PowerBuilder using the API Server.
-
Connect to Pinecone Data from PowerBuilder via JDBC
This article demonstrates how to access Pinecone data from PowerBuilder using the Pinecone JDBC Driver.
-
Deploy the ADO.NET Provider for Microsoft Exchange on an SSRS Report Server
Connect to Microsoft Exchange data 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.
-
Link Typeform with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Typeform data in Filemaker Pro for Mac or Windows.
-
View Reports on Real-Time MessageBird Data in Power BI Report Server
Use the CData ODBC Driver for MessageBird to visualize MessageBird data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate with Google Search Results using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Search results to a JSON file on disk.
-
Connect to Attio Data from PowerBuilder via ADO.NET
This article demonstrates how to access Attio data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to TaxJar Data in Jaspersoft Studio
Execute SQL to remote TaxJar data in Jaspersoft Studio.
-
Automated Continuous Azure Data Lake Storage Replication to MySQL
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to MySQL.
-
Build Charts with Azure Analysis Services Data in Clear Analytics
Create dynamic charts and perform analytics based on Azure Analysis Services data in Clear Analytics.
-
Automate Bullhorn CRM Data Replication to SAP HANA
Use CData Sync to customize and automate Bullhorn CRM data replication to SAP HANA.
-
How to create an RPA flow for Square Data in UiPath Studio
Use the Square ODBC Driver to create workflows that access real-time Square data without any coding.
-
Process & Analyze Cosmos DB Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Cosmos DB Data.
-
How to Connect to & Open Pipeline CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Pipeline CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to DocuSign Data from HeidiSQL
Use CData Connect AI to connect to and query live DocuSign data from HeidiSQL.
-
Use the CData Software JDBC Driver for Jodoo in MicroStrategy
Connect to Jodoo data in MicroStrategy Developer using the CData Software JDBC Driver for Jodoo.
-
Create WooCommerce-Connected Nintex Workflows
Use CData Connect AI to connect to WooCommerce Data from Nintex Workflow Cloud and build custom workflows using live WooCommerce data.
-
Build Bitly-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Bitly Data and create custom apps in Bubble.
-
Automated Continuous Mailjet Replication to SingleStore
Use CData Sync for automated, continuous, customizable Mailjet replication to SingleStore.
-
Natively Connect to Smartsheet Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Smartsheet data. Leverage the native support for ODBC in PHP.
-
How to Visualize HubDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live HubDB data in Python.
-
Connect to FreshBooks Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to FreshBooks and work with FreshBooks data in your FileMaker applications.
-
Connect to Superchat Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Superchat.
-
Build Visualizations of LinkedIn Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of LinkedIn data in Birst.
-
Create OneNote-Connected Business Apps in AppSheet
Connect to OneNote Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to OneNote data.
-
How to Build an ETL App for Google Sheets Data in Python with CData Connect AI
Build ETL pipelines that read and write live Google Sheets data in Python with petl and the CData Connect AI Python SDK.
-
Automated Continuous Wistia Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Wistia replication to Google Cloud SQL.
-
Use Dash to Build to Web Apps on Redshift Data
Create Python applications that use pandas and Dash to build Redshift-connected web apps.
-
Automated Continuous Moosend Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Moosend replication to Apache Kafka.