CData Software - Knowledge Base
Recent Articles
-
Easily Integrate Cloudflare Data in Lazarus Pascal IDE
Learn how to easily integrate live Cloudflare in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect to Trello Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Trello. Leverage the pyodbc module for ODBC in Python.
-
Use the CData API Server to Access YouTube Analytics Data in Microsoft PowerPivot
Use the CData API Server to connect to live YouTube Analytics in the Power Pivot business intelligence tool.
-
Stream Guru Data into Apache Kafka Topics
Access and stream Guru in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect SendPulse Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SendPulse using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
SharePoint Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft SharePoint through CData Connect AI using different applications and tools.
-
Build Oracle HCM Cloud-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Oracle HCM Cloud to explore live Oracle HCM Cloud Data in GitHub Copilot to assist with building Oracle HCM Cloud-powered applications.
-
Working with ZeroBounce Data in LINQPad
Execute LINQ queries to ZeroBounce in LINQPad.
-
Build Hive-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Hive Data from Zoho Analytics and import live Apache Hive.
-
Build AI/ML Models with Live Guru Data using Dataiku
Connect Guru Data with Dataiku using the CData API Driver for JDBC.
-
Integrate CampaignMonitor with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate CampaignMonitor with External Services.
-
Automated Continuous Salesforce CRM Analytics Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Apache Cassandra.
-
Integrating GitHub Copilot CLI with Brex 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.
-
How to Connect DBeaver to Printify via a JDBC Driver
Manage Printify with visual tools in DBeaver like the query browser.
-
Integrate Live Gmail Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Gmail and integrate live Gmail into apps built in Microsoft Power Apps.
-
How to Import Data from Ontraport into Google Sheets
Import Ontraport into a Google spreadsheet that is automatically refreshed.
-
How to work with Typeform Data in Apache Spark using SQL
Access and process Typeform Data in Apache Spark using the CData Software JDBC Driver.
-
Work with Pushbullet Data in FoxPro
Load Pushbullet into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Mouseflow Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Mouseflow replication to PostgreSQL.
-
Moving Data from LaunchDarkly to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live LaunchDarkly data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Provide OData Services of Presto Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Presto by developing a WCF Service Application.
-
Use the CData ODBC Driver for Planio in Microsoft Power Query
You can use the CData Planio ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Planio into Microsoft Power Query.
-
Build Dashboards with REST Data in DBxtra
Create dynamic dashboards and perform analytics based on REST in DBxtra.
-
Create Informatica Mappings From/To a JDBC Data Source for LinkedIn Ads
Create LinkedIn Ads data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Salesforce Pardot Data in DBArtisan
Use wizards in DBArtisan to configure Salesforce Pardot as a data source.
-
Connect Coinbase to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Coinbase using the CData Python MCP Server.
-
Work with LaunchDarkly Data in FoxPro
Load LaunchDarkly into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software JDBC Driver for Redshift in MicroStrategy Desktop
Connect to Amazon Redshift in MicroStrategy Desktop using the CData Software JDBC Driver for Redshift.
-
Create Reports with Hugging Face Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Hugging Face.
-
How to Query Live MYOB AccountRight Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live MYOB AccountRight data in natural language using Python.
-
Import Real-Time ConstantContact Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ConstantContact in ColdFusion.
-
How to import Bitbucket Data into Apache Solr
Use the CData Software JDBC Driver for Bitbucket in Data Import Handler and create an automated import of Bitbucket to Apache Solr Enterprise Search platform.
-
How to load Pipeliner CRM data into Elasticsearch via Logstash
Introducing a simple method to load Pipeliner CRM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZohoExpense
Provide connectivity to ZohoExpense through an SAP BusinessObjects universe.
-
Analyze Azure DevOps Data in Looker
Use CData Connect AI to connect to Azure DevOps Data from Looker and build custom apps using live Azure DevOps.
-
Automated Continuous Helpscout Replication to SQLite
Use CData Sync for automated, continuous, customizable Helpscout replication to SQLite.
-
Provide OData Services of SQL Analysis Services Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SQL Analysis Services by developing a WCF Service Application.
-
Create Reports with Freshteam Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Freshteam.
-
Building Dynamic Web Pages with MySQL Data Using AngularJS
Create single-page applications with live connectivity to MySQL using the CData API Server.
-
DataBind HCL Domino Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for HCL Domino with the DevExpress Windows Forms and Web controls to provide HCL Domino to a chart.
-
Rapidly Develop Salesforce-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 Salesforce.
-
Build MVC Applications with Connectivity to REST Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access REST from an ASP.NET MVC application.
-
Excel Spreadsheet Automation on Wave Financial Data with the QUERY Formula
Pull data from Wave Financial, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData ADO.NET Provider for ScrapingBee
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate Perigon with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Perigon with External Services.
-
Use the CData Software JDBC Driver for IBM Cloud Object Storage in MicroStrategy Web
Connect to IBM Cloud Object Storage in MicroStrategy Web using the CData Software JDBC Driver for IBM Cloud Object Storage.
-
Object-Relational Mapping (ORM) with FormSite Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to FormSite into a Java-based ORM framework, Hibernate.
-
Automated Continuous Impala Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apache Impala replication to OneLake in Microsoft Fabric.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Bitbucket
Provide connectivity to Bitbucket through an SAP BusinessObjects universe.
-
How to update SAP Ariba Source from Excel
This article explains how to transfer data from Excel to SAP Ariba Source using the Excel Add-In for SAP Ariba Source.
-
Automated Continuous Amplitude Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Amplitude replication to Google BigQuery.
-
Validate Freshdesk Data with QuerySurge
Access and validate Freshdesk in QuerySurge using the CData JDBC Driver.
-
Build Voice Agents in ElevenLabs with access to Live Shopify Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Shopify.
-
Viewing Act-On Data in RAD Studio Data Explorer
How to view Act-On in RAD Studio Data Explorer using the CData ODBC Driver for Act-On.
-
Access Live Google Calendar Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Google Calendar data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use Microsoft Copilot Studio to talk to your Instagram 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 Instagram for you.
-
Getting Started with the CData Tableau Connector for BigQuery
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google BigQuery.
-
Connect to Omnisend Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Omnisend.
-
Access Live PayPal Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to PayPal from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Design BIRT Reports on Azure Data Lake Storage Data
Provide current Azure Data Lake Storage to your embedded analytics.
-
How to Query Live JotForm Data in Perplexity MacOS Desktop
Connect to and query live JotForm Data in Perplexity Desktop using CData MCP Server.
-
Automate SendInBlue Data Replication to SAP HANA
Use CData Sync to customize and automate SendInBlue replication to SAP HANA.
-
How to Seamlessly Import Google Drive Data into IBM SPSS Modeler
Integrate Google Drive data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
View Reports on Real-Time Pipedrive Data in Power BI Report Server
Use the CData ODBC Driver for Pipedrive to visualize Pipedrive in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Freshservice Data in CloverDX (formerly CloverETL)
Transfer Freshservice using the visual workflow in the CloverDX data integration tool.
-
Automate BenchmarkEmail Integration Tasks from PowerShell
Are you in search of a quick and easy way to access BenchmarkEmail from PowerShell? This article demonstrates how to utilize the BenchmarkEmail Cmdlets for tasks like connecting to BenchmarkEmail, automating operations, downloading data, and more.
-
Connect to JSON Services in DBArtisan
Use wizards in DBArtisan to configure JSON as a data source.
-
Connect SAP SuccessFactors LMS Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP SuccessFactors LMS using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Exa Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Exa using standard SQL.
-
Configure the CData JDBC Driver for FreeAgent in a Connection Pool in Tomcat
Connect to FreeAgent from a connection pool in Tomcat.
-
Getting Started with the CData SSIS Components for ClickTime
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ClickTime.
-
Build Sentry-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sentry.
-
Connect to Mailjet Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use CData Connect AI to Access LinkedIn Data in Microsoft Power Pivot
Use CData Connect AI to connect to live LinkedIn in the Power Pivot business intelligence tool.
-
Connect to HCL Domino Data from PowerBuilder via ADO.NET
This article demonstrates how to access HCL Domino from Appeon PowerBuilder using the CData ADO.NET Provider for HCL Domino.
-
Prepare, Blend, and Analyze Procore Data in Alteryx Designer (Connect AI)
Build workflows to access live Procore for self-service data analytics.
-
Connecting Moonlit Workflow with MySQL 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 MySQL in real time.
-
Automated Continuous Spark Replication to MongoDB
Use CData Sync for automated, continuous, customizable Spark replication to MongoDB.
-
Automated Continuous SAP BusinessObjects BI Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Snowflake.
-
Getting Started with the CData Excel Add-In for Google Spanner
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Spanner.
-
Moving Data from Reply.io to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Reply.io data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating LlamaIndex with FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on FreshBooks in real time.
-
Connect to MySQL 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 MySQL.
-
Connect to GitLab Data from PowerBuilder via JDBC
This article demonstrates how to access GitLab from PowerBuilder using the GitLab JDBC Driver.
-
Query ZohoInvoice Data in ColdFusion
Write standard ColdFusion data access code to connect to ZohoInvoice.
-
Integrate Live Jira Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Jira from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Atlassian Jira.
-
Automated Continuous Tickspot Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Tickspot replication to AlloyDB.
-
Integrate Cline with Live QuickBooks Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live QuickBooks Online from within your IDE.
-
Build Codat-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Codat and build web apps with connectivity to live Codat.
-
Load Google Search Results to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Search to a database.
-
How to connect to Oracle Eloqua Reporting Data in DBVisualizer
Integrate Oracle Eloqua Reporting with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating Gumloop with PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on PayPal within automated workflows.
-
Automated Continuous Oracle SCM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle SCM replication to OneLake in Microsoft Fabric.
-
A PostgreSQL Interface for Amplitude Data (MySQL Remoting via JDBC)
Use the Remoting features of the Amplitude JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Accelo Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Accelo and work with Accelo in your FileMaker applications.
-
Use Manus AI to Talk to Your DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on IBM DB2.
-
Load Qualaroo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Qualaroo to a database.
-
DataBind Controls to Stack Exchange Data in C++Builder
DataBind to Stack Exchange in C++Builder with standard components and controls.
-
How to connect PolyBase to EnterpriseDB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live EnterpriseDB.
-
Getting Started with the CData ODBC Driver for ScrapingBee
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ScrapingBee.