CData Software - Knowledge Base
Recent Articles
-
How to connect to Azure Analysis Services Data from Spring Boot
Connect to Azure Analysis Services in a Spring Boot Application using the CData JDBC Driver for Azure Analysis Services
-
Automate Tasks in Power Automate Using the CData API Server
Automate Shopify actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Integrating Codex CLI with Kintone 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.
-
HDFS Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on HDFS facts in real time.
-
Build Dashboards with Marketo Data in Dundas BI
Create dynamic dashboards and perform analytics based on Marketo in Dundas BI.
-
Create Data Visualizations in Cognos BI with CouchDB Data
Access Apache CouchDB as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Odoo Replication to MongoDB
Use CData Sync for automated, continuous, customizable Odoo replication to MongoDB.
-
Integrating Codex CLI with Databricks 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 Visualize Moosend Data in Python with pandas
Use pandas and other modules to analyze and visualize live Moosend in Python.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP SuccessFactors
Provide connectivity to SAP SuccessFactors through an SAP BusinessObjects universe.
-
Bind Live eBay Analytics Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live eBay Analytics data
-
Integrate with live Stripe Data in Jitterbit
Use CData Connect AI to connect to and integrate live Stripe in Jitterbit.
-
Build a PostgreSQL Interface for Drip Data using the CData JDBC Driver
Use the Remoting features of the Drip JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Discourse Data from a Connection Pool in JBoss
Integrate Discourse into Java servlets: Use the Management Console in JBoss to install the Discourse JDBC Driver.
-
Extract, Transform, and Load Vercel Data in Informatica PowerCenter
Create a simple Workflow for Vercel in Informatica PowerCenter.
-
A PostgreSQL Interface for Neo4J Data using the CData ODBC Driver
Use the SQL Gateway and Neo4J ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Apps with Live SAP Hybris C4C in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP Hybris C4C into the Adalo platform and build custom mobile and web applications with real-time SAP Hybris C4C.
-
Building Dynamic Web Pages with Azure DevOps Data Using AngularJS
Create single-page applications with live connectivity to Azure DevOps using the CData API Server.
-
Getting Started with the CData Excel Add-In for OData
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for OData.
-
Integrating Cursor CLI with Factorial 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 QuickBooks Online-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to QuickBooks Online and build web apps with connectivity to live QuickBooks Online.
-
Automated Continuous Sendwithus Replication to SQLite
Use CData Sync for automated, continuous, customizable Sendwithus replication to SQLite.
-
Automated Continuous Salesforce Pardot Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to delimited files (CSV/TSV).
-
Access Live Impala Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Impala data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create Datasets from Placid in Domo Workbench and Build Visualizations of Placid Data in Domo
Use the CData Software ODBC Driver for Placid to create datasets from Placid in Domo Workbench and then build visualizations in the Domo service.
-
Easily Integrate Sage Cloud Accounting Data in Lazarus Pascal IDE
Learn how to easily integrate live Sage Business Cloud Accounting in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate with FTP Data in SnapLogic
Use CData Connect AI to connect to and integrate with live FTP Servers in SnapLogic.
-
Visualize Dynamics 365 Business Central Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Dynamics 365 Business Central into TIBCO Spotfire.
-
Build Semantic Layer Views for PingOne Data in APOS Live Data Gateway
Use the CData Connector for PingOne in APOS Live Data Gateway to build Semantic Layer Views for PingOne.
-
Build Semantic Layer Views for Zoho CRM Data in APOS Live Data Gateway
Use the CData Connector for Zoho CRM in APOS Live Data Gateway to build Semantic Layer Views for Zoho CRM.
-
Use the CData Software JDBC Driver for Google Campaign Manager 360 in MicroStrategy
Connect to Google Campaign Manager 360 in MicroStrategy Developer using the CData Software JDBC Driver for Google Campaign Manager 360.
-
Stream Workday Data into Apache Kafka Topics
Access and stream Workday in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live Greenplum Data in Excel 365 Online (Excel for the web)
Connect to Pivotal GreenPlum from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Visualize ClickUp Data in Sisense
Create an ElastiCube in Sisense app with access to ClickUp.
-
Automated Continuous Pingdom Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Pingdom replication to OneLake in Microsoft Fabric.
-
Connect to eBay Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Connect DBeaver to Oracle Service Cloud via a JDBC Driver
Manage Oracle Service Cloud with visual tools in DBeaver like the query browser.
-
Integrate Couchbase with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Couchbase with External Services.
-
How to import Drip Data into Apache Solr
Use the CData Software JDBC Driver for Drip in Data Import Handler and create an automated import of Drip to Apache Solr Enterprise Search platform.
-
Use the CData Software JDBC Driver for Azure Data Catalog in MicroStrategy
Connect to Azure Data Catalog in MicroStrategy Developer using the CData Software JDBC Driver for Azure Data Catalog.
-
Integrate Real-Time Access to Zuora in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Zuora in real time.
-
Automated Continuous NetSuite Replication to SQL Server
Use CData Sync for automated, continuous, customizable NetSuite replication to SQL Server.
-
Visualize Box Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Box into TIBCO Spotfire.
-
Getting Started with the CData Power BI Connector for Zoho Inventory
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Zoho Inventory.
-
Connect to and Visualize Live SpaceX Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SpaceX.
-
Automated Continuous Google Sheets Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Sheets replication to PostgreSQL.
-
Replicate Multiple QuickBooks Accounts
Replicate multiple QuickBooks accounts to one or many databases.
-
Query Live Salesforce Marketing Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Salesforce Marketing Cloud directly from the development environment.
-
Replicate SpaceX Data from PowerShell
Write a quick PowerShell script to query SpaceX. Use connectivity to the live data to replicate SpaceX to SQL Server.
-
Use Azure AI Foundry to Talk to Your Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Snapchat Ads for you.
-
Connect to OData in SpagoBI
Create reports featuring live OData in SpagoBI Studio. Host OData reports on SpagoBI Server.
-
Add Zoho Books Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Zoho Books with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Float Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Float replication to Amazon Redshift.
-
Visualize Toggl Data in Tableau
The CData ODBC driver for Toggl enables you integrate Toggl into Tableau dashboards.
-
Design BIRT Reports on Presto Data
Provide current Presto to your embedded analytics.
-
Automated Continuous MessageBird Replication to Databricks
Use CData Sync for automated, continuous, customizable MessageBird replication to Databricks.
-
How to connect to LaunchDarkly Data in DBVisualizer
Integrate LaunchDarkly with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating Codex CLI with Workable 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.
-
Extract, Transform, and Load Smartsheet Data in Informatica PowerCenter
Create a simple Workflow for Smartsheet in Informatica PowerCenter.
-
Automated Continuous Microsoft Dataverse Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Azure SQL Database.
-
Visualize Live SAP Hybris C4C Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Hybris C4C.
-
Build Zuora Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Zuora and build visualizations in Tableau Cloud.
-
Visualize Salesforce CRM Analytics Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Salesforce CRM Analytics.
-
Connect to WordPress Data from HeidiSQL
Use CData Connect AI to connect to and query live WordPress from HeidiSQL.
-
Connect to GraphQL Data in Google Apps Script via Connect AI
Use CData Connect AI to access GraphQL in Google Apps Script.
-
Getting Started with the CData Power BI Connector for Bitbucket
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Bitbucket.
-
DataBind Charts to Oracle SCM Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle SCM from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build a Singer.io Tap for Stack Exchange With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Stack Exchange data using
-
Getting Started with the CData Tableau Connector for Sage Cloud Accounting
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Sage Cloud Accounting.
-
Build Charts with Calendly Data in Clear Analytics
Create dynamic charts and perform analytics based on Calendly in Clear Analytics.
-
How to import DB2 Data into Apache Solr
Use the CData Software JDBC Driver for DB2 in Data Import Handler and create an automated import of IBM DB2 to Apache Solr Enterprise Search platform.
-
Migrating data from OnePageCrm to Google BigQuery using CData SSIS Components.
Easily push OnePageCrm to Google BigQuery using the CData SSIS Tasks for OnePageCrm and Google BigQuery.
-
Analyze Dynamics CRM Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft Dynamics CRM and visualize live Microsoft Dynamics CRM in Infragistics Reveal.
-
Integrating OpenCode Terminal with PhantomBuster 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.
-
Edit and Search External Azure Data Lake Storage Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Azure Data Lake Storage to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Azure Data Lake Storage Data objects that you can access from apps and the dashboard.
-
Build a PostgreSQL Interface for EmailOctopus Data using the CData JDBC Driver
Use the Remoting features of the EmailOctopus JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous SAP Hybris C4C Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Google BigQuery.
-
Stream Hubstaff Data into Apache Kafka Topics
Access and stream Hubstaff in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create a Data Access Object for QuickBooks Data using JDBI
A brief overview of creating a SQL Object API for QuickBooks Desktop in JDBI.
-
Integrating OpenCode Terminal with Square 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.
-
Analyze SpaceX Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SpaceX in Microsoft R Open.
-
Connect to BambooHR from a Connection Pool in WebLogic
Use the CData JDBC Driver for BambooHR to connect to BambooHR from Web applications running on WebLogic.
-
Build Pipelines with Live Smartsheet Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Smartsheet from Google Cloud Data Fusion, enabling the integration of live Smartsheet into the building and management of effective data pipelines.
-
Create IBM Cloud Object Storage-Connected Applications in Appsmith
Connect to IBM Cloud Object Storage Data via CData Connect AI in Appsmith and create custom business applications with real-time access to IBM Cloud Object Storage.
-
Consume Zendesk OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Zendesk feeds that reflect any changes in SAP Lumira.
-
Build Pipelines with Live Azure Table Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Azure Table from Google Cloud Data Fusion, enabling the integration of live Azure Table Storage into the building and management of effective data pipelines.
-
Automated Continuous Kintone Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Kintone replication to OneLake in Microsoft Fabric.
-
Enable the Sage Intacct JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Sage Intacct.
-
Connect to CampaignMonitor Data in RazorSQL
Connect to CampaignMonitor from wizards and query CampaignMonitor from the GUI in the RazorSQL database management tool.
-
Connect to Missive Data in JRuby
Create a simple JRuby app with access to live Missive.
-
Create SSAS Tabular Models from PivotalTracker Data
How to build a SQL Server Analysis Service Tabular Model from PivotalTracker using CData drivers.
-
Moving Data from Zuora to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Zuora data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automate NetSuite Integration Tasks from PowerShell
Are you in search of a quick and easy way to access NetSuite CRM & ERP from PowerShell? This article demonstrates how to utilize the NetSuite Cmdlets for tasks like connecting to NetSuite CRM & ERP, automating operations, downloading data, and more.
-
How to Build an ETL App for SAP BusinessObjects BI Data in Python with CData
Create ETL applications and real-time data pipelines for SAP BusinessObjects BI in Python with petl.
-
Integrate Avalara AvaTax Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Avalara AvaTax and integrate live Avalara AvaTax into your Power Automate tasks.
-
How to Query Outreach.io Data in MySQL Workbench
Execute MySQL queries against live Outreach.io from MySQL Workbench.
-
Build Dashboards with Amplitude Data in Dundas BI
Create dynamic dashboards and perform analytics based on Amplitude in Dundas BI.
-
Automated Continuous Twitter Ads Replication to MySQL
Use CData Sync for automated, continuous, customizable Twitter Ads replication to MySQL.
-
Choosing the Best Method to Connect Vimeo to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Vimeo from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to use SQLAlchemy ORM to access ElevenLabs Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ElevenLabs.