CData Software - Knowledge Base
Recent Articles
-
Publish Crystal Reports on Vercel Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Vercel data.
-
Automated Beeminder Data Replication to Teradata
Use CData Sync to Customize and automate Beeminder data replication to Teradata.
-
Connect to LeadDesk Data as an External Source in Dremio
Use the CData JDBC Driver to connect to LeadDesk as an External Source in Dremio.
-
Getting Started with the CData Power BI Connector for PolarTeamPro
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Access Phoenix Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Phoenix data from your Oracle system.
-
Automated Continuous Pingdom Replication to Vertica
Use CData Sync for automated, continuous, customizable Pingdom replication to Vertica.
-
Analyze Pinterest Data in Looker
Use CData Connect AI to connect to Pinterest Data from Looker and build custom apps using live Pinterest data.
-
Use the CData ODBC Driver for Mistral AI in Microsoft Power Query
You can use the CData Mistral AI ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Mistral AI data into Microsoft Power Query.
-
Integrate with Sage 300 Data in JReport Designer
Create charts and reports based on Sage 300 data in JReport Designer.
-
DataBind Act CRM Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Act CRM with the DevExpress Windows Forms and Web controls to provide Act CRM data to a chart.
-
Connect to Grafana Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Grafana data.
-
Process & Analyze Parallel Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Parallel Data.
-
Create Informatica Mappings From/To an ODBC Data Source for BambooHR
Create an ODBC connection to BambooHR in Informatica and browse and transfer BambooHR data.
-
Integrating Avalara AvaTax Data in Talend Cloud Data Management Platform
Connect Avalara AvaTax Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Avalara AvaTax.
-
Automated Continuous Factorial Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Factorial data replication to OneLake in Microsoft Fabric.
-
How to Visualize SharePoint Excel Services Data in Python with pandas
Use pandas and other modules to analyze and visualize live SharePoint Excel Services data in Python.
-
Back Up Azure Synapse data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Azure Synapse. In this article, we will employ an SSIS workflow to populate a database with Azure Synapse data data.
-
Easily Integrate Scrapfly Data in Lazarus Pascal IDE
Learn how to easily integrate live Scrapfly data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Model, Search, and Visualize Live Google Sheets Data in ThoughtSpot
Use CData Connect AI to connect to live Google Sheets data for modeling, searching, and visualizing.
-
Use CData Connect AI to Access Tally Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Tally data in the Power Pivot business intelligence tool.
-
Connect to Zendesk Data from Crystal Reports
Use CData Connect AI to connect to and report on live Zendesk data from Crystal Reports.
-
Visualize Shopify Data in TIBCO Spotfire through ADO.NET
Integrate Shopify data into dashboards in TIBCO Spotfire.
-
Query SAP Hybris C4C Data as a MySQL Database in Node.js
Execute MySQL queries against SAP Hybris C4C data from Node.js.
-
Automated Continuous LaunchDarkly Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Amazon Redshift.
-
Integrating OpenCode with OneNote 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.
-
Connect to SendPulse Data in Aqua Data Studio
Access SendPulse data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Presto Replication to MongoDB
Use CData Sync for automated, continuous, customizable Presto replication to MongoDB.
-
Access Live Google Ads Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Ads data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous CSV Replication to IBM DB2
Use CData Sync for automated, continuous, customizable CSV replication to IBM DB2.
-
Create Datasets from Marketo in Domo Workbench and Build Visualizations of Marketo Data in Domo
Use the CData Software ODBC Driver for Marketo to create datasets from Marketo data in Domo Workbench and then build visualizations in the Domo service.
-
Visualize Live NetSuite Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live NetSuite data.
-
Create Data Visualizations Based On AgileCRM Data in Mode
Use CData Connect AI to connect to AgileCRM Data from Mode and build visualizations using live AgileCRM data.
-
Create Reports with OData Services in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date OData services.
-
Integrating Antigravity CLI with Keap data via CData CLI
Connect Keap data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Azure Data Catalog Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Azure Data Catalog data and integrate live Azure Data Catalog data into your Power Automate tasks.
-
Create SendGrid-Connected Nintex Workflows
Use CData Connect AI to connect to SendGrid Data from Nintex Workflow Cloud and build custom workflows using live SendGrid data.
-
Connect to Optimizely Data from a Connection Pool in JBoss
Integrate Optimizely data into Java servlets: Use the Management Console in JBoss to install the Optimizely JDBC Driver.
-
Use the CData Software JDBC Driver for Coda in MicroStrategy Web
Connect to Coda data in MicroStrategy Web using the CData Software JDBC Driver for Coda.
-
Publish Salesloft-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Salesloft data.
-
Object-Relational Mapping (ORM) with Airtable 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 Airtable data into a Java-based ORM framework, Hibernate.
-
ETL QuickBooks Time in Oracle Data Integrator
This article shows how to transfer QuickBooks Time data into a data warehouse using Oracle Data Integrator.
-
How to Connect FTP Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live FTP data in real time using natural language.
-
How to use SQLAlchemy ORM to access SFTP Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SFTP data.
-
Use Databricks Agent Bricks to Talk to Your Smartsheet Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Smartsheet data for you.
-
Connect to HubDB Data in DBArtisan
Use wizards in DBArtisan to configure HubDB data as a data source.
-
Integrate Sage 200 Data into Power Automate Desktop using CData Connect
CData Connect for Sage 200 Data enables you to integrate Sage 200 data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Greenhouse Data in RapidMiner
Integrate Greenhouse data with standard components and data source configuration wizards in RapidMiner Studio.
-
Easily Integrate Jira Assets Data in Lazarus Pascal IDE
Learn how to easily integrate live Jira Assets data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate with SAP Business One Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP Business One data in SnapLogic.
-
Access Live Freshdesk Data in AWS Lambda
Connect to live Freshdesk data in AWS Lambda using the CData JDBC Driver.
-
Automate ClickTime Data Replication to Azure Data Lake
Use CData Sync to customize and automate ClickTime data replication to Azure Data Lake.
-
Automated Continuous Phoenix Replication to Snowflake
Use CData Sync for automated, continuous, customizable Phoenix replication to Snowflake.
-
Automated Continuous Outlook Replication to Snowflake
Use CData Sync for automated, continuous, customizable Outlook replication to Snowflake.
-
Integrate ServiceNow Data into Power Automate Desktop using CData Connect
CData Connect for ServiceNow Data enables you to integrate ServiceNow data into workflows built using Microsoft Power Automate Desktop.
-
Build Automated Kintone-Connected Workflows in Zapier
Use CData Connect AI to connect to live Kintone data and build automated workflows in Zapier.
-
Connect to Sybase Data from PowerBuilder via JDBC
This article demonstrates how to access Sybase data from PowerBuilder using the Sybase JDBC Driver.
-
Create Hive-Connected Business Apps in AppSheet
Connect to Hive Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Hive data.
-
Automated Pipedrive Data Replication to Teradata
Use CData Sync to Customize and automate Pipedrive data replication to Teradata.
-
Analyze Cloudant Data in Cognos Analytics
Use CData Connect AI to connect to Cloudant Data from Cognos Analytics and analyze live Cloudant data.
-
How to import BambooHR Data into Apache Solr
Use the CData Software JDBC Driver for BambooHR in Data Import Handler and create an automated import of BambooHR data to Apache Solr Enterprise Search platform.
-
Automated Continuous Shopify Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Shopify data replication to OneLake in Microsoft Fabric.
-
Import Real-Time QuickBooks Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use QuickBooks data in ColdFusion.
-
Working with Calendly Data in LINQPad
Execute LINQ queries to Calendly data in LINQPad.
-
Access Live ZeroBounce Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ZeroBounce data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
DataBind Controls to Kintone Data in C++Builder
DataBind to Kintone data in C++Builder with standard components and controls.
-
Design BIRT Reports on Quickbase Data
Provide current Quickbase data to your embedded analytics.
-
Replicate Sendwithus Data from PowerShell
Write a quick PowerShell script to query Sendwithus data. Use connectivity to the live data to replicate Sendwithus data to SQL Server.
-
Create Datasets from HCL Domino in Domo Workbench and Build Visualizations of HCL Domino Data in Domo
Use the CData Software ODBC Driver for HCL Domino to create datasets from HCL Domino data in Domo Workbench and then build visualizations in the Domo service.
-
Validate Bugsnag Data with QuerySurge
Access and validate Bugsnag data in QuerySurge using the CData JDBC Driver.
-
Connect to Samanage Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Samanage and the SQL Gateway to access Samanage data from Google Apps Script.
-
Build Microsoft Teams-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Teams data.
-
How to Connect the Power BI Service to Monday.com: Complete Guide
Connect to the CData Software Power BI Connector for Monday.com from PowerBI.com to provide real-time Monday.com data across the organization.
-
Access Live eBay Analytics Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate eBay Analytics data into the statistical analysis tools available in SAS JMP. This article shows how to use eBay Analytics data in the Graph Builder and Query Builder.
-
Replicate JotForm Data in Heroku for Use in Salesforce Connect
Replicate JotForm data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to integrate SAP SuccessFactors with Apache Airflow
Access and process SAP SuccessFactors data in Apache Airflow using the CData JDBC Driver.
-
Getting Started with the CData JDBC Driver for Instagram
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Instagram.
-
Access Live Bugsnag Data in AWS Lambda
Connect to live Bugsnag data in AWS Lambda using the CData JDBC Driver.
-
How to Connect to Live Google Ads Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Ads data securely in real time.
-
Natively Connect to AfterShip Data in PHP
The CData ODBC driver for AfterShip enables you to create PHP applications with connectivity to AfterShip data. Leverage the native support for ODBC in PHP.
-
Automated Continuous ZohoExpense Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Amazon S3.
-
Integrate Goose with Live Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Databricks data from within the local AI agent.
-
Replicate Pipeline CRM Data to Multiple Databases via the CData Sync CLI
Replicate Pipeline CRM data to disparate databases with a single configuration.
-
Connect to and Visualize Live Cohere Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Cohere data.
-
Analyze Cosmos DB Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Cosmos DB data with the CData JDBC Driver for Cosmos DB.
-
Replicate Multiple Placid Accounts via the CData Sync CLI
Replicate multiple Placid accounts to one or many databases.
-
Integrate ZohoExpense Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ZohoExpense data from Informatica Cloud.
-
Integrate Goose with Live TaxJar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live TaxJar data from within the local AI agent.
-
Replicate Multiple Guru Accounts via the CData Sync CLI
Replicate multiple Guru accounts to one or many databases.
-
Access Live Greenplum Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Greenplum data through MCP integration.
-
Integrate Google's Antigravity Agent with Live Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Quickbase data using the Model Context Protocol.
-
How to Build an ETL App for Redshift Data in Python with CData Connect AI
Build ETL pipelines that read and write live Redshift data in Python with petl and the CData Connect AI Python SDK.
-
Connect to SAP ByDesign Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP ByDesign Data and connect to SAP ByDesign data in Akorbi Digital RunMyProcess.
-
Stream Oracle Eloqua Reporting Data into Apache Kafka Topics
Access and stream Oracle Eloqua Reporting data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating Paddle Data in Talend Cloud Data Management Platform
Connect Paddle Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to Demio Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Demio data in the Denodo Virtual DataPort Administrator.
-
Connect ClickTime to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ClickTime with IBM WebSphere for seamless data integration and connectivity.
-
Deploy the ADO.NET Provider for SAP Ariba Source on an SSRS Report Server
Connect to SAP Ariba Source data 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.
-
View Reports on Real-Time OneNote Data in Power BI Report Server
Use the CData ODBC Driver for OneNote to visualize OneNote data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Google Spanner Data in Claris FileMaker Pro
Use the CData ODBC Driver for Google Spanner in FileMaker Pro to connect to Google Spanner and work with Google Spanner data in your FileMaker applications.
-
Connect to DB2 Data from PowerBuilder via ADO.NET
This article demonstrates how to access DB2 data from Appeon PowerBuilder using the CData ADO.NET Provider for DB2.