CData Software - Knowledge Base
Recent Articles
-
ETL Confluence in Oracle Data Integrator
This article shows how to transfer Confluence data into a data warehouse using Oracle Data Integrator.
-
Connect to Campaigner 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 Campaigner and work with Campaigner data in your FileMaker application.
-
Connect to Amplitude Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Amplitude as an External Source in Dremio.
-
Work with Procore Data in FoxPro
Load Procore data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Epicor Kinetic Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Google BigQuery.
-
Work with QuickBooks Time Data in FoxPro
Load QuickBooks Time data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Choosing the Best Method to Connect ShipStation to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ShipStation data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to import PabblySubscriptions Data into Apache Solr
Use the CData Software JDBC Driver for PabblySubscriptions in Data Import Handler and create an automated import of PabblySubscriptions data to Apache Solr Enterprise Search platform.
-
Connecting Mastra with MailerLite Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time MailerLite data, no replication required.
-
Validate Exact Online Data with QuerySurge
Access and validate Exact Online data in QuerySurge using the CData JDBC Driver.
-
Connect to Humanity Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Humanity.
-
Integrate Bitly Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Bitly data and integrate live Bitly data into your Power Automate tasks.
-
Connect to Oracle Eloqua Data in JRuby
Create a simple JRuby app with access to live Oracle Eloqua data.
-
ETL Zoho Projects in Oracle Data Integrator
This article shows how to transfer Zoho Projects data into a data warehouse using Oracle Data Integrator.
-
Build Data Flows from SQL Server to Gmail through SSIS
Easily push SQL Server data to Gmail using the CData SSIS Tasks for Gmail.
-
Operational Reporting on Google Forms Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Forms data.
-
Build Dashboards with Landbot Data in Dundas BI
Create dynamic dashboards and perform analytics based on Landbot data in Dundas BI.
-
Publish Crystal Reports on Zoho CRM Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zoho CRM data.
-
Build AI Agents with Box 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 Box data through CData Connect AI.
-
Analyze Parallel Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Parallel from Power Pivot. You will use the Table Import Wizard to load Parallel data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Hubstaff Data from PowerBuilder via JDBC
This article demonstrates how to access Hubstaff data from PowerBuilder using the Hubstaff JDBC Driver.
-
Getting Started with the CData ADO.NET Provider for LightSpeedRetail
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Mailgun Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Mailgun data.
-
Connecting Agentforce with Dynamics 365 Business Central Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Dynamics 365 Business Central data for you.
-
Access Live Oracle Financials Cloud Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Oracle Financials Cloud data from your Excel spreadsheets.
-
How to connect PolyBase to Adobe Analytics
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Adobe Analytics data.
-
How to Connect to ZarMoney Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ZarMoney data. Leverage the pyodbc module for ODBC in Python.
-
Create Egnyte-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Egnyte Data from OutSystems and build custom enterprise apps using live Egnyte data.
-
Bridge Google Cloud Storage Connectivity with Apache NiFi
Access and process Google Cloud Storage data in Apache NiFi using the CData JDBC Driver.
-
Edit and Search External Oracle Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Oracle data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Oracle Data objects that you can access from apps and the dashboard.
-
Automated Continuous Highrise Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Highrise replication to Apache Kafka.
-
Connect to SAS Data Sets Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAS Data Sets to connect to SAS Data Sets data and execute queries in PowerBuilder.
-
Connect to Cohere Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Cohere as an External Source in Dremio.
-
How to connect Amazon QuickSight to SAP ByDesign Data
Create a connection to SAP ByDesign data in CData Connect AI and insert SAP ByDesign data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrating Dataiku with Google Forms Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Google Forms data.
-
Integrate Trae with Live RSS Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live RSS feeds from within the AI-powered IDE.
-
Connect SAP Hybris C4C Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP Hybris C4C data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Outlook 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 Outlook and work with Outlook data in your FileMaker application.
-
Integrating Zoho Books Data in Talend Cloud Data Management Platform
Connect Zoho Books Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Zoho Books.
-
DataBind Controls to DB2 Data in Delphi
DataBind to DB2 data in Delphi with standard data access components and controls.
-
How to import ConstantContact Data into Apache Solr
Use the CData Software JDBC Driver for ConstantContact in Data Import Handler and create an automated import of ConstantContact data to Apache Solr Enterprise Search platform.
-
How to Connect to Live LinkedIn 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 LinkedIn data for you.
-
Feed eBay Analytics Data into FineReport
How to set eBay Analytics data as a JDBC data source in FineReport.
-
Connect to Real-Time Adobe Target Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Adobe Target and Dataflow to import and use Adobe Target data in Power Apps.
-
Establish a Live Connection with Gumroad Data using Tableau Bridge
The CData ODBC Driver for Gumroad enables you to integrate live Gumroad data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Live Procore Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Procore data and integrate live Procore data into apps built in Microsoft Power Apps.
-
Getting Started with the CData Excel Add-In for Act CRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Act CRM.
-
Build Semantic Layer Views for Tavily Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Tavily data.
-
Integrate ElevenLabs Data in the Pentaho Report Designer
Publish reports based on ElevenLabs data in the Pentaho BI tool.
-
Connecting Mastra with xBase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time xBase data, no replication required.
-
Moving Data from Todoist to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Todoist data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use the CData Software JDBC Driver for BambooHR in MicroStrategy Web
Connect to BambooHR data in MicroStrategy Web using the CData Software JDBC Driver for BambooHR.
-
Publish Reports with Reckon Accounts Hosted Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Reckon Accounts Hosted data.
-
Design BIRT Reports on XML Data
Provide current XML data to your embedded analytics.
-
Automated ZohoMarketingHub Data Replication to Teradata
Use CData Sync to Customize and automate ZohoMarketingHub data replication to Teradata.
-
Connect to Google Analytics Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Google Analytics.
-
Connect to Telegram 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 Telegram and work with Telegram data in your FileMaker application.
-
How to create an RPA flow for Oracle Service Cloud Data in UiPath Studio
Use the Oracle Service Cloud ODBC Driver to create workflows that access real-time Oracle Service Cloud data without any coding.
-
Use the CData Software JDBC Driver for Helpscout in MicroStrategy
Connect to Helpscout data in MicroStrategy Developer using the CData Software JDBC Driver for Helpscout.
-
How to Visualize Reckon Data in Python with pandas
Use pandas and other modules to analyze and visualize live Reckon data in Python.
-
Build Data Flows from Freshsales to SQL Server using SSIS
Easily back up Freshsales data to SQL Server using the SSIS components for Freshsales.
-
How to Connect to Live SAP HANA XS Advanced 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 SAP HANA XS Advanced data for you.
-
Integrating Antigravity CLI with Datadog data via CData CLI
Connect Datadog data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to connect to Rebilly Data from IntelliJ
Integrate connectivity to Rebilly data with wizards in IntelliJ.
-
Integrating Dataiku with SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SingleStore data.
-
Automate Cassandra Data Replication to SAP HANA
Use CData Sync to customize and automate Cassandra data replication to SAP HANA.
-
Build CSV-Connected Apps in Choreo
Use CData Connect AI to connect to CSV Data from Choreo and build custom apps using live CSV data.
-
How to Work with SAP SuccessFactors Data in ETL Validator JDBC
Connect to SAP SuccessFactors from ETL Validator jobs using the CData Software JDBC Driver.
-
Perform Batch Operations with GitHub Data in Apache NiFi
Connect to GitHub data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to connect Amazon QuickSight to SAP Concur Data
Create a connection to SAP Concur data in CData Connect AI and insert SAP Concur data into Amazon QuickSight SPICE to build interactive dashboards.
-
Access Live Hacker News Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Hacker News data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build HelloSign-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to HelloSign data and build web apps with connectivity to live HelloSign data.
-
Use the CData Software JDBC Driver for SAP Concur in MicroStrategy
Connect to SAP Concur data in MicroStrategy Developer using the CData Software JDBC Driver for SAP Concur.
-
Operational Reporting on Quickbase Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Quickbase data.
-
Access Live Gmail Data in TIBCO Data Virtualization
Use the Gmail Tibco DV Adapter to create a Gmail data data source in TIBCO Data Virtualization Studio and gain access to live Gmail data from your TDV Server.
-
Link Phoenix with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Phoenix data in Filemaker Pro for Mac or Windows.
-
Rapidly Develop QuickBooks Online-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 QuickBooks Online.
-
Integrating Brex Data in Talend Cloud Data Management Platform
Connect Brex Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
DataBind Airtable Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Airtable with the DevExpress Windows Forms and Web controls to provide Airtable data to a chart.
-
Connect to Invoiced Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Invoiced data.
-
Getting Started with the CData Python Connector for Adobe Target
Learn to install and license the CData Python Connector and configure a connection to live Adobe Target data.
-
DataBind Controls to Impala Data in C++Builder
DataBind to Impala data in C++Builder with standard components and controls.
-
Integrating Codex with Oracle Eloqua Reporting 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.
-
Publish Crystal Reports on Salesforce Data 360 Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Salesforce Data 360 data.
-
Connect to Omnisend from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Omnisend data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Connect to Live Act CRM Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Act CRM data securely in real time.
-
Connect to Google Translate Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Translate data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Connect to Snapchat Ads Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Snapchat Ads data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Azure Analysis Services Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Azure Analysis Services data using standard SQL.
-
Use ChatGPT to Talk to Your Google Drive 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 Google Drive data for you.
-
Connect to Real-Time Dropbox Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Dropbox and Dataflow to import and use Dropbox data in Power Apps.
-
Migrating data from Typeform to Databricks using CData SSIS Components.
Easily push Typeform data to Databricks using the CData SSIS Tasks for Typeform and Databricks.
-
Build Smartsheet Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Smartsheet data and build visualizations in Tableau Cloud.
-
Automated Continuous BenchmarkEmail Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to delimited files (CSV/TSV).
-
Publish Salesforce-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Salesforce data.
-
Connect Google Analytics Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Analytics data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live Greenplum Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Greenplum data from your Google Sheets.
-
Validate Adobe Experience Manager Data with QuerySurge
Access and validate Adobe Experience Manager data in QuerySurge using the CData JDBC Driver.
-
How to work with Cloudant Data in Apache Spark using SQL
Access and process Cloudant Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Jira Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Jira replication to Azure SQL Database.