CData Software - Knowledge Base
Recent Articles
-
How to Connect Outreach.io 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 Outreach.io data in real time using natural language.
-
Publish Shortcut-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Shortcut.
-
Use the CData API Server to Access Paylocity Data in Microsoft PowerPivot
Use the CData API Server to connect to live Paylocity in the Power Pivot business intelligence tool.
-
Automated Continuous Sybase Replication to MySQL
Use CData Sync for automated, continuous, customizable Sybase replication to MySQL.
-
How to Connect Flowise AI Agents to Live Airtable Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Airtable without replication.
-
Work with FormSite Data in FoxPro
Load FormSite into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData Python Connector for SAP BusinessObjects BI
Learn to install and license the CData Python Connector
-
Query Kintone Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Kintone entities in PHP by modeling them as objects.
-
Build Data Flows from Webflow to SQL Server using SSIS
Easily back up Webflow to SQL Server using the SSIS components for Webflow.
-
How to Easily Query Onfleet Data in OpenOffice Base
Connect to Onfleet data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Publish Reports with Facebook Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Facebook.
-
Automated Continuous Accelo Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Accelo replication to Apache Cassandra.
-
How to connect Amazon QuickSight to Outreach.io Data
Create a connection to Outreach.io in CData Connect AI and insert Outreach.io into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Instagram-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Instagram Data and create custom apps in Mendix.
-
Getting Started with the CData ADO.NET Provider for JotForm
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to SAP BusinessObjects BI Data in Jaspersoft Studio
Execute SQL to remote SAP BusinessObjects BI in Jaspersoft Studio.
-
How to connect to Miro Data from IntelliJ
Integrate connectivity to Miro with wizards in IntelliJ.
-
Provide OData Services of ZohoInvoice Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ZohoInvoice by developing a WCF Service Application.
-
Visualize Live Acumatica Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Acumatica ERP into custom reports in Power BI.
-
Build Sybase IQ-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sybase IQ.
-
A PostgreSQL Interface for Scrapfly Data (MySQL Remoting via JDBC)
Use the Remoting features of the Scrapfly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Microsoft Teams Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Microsoft Teams and the SQL Gateway to access Microsoft Teams from Google Apps Script.
-
Automate Google Tasks Data Replication to Azure Synapse
Use CData Sync to customize and automate Google Tasks replication to Azure Synapse.
-
Build AI/ML Models with Live SAP Fieldglass Data using Dataiku
Connect SAP Fieldglass Data with Dataiku using the CData JDBC Driver for SAP Fieldglass.
-
Create Amazon S3 Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Amazon S3 from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect and Query Live Cassandra Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Apache Cassandra into Databricks
-
Integrating Kiro CLI with FTP 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 Chargebee Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Chargebee and the SQL Gateway to access Chargebee from Google Apps Script.
-
Create Dashboards and Visualize Live Trello Data in Geckoboard
Use CData Connect AI to connect to live Trello and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to integrate Oracle Eloqua Reporting with Apache Airflow
Access and process Oracle Eloqua Reporting in Apache Airflow using the CData JDBC Driver.
-
Getting Started with the CData SSIS Components for Act CRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Act CRM.
-
Integrating GitHub Copilot CLI with Instagram 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.
-
ETL Harvest in Oracle Data Integrator
This article shows how to transfer Harvest into a data warehouse using Oracle Data Integrator.
-
Visualize Live CSV Data in the Power BI Service
Use CData Connect AI to connect to live CSV/TSV Files and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to import Facebook Data into Apache Solr
Use the CData Software JDBC Driver for Facebook in Data Import Handler and create an automated import of Facebook to Apache Solr Enterprise Search platform.
-
Automated Continuous Salesforce Pardot Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Apache Cassandra.
-
Building Dynamic Web Pages with Sybase IQ Data Using AngularJS
Create single-page applications with live connectivity to Sybase IQ using the CData API Server.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Sage Intacct using the Model Context Protocol.
-
Connecting Agentforce with Tally Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Tally ERP for you.
-
Build Apps with Live Microsoft Exchange in Adalo using CData Connect AI
Use CData Connect AI to integrate live Microsoft Exchange into the Adalo platform and build custom mobile and web applications with real-time Microsoft Exchange.
-
Query SAP HANA XS Advanced Data in DataGrip
Create a Data Source for SAP HANA XS Advanced in DataGrip and use SQL to query live SAP HANA XS Advanced.
-
How to connect to Stripe Data in DBVisualizer
Integrate Stripe with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Elasticsearch from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Elasticsearch, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Browserless Data in Aqua Data Studio
Access Browserless from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect DBeaver to Bitbucket via a JDBC Driver
Manage Bitbucket with visual tools in DBeaver like the query browser.
-
Create Informatica Mappings From/To a JDBC Data Source for PagerDuty
Create PagerDuty data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Replicate REST Data to Multiple Databases via the CData Sync CLI
Replicate REST to disparate databases with a single configuration.
-
How to create ClickUp federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ClickUp in MySQL .
-
Choosing the Best Method to Connect Autopilot to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Autopilot from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Parallel Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Parallel from PowerBI.com to create Power BI Dataflows with real-time data.
-
Moving Data from ShipStation to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ShipStation data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Analyze Amazon DynamoDB Data in Cognos Analytics
Use CData Connect AI to connect to Amazon DynamoDB Data from Cognos Analytics and analyze live Amazon DynamoDB.
-
Build Dashboards with Zendesk Data in Dundas BI
Create dynamic dashboards and perform analytics based on Zendesk in Dundas BI.
-
How to use SQLAlchemy ORM to access Acumatica Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Acumatica ERP.
-
Create Datasets from Invoiced in Domo Workbench and Build Visualizations of Invoiced Data in Domo
Use the CData Software ODBC Driver for Invoiced to create datasets from Invoiced in Domo Workbench and then build visualizations in the Domo service.
-
Replicate FHIR Data to Multiple Databases
Replicate FHIR to disparate databases with a point-and-click configuration.
-
Integrating Codex CLI with Perplexity 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 HCL Domino Data in Google Apps Script via Connect AI
Use CData Connect AI to access HCL Domino in Google Apps Script.
-
Provide OData Services of Auth0 Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Auth0 by developing a WCF Service Application.
-
Create FTP-Connected Business Apps in AppSheet
Connect to FTP Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to FTP Servers.
-
How to Connect to Live Google Contacts 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 Google Contacts for you.
-
Access Live Cassandra Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Apache Cassandra from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate with Live Workday Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Workday from the MuleSoft Anypoint Platform to integrate live Workday into custom reports and dashboards.
-
Visualize SAS Data Sets Data in Sisense
Create an ElastiCube in Sisense app with access to SAS Data Sets.
-
Design BIRT Reports on ActiveCampaign Data
Provide current ActiveCampaign to your embedded analytics.
-
Extract, Transform, and Load Helpscout Data in Informatica PowerCenter
Create a simple Workflow for Helpscout in Informatica PowerCenter.
-
How to publish and share TigerGraph Data dashboards with Tableau Server
The CData ODBC driver for TigerGraph enables you integrate TigerGraph into Tableau dashboards.
-
Automated Continuous Samanage Replication to SingleStore
Use CData Sync for automated, continuous, customizable Samanage replication to SingleStore.
-
Integrate MailerSend with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate MailerSend with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to MailerSend.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Mouseflow
Provide connectivity to Mouseflow through an SAP BusinessObjects universe.
-
Automated MYOB AccountRight Data Replication to Teradata
Use CData Sync to Customize and automate MYOB AccountRight replication to Teradata.
-
Use the CData Software JDBC Driver for Act CRM in MicroStrategy Web
Connect to Act CRM in MicroStrategy Web using the CData Software JDBC Driver for Act CRM.
-
Connect Dynamics CRM to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Dynamics CRM with IBM WebSphere for seamless data integration and connectivity.
-
Build Jira-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Atlassian Jira.
-
Viewing Recurly Data in RAD Studio Data Explorer
How to view Recurly in RAD Studio Data Explorer using the CData ODBC Driver for Recurly.
-
Visualize Live Vault CRM Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Veeva Vault & Vault CRM into custom reports in Power BI.
-
Integrate LionDesk with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate LionDesk with External Services.
-
Use Agno to Talk to Your Google Contacts 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 Google Contacts for you.
-
How to connect to Klaviyo Data from Spring Boot
Connect to Klaviyo in a Spring Boot Application using the CData JDBC Driver for Klaviyo
-
Integrate Clio Data in the Pentaho Report Designer
Publish reports based on Clio in the Pentaho BI tool.
-
Analyze SAS Data Sets Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAS Data Sets from Power Pivot. You will use the Table Import Wizard to load SAS Data Sets. You can visually build the import query or use any SQL supported by the driver.
-
View Reports on Real-Time Google Tasks Data in Power BI Report Server
Use the CData ODBC Driver for Google Tasks to visualize Google Tasks in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate SAP Concur Data in Pentaho Data Integration
Build ETL pipelines based on SAP Concur in the Pentaho Data Integration tool.
-
Integrate Live WooCommerce Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to WooCommerce from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live WooCommerce.
-
eBay Analytics Reporting in OBIEE with the eBay Analytics JDBC Driver
Deploy the eBay Analytics JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Manage SendPulse Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SendPulse.
-
Access Live Auth0 Data in Coginiti Pro
Connect to and query live Auth0 from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Provide OData Services of Zoom Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zoom by developing a WCF Service Application.
-
Integrate SAP Fieldglass Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAP Fieldglass and integrate live SAP Fieldglass into your Power Automate tasks.
-
How to create Visio diagrams from Shopify Data
Automatically update Shopify with the changes you make to Visio master shapes.
-
Connect Short.io to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Short.io with IBM WebSphere for seamless data integration and connectivity.
-
Build Voice Agents in ElevenLabs with access to Live Databricks Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Databricks.
-
Query LDAP Objects in ColdFusion
Write standard ColdFusion data access code to connect to LDAP.
-
Analyze SAP Business One Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP Business One from Power Pivot. You will use the Table Import Wizard to load SAP Business One. You can visually build the import query or use any SQL supported by the driver.
-
How to Visualize Telegram Data in Python with pandas
Use pandas and other modules to analyze and visualize live Telegram in Python.
-
How to Import Data from Redshift into Google Sheets
Import Amazon Redshift into a Google spreadsheet that is automatically refreshed.
-
How to Visualize Zoho Books Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Zoho Books in Python.
-
Access Live Greenhouse Data in AWS Lambda
Connect to live Greenhouse in AWS Lambda using the CData JDBC Driver.
-
Use ChatGPT to Talk to Your CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your CSV/TSV Files for you.
-
Tickspot Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Tickspot facts in real time.