CData Software - Knowledge Base
Recent Articles
-
Connect to Microsoft Dataverse Data in JRuby
Create a simple JRuby app with access to live Microsoft Dataverse (CDS).
-
How to import Pipeliner CRM Data into Apache Solr
Use the CData Software JDBC Driver for Pipeliner CRM in Data Import Handler and create an automated import of Pipeliner CRM to Apache Solr Enterprise Search platform.
-
How to publish and share PivotalTracker Data dashboards with Tableau Server
The CData ODBC driver for PivotalTracker enables you integrate PivotalTracker into Tableau dashboards.
-
Create Dynamic Dotmailer Grids Using the Infragistics XamDataGrid
Learn how you can connect Dotmailer to Infragistics XamDataGrid to build dynamic grids.
-
Replicate Slack Data from PowerShell
Write a quick PowerShell script to query Slack. Use connectivity to the live data to replicate Slack to SQL Server.
-
Integrate Calendly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Calendly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Calendly.
-
How to connect and process Twilio from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Twilio.
-
How to Work with Zoho CRM Data in AWS Glue Jobs Using JDBC
Connect to Zoho CRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate with live HBase Data in Jitterbit
Use CData Connect AI to connect to and integrate live Apache HBase in Jitterbit.
-
Feed Placid Data into FineReport
How to set Placid as a JDBC data source in FineReport.
-
How to connect to DocuSign Data from Spring Boot
Connect to DocuSign in a Spring Boot Application using the CData JDBC Driver for DocuSign
-
Build a Simple VCL Application for Teradata Data
How to build a simple VCL Application to view Teradata in RAD Studio using the CData ODBC Driver for Teradata.
-
Establish a Live Connection with Optimizely Data using Tableau Bridge
The CData ODBC Driver for Optimizely enables you to integrate live Optimizely into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Easily Query Wistia Data in OpenOffice Base
Connect to Wistia data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate LeadDesk Data in Pentaho Data Integration
Build ETL pipelines based on LeadDesk in the Pentaho Data Integration tool.
-
Use the CData Software ODBC Driver for Slack in MicroStrategy Desktop
Connect to Slack in MicroStrategy Desktop using the CData Software ODBC Driver for Slack.
-
Using the CData Software ODBC Driver for GitLab in PyCharm
Connect to GitLab as an ODBC data source in PyCharm using the CData Software ODBC Driver for GitLab.
-
Integrating Antigravity CLI with xBase via CData CLI
Connect xBase to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate with Tally Data in JReport Designer
Create charts and reports based on Tally ERP in JReport Designer.
-
Connect to Amazon S3 Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Pingdom Data in Ruby
Connect to Pingdom in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect to Live Confluence Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Atlassian Confluence without replication.
-
Build a Simple VCL Application for Cassandra Data
How to build a simple VCL Application to view Apache Cassandra in RAD Studio using the CData ODBC Driver for Cassandra.
-
Query Sybase IQ Data as a SQL Server Database in Node.js
Execute SQL Server queries against Sybase IQ from Node.js.
-
Integrate SAP HANA Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP HANA from Informatica Cloud.
-
ETL EmailOctopus in Oracle Data Integrator
This article shows how to transfer EmailOctopus into a data warehouse using Oracle Data Integrator.
-
Migrating data from Accelo to Google BigQuery using CData SSIS Components.
Easily push Accelo to Google BigQuery using the CData SSIS Tasks for Accelo and Google BigQuery.
-
Create Reports with MessageBird Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MessageBird.
-
Import and Visualize Productboard Data in Power View
Create data visualizations based on Productboard in Excel.
-
Replicate Multiple Microsoft Exchange Accounts
Replicate multiple Microsoft Exchange accounts to one or many databases.
-
Automated Continuous Oracle Financials Cloud Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Azure SQL Database.
-
Connecting Moonlit Workflow with SAP SuccessFactors Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SAP SuccessFactors in real time.
-
Integrating Claude Code CLI with Avro 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.
-
Analyze Rootly Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Rootly in Microsoft R Open.
-
Automated Continuous ZendeskSell Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ZendeskSell replication to OneLake in Microsoft Fabric.
-
Getting Started with the CData SSIS Components for SAS Data Sets
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAS Data Sets.
-
Integrating Boomi Agentstudio with Odoo Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Odoo ERP, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use the CData API Server to Access Asana Data in Microsoft PowerPivot
Use the CData API Server to connect to live Asana in the Power Pivot business intelligence tool.
-
Build Authorize.Net-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Authorize.Net and build Authorize.Net-connected web apps with Axios.
-
Integrating Claude Code CLI with Bullhorn CRM 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.
-
Connect to Amazon Athena Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Amazon Athena in the Denodo Virtual DataPort Administrator.
-
Getting Started with the CData Power BI Connector for Copper
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Design SAP Ariba Source Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to SAP Ariba Source from mobile and tablet Power Apps.
-
DataBind Apollo Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Apollo to a chart.
-
Replicate Salesforce Data to Multiple Databases
Replicate Salesforce & Force.com to disparate databases with a point-and-click configuration.
-
Build Apps with Live Highrise Data Using the Low-Code Development Platform of Mendix
Connect Highrise CRM with Mendix to build apps using the CData JDBC Driver for Highrise.
-
Publish Delighted-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Delighted.
-
Use the CData Software ODBC Driver for PhantomBuster in MicroStrategy
Connect to PhantomBuster in MicroStrategy Developer using the CData Software ODBC Driver for PhantomBuster.
-
Automate Google Calendar Data Replication to Couchbase
Use CData Sync to Customize and automate Google Calendar replication to Couchbase.
-
Use the CData ODBC Driver for Timely from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Timely to connect to Timely from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Timely in Excel.
-
Upload CSV Data to Airtable with CData
Learn how to load CSV files into Airtable through CData Airtable SyncCSV stored procedure in DBeaver.
-
How to Build an ETL App for Acumatica Data in Python with CData
Create ETL applications and real-time data pipelines for Acumatica ERP in Python with petl.
-
How to load Apollo data into Elasticsearch via Logstash
Introducing a simple method to load Apollo data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to eBay Analytics Data in Jaspersoft Studio
Execute SQL to remote eBay Analytics in Jaspersoft Studio.
-
Connect to HubSpot Data in DBArtisan
Use wizards in DBArtisan to configure HubSpot as a data source.
-
Deploy the ADO.NET Provider for ShipStation on an SSRS Report Server
Connect to ShipStation 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.
-
MailChimp Reporting in OBIEE with the MailChimp JDBC Driver
Deploy the MailChimp JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous FormSite Replication to Amazon S3
Use CData Sync for automated, continuous, customizable FormSite replication to Amazon S3.
-
Integrating LangGraph with Gong Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Gong within automated workflows.
-
Access Live Act CRM Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Act CRM into the statistical analysis tools available in SAS JMP. This article shows how to use Act CRM in the Graph Builder and Query Builder.
-
How to create an RPA flow for Odoo Data in UiPath Studio
Use the Odoo ODBC Driver to create workflows that access real-time Odoo ERP without any coding.
-
DataBind Controls to SAP Ariba Source Data in Delphi
DataBind to SAP Ariba Source in Delphi with standard data access components and controls.
-
Automated Continuous Zoho Books Replication to SQLite
Use CData Sync for automated, continuous, customizable Zoho Books replication to SQLite.
-
Access Live SingleStore Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SingleStore from your Excel spreadsheets.
-
Integrating LlamaIndex with Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Sybase IQ in real time.
-
Build Zoom-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Zoom Data from Zoho Analytics and import live Zoom.
-
Connect to Coda Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Coda.
-
Connect ZohoSubscriptions to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ZohoSubscriptions using the CData Python MCP Server.
-
Getting Started with the CData ODBC Driver for Discord
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Discord.
-
Integrate LightSpeedRetail Data in the Pentaho Report Designer
Publish reports based on LightSpeedRetail in the Pentaho BI tool.
-
Manage MailerSend Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for MailerSend.
-
Build Automated FreshBooks-Connected Workflows in Zapier
Use CData Connect AI to connect to live FreshBooks and build automated workflows in Zapier.
-
How to Connect to Live WooCommerce 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 WooCommerce for you.
-
A PostgreSQL Interface for Google Ad Manager Data using the CData ODBC Driver
Use the SQL Gateway and Google Ad Manager ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Theia IDE with Live PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrating Gumloop with Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Oracle SCM within automated workflows.
-
How to Connect to JSON Services in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to JSON. Leverage the pyodbc module for ODBC in Python.
-
Replicate Stripe Data from PowerShell
Write a quick PowerShell script to query Stripe. Use connectivity to the live data to replicate Stripe to SQL Server.
-
Edit and Search Asana External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Asana to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Asana objects that you can access from apps and the dashboard.
-
Connect to ClickUp Data from a Connection Pool in Jetty
The ClickUp JDBC Driver supports connection pooling: This article shows how to connect faster to ClickUp from Web apps in Jetty.
-
Use Dash to Build Web Apps on Oracle HCM Cloud Data via CData Connect AI
Build interactive Dash web apps on live Oracle HCM Cloud using pandas and the CData Connect AI Python SDK.
-
Moving Data from Cloudflare to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Cloudflare data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Live Airtable Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Airtable from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Airtable.
-
Publish Crystal Reports on Google Ad Manager Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Ad Manager.
-
Connect and Query Live Google Calendar Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Calendar into Databricks
-
Migrating data from Azure DevOps to Snowflake using CData SSIS Components.
Easily push Azure DevOps to Snowflake using the CData SSIS Tasks for Azure DevOps and Snowflake.
-
Integrate with Twitter Ads Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Twitter Ads to a JSON file on disk.
-
Bidirectional Access to TigerGraph Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate TigerGraph in Filemaker Pro for Mac or Windows.
-
How to Access Live Nuclia Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Nuclia enables you to integrate Nuclia into workflows built using Microsoft Power Automate Desktop.
-
LINQ to Tavily 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 Tavily Data Provider.
-
Connect to Google Sheets Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google Sheets from Filemaker Pro on Mac.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Greenhouse within intelligent workflows.
-
Integrate Marketo Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Marketo from Informatica Cloud.
-
How to Query CampaignMonitor Data in MySQL Workbench
Execute MySQL queries against live CampaignMonitor from MySQL Workbench.
-
Use the CData Software ODBC Driver for eBay Analytics in MicroStrategy Web
Connect to eBay Analytics in MicroStrategy Web using the CData Software ODBC Driver for eBay Analytics.
-
Model SendGrid Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SendGrid, enabling the direct import of real-time SendGrid.
-
Migrating data from JSON to Snowflake using CData SSIS Components.
Easily push JSON to Snowflake using the CData SSIS Tasks for JSON and Snowflake.
-
Enable the Power BI XMLA JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Power BI XMLA.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live WordPress within intelligent workflows.
-
Getting Started with the CData Power BI Connector for Amazon DynamoDB
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Amazon DynamoDB.