CData Software - Knowledge Base
Recent Articles
-
Automate Tasks in Power Automate Using the CData API Server
Automate Highrise actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Automated Continuous Epicor Kinetic Replication to Oracle
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Oracle.
-
Consume Twilio OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Twilio feeds that reflect any changes in SAP Lumira.
-
Automated Continuous Smartsheet Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Smartsheet replication to Google BigQuery.
-
Build Semantic Layer Views for Blackbaud FE NXT Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Blackbaud FE NXT.
-
Write a Simple Go Application to work with FHIR Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to FHIR.
-
Build AI Agents with BigQuery Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Google BigQuery through CData Connect AI.
-
Getting Started with the CData ADO.NET Provider for Zoho Recruit
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Replicate Salesforce Data from PowerShell
Write a quick PowerShell script to query Salesforce & Force.com. Use connectivity to the live data to replicate Salesforce & Force.com to SQL Server.
-
How to work with Bright Data Data in Apache Spark using SQL
Access and process Bright Data Data in Apache Spark using the CData Software JDBC Driver.
-
Moving Data from Highrise to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Highrise data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Dash to Build Web Apps on Adobe Analytics Data via CData Connect AI
Build interactive Dash web apps on live Adobe Analytics using pandas and the CData Connect AI Python SDK.
-
Getting Started with the CData Power BI Connector for ConvertKit
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Access Live ZohoDesk Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ZohoDesk enables you to integrate ZohoDesk into workflows built using Microsoft Power Automate Desktop.
-
How to integrate SAP Business One with Apache Airflow
Access and process SAP Business One in Apache Airflow using the CData JDBC Driver.
-
Build Cassandra-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Apache Cassandra.
-
Create Microsoft Entra ID-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Microsoft Entra ID Data from Klipfolio and build custom visualizations using live Microsoft Entra ID.
-
Automate MailChimp Data Replication to Azure Synapse
Use CData Sync to customize and automate MailChimp replication to Azure Synapse.
-
Create a Data Access Object for Act-On Data using JDBI
A brief overview of creating a SQL Object API for Act-On in JDBI.
-
Migrating data from CSV to Databricks using CData SSIS Components.
Easily push CSV/TSV Files to Databricks using the CData SSIS Tasks for CSV and Databricks.
-
Create SurveyMonkey-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SurveyMonkey Data from Klipfolio and build custom visualizations using live SurveyMonkey.
-
How to Connect to Parquet Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apache Parquet. Leverage the pyodbc module for ODBC in Python.
-
Visualize Live GetResponse Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live GetResponse using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Act-On Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Act-On in Airbyte.
-
Building Dynamic Web Pages with HCL Domino Data Using AngularJS
Create single-page applications with live connectivity to HCL Domino using the CData API Server.
-
Analyze Wrike Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Wrike with the CData JDBC Driver for Wrike.
-
Migrating data from CouchDB to Databricks using CData SSIS Components.
Easily push Apache CouchDB to Databricks using the CData SSIS Tasks for CouchDB and Databricks.
-
Operational Reporting on DocuSign Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote DocuSign.
-
Use Agno to Talk to Your Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Bullhorn CRM for you.
-
Use ChatGPT to Talk to Your ServiceNow 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 ServiceNow for you.
-
Access Impala Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Apache Impala from your Oracle system.
-
Build an OLAP Cube in SSAS from Reply.io Data
Establish a connection to Reply.io data from SQL Server Analysis Services, and use the Reply.io Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous AfterShip Replication to Snowflake
Use CData Sync for automated, continuous, customizable AfterShip replication to Snowflake.
-
Build Bullhorn CRM-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Bullhorn CRM.
-
Analyze OneNote Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for OneNote from Power Pivot. You will use the Table Import Wizard to load Microsoft OneNote. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Kiro CLI with SageHR 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.
-
Automate GitHub Data Replication to SAP HANA
Use CData Sync to customize and automate GitHub replication to SAP HANA.
-
Automate Marketo Data Replication to Couchbase
Use CData Sync to Customize and automate Marketo replication to Couchbase.
-
How to work with Bitly Data in Apache Spark using SQL
Access and process Bitly Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live Pipedrive Data in AWS Lambda
Connect to live Pipedrive in AWS Lambda using the CData JDBC Driver.
-
Connect to SQL Analysis Services Data from PowerBuilder via ADO.NET
This article demonstrates how to access SQL Analysis Services from Appeon PowerBuilder using the CData ADO.NET Provider for SQL Analysis Services.
-
Visualize OnePageCrm Data in Tableau
The CData ODBC driver for OnePageCrm enables you integrate OnePageCrm into Tableau dashboards.
-
Connect to Amazon S3 Data from a Connection Pool in Jetty
The Amazon S3 JDBC Driver supports connection pooling: This article shows how to connect faster to Amazon S3 from Web apps in Jetty.
-
Query MongoDB Data as a MySQL Database in Node.js
Execute MySQL queries against MongoDB from Node.js.
-
How to Easily Query Cloudflare Data in OpenOffice Base
Connect to Cloudflare data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create Datasets from PostgreSQL in Domo Workbench and Build Visualizations of PostgreSQL Data in Domo
Use the CData Software ODBC Driver for PostgreSQL to create datasets from PostgreSQL in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Google Forms Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Forms replication to Amazon S3.
-
Query Google Spanner Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Spanner.
-
Publish AgileCRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live AgileCRM.
-
Query Live Quickbase Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Quickbase directly from the development environment.
-
How to integrate Microsoft Planner with Apache Airflow
Access and process Microsoft Planner in Apache Airflow using the CData JDBC Driver.
-
Access Live ClickUp Data in Coginiti Pro
Connect to and query live ClickUp from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for MySQL
Provide connectivity to MySQL through an SAP BusinessObjects universe.
-
Automate Sage 300 Data Replication to SAP HANA
Use CData Sync to customize and automate Sage 300 replication to SAP HANA.
-
How to Easily Query Optimizely Data in OpenOffice Base
Connect to Optimizely data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Using the CData Software ODBC Driver for Access in PyCharm
Connect to Access as an ODBC data source in PyCharm using the CData Software ODBC Driver for Access.
-
Analyze Redshift Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Amazon Redshift and visualize live Amazon Redshift in Infragistics Reveal.
-
Automated Continuous Wrike Replication to SingleStore
Use CData Sync for automated, continuous, customizable Wrike replication to SingleStore.
-
Analyze Amazon Marketplace Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Amazon Marketplace from Power Pivot. You will use the Table Import Wizard to load Amazon Marketplace. You can visually build the import query or use any SQL supported by the driver.
-
How to Work with Microsoft Entra ID Data in AWS Glue Jobs Using JDBC
Connect to Microsoft Entra ID from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Publish Reports with Accelo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Accelo.
-
A PostgreSQL Interface for Samanage Data (MySQL Remoting via JDBC)
Use the Remoting features of the Samanage JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with MongoDB Data in SnapLogic
Use CData Connect AI to connect to and integrate with live MongoDB in SnapLogic.
-
Integrate with Salesforce Data 360 Data in JReport Designer
Create charts and reports based on Salesforce Data 360 in JReport Designer.
-
Integrate with Act-On Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Act-On in SnapLogic.
-
Automated Continuous Azure Blob Storage Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Amazon Redshift.
-
Manage BigCommerce Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for BigCommerce.
-
Prepare, Blend, and Analyze Calendly Data in Alteryx Designer (ODBC)
Build workflows to access live Calendly for self-service data analytics.
-
How to Connect DBeaver to Mouseflow via a JDBC Driver
Manage Mouseflow with visual tools in DBeaver like the query browser.
-
Access NetSuite Saved Searches as Views
You can use CData NetSuite Data Providers to access saved searches from third-party tools.
-
Getting Started with the CData Tableau Connector for Azure Synapse
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Azure Synapse.
-
Connect to Zoho Creator Data in ACL Analytics
Connect to Zoho Creator via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Zoho Creator.
-
How to Connect the Power BI Service to Google Forms: Complete Guide
Connect to the CData Software Power BI Connector for Google Forms from PowerBI.com to provide real-time Google Forms across the organization.
-
Access Live IBM Cloud Object Storage Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live IBM Cloud Object Storage through MCP integration.
-
Visualize Dropbox Data in TIBCO Spotfire through ADO.NET
Integrate Dropbox into dashboards in TIBCO Spotfire.
-
Publish Reports with Greenplum Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pivotal GreenPlum.
-
A PostgreSQL Interface for WordPress Data using the CData ODBC Driver
Use the SQL Gateway and WordPress ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Sentry Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Sentry.
-
Visualize Live Amazon S3 Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Amazon S3 into custom reports in Power BI.
-
Integrating Claude Code CLI with Scrapfly 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.
-
Use ChatGPT to Talk to Your Microsoft Entra ID 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 Microsoft Entra ID for you.
-
Connect to Demio Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Demio to connect to Demio and execute queries in PowerBuilder.
-
Bridge Testmonitor Connectivity with Apache NiFi
Access and process Testmonitor in Apache NiFi using the CData JDBC Driver.
-
Access Live Certinia Data in Excel 365 Online (Excel for the web)
Connect to Certinia from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Oracle Financials Cloud Data in DBeaver
Use the CData ODBC Driver to connect to Oracle Financials Cloud in DBeaver.
-
A PostgreSQL Interface for Zoho Books Data (MySQL Remoting via JDBC)
Use the Remoting features of the Zoho Books JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze MariaDB Data in Cognos Analytics
Use CData Connect AI to connect to MariaDB Data from Cognos Analytics and analyze live MariaDB.
-
Use the CData ODBC Driver for Insightly from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Insightly to connect to Insightly from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Insightly in Excel.
-
Deploy the ADO.NET Provider for Contentful on an SSRS Report Server
Connect to Contentful 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.
-
Use the CData Software JDBC Driver for Optimizely in MicroStrategy
Connect to Optimizely in MicroStrategy Developer using the CData Software JDBC Driver for Optimizely.
-
Query MongoDB Data in DataGrip
Create a Data Source for MongoDB in DataGrip and use SQL to query live MongoDB.
-
Connect to Smartsheet Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Smartsheet to connect to Smartsheet and execute queries in PowerBuilder.
-
How to create an RPA flow for Oracle HCM Cloud Data in UiPath Studio
Use the Oracle HCM Cloud ODBC Driver to create workflows that access real-time Oracle HCM Cloud without any coding.
-
Access Live Redshift Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Redshift data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrating Boomi Agentstudio with Dynamics 365 Business Central Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Dynamics 365 Business Central, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate SharePoint Excel Services Data in Pentaho Data Integration
Build ETL pipelines based on SharePoint Excel Services in the Pentaho Data Integration tool.
-
DataBind Cvent Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Cvent with the DevExpress Windows Forms and Web controls to provide Cvent to a chart.
-
Integrate Real-Time Access to Trello in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Trello in real time.
-
How to connect and process Coda from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Coda.
-
Connect to Office 365 Data in Ruby
Connect to Microsoft Office 365 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.