CData Software - Knowledge Base
Recent Articles
-
Integrate with Sendwithus Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sendwithus to a JSON file on disk.
-
How to Import Data from Google Calendar into Google Sheets
Import Google Calendar into a Google spreadsheet that is automatically refreshed.
-
Create Data Visualizations in Cognos BI with Bullhorn CRM Data
Access Bullhorn CRM as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Oracle Service Cloud Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Oracle Service Cloud Data and connect to Oracle Service Cloud in Akorbi Digital RunMyProcess.
-
Integrating LlamaIndex with Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Zoho Books in real time.
-
Integrate with Live Raisers Edge NXT Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Raisers Edge NXT from the MuleSoft Anypoint Platform to integrate live Raisers Edge NXT into custom reports and dashboards.
-
Rapidly Develop Authorize.Net-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 Authorize.Net.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Azure Cosmos DB using the Model Context Protocol.
-
Build Zoho Creator-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Zoho Creator.
-
Visualize Live Simplesat Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Simplesat using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create SSAS Tabular Models from SAP SuccessFactors LMS Data
How to build a SQL Server Analysis Service Tabular Model from SAP SuccessFactors LMS using CData drivers.
-
Use Agno to Talk to Your Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Zoho CRM for you.
-
Access Live SingleStore Data in TIBCO Data Virtualization
Use the SingleStore Tibco DV Adapter to create a SingleStore data source in TIBCO Data Virtualization Studio and gain access to live SingleStore from your TDV Server.
-
Use the CData API Server to Access ClickUp Data in Microsoft PowerPivot
Use the CData API Server to connect to live ClickUp in the Power Pivot business intelligence tool.
-
Twilio Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Twilio through CData Connect AI using different applications and tools.
-
Extend Google Sheets with CSV Data
Make calls to CSV from Google Apps Script via the API Server.
-
Create Reports with Microsoft Exchange Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Exchange.
-
Import and Visualize SAP HANA XS Advanced Data in Power View
Create data visualizations based on SAP HANA XS Advanced in Excel.
-
Use the CData ODBC Driver for HDFS from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for HDFS to connect to Apache HDFS from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apache HDFS in Excel.
-
How to Work with FreshBooks Data in AWS Glue Jobs Using JDBC
Connect to FreshBooks from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Import and Visualize Asana Data in Power View
Create data visualizations based on Asana in Excel.
-
How to load BigQuery data into Elasticsearch via Logstash
Introducing a simple method to load BigQuery data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software ODBC Driver for Missive in SAS for Real-Time Reporting and Analytics
Connect to real-time Missive in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Missive.
-
Automate Typeform Data Replication to SAP HANA
Use CData Sync to customize and automate Typeform replication to SAP HANA.
-
Automated Continuous WordPress Replication to MySQL
Use CData Sync for automated, continuous, customizable WordPress replication to MySQL.
-
Connect to Amazon Marketplace Data in ACL Analytics
Connect to Amazon Marketplace via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Amazon Marketplace.
-
How to integrate Metabase with Salesforce Marketing Data
Use CData Connect AI to connect to live Salesforce Marketing Cloud and create an interactive dashboard in Metabase from Salesforce Marketing Cloud.
-
How to work with Printify Data in Apache Spark using SQL
Access and process Printify Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData Software JDBC Driver for IBM Informix in MicroStrategy Desktop
Connect to IBM Informix in MicroStrategy Desktop using the CData Software JDBC Driver for IBM Informix.
-
How to Connect the Power BI Service to JobNimbus: Complete Guide
Connect to the CData Software Power BI Connector for JobNimbus from PowerBI.com to provide real-time JobNimbus across the organization.
-
How to create an RPA flow for Hacker News Data in UiPath Studio
Use the Hacker News ODBC Driver to create workflows that access real-time Hacker News without any coding.
-
How to Access Live Bullhorn CRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Bullhorn CRM enables you to integrate Bullhorn CRM into workflows built using Microsoft Power Automate Desktop.
-
Analyze Excel Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Excel with the CData JDBC Driver for Excel.
-
Connect to Discord from a Connection Pool in WebLogic
Use the CData JDBC Driver for Discord to connect to Discord from Web applications running on WebLogic.
-
Add Beeminder Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Beeminder with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData ODBC Driver for Webflow
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Webflow.
-
Integrate Live Azure Table Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Azure Table Storage to Blue Prism using the CData ODBC Driver for Azure to create automated workflows for repetitive business tasks.
-
Create Dynamic Active Directory Grids Using the Infragistics XamDataGrid
Learn how you can connect Active Directory to Infragistics XamDataGrid to build dynamic grids.
-
Getting Started with the CData Python Connector for Slack
Learn to install and license the CData Python Connector
-
Connect to Moosend Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Moosend as an External Source in Dremio.
-
Build Voice Agents in ElevenLabs with access to Live Stripe Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Stripe.
-
Automated Continuous SuiteCRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SuiteCRM replication to delimited files (CSV/TSV).
-
Automated Continuous Stack Exchange Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Amazon S3.
-
Getting Started with the CData ADO.NET Provider for Highrise
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Highrise.
-
Integrate LibreChat with Live Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Sybase from within the chat interface.
-
Automated Continuous Lakebase Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Lakebase replication to Amazon S3.
-
Connect to Grafana Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Grafana in the Denodo Virtual DataPort Administrator.
-
How to Connect to Live Outreach.io 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 Outreach.io for you.
-
Integrate Real-Time Access to Testmonitor in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Testmonitor in real time.
-
Add Certinia Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Certinia with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Workday Data Replication to Teradata
Use CData Sync to Customize and automate Workday replication to Teradata.
-
Add Outlook Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Outlook with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to MarkLogic Data in DBeaver
Use the CData ODBC Driver to connect to MarkLogic in DBeaver.
-
Automated Continuous Authorize.Net Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Apache Cassandra.
-
How to Easily Query Teamwork Data in OpenOffice Base
Connect to Teamwork data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate SAP Concur Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Concur from Informatica Cloud.
-
Integrate Parquet Data in the Pentaho Report Designer
Publish reports based on Apache Parquet in the Pentaho BI tool.
-
Validate SAS Data Sets Data with QuerySurge
Access and validate SAS Data Sets in QuerySurge using the CData JDBC Driver.
-
Manage Templated Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Templated.
-
Access Live Monday.com Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Monday.com into the statistical analysis tools available in SAS JMP. This article shows how to use Monday.com in the Graph Builder and Query Builder.
-
Analyze Wistia Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Wistia with the CData JDBC Driver for Wistia.
-
Excel Spreadsheet Automation on Highrise Data with the QUERY Formula
Pull data from Highrise, automate spreadsheets, and more with the QUERY formula.
-
Bind Live Contentful Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Contentful data
-
Integrate Zoho CRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Zoho CRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Zoho CRM.
-
Replicate Microsoft Exchange Data from PowerShell
Write a quick PowerShell script to query Microsoft Exchange. Use connectivity to the live data to replicate Microsoft Exchange to SQL Server.
-
How to Work with Tanda Data in ETL Validator JDBC
Connect to Tanda from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Visualize Elorus Data in Python with pandas
Use pandas and other modules to analyze and visualize live Elorus in Python.
-
Integrate Facebook Ads Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Facebook Ads and integrate live Facebook Ads into your Power Automate tasks.
-
Automate ZarMoney Data Replication to Azure Synapse
Use CData Sync to customize and automate ZarMoney replication to Azure Synapse.
-
Analyze SQL Analysis Services Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SQL Analysis Services in Microsoft R Open.
-
Excel Spreadsheet Automation on Oracle SCM Data with the QUERY Formula
Pull data from Oracle SCM, automate spreadsheets, and more with the QUERY formula.
-
Connect to Clockify Data in Jaspersoft Studio
Execute SQL to remote Clockify in Jaspersoft Studio.
-
Access Live Wave Financial Data in AWS Lambda
Connect to live Wave Financial in AWS Lambda using the CData JDBC Driver.
-
Create SAS xpt-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAS xpt Data from OutSystems and build custom enterprise apps using live SAS XPORT.
-
Connect Spreadsheets Getting Started Guide
A basic guide to setting up and connecting to data through Connect Spreadsheets by CData
-
Prepare, Blend, and Analyze Drift Data in Alteryx Designer (ODBC)
Build workflows to access live Drift for self-service data analytics.
-
Object-Relational Mapping (ORM) with MYOB AccountRight Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to MYOB AccountRight into a Java-based ORM framework, Hibernate.
-
Write a Simple Go Application to work with Vercel Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Vercel.
-
How to integrate Mocean with Apache Airflow
Access and process Mocean in Apache Airflow using the CData JDBC Driver.
-
Use the CData ODBC Driver for Mixpanel in Microsoft Power Query
You can use the CData Mixpanel ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Mixpanel into Microsoft Power Query.
-
Easily Integrate Avro Data in Lazarus Pascal IDE
Learn how to easily integrate live Apache Avro in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect the Power BI Service to Nethunt: Complete Guide
Connect to the CData Software Power BI Connector for Nethunt from PowerBI.com to provide real-time Nethunt across the organization.
-
Connect to Pipeline CRM Data in DBArtisan
Use wizards in DBArtisan to configure Pipeline CRM as a data source.
-
How to Connect to & Open BigCommerce Data in Microsoft Excel
This article uses the CData ODBC driver for BigCommerce to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automate Tanda Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Tanda from PowerShell? This article demonstrates how to utilize the Tanda Cmdlets for tasks like connecting to Tanda, automating operations, downloading data, and more.
-
Integrate with PhantomBuster Data in JReport Designer
Create charts and reports based on PhantomBuster in JReport Designer.
-
How to Query Live Google Drive Data in Perplexity MacOS Desktop
Connect to and query live Google Drive Data in Perplexity Desktop using CData MCP Server.
-
Connecting GenSpark with Snowflake Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Snowflake without any replication or custom integration required.
-
View Reports on Real-Time Simplesat Data in Power BI Report Server
Use the CData ODBC Driver for Simplesat to visualize Simplesat in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Live Oracle Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Oracle in CData Connect AI and connect to your Oracle Database from PostgreSQL.
-
How to integrate xBase with Apache Airflow
Access and process xBase in Apache Airflow using the CData JDBC Driver.
-
Create Reports with Twilio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Twilio.
-
Create Office 365 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Office 365 data access from reports, embedded analytics, and more.
-
Choosing the Best Method to Connect Outlook to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Outlook from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to Live GitLab Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your GitLab for you.
-
Integrating Boomi Agentstudio with SendGrid Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SendGrid, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Replicate Multiple Harvest Accounts via the CData Sync CLI
Replicate multiple Harvest accounts to one or many databases.
-
Connect to Stripe 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 Stripe.
-
Integrate Live GraphQL Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to GraphQL and integrate live GraphQL into apps built in Microsoft Power Apps.
-
Analyze BambooHR Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of BambooHR and visualize live BambooHR in Infragistics Reveal.