CData Software - Knowledge Base
Recent Articles
-
Access Live Placid Data in Coginiti Pro
Connect to and query live Placid data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Publish Reports with PabblySubscriptions Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PabblySubscriptions data.
-
Feed TigerGraph Data into FineReport
How to set TigerGraph data as a JDBC data source in FineReport.
-
Integrating OpenCode with QuickBooks Time 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.
-
Automate Google Calendar Data Replication to Azure Synapse
Use CData Sync to customize and automate Google Calendar data replication to Azure Synapse.
-
Access Zuora Data from MySQL in Amazon QuickSight
Connect to Zuora and build visualizations of Zuora data using a MySQL Connection in Amazon QuickSight.
-
Use Biml to Build SSIS Tasks to Replicate Anaplan Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Anaplan data to SQL Server.
-
Integrate Goose with Live PingOne Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live PingOne data from within the local AI agent.
-
Automated Continuous MariaDB Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable MariaDB replication to Amazon Redshift.
-
Getting Started with the CData Python Connector for CapsuleCRM
Learn to install and license the CData Python Connector and configure a connection to live CapsuleCRM data.
-
Connect to Google Forms Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Google Forms and work with Google Forms data in your FileMaker applications.
-
Link Amazon Marketplace with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Amazon Marketplace data in Filemaker Pro for Mac or Windows.
-
Prepare, Blend, and Analyze Google Forms Data in Alteryx Designer (ODBC)
Build workflows to access live Google Forms data for self-service data analytics.
-
Build Oracle HCM Cloud-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Oracle HCM Cloud data.
-
Automated Continuous Intercom Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Intercom replication to IBM DB2.
-
Create Redshift-Connected Dashboards in Grafana
Connect to Redshift Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Redshift data.
-
Access Live Exa Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Exa data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating Kiro with ZohoPeople 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 Live Lakebase Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Lakebase from the MuleSoft Anypoint Platform to integrate live Lakebase data into custom reports and dashboards.
-
Build Semantic Layer Views for Oracle Financials Cloud Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Oracle Financials Cloud data.
-
How to Connect to Live Active Directory 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 Active Directory data without replication.
-
Edit and Search External Greenplum Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Greenplum data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Greenplum Data objects that you can access from apps and the dashboard.
-
Build Pipelines with Live Paylocity Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Paylocity from Google Cloud Data Fusion, enabling the integration of live Paylocity data into the building and management of effective data pipelines.
-
Build a Simple VCL Application for Google Calendar Data
How to build a simple VCL Application to view Google Calendar data in RAD Studio using the CData ODBC Driver for Google Calendar.
-
How to connect SharePoint with CSV Data through external lists
Provide CSV data to SharePoint users as an external list.
-
Automated Continuous Guru Replication to SingleStore
Use CData Sync for automated, continuous, customizable Guru replication to SingleStore.
-
How to create an RPA flow for Trello Data in UiPath Studio
Use the Trello ODBC Driver to create workflows that access real-time Trello data without any coding.
-
Integrating Kiro with Sage 200 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.
-
How to Query Google Sheets Data in MySQL Workbench
Execute MySQL queries against live Google Sheets data from MySQL Workbench.
-
How to Create Power BI Visual Reports with Real-Time Exact Online Data
Use CData Power BI Connectors to visualize Exact Online data in Power BI.
-
Getting Started with the CData Python Connector for Microsoft Planner
Learn to install and license the CData Python Connector and configure a connection to live Microsoft Planner data.
-
Access Live Invoiced Data in AWS Lambda
Connect to live Invoiced data in AWS Lambda using the CData JDBC Driver.
-
Create SSAS Tabular Models from Paylocity Data
How to build a SQL Server Analysis Service Tabular Model from Paylocity data using CData drivers.
-
Build Semantic Layer Views for Cvent Data in APOS Live Data Gateway
Use the CData Connector for Cvent in APOS Live Data Gateway to build Semantic Layer Views for Cvent data.
-
Pinecone Reporting in OBIEE with the Pinecone JDBC Driver
Deploy the Pinecone JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Access Live Webflow Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Webflow enables you to integrate Webflow data into workflows built using Microsoft Power Automate Desktop.
-
Create Sendwithus-Connected Dashboards in Grafana
Connect to Sendwithus Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Sendwithus data.
-
Create Data Visualizations in Cognos BI with Flowlu Data
Access Flowlu data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software JDBC Driver for SingleStore in MicroStrategy
Connect to SingleStore data in MicroStrategy Developer using the CData Software JDBC Driver for SingleStore.
-
How to connect and process MYOB AccountRight data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MYOB AccountRight data.
-
Design BIRT Reports on Blackbaud FE NXT Data
Provide current Blackbaud FE NXT data to your embedded analytics.
-
Connect to Cloudflare Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Cloudflare data.
-
Create Mailjet-Connected Applications in Appsmith
Connect to Mailjet Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Mailjet data.
-
Create Power BI Reports on Real-Time Oracle Sales Data
Use the CData ODBC Driver for Oracle Sales to visualize Oracle Sales data in Power BI Desktop.
-
Connect to Discourse Data in RapidMiner
Integrate Discourse data with standard components and data source configuration wizards in RapidMiner Studio.
-
Cohere Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Cohere facts in real time.
-
A PostgreSQL Interface for Google Forms Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Forms JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Bright Data Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Bright Data to connect to Bright Data data and execute queries in PowerBuilder.
-
Integrate OpenCode with Live Suadeo Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Suadeo data from within your AI coding agent.
-
Connect Timely to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Timely data using the CData Python MCP Server.
-
Automated Continuous Tanda Replication to MongoDB
Use CData Sync for automated, continuous, customizable Tanda replication to MongoDB.
-
Create BenchmarkEmail Dataflows on PowerBI.com
Connect to the CData Power BI Connector for BenchmarkEmail from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous ScrapingBee Replication to SingleStore
Use CData Sync for automated, continuous, customizable ScrapingBee replication to SingleStore.
-
Connect to ChartMogul Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ChartMogul and the SQL Gateway to access ChartMogul data from Google Apps Script.
-
Create Scrapfly Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Scrapfly data access from reports, embedded analytics, and more.
-
Build Apps with Live Power BI XMLA data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Power BI XMLA data into the Adalo platform and build custom mobile and web applications with real-time Power BI XMLA data.
-
Automated Continuous Workday Replication to SQLite
Use CData Sync for automated, continuous, customizable Workday replication to SQLite.
-
Migrating data from GitLab to Databricks using CData SSIS Components.
Easily push GitLab data to Databricks using the CData SSIS Tasks for GitLab and Databricks.
-
Build a Simple VCL Application for Sage 300 Data
How to build a simple VCL Application to view Sage 300 data in RAD Studio using the CData ODBC Driver for Sage 300.
-
Connect to Impala Data in NetBeans
Connect to Impala data in NetBeans with the data source configuration wizard.
-
Automated Continuous Salesforce Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Salesforce replication to PostgreSQL.
-
Query Live Dynamics NAV Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Dynamics NAV data directly from the development environment.
-
Working with GitHub Data in LINQPad
Execute LINQ queries to GitHub data in LINQPad.
-
Connecting Moonlit Workflow with Avro Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Avro data in real time.
-
Build a PostgreSQL Interface for ZendeskSell Data using the CData JDBC Driver
Use the Remoting features of the ZendeskSell JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to integrate Superchat with Apache Airflow
Access and process Superchat data in Apache Airflow using the CData JDBC Driver.
-
Connect to YouTube Analytics Data in RazorSQL
Connect to YouTube Analytics from wizards and query YouTube Analytics data from the GUI in the RazorSQL database management tool.
-
Connect to Reckon Accounts Hosted Data in DBeaver
Use the CData ODBC Driver to connect to Reckon Accounts Hosted data in DBeaver.
-
Build AI Agents with Zoho CRM 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 Zoho CRM data through CData Connect AI.
-
Enable the Outreach.io JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Outreach.io data.
-
Feed Perigon Data into FineReport
How to set Perigon data as a JDBC data source in FineReport.
-
Integrate with live FTP Data in Jitterbit
Use CData Connect AI to connect to and integrate live FTP data in Jitterbit.
-
Build Agents in Relevance AI with Access to Live Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Spark data within intelligent agent workflows.
-
Analyze HubSpot Data in Cognos Analytics
Use CData Connect AI to connect to HubSpot Data from Cognos Analytics and analyze live HubSpot data.
-
Automated Continuous SAP BusinessObjects BI Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Apache Cassandra.
-
A PostgreSQL Interface for ZohoMarketingHub Data (MySQL Remoting via JDBC)
Use the Remoting features of the ZohoMarketingHub JDBC Driver to create a PostgreSQL entry-point for data access.
-
Migrating data from Factorial to Snowflake using CData SSIS Components.
Easily push Factorial data to Snowflake using the CData SSIS Tasks for Factorial and Snowflake.
-
Manage Mailjet Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Mailjet.
-
Getting Started with the CData Excel Add-In for xBase
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for xBase.
-
Connect to Retently Data in JRuby
Create a simple JRuby app with access to live Retently data.
-
Connect to Strava Data in NetBeans
Connect to Strava data in NetBeans with the data source configuration wizard.
-
Connect to GraphQL Data in CloverDX (formerly CloverETL)
Transfer GraphQL data using the visual workflow in the CloverDX data integration tool.
-
Extract, Transform, and Load Google Campaign Manager 360 Data in Informatica PowerCenter
Create a simple Workflow for Google Campaign Manager 360 data in Informatica PowerCenter.
-
Create SAP SuccessFactors-Connected Nintex Workflows
Use CData Connect AI to connect to SAP SuccessFactors Data from Nintex Workflow Cloud and build custom workflows using live SAP SuccessFactors data.
-
Extract, Transform, and Load ClickTime Data in Informatica PowerCenter
Create a simple Workflow for ClickTime data in Informatica PowerCenter.
-
Integrate Live Paymo Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Paymo from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Paymo data.
-
Getting Started with the CData SSIS Components for Gmail
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Gmail.
-
Publish Reports with Webflow Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Webflow data.
-
Analyze TigerGraph Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze TigerGraph data in Microsoft R Open.
-
Visualize Oracle SCM Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Oracle SCM data.
-
Integrating Kiro with Adobe Experience Manager 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.
-
DataBind Shippo Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Shippo data to a chart.
-
Integrate with live Splunk Data in Jitterbit
Use CData Connect AI to connect to and integrate live Splunk data in Jitterbit.
-
How to Connect the Power BI Service to Phoenix: Complete Guide
Connect to the CData Software Power BI Connector for Phoenix from PowerBI.com to provide real-time Phoenix data across the organization.
-
Automated Continuous Clockify Replication to Databricks
Use CData Sync for automated, continuous, customizable Clockify replication to Databricks.
-
Connect and Query Live Microsoft OneDrive Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft OneDrive data into Databricks and enable direct, live querying and analysis without replication.
-
How to connect to Auth0 Data from Spring Boot
Connect to Auth0 in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Avro Data in RapidMiner
Integrate Avro data with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Live Microsoft Entra ID Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft Entra ID data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Natively Connect to Clari Data in PHP
The CData ODBC driver for Clari enables you to create PHP applications with connectivity to Clari data. Leverage the native support for ODBC in PHP.