CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for Elorus in MicroStrategy Web
Connect to Elorus data in MicroStrategy Web using the CData Software JDBC Driver for Elorus.
-
Automated Continuous MYOB AccountRight Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to delimited files (CSV/TSV).
-
Design BIRT Reports on Shortcut Data
Provide current Shortcut data to your embedded analytics.
-
Access Strava Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Strava data from HeidiSQL.
-
Connect to ClickTime Data in JRuby
Create a simple JRuby app with access to live ClickTime data.
-
Use the CData Software JDBC Driver for SAP Concur in MicroStrategy Desktop
Connect to SAP Concur data in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Concur.
-
Connect to Timely Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Timely to connect to Timely data and execute queries in PowerBuilder.
-
Create Data Visualizations Based On AlloyDB Data in Mode
Use CData Connect AI to connect to AlloyDB Data from Mode and build visualizations using live AlloyDB data.
-
Edit and Search External SFTP Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SFTP data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SFTP Data objects that you can access from apps and the dashboard.
-
Automated Continuous ElevenLabs Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ElevenLabs replication to PostgreSQL.
-
Getting Started with the CData Python Connector for Email
Learn to install and license the CData Python Connector and configure a connection to live Email data.
-
Use Azure AI Foundry to Talk to Your Bitbucket 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 Bitbucket data for you.
-
Integrate PolarTeamPro with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PolarTeamPro with External Services.
-
Query DB2 Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume DB2 entities in PHP by modeling them as objects.
-
Getting Started with the CData SSIS Components for Freshservice
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Freshservice.
-
Connect to Xero Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Xero to connect to Xero data and execute queries in PowerBuilder.
-
Automate Microsoft Teams Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Teams data replication to Couchbase.
-
Connect to ConstantContact in SpagoBI
Create reports featuring live ConstantContact data in SpagoBI Studio. Host ConstantContact reports on SpagoBI Server.
-
Migrating data from Vimeo to Google BigQuery using CData SSIS Components.
Easily push Vimeo data to Google BigQuery using the CData SSIS Tasks for Vimeo and Google BigQuery.
-
Automated Continuous AdRoll Replication to Amazon S3
Use CData Sync for automated, continuous, customizable AdRoll replication to Amazon S3.
-
Build a PostgreSQL Interface for MYOB AccountRight Data using the CData JDBC Driver
Use the Remoting features of the MYOB AccountRight JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData ODBC Driver for Exact Online from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Exact Online to connect to Exact Online data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Exact Online data in Excel.
-
Use Agno to Talk to Your Monday.com 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 Monday.com data for you.
-
Import Real-Time Amazon Marketplace Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Amazon Marketplace data in ColdFusion.
-
How to connect to LeadDesk Data in DBVisualizer
Integrate LeadDesk data with visual data analysis tools and data connection wizards in DBVisualizer
-
Consume Reckon OData Feeds in PowerBuilder
This article demonstrates how to consume Reckon data as OData feeds from PowerBuilder using the API Server.
-
Connect to Office 365 Data in NetBeans
Connect to Office 365 data in NetBeans with the data source configuration wizard.
-
Analyze Live Oracle Financials Cloud Data in SAS Viya
Use CData Connect AI to connect to Oracle Financials Cloud data from SAS Viya and deploy self-service analytics using live Oracle Financials Cloud data.
-
Access Postmark Data from MySQL in PHP
Connect to Postmark through the standard MySQL libraries in PHP.
-
How to Visualize ZohoDesk 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 ZohoDesk data in Python.
-
Build VWO-Connected Apps in Choreo
Use CData Connect AI to connect to VWO Data from Choreo and build custom apps using live VWO data.
-
Automated Continuous CircleCI Replication to Vertica
Use CData Sync for automated, continuous, customizable CircleCI replication to Vertica.
-
Create Odoo Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Odoo data access from reports, embedded analytics, and more.
-
How to connect and process Access data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Access data.
-
Analyze Oracle Eloqua Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Oracle Eloqua data in Microsoft R Open.
-
Query SingleStore Data as a SQL Server Database in Node.js
Execute SQL Server queries against SingleStore data from Node.js.
-
Build a Singer.io Tap for Greenplum With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Greenplum data using the CData Python Connector.
-
Connect to YouTube Analytics Data in Aqua Data Studio
Access YouTube Analytics data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build a PostgreSQL Interface for Tavily Data using the CData JDBC Driver
Use the Remoting features of the Tavily JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Informatica Mappings From/To a JDBC Data Source for Hugging Face
Create Hugging Face data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Retently Data in Ruby
Connect to Retently data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Greenplum Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Greenplum data and build visualizations in Tableau Cloud.
-
Connect to and Visualize Live Oracle HCM Cloud Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle HCM Cloud data.
-
Analyze Zoom Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Zoom data and visualize live Zoom data in Infragistics Reveal.
-
How to Easily Query Jira Assets Data in OpenOffice Base
Connect to Jira Assets data in OpenOffice Base using the CData ODBC Driver for Jira Assets and generate reports with live data insights.
-
Connect to Live Oracle HCM Cloud Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Oracle HCM Cloud in CData Connect AI and connect to your Oracle HCM Cloud data from PostgreSQL.
-
Integrate Reckon with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Reckon with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Reckon data.
-
Connect to Testmonitor from a Connection Pool in WebLogic
Use the CData JDBC Driver for Testmonitor to connect to Testmonitor data from Web applications running on WebLogic.
-
Connect to Reckon Accounts Hosted Data from HeidiSQL
Use CData Connect AI to connect to and query live Reckon Accounts Hosted data from HeidiSQL.
-
Excel Spreadsheet Automation on Pinecone Data with the QUERY Formula
Pull data from Pinecone, automate spreadsheets, and more with the QUERY formula.
-
How to Connect the Power BI Service to FreshBooks: Complete Guide
Connect to the CData Software Power BI Connector for FreshBooks from PowerBI.com to provide real-time FreshBooks data across the organization.
-
Use CData Connect AI to Access MariaDB Data in Microsoft Power Pivot
Use CData Connect AI to connect to live MariaDB data in the Power Pivot business intelligence tool.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for PingOne
Provide connectivity to PingOne data through an SAP BusinessObjects universe.
-
Integrate Cline with Live SageHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SageHR data from within your IDE.
-
Integrate Live Splunk Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Splunk from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Splunk data.
-
View Reports on Real-Time Google Ads Data in Power BI Report Server
Use the CData ODBC Driver for Google Ads to visualize Google Ads data in Power BI Desktop and then publish them to Power BI Report Server.
-
ETL IBM Cloud Object Storage in Oracle Data Integrator
This article shows how to transfer IBM Cloud Object Storage data into a data warehouse using Oracle Data Integrator.
-
Create Jira-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Jira Data from OutSystems and build custom enterprise apps using live Jira data.
-
Build Avro-Connected Apps in Choreo
Use CData Connect AI to connect to Avro Data from Choreo and build custom apps using live Avro data.
-
A PostgreSQL Interface for Okta Data (MySQL Remoting via JDBC)
Use the Remoting features of the Okta JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connecting Mastra with Stripe Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Stripe data, no replication required.
-
Automate PayPal Integration Tasks from PowerShell
Are you in search of a quick and easy way to access PayPal data from PowerShell? This article demonstrates how to utilize the PayPal Cmdlets for tasks like connecting to PayPal data, automating operations, downloading data, and more.
-
Build Kintone-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Kintone Data and create custom apps in Bubble.
-
Consume Salesforce OData Feeds in PowerBuilder
This article demonstrates how to consume Salesforce data as OData feeds from PowerBuilder using the API Server.
-
How to use SQLAlchemy ORM to access Google Campaign Manager 360 Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Campaign Manager 360 data.
-
Access Egnyte Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Egnyte data from your Oracle system.
-
Build Xero-Connected Apps in Choreo
Use CData Connect AI to connect to Xero Data from Choreo and build custom apps using live Xero data.
-
DataBind Controls to Azure Table Data in Delphi
DataBind to Azure Table data in Delphi with standard data access components and controls.
-
Publish Reports with Egnyte Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Egnyte data.
-
Query Live SparkPost Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live SparkPost data through a conversational interface.
-
Automated Continuous SAP Fieldglass Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Apache Cassandra.
-
Create Zoho Recruit Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Zoho Recruit data access from reports, embedded analytics, and more.
-
Connect to and Visualize Live GitHub Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live GitHub data.
-
Integrate ZohoMarketingHub Data into Power Automate Desktop using CData Connect
CData Connect for ZohoMarketingHub Data enables you to integrate ZohoMarketingHub data into workflows built using Microsoft Power Automate Desktop.
-
Access Live YouTube Analytics 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 YouTube Analytics data through MCP integration.
-
Seamlessly Bring Jumpseller Data into Retool Using CData Connect AI
Integrate Jumpseller data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Establish a Live Connection with TigerGraph Data using Tableau Bridge
The CData ODBC Driver for TigerGraph enables you to integrate live TigerGraph data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect and Visualize Live Testmonitor Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Testmonitor data into the Databricks platform and create visualization dashboards with real-time Testmonitor data.
-
Link Mixpanel with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Mixpanel data in Filemaker Pro for Mac or Windows.
-
How to connect and process SAS Data Sets data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAS Data Sets data.
-
How to connect Amazon QuickSight to Basecamp Data
Create a connection to Basecamp data in CData Connect AI and insert Basecamp data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to create an RPA flow for Slack Data in UiPath Studio
Use the Slack ODBC Driver to create workflows that access real-time Slack data without any coding.
-
How to Access Webex Data Using Entity Framework
This article shows how to access Webex data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Live Shortcut Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Shortcut from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Shortcut data.
-
Connecting Moonlit Workflow with Dynamics CRM 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 Dynamics CRM data in real time.
-
Analyze SAP SuccessFactors LMS Data in Cognos Analytics
Use CData Connect AI to connect to SAP SuccessFactors LMS Data from Cognos Analytics and analyze live SAP SuccessFactors LMS data.
-
Build Agents in Relevance AI with Access to Live Tally Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Tally data within intelligent agent workflows.
-
Getting Started with the CData Excel Add-In for Snapchat Ads
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Snapchat Ads.
-
Use the CData Software JDBC Driver for Clio in MicroStrategy Desktop
Connect to Clio data in MicroStrategy Desktop using the CData Software JDBC Driver for Clio.
-
Connect to HubSpot Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for HubSpot data in the Denodo Virtual DataPort Administrator.
-
Integrate Sendwithus Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Sendwithus data and integrate live Sendwithus data into your Power Automate tasks.
-
Deploy the ADO.NET Provider for Webflow on an SSRS Report Server
Connect to Webflow 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.
-
Connect to Basecamp Data from PowerBuilder via ADO.NET
This article demonstrates how to access Basecamp data from Appeon PowerBuilder using the CData ADO.NET Provider for Basecamp.
-
Build Agents in Relevance AI with Access to Live ZohoInvoice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on ZohoInvoice data within intelligent agent workflows.
-
How to connect and process Teamgate data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Teamgate data.
-
Build a PostgreSQL Interface for DB2 Data using the CData JDBC Driver
Use the Remoting features of the DB2 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Link Spotify with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Spotify data in Filemaker Pro for Mac or Windows.
-
Connect to Neo4J Data in NetBeans
Connect to Neo4J data in NetBeans with the data source configuration wizard.
-
Automated Continuous Unbounce Replication to SingleStore
Use CData Sync for automated, continuous, customizable Unbounce replication to SingleStore.
-
Build Snapchat Ads-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Snapchat Ads data.