CData Software - Knowledge Base
Recent Articles
-
Integrate BenchmarkEmail Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live BenchmarkEmail data from Informatica Cloud.
-
Build Zoom Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Zoom data and build visualizations in Tableau.
-
Build FreshBooks-Connected Apps in Choreo
Use CData Connect AI to connect to FreshBooks Data from Choreo and build custom apps using live FreshBooks data.
-
How to Connect to & Open Codat Data in Microsoft Excel
This article uses the CData ODBC driver for Codat to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Typeform Replication to MySQL
Use CData Sync for automated, continuous, customizable Typeform replication to MySQL.
-
DataBind Controls to YouTube Analytics Data in C++Builder
DataBind to YouTube Analytics data in C++Builder with standard components and controls.
-
How to Access ConvertAPI Data Using Entity Framework
This article shows how to access ConvertAPI data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Datasets from Keap in Domo Workbench and Build Visualizations of Keap Data in Domo
Use the CData Software ODBC Driver for Keap to create datasets from Keap data in Domo Workbench and then build visualizations in the Domo service.
-
A PostgreSQL Interface for Dotmailer Data using the CData ODBC Driver
Use the SQL Gateway and Dotmailer ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Data Visualizations in Cognos BI with Telegram Data
Access Telegram data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Accelo Replication to MySQL
Use CData Sync for automated, continuous, customizable Accelo replication to MySQL.
-
How to connect to Teamgate Data with Squirrel SQL client
Connect to Teamgate data and execute queries in the Squirrel SQL Client.
-
Integrate Google's Antigravity Agent with Live Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Azure DevOps data using the Model Context Protocol.
-
Moving Data from Oracle Eloqua to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Oracle Eloqua data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Query Certinia Data as a MySQL Database in Node.js
Execute MySQL queries against Certinia data from Node.js.
-
How to Seamlessly Import AgileCRM Data into IBM SPSS Modeler
Integrate AgileCRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Getting Started with the CData Excel Add-In for SAP Business One
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP Business One.
-
Access Mailjet Data from MySQL in Amazon QuickSight
Connect to Mailjet and build visualizations of Mailjet data using a MySQL Connection in Amazon QuickSight.
-
Back Up Instagram data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Instagram. In this article, we will employ an SSIS workflow to populate a database with Instagram data data.
-
Build Semantic Layer Views for Oracle HCM Cloud Data in APOS Live Data Gateway
Use the CData Connector for Oracle HCM Cloud in APOS Live Data Gateway to build Semantic Layer Views for Oracle HCM Cloud data.
-
Connect to Notion Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Notion and work with Notion data in your FileMaker application.
-
Integrate OpenCode with Live GitHub Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live GitHub data from within your AI coding agent.
-
Publish Crystal Reports on Wistia Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Wistia data.
-
Extract, Transform, and Load Bitbucket Data in Informatica PowerCenter
Create a simple Workflow for Bitbucket data in Informatica PowerCenter.
-
Use Azure AI Foundry to Talk to Your GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your GitLab data for you.
-
How to integrate ChargeOver with Apache Airflow
Access and process ChargeOver data in Apache Airflow using the CData JDBC Driver.
-
Build a PostgreSQL Interface for Shortcut Data using the CData JDBC Driver
Use the Remoting features of the Shortcut JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to ShipStation Data from Spring Boot
Connect to ShipStation in a Spring Boot Application using the CData JDBC Driver for ShipStation
-
How to Connect the Power BI Service to MarkLogic: Complete Guide
Connect to the CData Software Power BI Connector for MarkLogic from PowerBI.com to provide real-time MarkLogic data across the organization.
-
Connect to CapsuleCRM Data in HULFT Integrate
Connect to CapsuleCRM as a JDBC data source in HULFT Integrate
-
How to connect Amazon QuickSight to Guru Data
Create a connection to Guru data in CData Connect AI and insert Guru data into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous MySQL Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable MySQL replication to Google Cloud SQL.
-
Visualize Live Microsoft Exchange Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Exchange data into custom reports in Power BI.
-
Link Invoiced with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Invoiced data in Filemaker Pro for Mac or Windows.
-
Integrate Vimeo Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Vimeo data from Informatica Cloud.
-
Build Apps with Live WordPress Data Using the Low-Code Development Platform of Mendix
Connect WordPress data with Mendix to build apps using the CData JDBC Driver for WordPress.
-
How to Build an ETL App for Slack Data in Python with CData Connect AI
Build ETL pipelines that read and write live Slack data in Python with petl and the CData Connect AI Python SDK.
-
Automated Continuous Egnyte Replication to SQLite
Use CData Sync for automated, continuous, customizable Egnyte replication to SQLite.
-
Access SAS xpt Data from MySQL in Amazon QuickSight
Connect to SAS xpt and build visualizations of SAS xpt data using a MySQL Connection in Amazon QuickSight.
-
Connect and Visualize Live YouTube Analytics Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live YouTube Analytics data into the Databricks platform and create visualization dashboards with real-time YouTube Analytics data.
-
Create Dashboards and Visualize Live eBay Data in Geckoboard
Use CData Connect AI to connect to live eBay data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connecting GenSpark with Elasticsearch Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Elasticsearch data without any replication or custom integration required.
-
Access Live Omnisend Data in Coginiti Pro
Connect to and query live Omnisend data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build an OLAP Cube in SSAS from MongoDB Data
Establish a connection to MongoDB data data from SQL Server Analysis Services, and use the MongoDB Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to and Visualize Live PagerDuty Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live PagerDuty data.
-
Integrating GitHub Copilot with BigCommerce 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.
-
Create Dashboards and Visualize Live SAP HANA Data in Geckoboard
Use CData Connect AI to connect to live SAP HANA data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous SharePoint Excel Services Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Amazon S3.
-
Connect to API Data from Crystal Reports
Use CData Connect AI to connect to and report on live API data from Crystal Reports.
-
A PostgreSQL Interface for Highrise Data using the CData ODBC Driver
Use the SQL Gateway and Highrise ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Dynamic BigQuery Grids Using the Infragistics XamDataGrid
Learn how you can connect BigQuery to Infragistics XamDataGrid to build dynamic grids.
-
Build SAP Fieldglass Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP Fieldglass data and build visualizations in Tableau.
-
Build Toggl-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Toggl data without replication.
-
Access Live Active Directory Data in TIBCO Data Virtualization
Use the Active Directory Tibco DV Adapter to create a Active Directory data data source in TIBCO Data Virtualization Studio and gain access to live Active Directory data from your TDV Server.
-
Access Azure Table Data from MySQL in Amazon QuickSight
Connect to Azure Table and build visualizations of Azure Table data using a MySQL Connection in Amazon QuickSight.
-
Access Live YouTube Analytics Data in Coginiti Pro
Connect to and query live YouTube Analytics data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use Microsoft Copilot Studio to talk to your MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your MySQL data for you.
-
Deploy the ADO.NET Provider for WooCommerce on an SSRS Report Server
Connect to WooCommerce 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.
-
Getting Started with the CData Power BI Connector for Pipeliner CRM
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connecting Pipedream with Act-On Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Act-On data in real time.
-
Integrating LangGraph with Oracle Service Cloud Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Oracle Service Cloud data within automated workflows.
-
How to Visualize Oracle Eloqua 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 Oracle Eloqua data in Python.
-
Publish Reports with Jira Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Jira data.
-
Visualize Live Sendwithus Data in the Power BI Service
Use CData Connect AI to connect to live Sendwithus data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData Python Connector for MailerLite
Learn to install and license the CData Python Connector and configure a connection to live MailerLite data.
-
Connect to SurveyMonkey Data in DBeaver
Use the CData ODBC Driver to connect to SurveyMonkey data in DBeaver.
-
Add AfterShip Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for AfterShip with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect Flowise AI Agents to Live Raisers Edge NXT 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 Raisers Edge NXT data without replication.
-
Publish Reports with Mistral AI Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mistral AI data.
-
Automated Continuous Shortcut Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Shortcut data replication to OneLake in Microsoft Fabric.
-
Create Reports from Authorize.Net Data in Looker Studio
Use CData Connect AI to gain access to live Authorize.Net data and create custom reports in Looker Studio.
-
Create Unbounce Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Unbounce data access from reports, embedded analytics, and more.
-
Analyze Bannerbear Data in Looker
Use CData Connect AI to connect to Bannerbear Data from Looker and build custom apps using live Bannerbear data.
-
Create Data Visualizations in Cognos BI with Todoist Data
Access Todoist data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect Jira Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Jira data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Enable the Kintone JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Kintone data.
-
Automated Continuous Pingdom Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Pingdom replication to Apache Cassandra.
-
Replicate DB2 for i Data to Multiple Databases
Replicate DB2 for i data to disparate databases with a point-and-click configuration.
-
Connect to Onfleet Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Onfleet.
-
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.
-
How to connect to Kafka Data with Squirrel SQL client
Connect to Kafka data and execute queries in the Squirrel SQL Client.
-
Automated Continuous HBase Replication to SingleStore
Use CData Sync for automated, continuous, customizable HBase replication to SingleStore.
-
How to connect to SAP Data in DBVisualizer
Integrate SAP data with visual data analysis tools and data connection wizards in DBVisualizer
-
Publish Everhour-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Everhour data.
-
How to Query Live PayPal Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live PayPal data data in natural language using Python.
-
Automated Continuous Salesloft Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Salesloft replication to PostgreSQL.
-
LINQ to Sybase IQ 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 Sybase IQ Data Provider.
-
Automated Continuous HelloSign Replication to AlloyDB
Use CData Sync for automated, continuous, customizable HelloSign replication to AlloyDB.
-
View Reports on Real-Time Azure Data Lake Storage Data in Power BI Report Server
Use the CData ODBC Driver for Azure Data Lake Storage to visualize Azure Data Lake Storage data in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize MailChimp Data in Tableau
The CData ODBC driver for MailChimp enables you integrate MailChimp data into Tableau dashboards.
-
Connect to SAP Fieldglass Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP Fieldglass data from HeidiSQL.
-
Integrating Kiro 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.
-
Enable the Cohere JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Cohere data.
-
Connect to Chargebee Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Chargebee and the SQL Gateway to access Chargebee data from Google Apps Script.
-
Connect to Mailgun Data from PowerBuilder via JDBC
This article demonstrates how to access Mailgun data from PowerBuilder using the Mailgun JDBC Driver.
-
How to integrate Oracle Eloqua Reporting with Apache Airflow
Access and process Oracle Eloqua Reporting data in Apache Airflow using the CData JDBC Driver.
-
Build Charts with Aha! Data in Clear Analytics
Create dynamic charts and perform analytics based on Aha! data in Clear Analytics.
-
Integrate OpenCode with Live Pinterest Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Pinterest data from within your AI coding agent.
-
Access Live Quaderno Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Quaderno data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Avalara AvaTax Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Avalara AvaTax Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.