CData Software - Knowledge Base
Recent Articles
-
Connect to Odoo Data from a Connection Pool in JBoss
Integrate Odoo data into Java servlets: Use the Management Console in JBoss to install the Odoo JDBC Driver.
-
A PostgreSQL Interface for Oracle Financials Cloud Data using the CData ODBC Driver
Use the SQL Gateway and Oracle Financials Cloud ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Dashboards with BenchmarkEmail Data in DBxtra
Create dynamic dashboards and perform analytics based on BenchmarkEmail data in DBxtra.
-
Easily Integrate Presto Data in Lazarus Pascal IDE
Learn how to easily integrate live Presto data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Sage Intacct Data from Crystal Reports
Use CData Connect AI to connect to and report on live Sage Intacct data from Crystal Reports.
-
Use Microsoft Copilot Studio to talk to your Teradata 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 Teradata data for you.
-
Integrate SAP Fieldglass with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP Fieldglass with External Services.
-
Create Datasets from SendInBlue in Domo Workbench and Build Visualizations of SendInBlue Data in Domo
Use the CData Software ODBC Driver for SendInBlue to create datasets from SendInBlue data in Domo Workbench and then build visualizations in the Domo service.
-
Prepare, Blend, and Analyze Opsgenie Data in Alteryx Designer (ODBC)
Build workflows to access live Opsgenie data for self-service data analytics.
-
Visualize Live IBM Informix Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live IBM Informix data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize CampaignMonitor Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to CampaignMonitor data.
-
Natively Connect to Email Data in PHP
The CData ODBC driver for Email enables you to create PHP applications with connectivity to Email data. Leverage the native support for ODBC in PHP.
-
How to import SQL Analysis Services Data into Apache Solr
Use the CData Software JDBC Driver for SQL Analysis Services in Data Import Handler and create an automated import of SQL Analysis Services data to Apache Solr Enterprise Search platform.
-
Use Microsoft Copilot Studio to talk to your PayPal 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 PayPal data for you.
-
Analyze Klaviyo Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Klaviyo data and visualize live Klaviyo data in Infragistics Reveal.
-
Choosing the Best Method to Connect Gmail to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Gmail data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData Software ODBC Driver for SAP ByDesign in MicroStrategy Web
Connect to SAP ByDesign data in MicroStrategy Web using the CData Software ODBC Driver for SAP ByDesign.
-
Create Apps from SuiteCRM Data in Qlik Sense Cloud
Use CData Connect AI to connect to SuiteCRM Data and build apps from live SuiteCRM data in Qlik Sense Cloud.
-
Operational Reporting on Tanda Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Tanda data.
-
Moving Data from HBase to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live HBase data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automate Salesforce Data 360 Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Salesforce Data 360 data from PowerShell? This article demonstrates how to utilize the Salesforce Data 360 Cmdlets for tasks like connecting to Salesforce Data 360 data, automating operations, downloading data, and more.
-
Extract, Transform, and Load Templated Data in Informatica PowerCenter
Create a simple Workflow for Templated data in Informatica PowerCenter.
-
Connect to Live BigQuery Data in PostGresSQL Interface through CData Connect AI
Create a live connection to BigQuery in CData Connect AI and connect to your BigQuery data from PostgreSQL.
-
Automated Continuous Google Forms Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google Forms data replication to OneLake in Microsoft Fabric.
-
Replicate Multiple ChartMogul Accounts
Replicate multiple ChartMogul accounts to one or many databases.
-
Prepare, Blend, and Analyze Oracle Financials Cloud Data in Alteryx Designer (ODBC)
Build workflows to access live Oracle Financials Cloud data for self-service data analytics.
-
Build Visualizations of ClickUp Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ClickUp data in Birst.
-
Connect to Webflow from Asprova with CData Software ODBC Driver for Webflow
This article shows how to connect faster to Webflow data from Asprova.
-
Create a Data Access Object for ShipEngine Data using JDBI
A brief overview of creating a SQL Object API for ShipEngine data in JDBI.
-
Connect to Paymo Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Paymo and work with Paymo data in your FileMaker applications.
-
How to Build an ETL App for Blackbaud FE NXT Data in Python with CData Connect AI
Build ETL pipelines that read and write live Blackbaud FE NXT data in Python with petl and the CData Connect AI Python SDK.
-
Build a Simple VCL Application for AgileCRM Data
How to build a simple VCL Application to view AgileCRM data in RAD Studio using the CData ODBC Driver for AgileCRM.
-
Connect to Oracle HCM Cloud Data in Jaspersoft Studio
Execute SQL to remote Oracle HCM Cloud data in Jaspersoft Studio.
-
Connect to Invoiced Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Invoiced data in the Denodo Virtual DataPort Administrator.
-
A PostgreSQL Interface for Landbot Data (MySQL Remoting via JDBC)
Use the Remoting features of the Landbot JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Impala-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Impala Data from Zoho Analytics and import live Impala data.
-
Rapidly Develop PagerDuty-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 PagerDuty.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for AdRoll
Provide connectivity to AdRoll data through an SAP BusinessObjects universe.
-
Visualize Google Sheets Data in TIBCO Spotfire through OData
Integrate Google Sheets data into dashboards in TIBCO Spotfire.
-
Connect to Discord Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Discord Data and connect to Discord data in Akorbi Digital RunMyProcess.
-
How to Connect to Live Toggl 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 Toggl data for you.
-
Automated Continuous Greenplum Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Greenplum replication to IBM DB2.
-
Rapidly Develop OpenWeatherMap-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 OpenWeatherMap.
-
Access Reckon 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 Reckon data.
-
Integrate Spotify with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Spotify with External Services.
-
Create SSAS Tabular Models from Bitly Data
How to build a SQL Server Analysis Service Tabular Model from Bitly data using CData drivers.
-
How to create an RPA flow for XML Data in UiPath Studio
Use the XML ODBC Driver to create workflows that access real-time XML data without any coding.
-
Automated Continuous Procore Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Procore replication to AlloyDB.
-
SAP Business Warehouse Reporting in OBIEE with the SAP Business Warehouse JDBC Driver
Deploy the SAP Business Warehouse JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Coda Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Coda data from Filemaker Pro on Mac.
-
Analyze SendGrid Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SendGrid from Power Pivot. You will use the Table Import Wizard to load SendGrid data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Instagram Data in Google Apps Script via Connect AI
Use CData Connect AI to access Instagram data in Google Apps Script.
-
Connect to Vercel Data in RapidMiner
Integrate Vercel data with standard components and data source configuration wizards in RapidMiner Studio.
-
DataBind Controls to SingleStore Data in Delphi
DataBind to SingleStore data in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for HBase in MicroStrategy Web
Connect to HBase data in MicroStrategy Web using the CData Software ODBC Driver for HBase.
-
Automated Continuous SAP Ariba Source Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Vertica.
-
Automated Continuous Azure DevOps Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Apache Kafka.
-
Create Reports from SurveyMonkey Data in Looker Studio
Use CData Connect AI to gain access to live SurveyMonkey data and create custom reports in Looker Studio.
-
How to connect to Qualaroo Data from IntelliJ
Integrate connectivity to Qualaroo data with wizards in IntelliJ.
-
Integrate Live HCL Domino Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to HCL Domino from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live HCL Domino data.
-
Build Charts with SAP Concur Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP Concur data in Clear Analytics.
-
Bridge Exact Online Connectivity with Apache NiFi
Access and process Exact Online data in Apache NiFi using the CData JDBC Driver.
-
Enable the Tally JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Tally data.
-
Connect to Mailjet Data from PowerBuilder via JDBC
This article demonstrates how to access Mailjet data from PowerBuilder using the Mailjet JDBC Driver.
-
Build a Simple VCL Application for WooCommerce Data
How to build a simple VCL Application to view WooCommerce data in RAD Studio using the CData ODBC Driver for WooCommerce.
-
How to Work with Insightly Data in AWS Glue Jobs Using JDBC
Connect to Insightly from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Model CSV Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and CSV, enabling the direct import of real-time CSV data.
-
Visualize Short.io Data in Tableau
The CData ODBC driver for Short.io enables you integrate Short.io data into Tableau dashboards.
-
Build AI Agents with QuickBooks 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 QuickBooks data through CData Connect AI.
-
Automate Mode Data Replication to SAP HANA
Use CData Sync to customize and automate Mode data replication to SAP HANA.
-
Build MVC Applications with Connectivity to SAP Hybris C4C Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP Hybris C4C from an ASP.NET MVC application.
-
Access Live SAP HANA Data in TIBCO Data Virtualization
Use the SAP HANA Tibco DV Adapter to create a SAP HANA data data source in TIBCO Data Virtualization Studio and gain access to live SAP HANA data from your TDV Server.
-
Connecting Moonlit Workflow with PostgreSQL Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your PostgreSQL data in real time.
-
Connect to WooCommerce Data in Claris FileMaker Pro
Use the CData ODBC Driver for WooCommerce in FileMaker Pro to connect to WooCommerce and work with WooCommerce data in your FileMaker applications.
-
Connect to Flowlu Data from PowerBuilder via JDBC
This article demonstrates how to access Flowlu data from PowerBuilder using the Flowlu JDBC Driver.
-
Replicate Adobe Commerce Data to Multiple Databases
Replicate Adobe Commerce data to disparate databases with a point-and-click configuration.
-
Access Live Sage 300 Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Sage 300 data through MCP integration.
-
Create Airtable-Connected Dashboards in Grafana
Connect to Airtable Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Airtable data.
-
Configure the CData JDBC Driver for Freshservice in a Connection Pool in Tomcat
Connect to Freshservice data from a connection pool in Tomcat.
-
Migrating data from Google Calendar to Google BigQuery using CData SSIS Components.
Easily push Google Calendar data to Google BigQuery using the CData SSIS Tasks for Google Calendar and Google BigQuery.
-
Access Google Directory 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 Google Directory data.
-
How to Work with ZohoDesk Data in AWS Glue Jobs Using JDBC
Connect to ZohoDesk from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Work with Billsby Data in ETL Validator JDBC
Connect to Billsby from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect PolyBase to PingOne
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PingOne data.
-
Integrate Cursor with Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live eBay data from within the editor.
-
Build Visualizations of FormSite Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of FormSite data in Birst.
-
Visualize Live Webex Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Webex data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import Real-Time Zoho CRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zoho CRM data in ColdFusion.
-
Integrate QuickBooks with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate QuickBooks with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to QuickBooks data.
-
Visualize Live Google Calendar Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Calendar data.
-
Integrating OpenCode with Toggl 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.
-
Query Snowflake Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Snowflake entities in PHP by modeling them as objects.
-
Automated Continuous Freshdesk Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Freshdesk replication to Google BigQuery.
-
Connect to and Query Outreach.io Data in QlikView over ODBC
Create data visualizations with Outreach.io data in QlikView.
-
A PostgreSQL Interface for Oracle Sales Data (MySQL Remoting via JDBC)
Use the Remoting features of the Oracle Sales JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Gong Data from MySQL in Amazon QuickSight
Connect to Gong and build visualizations of Gong data using a MySQL Connection in Amazon QuickSight.
-
Publish Reports with Dynamics NAV Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Dynamics NAV data.
-
Natively Connect to Mode Data in PHP
The CData ODBC driver for Mode enables you to create PHP applications with connectivity to Mode data. Leverage the native support for ODBC in PHP.
-
DataBind Charts to LeadDesk Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to LeadDesk data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Bridge Datadog Connectivity with Apache NiFi
Access and process Datadog data in Apache NiFi using the CData JDBC Driver.