CData Software - Knowledge Base
Recent Articles
-
Connect to Oracle Financials Cloud Data in Jaspersoft Studio
Execute SQL to remote Oracle Financials Cloud in Jaspersoft Studio.
-
Moving Data from Helpscout to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Helpscout data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate with HubDB Data in JReport Designer
Create charts and reports based on HubDB in JReport Designer.
-
Use the CData Software JDBC Driver for Act-On in MicroStrategy Desktop
Connect to Act-On in MicroStrategy Desktop using the CData Software JDBC Driver for Act-On.
-
Query Epicor Kinetic Data as a SQL Server Database in Node.js
Execute SQL Server queries against Epicor Kinetic from Node.js.
-
Build Bullhorn CRM-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Bullhorn CRM Data and create custom apps in Mendix.
-
Automated Continuous CampaignMonitor Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Google BigQuery.
-
Automated Continuous RSS Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable RSS replication to Azure SQL Database.
-
Process & Analyze Landbot Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Landbot Data.
-
Integrate SQL Server Data in the Pentaho Report Designer
Publish reports based on Microsoft SQL Server in the Pentaho BI tool.
-
How to Connect the Power BI Service to Typeform: Complete Guide
Connect to the CData Software Power BI Connector for Typeform from PowerBI.com to provide real-time Typeform across the organization.
-
Create Reports with SAP Ariba Procurement Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Ariba Procurement.
-
Automated Continuous Cassandra Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Cassandra replication to Apache Kafka.
-
Use the CData Software ODBC Driver for ShipEngine in SAS for Real-Time Reporting and Analytics
Connect to real-time ShipEngine in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ShipEngine.
-
Connect to SageHR Data in NetBeans
Connect to SageHR in NetBeans with the data source configuration wizard.
-
Use the CData Software ODBC Driver for Cvent in MicroStrategy
Connect to Cvent in MicroStrategy Developer using the CData Software ODBC Driver for Cvent.
-
Use Biml to Build SSIS Tasks to Replicate Snowflake Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Snowflake to SQL Server.
-
Connect to SAP Concur Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP Concur using standard SQL.
-
Use the CData Software ODBC Driver for SAP Netweaver Gateway in MicroStrategy
Connect to SAP Netweaver Gateway in MicroStrategy Developer using the CData Software ODBC Driver for SAP Netweaver Gateway.
-
SAP Ariba Source Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP Ariba Source facts in real time.
-
Integrate Webex Data in Pentaho Data Integration
Build ETL pipelines based on Webex in the Pentaho Data Integration tool.
-
Connecting Agentforce with Couchbase Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Couchbase for you.
-
Connect to SAP Hybris C4C Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP Hybris C4C as an External Source in Dremio.
-
Use Dash to Build to Web Apps on Mixpanel Data
Create Python applications that use pandas and Dash to build Mixpanel-connected web apps.
-
Use Biml to Build SSIS Tasks to Replicate EnterpriseDB Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate EnterpriseDB to SQL Server.
-
ETL PayPal in Oracle Data Integrator
This article shows how to transfer PayPal into a data warehouse using Oracle Data Integrator.
-
Connect to Dropbox Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Dropbox from Filemaker Pro on Mac.
-
Rapidly Develop Toggl-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 Toggl.
-
How to Design Greenplum Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Greenplum from mobile and tablet Power Apps.
-
Analyze Ontraport Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Ontraport in Microsoft R Open.
-
Integrate Goose with Live SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP BusinessObjects BI from within the local AI agent.
-
Build a Simple VCL Application for Azure Analysis Services Data
How to build a simple VCL Application to view Azure Analysis Services in RAD Studio using the CData ODBC Driver for Azure Analysis Services.
-
How to Connect to Live CouchDB Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Apache CouchDB for you.
-
Integrate SingleStore with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SingleStore with External Services.
-
Integrate Google Ads with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Ads with External Services.
-
Access Live Freshdesk Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Freshdesk into the statistical analysis tools available in SAS JMP. This article shows how to use Freshdesk in the Graph Builder and Query Builder.
-
Connect to Spotify Data in NetBeans
Connect to Spotify in NetBeans with the data source configuration wizard.
-
Use the CData SSIS Components to Insert New or Update Existing Snapchat Ads Records from SQL Server
Easily push SQL Server data to Snapchat Ads using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Snapchat Ads or update existing records with data from a SQL Server database.
-
Use the CData Software ODBC Driver for eBay in SAS for Real-Time Reporting and Analytics
Connect to real-time eBay in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for eBay.
-
Use the CData SSIS Components to Insert New or Update Existing TaxJar Records from SQL Server
Easily push SQL Server data to TaxJar using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into TaxJar or update existing records with data from a SQL Server database.
-
Build Charts with MailerLite Data in Clear Analytics
Create dynamic charts and perform analytics based on MailerLite in Clear Analytics.
-
Model, Search, and Visualize Live Cassandra Data in ThoughtSpot
Use CData Connect AI to connect to live Apache Cassandra for modeling, searching, and visualizing.
-
Build Email-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Email.
-
Viewing Procore Data in RAD Studio Data Explorer
How to view Procore in RAD Studio Data Explorer using the CData ODBC Driver for Procore.
-
Connect to Live Hive Data in MicroStrategy through CData Connect AI
Create a live connection to Hive Data in CData Connect AI and connect to your Apache Hive from MicroStrategy.
-
Add HubSpot Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for HubSpot with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Hive from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Apache Hive, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automate QuickBooks Integration Tasks from PowerShell
Are you in search of a quick and easy way to access QuickBooks Desktop from PowerShell? This article demonstrates how to utilize the QuickBooks Cmdlets for tasks like connecting to QuickBooks Desktop, automating operations, downloading data, and more.
-
Build Automated Workflows with Live PostgreSQL Data in Workato
Use CData Connect AI to connect to live PostgreSQL and build automated workflows in Workato.
-
Stream Salesforce Pardot Data into Apache Kafka Topics
Access and stream Salesforce Pardot in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create a Data Access Object for Elorus Data using JDBI
A brief overview of creating a SQL Object API for Elorus in JDBI.
-
Automated Continuous ZohoPeople Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ZohoPeople replication to AlloyDB.
-
DataBind Controls to LinkedIn Ads Data in C++Builder
DataBind to LinkedIn Ads in C++Builder with standard components and controls.
-
Build a PostgreSQL Interface for Coda Data using the CData JDBC Driver
Use the Remoting features of the Coda JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Biml to Build SSIS Tasks to Replicate Perigon Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Perigon to SQL Server.
-
Use Claude to Talk to Your Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Amazon Marketplace for you.
-
Use the CData Software ODBC Driver for IBM Informix in MicroStrategy Desktop
Connect to IBM Informix in MicroStrategy Desktop using the CData Software ODBC Driver for IBM Informix.
-
Build Dashboards with ChartMogul Data in Dundas BI
Create dynamic dashboards and perform analytics based on ChartMogul in Dundas BI.
-
Getting Started with the CData Tableau Connector for Insightly
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Visualize Reckon Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Reckon.
-
Build a Singer.io Tap for Sentry With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Sentry data using
-
Connect to SAP HANA in SpagoBI
Create reports featuring live SAP HANA in SpagoBI Studio. Host SAP HANA reports on SpagoBI Server.
-
How to Connect to Moosend Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Moosend. Leverage the pyodbc module for ODBC in Python.
-
Extend Google Sheets with Zendesk Data
Make calls to Zendesk from Google Apps Script via the API Server.
-
Connect to and Visualize Live Microsoft Dataverse Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Dataverse (CDS).
-
Automated Continuous Apify Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Apify replication to Google BigQuery.
-
Analyze Dynamics CRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Dynamics CRM in Microsoft R Open.
-
Build an OLAP Cube in SSAS from ZohoMarketingHub Data
Establish a connection to ZohoMarketingHub data from SQL Server Analysis Services, and use the ZohoMarketingHub Data Provider to build OLAP cubes for use in analytics and reporting.
-
Analyze Exact Online Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Exact Online and visualize live Exact Online in Infragistics Reveal.
-
Build Semantic Layer Views for Ontraport Data in APOS Live Data Gateway
Use the CData Connector for Ontraport in APOS Live Data Gateway to build Semantic Layer Views for Ontraport.
-
Use Dash to Build to Web Apps on Superchat Data
Create Python applications that use pandas and Dash to build Superchat-connected web apps.
-
Using the CData Software ODBC Driver for Apify in PyCharm
Connect to Apify as an ODBC data source in PyCharm using the CData Software ODBC Driver for Apify.
-
How to connect to Databricks Data in DBVisualizer
Integrate Databricks with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Biml to Build SSIS Tasks to Replicate OData Services to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate OData to SQL Server.
-
Use the CData Software ODBC Driver for Drift in MicroStrategy Desktop
Connect to Drift in MicroStrategy Desktop using the CData Software ODBC Driver for Drift.
-
Integrate Freshdesk Data in Pentaho Data Integration
Build ETL pipelines based on Freshdesk in the Pentaho Data Integration tool.
-
Create Active Directory-Connected Applications in Appsmith
Connect to Active Directory Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Active Directory.
-
Create Reports with Scrapfly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Scrapfly.
-
Visualize Live Parallel Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Parallel.
-
Analyze Oracle HCM Cloud Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Oracle HCM Cloud and visualize Oracle HCM Cloud in SAP Analytics Cloud.
-
Prepare, Blend, and Analyze ZohoDesk Data in Alteryx Designer (ODBC)
Build workflows to access live ZohoDesk for self-service data analytics.
-
Automated Continuous EnterpriseDB Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Google BigQuery.
-
Integrate AdRoll Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live AdRoll from Informatica Cloud.
-
Connect to Klipfolio Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Klipfolio to connect to Klipfolio and execute queries in PowerBuilder.
-
LINQ to XML Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the XML Data Provider.
-
Automated Continuous Salesforce CRM Analytics Replication to MySQL
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to MySQL.
-
Automated Continuous Bitbucket Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Bitbucket replication to AlloyDB.
-
Consume Azure Data Lake Storage OData Feeds in PowerBuilder
This article demonstrates how to consume Azure Data Lake Storage as OData feeds from PowerBuilder using the API Server.
-
View Reports on Real-Time Acumatica Data in Power BI Report Server
Use the CData ODBC Driver for Acumatica to visualize Acumatica ERP in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating GitHub Copilot CLI with ClickTime 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.
-
Create Informatica Mappings From/To an ODBC Data Source for Microsoft OneDrive
Create an ODBC connection to Microsoft OneDrive in Informatica and browse and transfer Microsoft OneDrive.
-
Natively Connect to Sybase Data in PHP
The CData ODBC driver for Sybase enables you to create PHP applications with connectivity to Sybase. Leverage the native support for ODBC in PHP.
-
Integrate Outreach.io Data in the Pentaho Report Designer
Publish reports based on Outreach.io in the Pentaho BI tool.
-
Creating FTP-Connected Applications in Unqork
You can use CData Connect AI to feed FTP Servers to Unqork and build custom business apps.
-
Build Dashboards with Stripe Data in Dundas BI
Create dynamic dashboards and perform analytics based on Stripe in Dundas BI.
-
Integrate Humanity Data in Pentaho Data Integration
Build ETL pipelines based on Humanity in the Pentaho Data Integration tool.
-
Bind Live SAP Business One Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP Business One data
-
DataBind Controls to PayPal Data in Delphi
DataBind to PayPal in Delphi with standard data access components and controls.
-
Integrate Brex with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Brex with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Brex.
-
How to Build an ETL App for Google Forms Data in Python with CData
Create ETL applications and real-time data pipelines for Google Forms in Python with petl.