CData Software - Knowledge Base
Recent Articles
-
Build Charts with Mode Data in Clear Analytics
Create dynamic charts and perform analytics based on Mode in Clear Analytics.
-
Connect to FormSite Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for FormSite and the SQL Gateway to access FormSite from Google Apps Script.
-
DataBind Controls to Customer.io Data in C++Builder
DataBind to Customer.io in C++Builder with standard components and controls.
-
Connect to GetResponse Data in Ruby
Connect to GetResponse in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Voice Agents in ElevenLabs with access to Live Quickbase Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Quickbase.
-
Connect to Adobe Analytics Data from AWS Glue
Use CData Connect AI to gain access to live Adobe Analytics from your AWS Glue jobs.
-
Replicate Multiple ZohoMarketingHub Accounts via the CData Sync CLI
Replicate multiple ZohoMarketingHub accounts to one or many databases.
-
Build Bright Data-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Bright Data and build web apps with connectivity to live Bright Data.
-
Integrate with Tally Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Tally ERP to a JSON file on disk.
-
Build Charts with Salesforce Pardot Data in Clear Analytics
Create dynamic charts and perform analytics based on Salesforce Pardot in Clear Analytics.
-
Connect to Oracle Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Oracle Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Campaigner Data in the Pentaho Report Designer
Publish reports based on Campaigner in the Pentaho BI tool.
-
Automated Continuous ZohoInvoice Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to OneLake in Microsoft Fabric.
-
Use JayDeBeApi to access TaxJar Data in Python
Use standard Python scripting and the development environment of your choice to access live TaxJar.
-
Use the CData ODBC Driver for AgileCRM in Microsoft Power Query
You can use the CData AgileCRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import AgileCRM into Microsoft Power Query.
-
Connect to Dynamics 365 Business Central Data in DBArtisan
Use wizards in DBArtisan to configure Dynamics 365 Business Central as a data source.
-
ETL FreshBooks in Oracle Data Integrator
This article shows how to transfer FreshBooks into a data warehouse using Oracle Data Integrator.
-
Consume MariaDB OData Feeds in SAP Lumira
Use the API Server to create data visualizations on MariaDB feeds that reflect any changes in SAP Lumira.
-
Manage OData Services in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for OData.
-
Query Zoho Creator Data as a MySQL Database in Node.js
Execute MySQL queries against Zoho Creator from Node.js.
-
Automated Continuous Kintone Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Kintone replication to PostgreSQL.
-
Integrate NASA Data in the Pentaho Report Designer
Publish reports based on NASA in the Pentaho BI tool.
-
Build Pipelines with Live PayPal Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to PayPal from Google Cloud Data Fusion, enabling the integration of live PayPal into the building and management of effective data pipelines.
-
Visualize Close Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Close.
-
Analyze SAP Business Warehouse Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP Business Warehouse from Power Pivot. You will use the Table Import Wizard to load SAP Business Warehouse. You can visually build the import query or use any SQL supported by the driver.
-
Access Live Cassandra Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Cassandra data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Automated Continuous LightSpeedRetail Replication to Oracle
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to Oracle.
-
How to connect Amazon QuickSight to Greenhouse Data
Create a connection to Greenhouse in CData Connect AI and insert Greenhouse into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Work with Avaza Data in AWS Glue Jobs Using JDBC
Connect to Avaza from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live ClickUp Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ClickUp into the statistical analysis tools available in SAS JMP. This article shows how to use ClickUp in the Graph Builder and Query Builder.
-
A PostgreSQL Interface for ConvertKit Data (MySQL Remoting via JDBC)
Use the Remoting features of the ConvertKit JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Oracle SCM
Provide connectivity to Oracle SCM through an SAP BusinessObjects universe.
-
Create Dynamic Vercel Grids Using the Infragistics XamDataGrid
Learn how you can connect Vercel to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Mouseflow Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Mouseflow to connect to Mouseflow and execute queries in PowerBuilder.
-
Visualize Vault CRM Data in TIBCO Spotfire through ADO.NET
Integrate Veeva Vault & Vault CRM into dashboards in TIBCO Spotfire.
-
How to Build an ETL App for Clockify Data in Python with CData
Create ETL applications and real-time data pipelines for Clockify in Python with petl.
-
Build ConvertAPI-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ConvertAPI and build web apps with connectivity to live ConvertAPI.
-
How to Connect SharePoint Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live SharePoint data in real time using natural language.
-
Analyze Live Workday Data in SAS Viya
Use CData Connect AI to connect to Workday from SAS Viya and deploy self-service analytics using live Workday.
-
Connect to Real-Time Zoho Books Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Zoho Books and Dataflow to import and use Zoho Books in Power Apps.
-
Connect to Coinbase 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 Coinbase and work with Coinbase in your FileMaker application.
-
A PostgreSQL Interface for Teradata Data using the CData ODBC Driver
Use the SQL Gateway and Teradata ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Jira Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Atlassian Jira using standard SQL.
-
Build Data Flows from MySQL to SQL Server using SSIS
Easily back up MySQL to SQL Server using the SSIS components for MySQL.
-
Edit and Search Klaviyo External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Klaviyo to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Klaviyo objects that you can access from apps and the dashboard.
-
Use CData Connect AI to Access Sage 200 Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Sage 200 in the Power Pivot business intelligence tool.
-
How to create an RPA flow for Wrike Data in UiPath Studio
Use the Wrike ODBC Driver to create workflows that access real-time Wrike without any coding.
-
Back Up Acumatica ERP to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Acumatica. In this article, we will employ an SSIS workflow to populate a database with Acumatica ERP data.
-
Replicate Mouseflow Data to Multiple Databases via the CData Sync CLI
Replicate Mouseflow to disparate databases with a single configuration.
-
How to Connect to Live Oracle Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Oracle Database for you.
-
Connect to SAP Ariba Source Data in HULFT Integrate
Connect to SAP Ariba Source as a JDBC data source in HULFT Integrate
-
Access Live SharePoint Excel Services Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SharePoint Excel Services into the statistical analysis tools available in SAS JMP. This article shows how to use SharePoint Excel Services in the Graph Builder and Query Builder.
-
Connect to Real-Time Google Sheets Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Sheets and Dataflow to import and use Google Sheets in Power Apps.
-
Connect to Google Campaign Manager 360 from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Campaign Manager 360 to connect to Google Campaign Manager 360 from Web applications running on WebLogic.
-
Use the CData Software ODBC Driver for Webflow in MicroStrategy Web
Connect to Webflow in MicroStrategy Web using the CData Software ODBC Driver for Webflow.
-
Natively Connect to Pinecone Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Pinecone. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for Everhour in MicroStrategy Web
Connect to Everhour in MicroStrategy Web using the CData Software JDBC Driver for Everhour.
-
How to Build an ETL App for Todoist Data in Python with CData
Create ETL applications and real-time data pipelines for Todoist in Python with petl.
-
Use the CData Software ODBC Driver for Redshift in MicroStrategy Desktop
Connect to Amazon Redshift in MicroStrategy Desktop using the CData Software ODBC Driver for Redshift.
-
Natively Connect to Hacker News Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Hacker News. Leverage the native support for ODBC in PHP.
-
Connect to EnterpriseDB from Asprova with CData Software ODBC Driver for EnterpriseDB
This article shows how to connect faster to EnterpriseDB data from Asprova.
-
Connect to Microsoft Teams Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft Teams as a data source.
-
Use the CData API Server to Access SAP Ariba Source Data in Microsoft PowerPivot
Use the CData API Server to connect to live SAP Ariba Source in the Power Pivot business intelligence tool.
-
Integrating LlamaIndex with Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Atlassian Confluence in real time.
-
Automated Continuous Cloudflare Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Cloudflare replication to Google BigQuery.
-
How to Easily Set Up OAuth Authentication in Salesforce
A quick guide to setting up a Salesforce API app with OAuth 2.0 enabled.
-
How to Connect to & Open Vercel Data in Microsoft Excel
This article uses the CData ODBC driver for Vercel to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Humanity Replication to SQL Server
Use CData Sync for automated, continuous, customizable Humanity replication to SQL Server.
-
Build Charts with ZarMoney Data in Clear Analytics
Create dynamic charts and perform analytics based on ZarMoney in Clear Analytics.
-
Build Salesforce Marketing Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Salesforce Marketing Cloud and build visualizations in Tableau.
-
Access Live Access Data in Coginiti Pro
Connect to and query live Microsoft Access from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create SSAS Tabular Models from Vercel Data
How to build a SQL Server Analysis Service Tabular Model from Vercel using CData drivers.
-
Add Cloudflare Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Cloudflare with the Informatica Enterprise Data Catalog to classify and organize data.
-
Bidirectional Access to Twitter Ads Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Twitter Ads in Filemaker Pro for Mac or Windows.
-
Build a Simple VCL Application for Google Translate Data
How to build a simple VCL Application to view Google Translate in RAD Studio using the CData ODBC Driver for Google Translate.
-
Connect to Zoom Data in JRuby
Create a simple JRuby app with access to live Zoom.
-
Connect to HDFS in SpagoBI
Create reports featuring live Apache HDFS in SpagoBI Studio. Host HDFS reports on SpagoBI Server.
-
Import MailChimp Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to MailChimp Data and provide access to live MailChimp for custom reports in the Power BI Service.
-
How to Work with Power BI XMLA Data in AWS Glue Jobs Using JDBC
Connect to Power BI XMLA from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Query Calendly Data in ColdFusion
Write standard ColdFusion data access code to connect to Calendly.
-
Use Azure AI Foundry to Talk to Your Odoo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Odoo ERP for you.
-
Getting Started with the CData SSIS Components for Mistral AI
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Mistral AI.
-
Integrate Google Drive with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Drive with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Drive.
-
Use the CData Software JDBC Driver for Brex in MicroStrategy Web
Connect to Brex in MicroStrategy Web using the CData Software JDBC Driver for Brex.
-
Bind Live Azure DevOps Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Azure DevOps data
-
Connect to Live Authorize.Net Data in MicroStrategy through CData Connect AI
Create a live connection to Authorize.Net Data in CData Connect AI and connect to your Authorize.Net from MicroStrategy.
-
Connect to Outreach.io Data in Jaspersoft Studio
Execute SQL to remote Outreach.io in Jaspersoft Studio.
-
Automated Continuous Opsgenie Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Opsgenie replication to IBM DB2.
-
Automated Continuous AfterShip Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable AfterShip replication to OneLake in Microsoft Fabric.
-
Provide OData Services of Vimeo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Vimeo by developing a WCF Service Application.
-
How to integrate Google Campaign Manager 360 with Apache Airflow
Access and process Google Campaign Manager 360 in Apache Airflow using the CData JDBC Driver.
-
Integrating GitHub Copilot CLI with Amazon Redshift 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.
-
Import PayPal Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to PayPal Data and provide access to live PayPal for custom reports in the Power BI Service.
-
Integrate Vault CRM Data in the Pentaho Report Designer
Publish reports based on Veeva Vault & Vault CRM in the Pentaho BI tool.
-
Connect to Dynamics 365 Business Central Data from a Connection Pool in Jetty
The Dynamics 365 Business Central JDBC Driver supports connection pooling: This article shows how to connect faster to Dynamics 365 Business Central from Web apps in Jetty.
-
Create Reports with Pushbullet Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pushbullet.
-
Seamlessly Bring QuickBooks Time Data into Retool Using CData Connect AI
Integrate QuickBooks Time data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate with Presto Data in JReport Designer
Create charts and reports based on Presto in JReport Designer.
-
Connect to Azure Table from a Connection Pool in WebLogic
Use the CData JDBC Driver for Azure Table to connect to Azure Table Storage from Web applications running on WebLogic.
-
Replicate Multiple Invoiced Accounts
Replicate multiple Invoiced accounts to one or many databases.