CData Software - Knowledge Base
Recent Articles
-
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.
-
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 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.
-
Access Oracle HCM Cloud Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Oracle HCM Cloud 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 through CData Connect AI.
-
Integrating GitHub Copilot CLI with Pinterest 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 Dashboards with SAP SuccessFactors LMS Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP SuccessFactors LMS in DBxtra.
-
Build a Simple VCL Application for ZohoSubscriptions Data
How to build a simple VCL Application to view ZohoSubscriptions in RAD Studio using the CData ODBC Driver for ZohoSubscriptions.
-
Connect to Nuclia Data in NetBeans
Connect to Nuclia 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 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 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.
-
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 in Power Apps.
-
Access Live ConvertKit Data in AWS Lambda
Connect to live ConvertKit 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 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 in DBeaver.
-
How to connect to SAP Ariba Procurement Data from IntelliJ
Integrate connectivity to SAP Ariba Procurement with wizards in IntelliJ.
-
Migrating data from ClickTime to Databricks using CData SSIS Components.
Easily push ClickTime to Databricks using the CData SSIS Tasks for ClickTime and Databricks.
-
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.
-
Import Real-Time Exact Online Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Exact Online in ColdFusion.
-
Automate Stripe Data Replication to Azure Data Lake
Use CData Sync to customize and automate Stripe replication to Azure Data Lake.
-
Automated Continuous Instagram Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Instagram 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 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 in JDBI.
-
Query Azure Table Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Azure Table Storage and perform CRUD operations on Azure Table from Node.js.
-
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 & Force.com.
-
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.
-
How to create Wrike federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Wrike in MySQL .
-
How to Query Live SAP BusinessObjects BI Data in Claude Desktop
Connect to and query live SAP BusinessObjects BI Data in Claude Desktop using CData MCP Server.
-
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 through MCP integration.
-
Integrate Bright Data Data in Pentaho Data Integration
Build ETL pipelines based on Bright 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 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 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 CLI 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 across the organization.
-
How to Access JotForm Data Using Entity Framework
This article shows how to access JotForm 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 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.
-
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 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 Apache Parquet 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.
-
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 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 in QuerySurge using the CData JDBC Driver.
-
Integrating Kiro CLI 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 in Python with petl.
-
Replicate SAP Business Warehouse Data from PowerShell
Write a quick PowerShell script to query SAP Business Warehouse. Use connectivity to the live data to replicate SAP Business Warehouse to SQL Server.
-
Build BigQuery Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google BigQuery 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 IBM DB2.
-
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
-
How to Connect to Lakebase Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Lakebase. 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 from Web apps in Jetty.
-
Access Live PagerDuty Data in AWS Lambda (with IntelliJ IDEA)
Connect to live PagerDuty 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 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 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 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
-
Import Cloudant Data Using Azure Data Factory
Use CData Connect AI to connect to Cloudant Data from Azure Data Factory and import live IBM Cloudant.
-
Connect to Xero Data in RazorSQL
Connect to Xero from wizards and query Xero Accounting 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 Apache Hive 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, 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.
-
Connect to Zoho Inventory in SpagoBI
Create reports featuring live Zoho Inventory in SpagoBI Studio. Host Zoho Inventory reports on SpagoBI Server.
-
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 in your FileMaker applications.
-
Publish BambooHR-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live BambooHR.
-
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 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 Apache Phoenix.
-
Connect to BigCommerce Data in NetBeans
Connect to BigCommerce in NetBeans with the data source configuration wizard.
-
Connect to Eventbrite Data in DBeaver
Use the CData ODBC Driver to connect to Eventbrite 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 within assisted coding and automated development workflows.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Simplesat
Provide connectivity to Simplesat through an SAP BusinessObjects universe.
-
Feed Dynamics NAV Data into FineReport
How to set Microsoft Dynamics NAV 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 from within the chat interface.
-
Integrating Cursor CLI 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.
-
How to Query Live Authorize.Net Data in Claude Desktop
Connect to and query live Authorize.Net Data in Claude Desktop using CData MCP Server.
-
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 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. 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.
-
How to Import Data from SAP SuccessFactors into Google Sheets
Import SAP SuccessFactors into a Google spreadsheet that is automatically refreshed.
-
ETL Confluence in Oracle Data Integrator
This article shows how to transfer Atlassian Confluence into a data warehouse using Oracle Data Integrator.
-
Connect to Campaigner 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 Campaigner and work with Campaigner in your FileMaker application.
-
Connect to Amplitude Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Amplitude as an External Source in Dremio.
-
Work with Procore Data in FoxPro
Load Procore into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Epicor Kinetic Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Google BigQuery.
-
Work with QuickBooks Time Data in FoxPro
Load QuickBooks Time into a FoxPro database. This article includes full code and a walk-through of the process.