CData Software - Knowledge Base
Recent Articles
-
Integrate Typeform with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Typeform with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Typeform.
-
Automated Continuous SAP Ariba Procurement Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Google Cloud SQL.
-
Excel Spreadsheet Automation on Delighted Data with the QUERY Formula
Pull data from Delighted, automate spreadsheets, and more with the QUERY formula.
-
Build AI/ML Models with Live Salesforce CRM Analytics Data using Dataiku
Connect Salesforce CRM Analytics Data with Dataiku using the CData JDBC Driver for Salesforce CRM Analytics.
-
How to Visualize Facebook Ads Data in Python with pandas
Use pandas and other modules to analyze and visualize live Facebook Ads in Python.
-
Excel Spreadsheet Automation on ADP Data with the QUERY Formula
Pull data from ADP, automate spreadsheets, and more with the QUERY formula.
-
ETL Vercel in Oracle Data Integrator
This article shows how to transfer Vercel into a data warehouse using Oracle Data Integrator.
-
Integrate with Exact Online Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Exact Online to a JSON file on disk.
-
Integrating Dataiku with Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Slack.
-
Process & Analyze Harvest Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Harvest Data.
-
Bind Live Google Calendar Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Calendar data
-
Create Data Visualizations in Cognos BI with Bitbucket Data
Access Bitbucket as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Paymo Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Paymo replication to delimited files (CSV/TSV).
-
Connect to Google Spanner Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Spanner and the SQL Gateway to access Google Spanner from Google Apps Script.
-
Automate FHIR Integration Tasks from PowerShell
Are you in search of a quick and easy way to access FHIR from PowerShell? This article demonstrates how to utilize the FHIR Cmdlets for tasks like connecting to FHIR, automating operations, downloading data, and more.
-
Migrating data from Webex to Google BigQuery using CData SSIS Components.
Easily push Webex to Google BigQuery using the CData SSIS Tasks for Webex and Google BigQuery.
-
DataBind Controls to Splunk Data in Delphi
DataBind to Splunk in Delphi with standard data access components and controls.
-
Provide OData Services of Sage Cloud Accounting Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sage Business Cloud Accounting by developing a WCF Service Application.
-
How to Connect DBeaver to OpenWeatherMap via a JDBC Driver
Manage OpenWeatherMap with visual tools in DBeaver like the query browser.
-
Object-Relational Mapping (ORM) with Cassandra 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 Apache Cassandra into a Java-based ORM framework, Hibernate.
-
Access Mixpanel Data from MySQL in PHP
Connect to Mixpanel through the standard MySQL libraries in PHP.
-
Access Live WooCommerce Data in Coginiti Pro
Connect to and query live WooCommerce from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect Figshare to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Figshare with IBM WebSphere for seamless data integration and connectivity.
-
How to connect SharePoint with REST Data through external lists
Provide REST to SharePoint users as an external list.
-
Connect to Marketo Data from a Connection Pool in Jetty
The Marketo JDBC Driver supports connection pooling: This article shows how to connect faster to Marketo from Web apps in Jetty.
-
Analyze Google Ad Manager Data in Cognos Analytics
Use CData Connect AI to connect to Google Ad Manager Data from Cognos Analytics and analyze live Google Ad Manager.
-
Build Semantic Layer Views for Google Contacts Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Contacts.
-
Query, Visualize, and Share live SAS Data Sets Data in Redash
Use CData Connect AI to connect to live SAS Data Sets in Redash for querying, visualizing, and sharing.
-
How to create an RPA flow for Outlook Data in UiPath Studio
Use the Outlook ODBC Driver to create workflows that access real-time Outlook without any coding.
-
Choosing the Best Method to Connect PhantomBuster to SQL Server: 5 Options Explained
Discover multiple ways to connect and use PhantomBuster from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Access Live Databricks Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Databricks enables you to integrate Databricks into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData ODBC Driver for Jira Assets
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Jira Assets.
-
Migrating data from MailChimp to Google BigQuery using CData SSIS Components.
Easily push MailChimp to Google BigQuery using the CData SSIS Tasks for MailChimp and Google BigQuery.
-
Build Oracle HCM Cloud-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Oracle HCM Cloud to explore live Oracle HCM Cloud Data in Claude Code to assist with building Oracle HCM Cloud-powered applications.
-
How to Work with Contentful Data in AWS Glue Jobs Using JDBC
Connect to Contentful from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build AI/ML Models with Live CloudConvert Data using Dataiku
Connect CloudConvert Data with Dataiku using the CData API Driver for JDBC.
-
Create Data Visualizations in Cognos BI with IBM Informix Data
Access IBM Informix as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Connect to Salesforce Data 360 Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Salesforce Data 360. Leverage the pyodbc module for ODBC in Python.
-
Access Microsoft OneDrive Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft OneDrive from HeidiSQL.
-
Connect to Azure DevOps Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Azure DevOps in Airbyte.
-
Google Translate Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Translate facts in real time.
-
Working with Avro Data in LINQPad
Execute LINQ queries to Apache Avro in LINQPad.
-
Automated Continuous Aircall Replication to Databricks
Use CData Sync for automated, continuous, customizable Aircall replication to Databricks.
-
Integrate Live Klaviyo Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Klaviyo to Blue Prism using the CData ODBC Driver for Klaviyo to create automated workflows for repetitive business tasks.
-
Analyze HDFS Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Apache HDFS and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
View Reports on Real-Time LDAP Objects in Power BI Report Server
Use the CData ODBC Driver for LDAP to visualize LDAP in Power BI Desktop and then publish them to Power BI Report Server.
-
Deploy the ADO.NET Provider for EmailOctopus on an SSRS Report Server
Connect to EmailOctopus 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.
-
DataBind Controls to ShipStation Data in C++Builder
DataBind to ShipStation in C++Builder with standard components and controls.
-
Analyze Planio Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Planio with the CData JDBC Driver for Planio.
-
Build Agents in Relevance AI with Access to Live SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft SharePoint within intelligent agent workflows.
-
Publish Reports with Oracle Service Cloud Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Service Cloud.
-
Connect to iContact Data in JRuby
Create a simple JRuby app with access to live iContact.
-
Automated Continuous Azure Data Lake Storage Replication to SingleStore
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to SingleStore.
-
Access Live SAP Concur Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Concur from your Google Sheets.
-
Visualize Live Email Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Email into custom reports in Power BI.
-
Automated Continuous ChargeOver Replication to SingleStore
Use CData Sync for automated, continuous, customizable ChargeOver replication to SingleStore.
-
Integrate Microsoft Entra ID with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Microsoft Entra ID with External Services.
-
View Reports on Real-Time Databricks Data in Power BI Report Server
Use the CData ODBC Driver for Databricks to visualize Databricks in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Cursor CLI with ZohoInvoice 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 Salesforce Pardot Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Salesforce Pardot.
-
Create Dynamic WooCommerce Grids Using the Infragistics XamDataGrid
Learn how you can connect WooCommerce to Infragistics XamDataGrid to build dynamic grids.
-
Rapidly Develop Figshare-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Figshare.
-
Access Live Freshdesk Data in Excel 365 Online (Excel for the web)
Connect to Freshdesk from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Microsoft Ads Data from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Ads from HeidiSQL.
-
How to Connect to Live Act CRM Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Act CRM for you.
-
Use JayDeBeApi to access Smartsheet Data in Python
Use standard Python scripting and the development environment of your choice to access live Smartsheet.
-
Visualize REST Data in Sisense
Create an ElastiCube in Sisense app with access to REST.
-
Use Dash to Build Web Apps on Zoho Books Data via CData Connect AI
Build interactive Dash web apps on live Zoho Books using pandas and the CData Connect AI Python SDK.
-
Create Informatica Mappings From/To an ODBC Data Source for LinkedIn Ads
Create an ODBC connection to LinkedIn Ads in Informatica and browse and transfer LinkedIn Ads.
-
Migrating data from Act CRM to Databricks using CData SSIS Components.
Easily push Act CRM to Databricks using the CData SSIS Tasks for Act CRM and Databricks.
-
Connect to Paddle Data from PowerBuilder via ADO.NET
This article demonstrates how to access Paddle from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use Microsoft Copilot Studio to talk to your Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Box for you.
-
Connect to Placid Data in DBArtisan
Use wizards in DBArtisan to configure Placid as a data source.
-
Edit and Search External Phoenix Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Apache Phoenix to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Phoenix Data objects that you can access from apps and the dashboard.
-
Access Zuora Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Zuora from HeidiSQL.
-
Use JayDeBeApi to access Intercom Data in Python
Use standard Python scripting and the development environment of your choice to access live Intercom.
-
Connect to SAP SuccessFactors LMS Data from a Connection Pool in Jetty
The SAP SuccessFactors LMS JDBC Driver supports connection pooling: This article shows how to connect faster to SAP SuccessFactors LMS from Web apps in Jetty.
-
Replicate Google Sheets Data in Heroku for Use in Salesforce Connect
Replicate Google Sheets to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to create HBase federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Apache HBase in MySQL .
-
Replicate Notion Data in Heroku for Use in Salesforce Connect
Replicate Notion to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Adobe Commerce Data from MySQL in Amazon QuickSight
Connect to Adobe Commerce and build visualizations of Adobe Commerce using a MySQL Connection in Amazon QuickSight.
-
Create Dynamic Elorus Grids Using the Infragistics XamDataGrid
Learn how you can connect Elorus to Infragistics XamDataGrid to build dynamic grids.
-
Access Live IBM Cloud Object Storage Data in TIBCO Data Virtualization
Use the IBM Cloud Object Storage Tibco DV Adapter to create a IBM Cloud Object Storage data source in TIBCO Data Virtualization Studio and gain access to live IBM Cloud Object Storage from your TDV Server.
-
Use the CData ODBC Driver for Calendly in Microsoft Power Query
You can use the CData Calendly ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Calendly into Microsoft Power Query.
-
Create Data Visualizations Based On Marketo Data in Mode
Use CData Connect AI to connect to Marketo Data from Mode and build visualizations using live
-
Automate SharePoint Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft SharePoint replication to Azure Synapse.
-
Automated Continuous Salesloft Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Salesloft replication to Azure SQL Database.
-
Connect to Splunk Data in RazorSQL
Connect to Splunk from wizards and query Splunk from the GUI in the RazorSQL database management tool.
-
Connect to MessageBird Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for MessageBird to connect to MessageBird and execute queries in PowerBuilder.
-
Integrating Claude Code with EnterpriseDB Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on EnterpriseDB within assisted coding and automated development workflows.
-
Analyze Google Spanner Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Spanner and visualize live Google Spanner in Infragistics Reveal.
-
Extract, Transform, and Load HubDB Data in Informatica PowerCenter
Create a simple Workflow for HubDB in Informatica PowerCenter.
-
Use Dash to Build Web Apps on OData Services via CData Connect AI
Build interactive Dash web apps on live OData using pandas and the CData Connect AI Python SDK.
-
How to create an RPA flow for Typeform Data in UiPath Studio
Use the Typeform ODBC Driver to create workflows that access real-time Typeform without any coding.
-
Build Splunk-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Splunk and build Splunk-connected web apps with Axios.
-
Connect to Microsoft Planner Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Microsoft Planner Data and connect to Microsoft Planner in Akorbi Digital RunMyProcess.
-
Operational Reporting on ZendeskSell Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ZendeskSell.
-
Integrate with SAS Data Sets Data in JReport Designer
Create charts and reports based on SAS Data Sets in JReport Designer.
-
Integrate with live Azure DevOps Data in Jitterbit
Use CData Connect AI to connect to and integrate live Azure DevOps in Jitterbit.
-
Validate Superchat Data with QuerySurge
Access and validate Superchat in QuerySurge using the CData JDBC Driver.