CData Software - Knowledge Base
Recent Articles
-
Connect to Figshare Data from a Connection Pool in Jetty
The Figshare JDBC Driver supports connection pooling: This article shows how to connect faster to Figshare from Web apps in Jetty.
-
ETL LeadDesk in Oracle Data Integrator
This article shows how to transfer LeadDesk into a data warehouse using Oracle Data Integrator.
-
Connect to OData Services from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time OData using standard SQL.
-
Prepare, Blend, and Analyze Notion Data in Alteryx Designer (ODBC)
Build workflows to access live Notion for self-service data analytics.
-
Build Dashboards with Retently Data in DBxtra
Create dynamic dashboards and perform analytics based on Retently in DBxtra.
-
How to Seamlessly Import Codat Data into IBM SPSS Modeler
Integrate Codat data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Analyze Zoho Projects Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Zoho Projects and visualize live Zoho Projects in Infragistics Reveal.
-
Build a Singer.io Tap for ClickTime With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ClickTime data using
-
Use the CData Software JDBC Driver for Vault CRM in MicroStrategy
Connect to Veeva Vault & Vault CRM in MicroStrategy Developer using the CData Software JDBC Driver for Vault CRM.
-
Migrating data from Freshservice to Databricks using CData SSIS Components.
Easily push Freshservice to Databricks using the CData SSIS Tasks for Freshservice and Databricks.
-
Excel Spreadsheet Automation on HCL Domino Data with the QUERY Formula
Pull data from HCL Domino, automate spreadsheets, and more with the QUERY formula.
-
Natively Connect to Zoho Inventory Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Zoho Inventory. Leverage the native support for ODBC in PHP.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Gorgias
Provide connectivity to Gorgias through an SAP BusinessObjects universe.
-
Build MVC Applications with Connectivity to Webflow Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Webflow from an ASP.NET MVC application.
-
Automated Continuous FHIR Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable FHIR replication to Google Cloud SQL.
-
Connect to Bitbucket Data in Ruby
Connect to Bitbucket in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Creating Office 365-Connected Applications in Unqork
You can use CData Connect AI to feed Microsoft Office 365 to Unqork and build custom business apps.
-
How to work with Email Data in Apache Spark using SQL
Access and process Email Data in Apache Spark using the CData Software JDBC Driver.
-
Choosing the Best Method to Connect PDFMonkey to SQL Server: 5 Options Explained
Discover multiple ways to connect and use PDFMonkey from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating OpenCode Terminal with Mixpanel 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.
-
Easily Integrate Hugging Face Data in Lazarus Pascal IDE
Learn how to easily integrate live Hugging Face in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous LDAP Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable LDAP replication to Apache Kafka.
-
Import and Visualize Instagram Data in Power View
Create data visualizations based on Instagram in Excel.
-
Build QuickBooks Time-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live QuickBooks Time.
-
Integrate Live Webflow Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Webflow to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automated Continuous ClickUp Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ClickUp replication to Amazon Redshift.
-
How to update Microsoft Exchange from Excel
This article explains how to transfer data from Excel to Microsoft Exchange using the Excel Add-In for Microsoft Exchange.
-
Analyze HCL Domino Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of HCL Domino and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automate Retently Data Replication to Azure Synapse
Use CData Sync to customize and automate Retently replication to Azure Synapse.
-
Use the CData ODBC Driver for Anaplan from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Anaplan to connect to Anaplan from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Anaplan in Excel.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Paylocity
Provide connectivity to Paylocity through an SAP BusinessObjects universe.
-
Connect to Oracle from a Connection Pool in WebLogic
Use the CData JDBC Driver for Oracle to connect to Oracle Database from Web applications running on WebLogic.
-
Extract, Transform, and Load ActiveCampaign Data in Informatica PowerCenter
Create a simple Workflow for ActiveCampaign in Informatica PowerCenter.
-
Getting Started with the CData ODBC Driver for Instantly
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Instantly.
-
Connect to QuickBooks Time Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live QuickBooks Time.
-
Build a Singer.io Tap for Salesforce Data 360 With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Salesforce Data 360 data using
-
Back Up Dynamics 365 Business Central to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Dynamics 365 Business Central. In this article, we will employ an SSIS workflow to populate a database with Dynamics 365 Business Central data.
-
Natively Connect to Humanity Data in PHP
The CData ODBC driver for Humanity enables you to create PHP applications with connectivity to Humanity. Leverage the native support for ODBC in PHP.
-
Deploy the ADO.NET Provider for PhantomBuster on an SSRS Report Server
Connect to PhantomBuster 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.
-
Migrating data from Salesforce Data 360 to Databricks using CData SSIS Components.
Easily push Salesforce Data 360 to Databricks using the CData SSIS Tasks for Salesforce Data 360 and Databricks.
-
Integrate SQL Server Data in Pentaho Data Integration
Build ETL pipelines based on Microsoft SQL Server in the Pentaho Data Integration tool.
-
Build SAP Ariba Procurement-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SAP Ariba Procurement to explore live SAP Ariba Procurement Data in GitHub Copilot to assist with building SAP Ariba Procurement-powered applications.
-
Connect Google Search Results to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Search using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Tanda Data Replication to Teradata
Use CData Sync to Customize and automate Tanda replication to Teradata.
-
Connect to Paymo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Paymo to connect to Paymo from Web applications running on WebLogic.
-
Prepare, Blend, and Analyze CSV Data in Alteryx Designer (ODBC)
Build workflows to access live CSV/TSV Files for self-service data analytics.
-
How to Build an ETL App for DB2 Data in Python with CData
Create ETL applications and real-time data pipelines for IBM DB2 in Python with petl.
-
Access Twitter Ads 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 Twitter Ads.
-
Connect to Oracle HCM Cloud Data from a Connection Pool in Jetty
The Oracle HCM Cloud JDBC Driver supports connection pooling: This article shows how to connect faster to Oracle HCM Cloud from Web apps in Jetty.
-
Build Dashboards with SAP Ariba Source Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Ariba Source in Dundas BI.
-
Connect to Google Campaign Manager 360 Data in RapidMiner
Integrate Google Campaign Manager 360 with standard components and data source configuration wizards in RapidMiner Studio.
-
Model Gmail Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Gmail, enabling the direct import of real-time Gmail.
-
Migrating data from Google Ads to Google BigQuery using CData SSIS Components.
Easily push Google Ads to Google BigQuery using the CData SSIS Tasks for Google Ads and Google BigQuery.
-
Analyze QuickBooks Online Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of QuickBooks Online and visualize live QuickBooks Online in Infragistics Reveal.
-
Use the CData Software JDBC Driver for Notion in MicroStrategy
Connect to Notion in MicroStrategy Developer using the CData Software JDBC Driver for Notion.
-
How to connect and process Keap from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Keap.
-
How to connect to Discord Data from Spring Boot
Connect to Discord in a Spring Boot Application using the CData API Driver for JDBC
-
Enable the Suadeo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Suadeo.
-
Build an OLAP Cube in SSAS from Nuclia Data
Establish a connection to Nuclia data from SQL Server Analysis Services, and use the Nuclia Data Provider to build OLAP cubes for use in analytics and reporting.
-
DataBind Kintone Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Kintone with the DevExpress Windows Forms and Web controls to provide Kintone to a chart.
-
Model BigQuery Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and BigQuery, enabling the direct import of real-time Google BigQuery.
-
Feed Act CRM Data into FineReport
How to set Act CRM as a JDBC data source in FineReport.
-
Use the CData Software ODBC Driver for Datadog in MicroStrategy Web
Connect to Datadog in MicroStrategy Web using the CData Software ODBC Driver for Datadog.
-
Connect to Pingdom Data in DBeaver
Use the CData ODBC Driver to connect to Pingdom in DBeaver.
-
Visualize MailerSend Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MailerSend.
-
Getting Started with the CData Power BI Connector for CampaignMonitor
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Factorial from Asprova with CData Software ODBC Driver for Factorial
This article shows how to connect faster to Factorial data from Asprova.
-
Connect to IBM Informix Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for IBM Informix in the Denodo Virtual DataPort Administrator.
-
Integrate Facebook Data in the Pentaho Report Designer
Publish reports based on Facebook in the Pentaho BI tool.
-
Process & Analyze Oracle SCM Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Oracle SCM Data.
-
Connect to SAP Ariba Procurement Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Ariba Procurement from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Ariba Procurement.
-
Connect to Apify Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Apify in the Denodo Virtual DataPort Administrator.
-
Manage ServiceNow Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ServiceNow.
-
Getting Started with the CData Excel Add-In for LightSpeedRetail
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for LightSpeedRetail.
-
Connect to SAP Hybris C4C Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Hybris C4C from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Hybris C4C.
-
Build WordPress-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for WordPress to explore live WordPress Data in Claude Code to assist with building WordPress-powered applications.
-
Back Up Flowlu to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Flowlu data.
-
Integrating OpenCode Terminal with Vimeo 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.
-
Connecting GenSpark with Certinia Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Certinia without any replication or custom integration required.
-
How to Design QuickBooks Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to QuickBooks from mobile and tablet Power Apps.
-
Extract, Transform, and Load CircleCI Data in Informatica PowerCenter
Create a simple Workflow for CircleCI in Informatica PowerCenter.
-
Automated Continuous xBase Replication to Amazon S3
Use CData Sync for automated, continuous, customizable xBase replication to Amazon S3.
-
Query Monday.com Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Monday.com and perform CRUD operations on Monday.com from Node.js.
-
Publish Crystal Reports on DB2 Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date IBM DB2.
-
Build AI/ML Models with Live Coinbase Data using Dataiku
Connect Coinbase Data with Dataiku using the CData API Driver for JDBC.
-
Connect to SAP Business One Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Business One from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Business One.
-
Access Live OData Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live OData data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
LINQ to CouchDB 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 CouchDB Data Provider.
-
Getting Started with the CData ODBC Driver for Paymo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Paymo.
-
Connect to Google Campaign Manager 360 Data in RazorSQL
Connect to Google Campaign Manager 360 from wizards and query Google Campaign Manager 360 from the GUI in the RazorSQL database management tool.
-
Migrating data from GraphQL to Databricks using CData SSIS Components.
Easily push GraphQL to Databricks using the CData SSIS Tasks for GraphQL and Databricks.
-
Create Informatica Mappings From/To an ODBC Data Source for Grafana
Create an ODBC connection to Grafana in Informatica and browse and transfer Grafana.
-
Integrating Cursor CLI with Jira Assets 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.
-
Getting Started with the CData Tableau Connector for Smartsheet
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Smartsheet.
-
Analyze Mouseflow Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Mouseflow in Microsoft R Open.
-
Analyze Snapchat Ads Data in Looker
Use CData Connect AI to connect to Snapchat Ads Data from Looker and build custom apps using live Snapchat Ads.
-
How to connect to SAS Data Sets Data in DBVisualizer
Integrate SAS Data Sets with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Yelp Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Yelp and the SQL Gateway to access Yelp from Google Apps Script.
-
Create Dashboards and Visualize Live HBase Data in Geckoboard
Use CData Connect AI to connect to live Apache HBase and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Agents in Relevance AI with Access to Live SAP Ariba Procurement Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP Ariba Procurement within intelligent agent workflows.