CData Software - Knowledge Base
Recent Articles
-
Import AgileCRM Data Using Azure Data Factory
Use CData Connect AI to connect to AgileCRM Data from Azure Data Factory and import live AgileCRM data.
-
Design BIRT Reports on Parquet Data
Provide current Parquet data to your embedded analytics.
-
Getting Started with the CData SSIS Components for SAP SuccessFactors LMS
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP SuccessFactors LMS.
-
Feed Browserless Data into FineReport
How to set Browserless data as a JDBC data source in FineReport.
-
Building Dynamic Web Pages with LinkedIn Data Using AngularJS
Create single-page applications with live connectivity to LinkedIn using the CData API Server.
-
Connect to Redshift Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Redshift data from Filemaker Pro on Mac.
-
Connect to Spark Data from PowerBuilder via ADO.NET
This article demonstrates how to access Spark data from Appeon PowerBuilder using the CData ADO.NET Provider for Spark.
-
Use Dash to Build Web Apps on Xero Data via CData Connect AI
Build interactive Dash web apps on live Xero data using pandas and the CData Connect AI Python SDK.
-
Integrating Dataiku with Egnyte Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Egnyte data.
-
Import Real-Time Vault CRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Vault CRM data in ColdFusion.
-
Provide OData Services of SageHR Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SageHR data by developing a WCF Service Application.
-
Operational Reporting on Beeminder Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Beeminder data.
-
Excel Spreadsheet Automation on Microsoft Teams Data with the QUERY Formula
Pull data from Microsoft Teams, automate spreadsheets, and more with the QUERY formula.
-
Visualize Live PostgreSQL Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live PostgreSQL data into custom reports in Power BI.
-
How to integrate Metabase with Snapchat Ads Data
Use CData Connect AI to connect to live Snapchat Ads data and create an interactive dashboard in Metabase from Snapchat Ads data.
-
How to Query Live Codat Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Codat data data in natural language using Python.
-
Connect to and Visualize Live MariaDB Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MariaDB data.
-
Replicate Accelo Data to Multiple Databases via the CData Sync CLI
Replicate Accelo data to disparate databases with a single configuration.
-
Design BIRT Reports on Billsby Data
Provide current Billsby data to your embedded analytics.
-
Replicate PayPal Data to Multiple Databases
Replicate PayPal data to disparate databases with a point-and-click configuration.
-
Creating Jira Assets-Connected Applications in Unqork
You can use CData Connect AI to feed Jira Assets data to Unqork and build custom business apps.
-
How to import NetSuite Data into Apache Solr
Use the CData Software JDBC Driver for NetSuite in Data Import Handler and create an automated import of NetSuite data to Apache Solr Enterprise Search platform.
-
Automate Azure Data Catalog Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Azure Data Catalog data from PowerShell? This article demonstrates how to utilize the Azure Data Catalog Cmdlets for tasks like connecting to Azure Data Catalog data, automating operations, downloading data, and more.
-
Automated Continuous Salesloft Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Salesloft data replication to OneLake in Microsoft Fabric.
-
Automated Continuous Redis Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Redis replication to Amazon S3.
-
Analyze Raisers Edge NXT Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Raisers Edge NXT data and visualize Raisers Edge NXT data in SAP Analytics Cloud.
-
Integrate with Salesforce Marketing Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Salesforce Marketing data in SnapLogic.
-
Integrate with live Trello Data in Jitterbit
Use CData Connect AI to connect to and integrate live Trello data in Jitterbit.
-
Use the CData Software JDBC Driver for JDBC-ODBC Bridge in MicroStrategy
Connect to JDBC-ODBC Bridge data in MicroStrategy Developer using the CData Software JDBC Driver for JDBC-ODBC Bridge.
-
Build Zendesk-Connected Apps in Choreo
Use CData Connect AI to connect to Zendesk Data from Choreo and build custom apps using live Zendesk data.
-
Automated Continuous ServiceNow Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ServiceNow replication to Amazon Redshift.
-
Connect BenchmarkEmail to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect BenchmarkEmail with IBM WebSphere for seamless data integration and connectivity.
-
A PostgreSQL Interface for Reckon Data (MySQL Remoting via JDBC)
Use the Remoting features of the Reckon JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect DBeaver to Toggl via a JDBC Driver
Manage Toggl data with visual tools in DBeaver like the query browser.
-
Operational Reporting on Outlook Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Outlook data.
-
Connect to SAP Hybris C4C Data in DBeaver
Use the CData ODBC Driver to connect to SAP Hybris C4C data in DBeaver.
-
Integrating BigQuery Data in Talend Cloud Data Management Platform
Connect BigQuery Data with Talend Cloud Data Management Platform using the CData JDBC Driver for BigQuery.
-
Connect to ActiveCampaign from a Connection Pool in WebLogic
Use the CData JDBC Driver for ActiveCampaign to connect to ActiveCampaign data from Web applications running on WebLogic.
-
Build Apps with Live MongoDB data in Adalo using CData Connect AI
Use CData Connect AI to integrate live MongoDB data into the Adalo platform and build custom mobile and web applications with real-time MongoDB data.
-
Connect to OData Services from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for OData to connect to OData services and execute queries in PowerBuilder.
-
Connect and Visualize Live Sendwithus Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Sendwithus data into the Databricks platform and create visualization dashboards with real-time Sendwithus data.
-
Use the CData Software JDBC Driver for Coda in MicroStrategy Desktop
Connect to Coda data in MicroStrategy Desktop using the CData Software JDBC Driver for Coda.
-
Access Live Jumpseller Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Jumpseller data into the statistical analysis tools available in SAS JMP. This article shows how to use Jumpseller data in the Graph Builder and Query Builder.
-
Automated Continuous CockroachDB Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable CockroachDB replication to PostgreSQL.
-
How to Connect to Live MarkLogic Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live MarkLogic data without replication.
-
Build Dashboards with Contentful Data in DBxtra
Create dynamic dashboards and perform analytics based on Contentful data in DBxtra.
-
How to use SQLAlchemy ORM to access Act-On Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Act-On data.
-
Integrate EmailOctopus Data in the Pentaho Report Designer
Publish reports based on EmailOctopus data in the Pentaho BI tool.
-
Integrate OpenCode with Live Highrise Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Highrise data from within your AI coding agent.
-
Automated Continuous HubSpot Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable HubSpot replication to PostgreSQL.
-
Analyze Power BI XMLA Data in Cognos Analytics
Use CData Connect AI to connect to Power BI XMLA Data from Cognos Analytics and analyze live Power BI XMLA data.
-
Build Procore-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Procore Data and create custom apps in Bubble.
-
Build Pipelines with Live AfterShip Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to AfterShip from Google Cloud Data Fusion, enabling the integration of live AfterShip data into the building and management of effective data pipelines.
-
Hacker News Reporting in OBIEE with the Hacker News JDBC Driver
Deploy the Hacker News JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Mixpanel Data in Aqua Data Studio
Access Mixpanel data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Work with Google Translate Data in AWS Glue Jobs Using JDBC
Connect to Google Translate from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Google Translate Data in Pentaho Data Integration
Build ETL pipelines based on Google Translate data in the Pentaho Data Integration tool.
-
Connect to Teradata Data in JRuby
Create a simple JRuby app with access to live Teradata data.
-
Integrate with Guru Data in JReport Designer
Create charts and reports based on Guru data in JReport Designer.
-
Automated Continuous Zuora Replication to Vertica
Use CData Sync for automated, continuous, customizable Zuora replication to Vertica.
-
How to Connect to & Open Planio Data in Microsoft Excel
This article uses the CData ODBC driver for Planio to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build AI/ML Models with Live Accelo Data using Dataiku
Connect Accelo Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous Scrapfly Replication to Vertica
Use CData Sync for automated, continuous, customizable Scrapfly replication to Vertica.
-
Access Live Pipeline CRM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Pipeline CRM data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect to Live TaxJar Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your TaxJar data for you.
-
DataBind Charts to HBase Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to HBase data 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.
-
How to integrate Paylocity with Apache Airflow
Access and process Paylocity data in Apache Airflow using the CData JDBC Driver.
-
Integrating Claude Code CLI with Zoom 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.
-
Integrate with BigCommerce Data in JReport Designer
Create charts and reports based on BigCommerce data in JReport Designer.
-
How to connect to Short.io Data with Squirrel SQL client
Connect to Short.io data and execute queries in the Squirrel SQL Client.
-
Model ServiceNow Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and ServiceNow, enabling the direct import of real-time ServiceNow data.
-
Build Semantic Layer Views for Aweber Data in APOS Live Data Gateway
Use the CData Connector for Aweber in APOS Live Data Gateway to build Semantic Layer Views for Aweber data.
-
Automated Continuous Freshservice Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Freshservice replication to Google Cloud SQL.
-
Access Live Anaplan Data in Excel 365 Online (Excel for the web)
Connect to Anaplan data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to load SAP data into Elasticsearch via Logstash
Introducing a simple method to load SAP data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Excel Spreadsheet Automation on Notion Data with the QUERY Formula
Pull data from Notion, automate spreadsheets, and more with the QUERY formula.
-
Connect Klipfolio Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Klipfolio data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Blackbaud FE NXT-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Blackbaud FE NXT Data from OutSystems and build custom enterprise apps using live Blackbaud FE NXT data.
-
Create PayPal Dataflows on PowerBI.com
Connect to the CData Power BI Connector for PayPal from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live Google Campaign Manager 360 Data in Excel 365 Online (Excel for the web)
Connect to Google Campaign Manager 360 data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Replicate ShipStation Data from PowerShell
Write a quick PowerShell script to query ShipStation data. Use connectivity to the live data to replicate ShipStation data to SQL Server.
-
Moving Data from Adobe Commerce to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Adobe Commerce data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build AI Agents with Snowflake 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 Snowflake data through CData Connect AI.
-
How to Seamlessly Import SharePoint Data into IBM SPSS Modeler
Integrate SharePoint data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Xero-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Xero data.
-
Add Paddle Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Paddle with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Figshare Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Figshare data from Informatica Cloud.
-
Natively Connect to Campaigner Data in PHP
The CData ODBC driver for Campaigner enables you to create PHP applications with connectivity to Campaigner data. Leverage the native support for ODBC in PHP.
-
Access Live Act-On Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Act-On data into the statistical analysis tools available in SAS JMP. This article shows how to use Act-On data in the Graph Builder and Query Builder.
-
Connect to Google Contacts Data from AWS Glue
Use CData Connect AI to gain access to live Google Contacts data from your AWS Glue jobs.
-
Query PabblySubscriptions Data in ColdFusion
Write standard ColdFusion data access code to connect to PabblySubscriptions data.
-
Getting Started with the CData Excel Add-In for PDFMonkey
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PDFMonkey.
-
Integrate with JobNimbus Data in JReport Designer
Create charts and reports based on JobNimbus data in JReport Designer.
-
Manage Insightly Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Insightly.
-
Access Live Jira Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Jira data from your Excel spreadsheets.
-
Connect to Cloudflare Data from PowerBuilder via ADO.NET
This article demonstrates how to access Cloudflare data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Explore Geographical Relationships in Adobe Analytics Data with Power Map
Create data visualizations with Adobe Analytics data in Power Map.
-
Build Bullhorn CRM-Connected Apps in Choreo
Use CData Connect AI to connect to Bullhorn CRM Data from Choreo and build custom apps using live Bullhorn CRM data.
-
Integrate Live JSON Services into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to JSON from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live JSON services.
-
Working with Bright Data Data in LINQPad
Execute LINQ queries to Bright Data data in LINQPad.