CData Software - Knowledge Base
Recent Articles
-
Integrate Live Mixpanel Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Mixpanel data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automated Continuous Zoho Inventory Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Apache Cassandra.
-
Connect to Live Sage 200 Data in MicroStrategy through CData Connect AI
Create a live connection to Sage 200 Data in CData Connect AI and connect to your Sage 200 data from MicroStrategy.
-
Build Snapchat Ads-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Snapchat Ads data.
-
Build a PostgreSQL Interface for Salesforce CRM Analytics Data using the CData JDBC Driver
Use the Remoting features of the Salesforce CRM Analytics JDBC Driver to create a PostgreSQL entry-point for data access.
-
Bridge LeadDesk Connectivity with Apache NiFi
Access and process LeadDesk data in Apache NiFi using the CData JDBC Driver.
-
Integrate Adobe Experience Manager with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Adobe Experience Manager with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Adobe Experience Manager data.
-
Access Oracle HCM Cloud Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Oracle HCM Cloud data from HeidiSQL.
-
Build AI Agents with Amazon Marketplace 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 Amazon Marketplace data through CData Connect AI.
-
Integrating GitHub Copilot with Pinterest 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.
-
Build Pipelines with Live Figshare Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Figshare from Google Cloud Data Fusion, enabling the integration of live Figshare data into the building and management of effective data pipelines.
-
Build Dashboards with SAP SuccessFactors LMS Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP SuccessFactors LMS data in DBxtra.
-
Build a Simple VCL Application for ZohoSubscriptions Data
How to build a simple VCL Application to view ZohoSubscriptions data in RAD Studio using the CData ODBC Driver for ZohoSubscriptions.
-
Connect to Nuclia Data in NetBeans
Connect to Nuclia data in NetBeans with the data source configuration wizard.
-
Create SFTP Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SFTP from PowerBI.com to create Power BI Dataflows with real-time data.
-
Using the CData Software ODBC Driver for Microsoft Planner in PyCharm
Connect to Microsoft Planner as an ODBC data source in PyCharm using the CData Software ODBC Driver for Microsoft Planner.
-
Bitly Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Bitly facts in real time.
-
Integrate Live eBay Analytics Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live eBay Analytics data to Blue Prism using the CData ODBC Driver for eBay Analytics to create automated workflows for repetitive business tasks.
-
Deploy the ADO.NET Provider for Google Spanner on an SSRS Report Server
Connect to Google Spanner data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Import Mailjet Data Using Azure Data Factory
Use CData Connect AI to connect to Mailjet Data from Azure Data Factory and import live Mailjet data.
-
Use Dash to Build to Web Apps on Freshteam Data
Create Python applications that use pandas and Dash to build Freshteam-connected web apps.
-
Connect to Real-Time Epicor Kinetic Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Epicor Kinetic and Dataflow to import and use Epicor Kinetic data in Power Apps.
-
Access Live ConvertKit Data in AWS Lambda
Connect to live ConvertKit data in AWS Lambda using the CData JDBC Driver.
-
Access Live SAP Ariba Source Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Ariba Source data from your Excel spreadsheets.
-
Connect to IBM Informix Data as an External Source in Dremio
Use the CData JDBC Driver to connect to IBM Informix as an External Source in Dremio.
-
Connect to Workday Data in DBeaver
Use the CData ODBC Driver to connect to Workday data in DBeaver.
-
How to connect to SAP Ariba Procurement Data from IntelliJ
Integrate connectivity to SAP Ariba Procurement data with wizards in IntelliJ.
-
Migrating data from ClickTime to Databricks using CData SSIS Components.
Easily push ClickTime data to Databricks using the CData SSIS Tasks for ClickTime and Databricks.
-
Automated Continuous Apollo Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Apollo replication to Amazon Redshift.
-
Connect FTP to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect FTP with IBM WebSphere for seamless data integration and connectivity.
-
Build Voice Agents in ElevenLabs with access to Live Exact Online Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Exact Online data.
-
Integrating LangGraph with eBay Analytics Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on eBay Analytics data within automated workflows.
-
Import Real-Time Exact Online Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Exact Online data in ColdFusion.
-
Automate Stripe Data Replication to Azure Data Lake
Use CData Sync to customize and automate Stripe data replication to Azure Data Lake.
-
Automated Continuous Instagram Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Instagram data replication to OneLake in Microsoft Fabric.
-
Connect to Live SAP HANA Data in MicroStrategy through CData Connect AI
Create a live connection to SAP HANA Data in CData Connect AI and connect to your SAP HANA data from MicroStrategy.
-
Create a Data Access Object for Zoho Projects Data using JDBI
A brief overview of creating a SQL Object API for Zoho Projects data in JDBI.
-
Build Anaplan-Connected Apps in Choreo
Use CData Connect AI to connect to Anaplan Data from Choreo and build custom apps using live Anaplan data.
-
Connect to Salesforce 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 Salesforce data.
-
Connect to ZohoDesk Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ZohoDesk data.
-
How to create Wrike federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Wrike data in MySQL .
-
Access Live SAP SuccessFactors 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 SAP SuccessFactors data through MCP integration.
-
Integrate Bright Data Data in Pentaho Data Integration
Build ETL pipelines based on Bright Data data in the Pentaho Data Integration tool.
-
How to connect to Dynamics 365 Business Central Data with Squirrel SQL client
Connect to Dynamics 365 Business Central data and execute queries in the Squirrel SQL Client.
-
Deploy the ADO.NET Provider for QuickBooks Online on an SSRS Report Server
Connect to QuickBooks Online data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrating Cursor with PabblySubscriptions 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.
-
How to Connect the Power BI Service to Suadeo: Complete Guide
Connect to the CData Software Power BI Connector for Suadeo from PowerBI.com to provide real-time Suadeo data across the organization.
-
How to Access JotForm Data Using Entity Framework
This article shows how to access JotForm data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous JotForm Replication to SQLite
Use CData Sync for automated, continuous, customizable JotForm replication to SQLite.
-
Build an OLAP Cube in SSAS from ScrapingBee Data
Establish a connection to ScrapingBee data data from SQL Server Analysis Services, and use the ScrapingBee Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create SAP Netweaver Gateway-Connected Business Apps in AppSheet
Connect to SAP Netweaver Gateway Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP Netweaver Gateway data.
-
Connect to ConvertKit Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ConvertKit and work with ConvertKit data in your FileMaker applications.
-
Connect to Typeform Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Typeform as an External Source in Dremio.
-
Process & Analyze ShipEngine Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ShipEngine Data.
-
Visualize Parquet Data in TIBCO Spotfire through ADO.NET
Integrate Parquet data into dashboards in TIBCO Spotfire.
-
Query Shippo Data in DataGrip
Create a Data Source for Shippo in DataGrip and use SQL to query live Shippo data.
-
Use Biml to Build SSIS Tasks to Replicate Salesforce CRM Analytics Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Salesforce CRM Analytics data to SQL Server.
-
How to Connect to & Open SingleStore Data in Microsoft Excel
This article uses the CData ODBC driver for SingleStore to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Validate SendInBlue Data with QuerySurge
Access and validate SendInBlue data in QuerySurge using the CData JDBC Driver.
-
Integrating Kiro with Simplesat 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.
-
How to Build an ETL App for Salesforce Data 360 Data in Python with CData
Create ETL applications and real-time data pipelines for Salesforce Data 360 data in Python with petl.
-
Replicate SAP Business Warehouse Data from PowerShell
Write a quick PowerShell script to query SAP Business Warehouse data. Use connectivity to the live data to replicate SAP Business Warehouse data to SQL Server.
-
Build BigQuery Visualizations in Tableau Cloud
Use CData Connect AI to connect to live BigQuery data and build visualizations in Tableau Cloud.
-
Connect to and Visualize Live DB2 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live DB2 data.
-
Build a Singer.io Tap for EnterpriseDB With the CData Python Connector
Learn how to easily build a Singer.io Tap for live EnterpriseDB data using the CData Python Connector.
-
How to Connect to Lakebase Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Lakebase data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Dynamics 365 Business Central Replication to SQL Server
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to SQL Server.
-
Connect to JobNimbus Data from a Connection Pool in Jetty
The JobNimbus JDBC Driver supports connection pooling: This article shows how to connect faster to JobNimbus data from Web apps in Jetty.
-
Access Live PagerDuty Data in AWS Lambda (with IntelliJ IDEA)
Connect to live PagerDuty data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Reports from Couchbase Data in Looker Studio
Use CData Connect AI to gain access to live Couchbase data and create custom reports in Looker Studio.
-
Automated Continuous Zoho Inventory Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Azure SQL Database.
-
Connect to Sage Intacct Data in Ruby
Connect to Sage Intacct data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to PhantomBuster Data as an External Source in Dremio
Use the CData JDBC Driver to connect to PhantomBuster as an External Source in Dremio.
-
Connect Freshdesk Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Freshdesk data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData Python Connector for Exa
Learn to install and license the CData Python Connector and configure a connection to live Exa data.
-
Import Cloudant Data Using Azure Data Factory
Use CData Connect AI to connect to Cloudant Data from Azure Data Factory and import live Cloudant data.
-
Connect to Xero Data in RazorSQL
Connect to Xero from wizards and query Xero data from the GUI in the RazorSQL database management tool.
-
Import Hive Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Hive Data and provide access to live Hive data for custom reports in the Power BI Service.
-
Integrating Boomi Agentstudio with Klaviyo Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Klaviyo data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to and Visualize Live Timely Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Timely data.
-
Connect to Zoho Inventory in SpagoBI
Create reports featuring live Zoho Inventory data in SpagoBI Studio. Host Zoho Inventory reports on SpagoBI Server.
-
Connect to AfterShip Data from Crystal Reports
Use CData Connect AI to connect to and report on live AfterShip data from Crystal Reports.
-
Connect to Teamgate Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Teamgate and work with Teamgate data in your FileMaker applications.
-
Publish BambooHR-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live BambooHR data.
-
Connect to Oracle Sales Data in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle Sales in FileMaker Pro to connect to Oracle Sales and work with Oracle Sales data in your FileMaker applications.
-
Connect to Phoenix Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Phoenix data.
-
Connect to BigCommerce Data in NetBeans
Connect to BigCommerce data in NetBeans with the data source configuration wizard.
-
Connect to Eventbrite Data in DBeaver
Use the CData ODBC Driver to connect to Eventbrite data in DBeaver.
-
Integrating Claude Code with FHIR Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on FHIR data within assisted coding and automated development workflows.
-
Integrate with live ZohoInvoice Data in Jitterbit
Use CData Connect AI to connect to and integrate live ZohoInvoice data in Jitterbit.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Simplesat
Provide connectivity to Simplesat data through an SAP BusinessObjects universe.
-
Feed Dynamics NAV Data into FineReport
How to set Dynamics NAV data as a JDBC data source in FineReport.
-
Connecting Pipedream with Salesforce CRM Analytics 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 Salesforce CRM Analytics data in real time.
-
Integrate LibreChat with Live Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Zoho Books data from within the chat interface.
-
Integrating Cursor with LightSpeedRetail 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.
-
Automated Continuous Mailgun Replication to MongoDB
Use CData Sync for automated, continuous, customizable Mailgun replication to MongoDB.
-
Choosing the Best Method to Connect Todoist to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Todoist data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Aha! Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Aha! replication to AlloyDB.
-
Natively Connect to Authorize.Net Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Authorize.Net data. Leverage the native support for ODBC in PHP.
-
Query Webflow Data in DataGrip
Create a Data Source for Webflow in DataGrip and use SQL to query live Webflow data.