CData Software - Knowledge Base
Recent Articles
-
Use the CData ODBC Driver for Supabase in Microsoft Power Query
You can use the CData Supabase ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Supabase into Microsoft Power Query.
-
Perform Batch Operations with Vault CRM Data in Apache NiFi
Connect to Veeva Vault & Vault CRM and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Replicate Instagram Data to Multiple Databases
Replicate Instagram to disparate databases with a point-and-click configuration.
-
Connect to Zoom Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Zoom from Filemaker Pro on Mac.
-
Connect to Active Directory Data in DBArtisan
Use wizards in DBArtisan to configure Active Directory as a data source.
-
Access Omnisend 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 Omnisend.
-
Easily Integrate AgileCRM Data in Lazarus Pascal IDE
Learn how to easily integrate live AgileCRM in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Viewing Google Cloud Storage Data in RAD Studio Data Explorer
How to view Google Cloud Storage in RAD Studio Data Explorer using the CData ODBC Driver for Google Cloud Storage.
-
Getting Started with the CData Excel Add-In for Hugging Face
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Hugging Face.
-
Getting Started with the CData Connect AI Python SDK for Salesforce CRM Analytics
Install the CData Connect AI Python SDK to read and write live Salesforce CRM Analytics with standard DB-API 2.0 Python code.
-
Integrate Cline with Live Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Salesforce Marketing Cloud from within your IDE.
-
How to Connect DBeaver to Aircall via a JDBC Driver
Manage Aircall with visual tools in DBeaver like the query browser.
-
Connect to EmailOctopus Data in NetBeans
Connect to EmailOctopus in NetBeans with the data source configuration wizard.
-
Explore Geographical Relationships in Testmonitor Data with Power Map
Create data visualizations with Testmonitor in Power Map.
-
Connect to Productboard Data in Ruby
Connect to Productboard in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
A PostgreSQL Interface for MailerLite Data (MySQL Remoting via JDBC)
Use the Remoting features of the MailerLite JDBC Driver to create a PostgreSQL entry-point for data access.
-
Edit and Search Office 365 External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Microsoft Office 365 to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Office 365 objects that you can access from apps and the dashboard.
-
Analyze Sage Cloud Accounting Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Sage Business Cloud Accounting and visualize Sage Business Cloud Accounting in SAP Analytics Cloud.
-
A PostgreSQL Interface for SQL Analysis Services Data (MySQL Remoting via JDBC)
Use the Remoting features of the SQL Analysis Services JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to work with Basecamp Data in Apache Spark using SQL
Access and process Basecamp Data in Apache Spark using the CData Software JDBC Driver.
-
Connecting Pipedream with LinkedIn Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on LinkedIn data in real time.
-
Rapidly Develop Shippo-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 Shippo.
-
Connect to SendPulse Data in CloverDX (formerly CloverETL)
Transfer SendPulse using the visual workflow in the CloverDX data integration tool.
-
How to connect PolyBase to Salesforce Data 360
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Salesforce Data 360.
-
Integrating Codex CLI with Apache CouchDB 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.
-
Use the CData SSIS Components to Insert New or Update Existing Smartsheet Records from SQL Server
Easily push SQL Server data to Smartsheet using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Smartsheet or update existing records with data from a SQL Server database.
-
HelloSign Reporting in OBIEE with the HelloSign JDBC Driver
Deploy the HelloSign JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData ODBC Driver for SingleStore from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SingleStore to connect to SingleStore from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SingleStore in Excel.
-
Connect to CockroachDB Data in RapidMiner
Integrate CockroachDB with standard components and data source configuration wizards in RapidMiner Studio.
-
Extract, Transform, and Load Reckon Data in Informatica PowerCenter
Create a simple Workflow for Reckon in Informatica PowerCenter.
-
Create Apps from WooCommerce Data in Qlik Sense Cloud
Use CData Connect AI to connect to WooCommerce Data and build apps from live WooCommerce in Qlik Sense Cloud.
-
Connect to ConstantContact Data in DBeaver
Use the CData ODBC Driver to connect to ConstantContact in DBeaver.
-
Build SAP Business Warehouse-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SAP Business Warehouse to explore live SAP Business Warehouse Data in Claude Code to assist with building SAP Business Warehouse-powered applications.
-
Use JayDeBeApi to access Mailjet Data in Python
Use standard Python scripting and the development environment of your choice to access live Mailjet.
-
Query Deel Data in DataGrip
Create a Data Source for Deel in DataGrip and use SQL to query live Deel.
-
Integrate Live Couchbase Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Couchbase to Blue Prism using the CData ODBC Driver for Couchbase to create automated workflows for repetitive business tasks.
-
How to Connect to SQL Server Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft SQL Server. Leverage the pyodbc module for ODBC in Python.
-
How to connect to Microsoft Teams Data from Spring Boot
Connect to Microsoft Teams in a Spring Boot Application using the CData JDBC Driver for Microsoft Teams
-
Using the CData Software ODBC Driver for SAP SuccessFactors in PyCharm
Connect to SAP SuccessFactors as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP SuccessFactors.
-
Migrating data from Pipeline CRM to Google BigQuery using CData SSIS Components.
Easily push Pipeline CRM to Google BigQuery using the CData SSIS Tasks for Pipeline CRM and Google BigQuery.
-
Visualize Live Xero Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Xero Accounting into custom reports in Power BI.
-
Automated Continuous Snapchat Ads Replication to SingleStore
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to SingleStore.
-
Bridge Couchbase Connectivity with Apache NiFi
Access and process Couchbase in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Clio Replication to Vertica
Use CData Sync for automated, continuous, customizable Clio replication to Vertica.
-
Getting Started with the CData SSIS Components for Todoist
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Todoist.
-
Automate CockroachDB Integration Tasks from PowerShell
Are you in search of a quick and easy way to access CockroachDB from PowerShell? This article demonstrates how to utilize the CockroachDB Cmdlets for tasks like connecting to CockroachDB, automating operations, downloading data, and more.
-
Use the CData Software ODBC Driver for Dynamics 365 in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft Dynamics 365 in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Dynamics 365.
-
Build a PostgreSQL Interface for Harvest Data using the CData JDBC Driver
Use the Remoting features of the Harvest JDBC Driver to create a PostgreSQL entry-point for data access.
-
Migrating data from Cloudant to Databricks using CData SSIS Components.
Easily push IBM Cloudant to Databricks using the CData SSIS Tasks for Cloudant and Databricks.
-
Migrating data from Sage 200 to Databricks using CData SSIS Components.
Easily push Sage 200 to Databricks using the CData SSIS Tasks for Sage 200 and Databricks.
-
Consume SAP Business One OData Feeds in PowerBuilder
This article demonstrates how to consume SAP Business One as OData feeds from PowerBuilder using the API Server.
-
Build a Simple VCL Application for Marketo Data
How to build a simple VCL Application to view Marketo in RAD Studio using the CData ODBC Driver for Marketo.
-
Rapidly Develop Amplitude-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 Amplitude.
-
Connect to Live Google Analytics Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Analytics in CData Connect AI and connect to your Google Analytics from PostgreSQL.
-
Access Live Trello Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Trello into the statistical analysis tools available in SAS JMP. This article shows how to use Trello in the Graph Builder and Query Builder.
-
Getting Started with the CData ADO.NET Provider for SFTP
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SFTP.
-
Model, Search, and Visualize Live HCL Domino Data in ThoughtSpot
Use CData Connect AI to connect to live HCL Domino for modeling, searching, and visualizing.
-
Use the CData ODBC Driver for Impala in Microsoft Power Query
You can use the CData Impala ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apache Impala into Microsoft Power Query.
-
Build Zoom-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Zoom Data and create custom apps in Mendix.
-
Connect to ZohoExpense Data in RapidMiner
Integrate ZohoExpense with standard components and data source configuration wizards in RapidMiner Studio.
-
Add ZohoExpense Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ZohoExpense with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Xero Data in Ruby
Connect to Xero Accounting in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Model Sybase Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Sybase, enabling the direct import of real-time Sybase.
-
Query Hacker News Data in ColdFusion
Write standard ColdFusion data access code to connect to Hacker News.
-
Build a Singer.io Tap for MessageBird With the CData Python Connector
Learn how to easily build a Singer.io Tap for live MessageBird data using
-
Getting Started with the CData SSIS Components for Aha!
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Aha!.
-
Create SSAS Tabular Models from Float Data
How to build a SQL Server Analysis Service Tabular Model from Float using CData drivers.
-
Connect Sentry Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Sentry using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Power BI Reports on Real-Time ZohoMarketingHub Data
Use the CData ODBC Driver for ZohoMarketingHub to visualize ZohoMarketingHub in Power BI Desktop.
-
Visualize Neo4J Data in Tableau
The CData ODBC driver for Neo4J enables you integrate Neo4J into Tableau dashboards.
-
How to Work with Salesforce Marketing Data in AWS Glue Jobs Using JDBC
Connect to Salesforce Marketing from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Agno to Talk to Your Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Microsoft Teams for you.
-
Automated Continuous Odoo Replication to Oracle
Use CData Sync for automated, continuous, customizable Odoo replication to Oracle.
-
Getting Started with the CData Python Connector for Google Campaign Manager 360
Learn to install and license the CData Python Connector
-
Feed RabbitMQ Data into FineReport
How to set RabbitMQ as a JDBC data source in FineReport.
-
Visualize Live Discord Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Discord.
-
Automate Zendesk Data Replication to Azure Data Lake
Use CData Sync to customize and automate Zendesk replication to Azure Data Lake.
-
Build an OLAP Cube in SSAS from Zuora Data
Establish a connection to Zuora data from SQL Server Analysis Services, and use the Zuora Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect to MailChimp Data from Spring Boot
Connect to MailChimp in a Spring Boot Application using the CData JDBC Driver for MailChimp
-
Build Pipelines with Live LinkedIn Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to LinkedIn from Google Cloud Data Fusion, enabling the integration of live LinkedIn into the building and management of effective data pipelines.
-
Publish Adobe Target-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Adobe Target.
-
Integrate ActiveCampaign Data in the Pentaho Report Designer
Publish reports based on ActiveCampaign in the Pentaho BI tool.
-
Connect to FreshBooks Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time FreshBooks using standard SQL.
-
Feed Google Contacts Data into FineReport
How to set Google Contacts as a JDBC data source in FineReport.
-
Access Live Dynamics 365 Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Microsoft Dynamics 365 from your Excel spreadsheets.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Okta
Provide connectivity to Okta through an SAP BusinessObjects universe.
-
Query GraphQL Data as a SQL Server Database in Node.js
Execute SQL Server queries against GraphQL from Node.js.
-
Consume PingOne OData Feeds in PowerBuilder
This article demonstrates how to consume PingOne as OData feeds from PowerBuilder using the API Server.
-
Build Dashboards with GetResponse Data in DBxtra
Create dynamic dashboards and perform analytics based on GetResponse in DBxtra.
-
Integrate Real-Time Access to Suadeo in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Suadeo in real time.
-
Create Power BI Reports on Real-Time Elasticsearch Data
Use the CData ODBC Driver for Elasticsearch to visualize Elasticsearch in Power BI Desktop.
-
Create SSAS Tabular Models from Salesforce Pardot Data
How to build a SQL Server Analysis Service Tabular Model from Salesforce Pardot using CData drivers.
-
Automate Twilio Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Twilio and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Viewing Neo4J Data in RAD Studio Data Explorer
How to view Neo4J in RAD Studio Data Explorer using the CData ODBC Driver for Neo4J.
-
Getting Started with the CData Python Connector for Basecamp
Learn to install and license the CData Python Connector
-
Integrating Codex CLI with Google Campaign Manager 360 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.
-
Automated Continuous Kafka Replication to SQL Server
Use CData Sync for automated, continuous, customizable Kafka replication to SQL Server.
-
Getting Started with the CData SSIS Components for Oracle
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Oracle.
-
Bidirectional Access to Workable Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Workable in Filemaker Pro for Mac or Windows.
-
Connect to Google Contacts Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Contacts Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.