CData Software - Knowledge Base
Recent Articles
-
Connect to Workday Data in CloverDX (formerly CloverETL)
Transfer Workday using the visual workflow in the CloverDX data integration tool.
-
How to Work with RSS Feeds in AWS Glue Jobs Using JDBC
Connect to RSS from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect to MYOB AccountRight Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to MYOB AccountRight. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData Power BI Connector for Bitly
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Visualize Dotmailer 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 Dotmailer into TIBCO Spotfire.
-
Connect to Amazon Marketplace Data in HULFT Integrate
Connect to Amazon Marketplace as a JDBC data source in HULFT Integrate
-
Integrate with live SAS xpt Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAS XPORT in Jitterbit.
-
Automated Continuous Adobe Commerce Replication to Snowflake
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Snowflake.
-
Automated Continuous Azure Data Lake Storage Replication to SQL Server
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to SQL Server.
-
How to Access Live Office 365 Data in Visual Studio Code via Cline
Run CData MCP Server for Office 365 on Windows Subsytem for Linux (WSL) and connect to live Microsoft Office 365 from the Cline extension in Visual Studio Code.
-
Visualize Live Facebook Ads Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Facebook Ads into custom reports in Power BI.
-
Connect to AdRoll Data in RazorSQL
Connect to AdRoll from wizards and query AdRoll from the GUI in the RazorSQL database management tool.
-
Build a PostgreSQL Interface for Act-On Data using the CData JDBC Driver
Use the Remoting features of the Act-On JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Shortcut Data Replication to Couchbase
Use CData Sync to Customize and automate Shortcut replication to Couchbase.
-
Configure the CData JDBC Driver for Mistral AI in a Connection Pool in Tomcat
Connect to Mistral AI from a connection pool in Tomcat.
-
Integrate with Cloudant Data in SnapLogic
Use CData Connect AI to connect to and integrate with live IBM Cloudant in SnapLogic.
-
Visualize Azure Analysis Services Data in TIBCO Spotfire through OData
Integrate Azure Analysis Services into dashboards in TIBCO Spotfire.
-
Use the CData Software JDBC Driver for Ontraport in MicroStrategy
Connect to Ontraport in MicroStrategy Developer using the CData Software JDBC Driver for Ontraport.
-
Analyze Keap Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Keap from Power Pivot. You will use the Table Import Wizard to load Keap. You can visually build the import query or use any SQL supported by the driver.
-
Connect to FHIR Data from a Connection Pool in Jetty
The FHIR JDBC Driver supports connection pooling: This article shows how to connect faster to FHIR from Web apps in Jetty.
-
How to Work with Tavily Data in ETL Validator JDBC
Connect to Tavily from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for Zoho CRM in SAS for Real-Time Reporting and Analytics
Connect to real-time Zoho CRM in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Zoho CRM.
-
Connect to Dropbox Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Dropbox in the Denodo Virtual DataPort Administrator.
-
How to Connect to & Open iContact Data in Microsoft Excel
This article uses the CData ODBC driver for iContact to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Dashboards with Beeminder Data in DBxtra
Create dynamic dashboards and perform analytics based on Beeminder in DBxtra.
-
Getting Started with the CData Connect AI Python SDK for Instagram
Install the CData Connect AI Python SDK to read and write live Instagram with standard DB-API 2.0 Python code.
-
Analyze Email Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Email and visualize live Email in Infragistics Reveal.
-
Automated SAP Fieldglass Data Replication to Teradata
Use CData Sync to Customize and automate SAP Fieldglass replication to Teradata.
-
ZendeskSell Reporting in OBIEE with the ZendeskSell JDBC Driver
Deploy the ZendeskSell JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Zoho Creator Replication to SingleStore
Use CData Sync for automated, continuous, customizable Zoho Creator replication to SingleStore.
-
Query IBM Cloud Object Storage Data as a MySQL Database in Node.js
Execute MySQL queries against IBM Cloud Object Storage from Node.js.
-
How to connect SharePoint with CockroachDB Data through external lists
Provide CockroachDB to SharePoint users as an external list.
-
How to Easily Query Sybase Data in OpenOffice Base
Connect to Sybase data in OpenOffice Base using the CData ODBC Driver for Sybase and generate reports with live data insights.
-
Integrate LibreChat with Live Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Apollo from within the chat interface.
-
Migrating data from BigQuery to Google BigQuery using CData SSIS Components.
Easily push Google BigQuery to Google BigQuery using the CData SSIS Tasks for BigQuery and Google BigQuery.
-
Publish MailChimp-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live MailChimp.
-
Access Flowlu 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 Flowlu.
-
DataBind Smartsheet Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Smartsheet with the DevExpress Windows Forms and Web controls to provide Smartsheet to a chart.
-
Use the CData ODBC Driver for Spark in Microsoft Power Query
You can use the CData Spark ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apache Spark SQL into Microsoft Power Query.
-
Connect to Coinbase Data in NetBeans
Connect to Coinbase in NetBeans with the data source configuration wizard.
-
Create Reports from Outreach.io Data in Looker Studio
Use CData Connect AI to gain access to live Outreach.io and create custom reports in Looker Studio.
-
Connect to NetSuite SuiteAnalytics Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for NetSuite SuiteAnalytics in Airbyte.
-
Automate Databricks Data Replication to Couchbase
Use CData Sync to Customize and automate Databricks replication to Couchbase.
-
Visualize Timely 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 Timely into TIBCO Spotfire.
-
Connect to Google Contacts Data in HULFT Integrate
Connect to Google Contacts as a JDBC data source in HULFT Integrate
-
Integrating Antigravity CLI with Egnyte via CData CLI
Connect Egnyte to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Replicate BenchmarkEmail Data from PowerShell
Write a quick PowerShell script to query BenchmarkEmail. Use connectivity to the live data to replicate BenchmarkEmail to SQL Server.
-
Create Dynamic Redis Grids Using the Infragistics XamDataGrid
Learn how you can connect Redis to Infragistics XamDataGrid to build dynamic grids.
-
Seamlessly Bring Slack Data into Retool Using CData Connect AI
Integrate Slack data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Klaviyo Data in Ruby
Connect to Klaviyo in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous REST Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable REST replication to Apache Kafka.
-
How to connect to JobNimbus Data with Squirrel SQL client
Connect to JobNimbus and execute queries in the Squirrel SQL Client.
-
Connect Eventbrite Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Eventbrite using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Create Power BI Visual Reports with Real-Time Anaplan Data
Use CData Power BI Connectors to visualize Anaplan in Power BI.
-
Analyze Reckon Accounts Hosted Data in Looker
Use CData Connect AI to connect to Reckon Accounts Hosted Data from Looker and build custom apps using live Reckon Accounts Hosted.
-
Operational Reporting on ScrapingBee Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ScrapingBee.
-
Integrate with live Google Cloud Storage Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google Cloud Storage in Jitterbit.
-
Automated Continuous Jira Assets Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Jira Assets replication to OneLake in Microsoft Fabric.
-
Write a Simple Go Application to work with Wave Financial Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Wave Financial.
-
Edit and Search External JSON Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of JSON to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create JSON Services objects that you can access from apps and the dashboard.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed QuickBooks Desktop to Power BI dashboards. Simply drag and drop QuickBooks Desktop into data visuals on the Power BI canvas.
-
Automated Continuous ShipEngine Replication to SQLite
Use CData Sync for automated, continuous, customizable ShipEngine replication to SQLite.
-
Use Dash to Build to Web Apps on Strava Data
Create Python applications that use pandas and Dash to build Strava-connected web apps.
-
Integrating Antigravity CLI with Close via CData CLI
Connect Close to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use Claude to Talk to Your Apollo 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 Apollo for you.
-
Object-Relational Mapping (ORM) with Drip 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 Drip into a Java-based ORM framework, Hibernate.
-
Connect to Sendwithus Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Sendwithus.
-
Use the CData Software JDBC Driver for Redis in MicroStrategy Desktop
Connect to Redis in MicroStrategy Desktop using the CData Software JDBC Driver for Redis.
-
How to Access Clio Data Using Entity Framework
This article shows how to access Clio using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous SAP BusinessObjects BI Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Vertica.
-
Viewing Bullhorn CRM Data in RAD Studio Data Explorer
How to view Bullhorn CRM in RAD Studio Data Explorer using the CData ODBC Driver for Bullhorn CRM.
-
DataBind Controls to Snapchat Ads Data in Delphi
DataBind to Snapchat Ads in Delphi with standard data access components and controls.
-
Connect to Strava in SpagoBI
Create reports featuring live Strava in SpagoBI Studio. Host Strava reports on SpagoBI Server.
-
Query HBase Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Apache HBase from Node.js.
-
Integrate Goose with Live Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Zoho Projects from within the local AI agent.
-
Query Avalara AvaTax Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Avalara AvaTax from Node.js.
-
Access Contentful 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 Contentful.
-
Enable the Snowflake JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Snowflake.
-
Use Databricks Agent Bricks to Talk to Your Avalara AvaTax Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Avalara AvaTax for you.
-
Integrate Dynamics CRM Data in the Pentaho Report Designer
Publish reports based on Microsoft Dynamics CRM in the Pentaho BI tool.
-
Getting Started with the CData Excel Add-In for LeadDesk
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for LeadDesk.
-
DataBind Redshift Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Redshift with the DevExpress Windows Forms and Web controls to provide Amazon Redshift to a chart.
-
Automated Continuous Access Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Access replication to Google BigQuery.
-
Integrating Antigravity CLI with ZeroBounce via CData CLI
Connect ZeroBounce to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect Apollo to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Apollo with IBM WebSphere for seamless data integration and connectivity.
-
Create a Data Access Object for Access Data using JDBI
A brief overview of creating a SQL Object API for Microsoft Access in JDBI.
-
Integrate Anaplan Data in the Pentaho Report Designer
Publish reports based on Anaplan in the Pentaho BI tool.
-
DataBind Controls to LinkedIn Ads Data in Delphi
DataBind to LinkedIn Ads in Delphi with standard data access components and controls.
-
Automate iContact Integration Tasks from PowerShell
Are you in search of a quick and easy way to access iContact from PowerShell? This article demonstrates how to utilize the iContact Cmdlets for tasks like connecting to iContact, automating operations, downloading data, and more.
-
Connect to PayPal Data in ACL Analytics
Connect to PayPal via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to PayPal.
-
Connect to Productboard Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Productboard and work with Productboard in your FileMaker application.
-
Build Semantic Layer Views for Adobe Commerce Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Adobe Commerce.
-
Create Power BI Reports on Real-Time Jumpseller Data
Use the CData ODBC Driver for Jumpseller to visualize Jumpseller in Power BI Desktop.
-
Process & Analyze Hugging Face Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Hugging Face Data.
-
How to import Amazon Athena Data into Apache Solr
Use the CData Software JDBC Driver for Amazon Athena in Data Import Handler and create an automated import of Amazon Athena to Apache Solr Enterprise Search platform.
-
Build Agents in Relevance AI with Access to Live Dynamics 365 Business Central Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Dynamics 365 Business Central within intelligent agent workflows.
-
Use Dash to Build to Web Apps on Drip Data
Create Python applications that use pandas and Dash to build Drip-connected web apps.
-
Query Qualaroo Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Qualaroo from Node.js.
-
Connect to Mode Data from PowerBuilder via ADO.NET
This article demonstrates how to access Mode from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Voice Agents in ElevenLabs with access to Live MariaDB Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live MariaDB.