CData Software - Knowledge Base
Recent Articles
-
Replicate Gorgias Data in Heroku for Use in Salesforce Connect
Replicate Gorgias to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Import Real-Time Auth0 Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Auth0 in ColdFusion.
-
Use JayDeBeApi to access SAP Concur Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP Concur.
-
Build Data Flows from SharePoint to SQL Server using SSIS
Easily back up Microsoft SharePoint to SQL Server using the SSIS components for SharePoint.
-
Connect to Drip 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 Drip and work with Drip in your FileMaker application.
-
Connect to Google Analytics Data from PowerBuilder via JDBC
This article demonstrates how to access Google Analytics from PowerBuilder using the Google Analytics JDBC Driver.
-
Visualize Live Workday Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Workday using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Apps with Live Pinterest Data Using the Low-Code Development Platform of Mendix
Connect Pinterest with Mendix to build apps using the CData JDBC Driver for Pinterest.
-
Build a Simple VCL Application for Cloudflare Data
How to build a simple VCL Application to view Cloudflare in RAD Studio using the CData ODBC Driver for Cloudflare.
-
Automated Continuous Teamgate Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Teamgate replication to PostgreSQL.
-
Build Dashboards with ZohoMarketingHub Data in DBxtra
Create dynamic dashboards and perform analytics based on ZohoMarketingHub in DBxtra.
-
Connect to ZohoMarketingHub from Asprova with CData Software ODBC Driver for ZohoMarketingHub
This article shows how to connect faster to ZohoMarketingHub data from Asprova.
-
Integrating Antigravity CLI with Perplexity via CData CLI
Connect Perplexity to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Mistral AI Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Mistral AI facts in real time.
-
Bidirectional Access to IBM Informix Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate IBM Informix in Filemaker Pro for Mac or Windows.
-
Automated Continuous ServiceNow Replication to SQL Server
Use CData Sync for automated, continuous, customizable ServiceNow replication to SQL Server.
-
Access Live Microsoft Dataverse Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Dataverse (CDS) into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Dataverse (CDS) in the Graph Builder and Query Builder.
-
Build Apps with Live Power BI XMLA Data Using the Low-Code Development Platform of Mendix
Connect Power BI XMLA with Mendix to build apps using the CData JDBC Driver for Power BI XMLA.
-
Query Mailgun Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Mailgun from Node.js.
-
Import Real-Time Avro Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Apache Avro in ColdFusion.
-
Access Live Certinia 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 Certinia through MCP integration.
-
Connect to Live Microsoft Entra ID Data in MicroStrategy through CData Connect AI
Create a live connection to Microsoft Entra ID Data in CData Connect AI and connect to your Microsoft Entra ID from MicroStrategy.
-
Use ChatGPT to Talk to Your Lakebase 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 Lakebase for you.
-
Automated Continuous SuiteCRM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SuiteCRM replication to OneLake in Microsoft Fabric.
-
Analyze Avro Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Apache Avro in Microsoft R Open.
-
Access Live SAP SuccessFactors Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP SuccessFactors from your Google Sheets.
-
Integrate with BambooHR Data in SnapLogic
Use CData Connect AI to connect to and integrate with live BambooHR in SnapLogic.
-
Using the CData Software ODBC Driver for Kintone in PyCharm
Connect to Kintone as an ODBC data source in PyCharm using the CData Software ODBC Driver for Kintone.
-
How to import Zendesk Data into Apache Solr
Use the CData Software JDBC Driver for Zendesk in Data Import Handler and create an automated import of Zendesk to Apache Solr Enterprise Search platform.
-
How to Query Teamwork Data in MySQL Workbench
Execute MySQL queries against live Teamwork from MySQL Workbench.
-
Use the CData ODBC Driver for Trello in Microsoft Power Query
You can use the CData Trello ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Trello into Microsoft Power Query.
-
Visualize Live Nuclia Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Nuclia.
-
Object-Relational Mapping (ORM) with Access 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 Microsoft Access into a Java-based ORM framework, Hibernate.
-
Automated Billsby Data Replication to Teradata
Use CData Sync to Customize and automate Billsby replication to Teradata.
-
Connect Chargebee to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Chargebee with IBM WebSphere for seamless data integration and connectivity.
-
Use Dash to Build to Web Apps on GitHub Data
Create Python applications that use pandas and Dash to build GitHub-connected web apps.
-
Stream Okta Data into Apache Kafka Topics
Access and stream Okta in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Google Calendar Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Calendar replication to Amazon S3.
-
How to Query Live Dynamics 365 Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Dynamics 365 data in natural language using Python.
-
Migrating data from GetResponse to Snowflake using CData SSIS Components.
Easily push GetResponse to Snowflake using the CData SSIS Tasks for GetResponse and Snowflake.
-
Connect to Live Azure Analysis Services Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Azure Analysis Services in CData Connect AI and connect to your Azure Analysis Services from PostgreSQL.
-
Query Harvest Data in DataGrip
Create a Data Source for Harvest in DataGrip and use SQL to query live Harvest.
-
How to use SQLAlchemy ORM to access Zendesk Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zendesk.
-
Prepare, Blend, and Analyze Neo4J Data in Alteryx Designer (ODBC)
Build workflows to access live Neo4J for self-service data analytics.
-
Build Semantic Layer Views for Okta Data in APOS Live Data Gateway
Use the CData Connector for Okta in APOS Live Data Gateway to build Semantic Layer Views for Okta.
-
Process & Analyze Dynamics 365 Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Dynamics 365 Data.
-
Automated Continuous BigCommerce Replication to MySQL
Use CData Sync for automated, continuous, customizable BigCommerce replication to MySQL.
-
Build Automated Raisers Edge NXT-Connected Workflows in Zapier
Use CData Connect AI to connect to live Raisers Edge NXT and build automated workflows in Zapier.
-
Deploy the ADO.NET Provider for ServiceNow on an SSRS Report Server
Connect to ServiceNow 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.
-
Using the CData Software ODBC Driver for SurveyMonkey in PyCharm
Connect to SurveyMonkey as an ODBC data source in PyCharm using the CData Software ODBC Driver for SurveyMonkey.
-
How to Design Oracle Sales Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Oracle Sales from mobile and tablet Power Apps.
-
Build Dashboards with Scrapfly Data in DBxtra
Create dynamic dashboards and perform analytics based on Scrapfly in DBxtra.
-
Getting Started with the CData JDBC Driver for Deel
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Deel.
-
Use ChatGPT to Talk to Your Elasticsearch 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 Elasticsearch for you.
-
DataBind Controls to ConvertAPI Data in Delphi
DataBind to ConvertAPI in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for TaxJar in MicroStrategy Web
Connect to TaxJar in MicroStrategy Web using the CData Software ODBC Driver for TaxJar.
-
Build Visualizations of Mistral AI Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Mistral AI in Birst.
-
Build Visualizations of Google Ads Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Ads in Birst.
-
Connect to FormSite from Asprova with CData Software ODBC Driver for FormSite
This article shows how to connect faster to FormSite data from Asprova.
-
Stream Paylocity Data into Apache Kafka Topics
Access and stream Paylocity in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Perform Batch Operations with Google Spanner Data in Apache NiFi
Connect to Google Spanner and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to Connect to & Open Smartsheet Data in Microsoft Excel
This article uses the CData ODBC driver for Smartsheet to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to create an RPA flow for Oracle Data in UiPath Studio
Use the Oracle ODBC Driver to create workflows that access real-time Oracle Database without any coding.
-
DataBind Controls to Microsoft Planner Data in C++Builder
DataBind to Microsoft Planner in C++Builder with standard components and controls.
-
Build Cvent-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Cvent Data and create custom apps in Bubble.
-
Integrate with Contentful Data in JReport Designer
Create charts and reports based on Contentful in JReport Designer.
-
Automated Continuous HelloSign Replication to IBM DB2
Use CData Sync for automated, continuous, customizable HelloSign replication to IBM DB2.
-
Integrate Okta with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Okta with External Services.
-
Access PabblySubscriptions Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access PabblySubscriptions from your Oracle system.
-
Getting Started with the CData Excel Add-In for Google Contacts
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Contacts.
-
Connect to ShipEngine Data in RazorSQL
Connect to ShipEngine from wizards and query ShipEngine from the GUI in the RazorSQL database management tool.
-
Visualize Bannerbear Data in Sisense
Create an ElastiCube in Sisense app with access to Bannerbear.
-
Configure the CData JDBC Driver for Raisers Edge NXT in a Connection Pool in Tomcat
Connect to Raisers Edge NXT from a connection pool in Tomcat.
-
How to Visualize Exa Data in Python with pandas
Use pandas and other modules to analyze and visualize live Exa in Python.
-
Design BIRT Reports on Google Cloud Storage Data
Provide current Google Cloud Storage to your embedded analytics.
-
Integrating Antigravity CLI with Google Translate via CData CLI
Connect Google Translate to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Redshift Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Amazon Redshift and integrate live Amazon Redshift into your Power Automate tasks.
-
Query Keap Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Keap from Node.js.
-
Create Data Visualizations Based On Phoenix Data in Mode
Use CData Connect AI to connect to Phoenix Data from Mode and build visualizations using live
-
Replicate Certinia Data from PowerShell
Write a quick PowerShell script to query Certinia. Use connectivity to the live data to replicate Certinia to SQL Server.
-
Access Deel 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 Deel.
-
Integrating Antigravity CLI with SuiteCRM via CData CLI
Connect SuiteCRM to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Connect to Live IBM Informix 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 IBM Informix for you.
-
Load Outlook Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Outlook to a database.
-
Prepare, Blend, and Analyze Freshservice Data in Alteryx Designer (ODBC)
Build workflows to access live Freshservice for self-service data analytics.
-
Edit and Search External Spark Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Apache Spark SQL to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Spark Data objects that you can access from apps and the dashboard.
-
Enable the SAP Business Warehouse JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP Business Warehouse.
-
Use Dash to Build Web Apps on FreshBooks Data via CData Connect AI
Build interactive Dash web apps on live FreshBooks using pandas and the CData Connect AI Python SDK.
-
View Reports on Real-Time Adobe Experience Manager Data in Power BI Report Server
Use the CData ODBC Driver for Adobe Experience Manager to visualize Adobe Experience Manager in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Microsoft Copilot Studio to talk to your Odoo 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 Odoo ERP for you.
-
View Reports on Real-Time Unbounce Data in Power BI Report Server
Use the CData ODBC Driver for Unbounce to visualize Unbounce in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Cursor CLI with CSV 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.
-
How to Connect DBeaver to eBay via a JDBC Driver
Manage eBay with visual tools in DBeaver like the query browser.
-
DataBind BigCommerce Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for BigCommerce with the DevExpress Windows Forms and Web controls to provide BigCommerce to a chart.
-
Build Sage 200 Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Sage 200 and build visualizations in Tableau Cloud.
-
Extract, Transform, and Load Oracle HCM Cloud Data in Informatica PowerCenter
Create a simple Workflow for Oracle HCM Cloud in Informatica PowerCenter.
-
Connect to Google Calendar Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Calendar from Appeon PowerBuilder using the CData ADO.NET Provider for Google Calendar.
-
Connect to Act CRM Data in DBArtisan
Use wizards in DBArtisan to configure Act CRM as a data source.
-
Build Automated Workflows with Live GitLab Data in Workato
Use CData Connect AI to connect to live GitLab and build automated workflows in Workato.
-
Extract, Transform, and Load Teamwork Data in Informatica PowerCenter
Create a simple Workflow for Teamwork in Informatica PowerCenter.