CData Software - Knowledge Base
Recent Articles
-
Build Automated Workflows with Live PingOne Data in Workato
Use CData Connect AI to connect to live PingOne data and build automated workflows in Workato.
-
Connect to Microsoft Ads Data in RapidMiner
Integrate Microsoft Ads data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Informatica Mappings From/To an ODBC Data Source for Notion
Create an ODBC connection to Notion in Informatica and browse and transfer Notion data.
-
Integrate Trae with Live HDFS Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live HDFS data from within the AI-powered IDE.
-
How to Create Power BI Visual Reports with Real-Time Humanity Data
Use CData Power BI Connectors to visualize Humanity data in Power BI.
-
DataBind Controls to SuiteCRM Data in C++Builder
DataBind to SuiteCRM data in C++Builder with standard components and controls.
-
Connect to Vercel Data in Ruby
Connect to Vercel data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use JayDeBeApi to access SendGrid Data in Python
Use standard Python scripting and the development environment of your choice to access live SendGrid data.
-
Publish Accelo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Accelo data.
-
Process & Analyze SAP Fieldglass Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Fieldglass Data.
-
Integrating Dataiku with Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Jira Assets data.
-
Build SAP Concur-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live SAP Concur data without replication.
-
DataBind Toggl Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Toggl data to a chart.
-
Integrating LangChain with Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Dropbox data within automated workflows.
-
Connect to Perplexity 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 Perplexity and work with Perplexity data in your FileMaker application.
-
Add Simplesat Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Simplesat with the Informatica Enterprise Data Catalog to classify and organize data.
-
Extract, Transform, and Load Timely Data in Informatica PowerCenter
Create a simple Workflow for Timely data in Informatica PowerCenter.
-
Connect to Zoom Data in ACL Analytics
Connect to Zoom data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Zoom data.
-
Automate Dynamics CRM Data Replication to Azure Data Lake
Use CData Sync to customize and automate Dynamics CRM data replication to Azure Data Lake.
-
Connect to Live IBM Informix Data in PostGresSQL Interface through CData Connect AI
Create a live connection to IBM Informix in CData Connect AI and connect to your IBM Informix data from PostgreSQL.
-
Connect to AdRoll Data in JRuby
Create a simple JRuby app with access to live AdRoll data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for OnePageCrm
Provide connectivity to OnePageCrm data through an SAP BusinessObjects universe.
-
Consume Dropbox OData Feeds in PowerBuilder
This article demonstrates how to consume Dropbox data as OData feeds from PowerBuilder using the API Server.
-
Import and Visualize DocuSign Data in Power View
Create data visualizations based on DocuSign data in Excel.
-
Access Live ConstantContact Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ConstantContact data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query CloudConvert Data in ColdFusion
Write standard ColdFusion data access code to connect to CloudConvert data.
-
Import Google Directory Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Directory Data and provide access to live Google Directory data for custom reports in the Power BI Service.
-
How to import Klipfolio Data into Apache Solr
Use the CData Software JDBC Driver for Klipfolio in Data Import Handler and create an automated import of Klipfolio data to Apache Solr Enterprise Search platform.
-
Exa Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Exa facts in real time.
-
Process & Analyze DocuSign Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live DocuSign Data.
-
Build Voice Agents in ElevenLabs with access to Live JSON Services
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live JSON services.
-
Integrate with Mailjet Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Mailjet data to a JSON file on disk.
-
Connect to Real-Time SAP Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SAP and Dataflow to import and use SAP data in Power Apps.
-
Replicate Multiple Zoho CRM Accounts via the CData Sync CLI
Replicate multiple Zoho CRM accounts to one or many databases.
-
How to import Dotmailer Data into Apache Solr
Use the CData Software JDBC Driver for Dotmailer in Data Import Handler and create an automated import of Dotmailer data to Apache Solr Enterprise Search platform.
-
Automated Continuous PayPal Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable PayPal replication to Amazon Redshift.
-
Connect to PolarTeamPro Data from a Connection Pool in Jetty
The PolarTeamPro JDBC Driver supports connection pooling: This article shows how to connect faster to PolarTeamPro data from Web apps in Jetty.
-
How to update Redis from Excel
This article explains how to transfer data from Excel to Redis using the Excel Add-In for Redis.
-
Query RSS Feeds using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume RSS entities in PHP by modeling them as objects.
-
Automated Continuous Presto Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Presto replication to Amazon S3.
-
Integrating Codex with CapsuleCRM 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 FormSite Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for FormSite from Power Pivot. You will use the Table Import Wizard to load FormSite data. You can visually build the import query or use any SQL supported by the driver.
-
Visualize SAP HANA Data in Sisense
Create an ElastiCube in Sisense app with access to SAP HANA data.
-
Connect to Spark in SpagoBI
Create reports featuring live Spark data in SpagoBI Studio. Host Spark reports on SpagoBI Server.
-
Natively Connect to Access Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Access data. Leverage the native support for ODBC in PHP.
-
Use the CData SSIS Components to Insert New or Update Existing DB2 Records from SQL Server
Easily push SQL Server data to DB2 using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into DB2 or update existing records with data from a SQL Server database.
-
Automated Continuous Paylocity Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Paylocity replication to Amazon Redshift.
-
Integrate Dify with Live AfterShip Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live AfterShip data.
-
Integrating Cursor with Bitbucket 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 SAS xpt Data in Aqua Data Studio
Access SAS xpt data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for EnterpriseDB
Provide connectivity to EnterpriseDB data through an SAP BusinessObjects universe.
-
Replicate Teamgate Data in Heroku for Use in Salesforce Connect
Replicate Teamgate data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect Zoho CRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zoho CRM data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Visualize Live Azure Data Lake Storage Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Azure Data Lake Storage data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Establish a Live Connection with Miro Data using Tableau Bridge
The CData ODBC Driver for Miro enables you to integrate live Miro data into Tableau Cloud dashboards using the Tableau Bridge.
-
Migrating data from LaunchDarkly to Databricks using CData SSIS Components.
Easily push LaunchDarkly data to Databricks using the CData SSIS Tasks for LaunchDarkly and Databricks.
-
How to connect to Microsoft Teams Data in DBVisualizer
Integrate Microsoft Teams data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect to Live Gong Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Gong data without replication.
-
Query Aircall Data in ColdFusion
Write standard ColdFusion data access code to connect to Aircall data.
-
Visualize Live SAP BusinessObjects BI Data in the Power BI Service
Use CData Connect AI to connect to live SAP BusinessObjects BI data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Oracle Financials Cloud Data from MySQL in PHP
Connect to Oracle Financials Cloud through the standard MySQL libraries in PHP.
-
Visualize Live Asana Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Asana data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Work with Okta Data in AWS Glue Jobs Using JDBC
Connect to Okta from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Bidirectional Access to REST Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate REST data in Filemaker Pro for Mac or Windows.
-
Use ChatGPT to Talk to Your RSS Feeds via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your RSS feeds for you.
-
How to connect and process Factorial data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Factorial data.
-
Automated Continuous Printful Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Printful replication to Apache Kafka.
-
Natively Connect to NASA Data in PHP
The CData ODBC driver for NASA enables you to create PHP applications with connectivity to NASA data. Leverage the native support for ODBC in PHP.
-
Model Google Forms Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Forms, enabling the direct import of real-time Google Forms data.
-
Publish Reports with Salesforce Marketing Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Salesforce Marketing data.
-
LINQ to Cohere 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 Cohere Data Provider.
-
Analyze Short.io Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Short.io data in Microsoft R Open.
-
Replicate Multiple Sage 200 Accounts
Replicate multiple Sage 200 accounts to one or many databases.
-
How to connect SharePoint with Greenplum Data through external lists
Provide Greenplum data to SharePoint users as an external list.
-
How to load Azure Table data into Elasticsearch via Logstash
Introducing a simple method to load Azure Table data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Live Presto Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Presto data to Blue Prism using the CData ODBC Driver for Presto to create automated workflows for repetitive business tasks.
-
Access Zoho Inventory Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zoho Inventory data from your Oracle system.
-
Moving Data from TaxJar to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live TaxJar data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Prepare, Blend, and Analyze SendGrid Data in Alteryx Designer (Connect AI)
Build workflows to access live SendGrid data for self-service data analytics.
-
Excel Spreadsheet Automation on Optimizely Data with the QUERY Formula
Pull data from Optimizely, automate spreadsheets, and more with the QUERY formula.
-
Using the CData Software ODBC Driver for LightSpeedRetail in PyCharm
Connect to LightSpeedRetail as an ODBC data source in PyCharm using the CData Software ODBC Driver for LightSpeedRetail.
-
Access Discourse Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Discourse data from HeidiSQL.
-
How to Build an ETL App for SAP Business Warehouse Data in Python with CData
Create ETL applications and real-time data pipelines for SAP Business Warehouse data in Python with petl.
-
Create Datasets from Typeform in Domo Workbench and Build Visualizations of Typeform Data in Domo
Use the CData Software ODBC Driver for Typeform to create datasets from Typeform data in Domo Workbench and then build visualizations in the Domo service.
-
Analyze ZohoExpense Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ZohoExpense data with the CData JDBC Driver for ZohoExpense.
-
DataBind Attio Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Attio data to a chart.
-
Integrate Real-Time Access to Sage Intacct in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Sage Intacct data in real time.
-
Connect to Codat Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Codat data.
-
Create Dynamic MongoDB Grids Using the Infragistics XamDataGrid
Learn how you can connect MongoDB to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Shippo Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Shippo data in Airbyte.
-
Working with Egnyte Data in LINQPad
Execute LINQ queries to Egnyte data in LINQPad.
-
Connect to Excel Data from a Connection Pool in Jetty
The Excel JDBC Driver supports connection pooling: This article shows how to connect faster to Excel data from Web apps in Jetty.
-
Automated Continuous Eventbrite Replication to Oracle
Use CData Sync for automated, continuous, customizable Eventbrite replication to Oracle.
-
Connect to Salesloft from Asprova with CData Software ODBC Driver for Salesloft
This article shows how to connect faster to Salesloft data from Asprova.
-
A PostgreSQL Interface for Helpscout Data using the CData ODBC Driver
Use the SQL Gateway and Helpscout ODBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Controls to Short.io Data in C++Builder
DataBind to Short.io data in C++Builder with standard components and controls.
-
Integrating Antigravity CLI with Vimeo data via CData CLI
Connect Vimeo data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Grafana Data into Power Automate Desktop using CData Connect
CData Connect for Grafana Data enables you to integrate Grafana data into workflows built using Microsoft Power Automate Desktop.
-
Access Live Vimeo Data in AWS Lambda
Connect to live Vimeo data in AWS Lambda using the CData JDBC Driver.
-
Connect to Salesforce Marketing Data from a Connection Pool in JBoss
Integrate Salesforce Marketing data into Java servlets: Use the Management Console in JBoss to install the Salesforce Marketing JDBC Driver.