CData Software - Knowledge Base
Recent Articles
-
Choosing the Best Method to Connect ShipStation to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ShipStation 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 to Apache Solr Enterprise Search platform.
-
Validate Exact Online Data with QuerySurge
Access and validate Exact Online in QuerySurge using the CData JDBC Driver.
-
Connect to Humanity Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Oracle Eloqua Data in JRuby
Create a simple JRuby app with access to live Oracle Eloqua.
-
ETL Zoho Projects in Oracle Data Integrator
This article shows how to transfer Zoho Projects 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.
-
Build Dashboards with Landbot Data in Dundas BI
Create dynamic dashboards and perform analytics based on Landbot 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.
-
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 through CData Connect AI.
-
Getting Started with the CData Power BI Connector for Drift
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
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. 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 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.
-
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 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 from your Excel spreadsheets.
-
How to Query Live Bitbucket Data in Perplexity MacOS Desktop
Connect to and query live Bitbucket Data in Perplexity Desktop using CData MCP Server.
-
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.
-
How to Connect to ZarMoney Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ZarMoney. Leverage the pyodbc module for ODBC in Python.
-
Bridge Google Cloud Storage Connectivity with Apache NiFi
Access and process Google Cloud Storage 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 Database 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 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 Business ByDesign in CData Connect AI and insert SAP Business ByDesign into Amazon QuickSight SPICE to build interactive dashboards.
-
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 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 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 IBM DB2 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 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 for you.
-
Feed eBay Analytics Data into FineReport
How to set eBay Analytics 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 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 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 and integrate live Procore 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.
-
Integrate with Delighted Data in JReport Designer
Create charts and reports based on Delighted in JReport Designer.
-
Integrate ElevenLabs Data in the Pentaho Report Designer
Publish reports based on ElevenLabs in the Pentaho BI tool.
-
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 in MicroStrategy Web using the CData Software JDBC Driver for BambooHR.
-
Query SurveyMonkey Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SurveyMonkey and perform CRUD operations on SurveyMonkey from Node.js.
-
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.
-
How to Access Live Oracle HCM Cloud Data in Visual Studio Code via Cline
Run CData MCP Server for Oracle HCM Cloud on Windows Subsytem for Linux (WSL) and connect to live Oracle HCM Cloud from the Cline extension in Visual Studio Code.
-
Design BIRT Reports on XML Data
Provide current XML Files to your embedded analytics.
-
Automated ZohoMarketingHub Data Replication to Teradata
Use CData Sync to Customize and automate ZohoMarketingHub replication to Teradata.
-
Connect to Google Analytics Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
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 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 without any coding.
-
Use the CData Software JDBC Driver for Helpscout in MicroStrategy
Connect to Helpscout 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 in Python.
-
Build Data Flows from Freshsales to SQL Server using SSIS
Easily back up Freshsales to SQL Server using the SSIS components for Freshsales.
-
Integrating Antigravity CLI with Datadog via CData CLI
Connect Datadog 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 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.
-
Automate Cassandra Data Replication to SAP HANA
Use CData Sync to customize and automate Apache Cassandra 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/TSV Files.
-
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 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 in CData Connect AI and insert SAP Concur into Amazon QuickSight SPICE to build interactive dashboards.
-
Access Live Hacker News Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Hacker News 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 and build web apps with connectivity to live HelloSign.
-
Bridge Delighted Connectivity with Apache NiFi
Access and process Delighted in Apache NiFi using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for SAP Concur in MicroStrategy
Connect to SAP Concur 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.
-
Access Live Gmail Data in TIBCO Data Virtualization
Use the Gmail Tibco DV Adapter to create a Gmail data source in TIBCO Data Virtualization Studio and gain access to live Gmail from your TDV Server.
-
Bidirectional Access to Phoenix Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Apache Phoenix 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 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.
-
Getting Started with the CData Python Connector for Adobe Target
Learn to install and license the CData Python Connector
-
DataBind Controls to Impala Data in C++Builder
DataBind to Apache Impala in C++Builder with standard components and controls.
-
Integrating Codex CLI with Oracle Eloqua Reporting 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.
-
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 securely in real time.
-
Connect to Google Translate Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Translate 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. 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 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 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 in Power Apps.
-
Migrating data from Typeform to Databricks using CData SSIS Components.
Easily push Typeform 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 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 & Force.com.
-
Connect Google Analytics Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Analytics 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 Pivotal GreenPlum from your Google Sheets.
-
Validate Adobe Experience Manager Data with QuerySurge
Access and validate Adobe Experience Manager 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.
-
Connect to and Query Calendly Data in QlikView over ODBC
Create data visualizations with Calendly in QlikView.
-
Automate Facebook Ads Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Facebook Ads and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Create Informatica Mappings From/To a JDBC Data Source for Grafana
Create Grafana data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect SharePoint with Phoenix Data through external lists
Provide Apache Phoenix to SharePoint users as an external list.
-
SAS Data Sets Reporting in OBIEE with the SAS Data Sets JDBC Driver
Deploy the SAS Data Sets JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to connect to OneNote Data from IntelliJ
Integrate connectivity to Microsoft OneNote with wizards in IntelliJ.
-
Model WordPress Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and WordPress, enabling the direct import of real-time WordPress.
-
Replicate Planio Data in Heroku for Use in Salesforce Connect
Replicate Planio to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to and Query ServiceNow Data in QlikView over ODBC
Create data visualizations with ServiceNow in QlikView.
-
Automate SendGrid Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SendGrid and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.