CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Dynamics CRM Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Dynamics CRM data in ColdFusion.
-
Integrate Goose with Live QuickBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live QuickBooks data from within the local AI agent.
-
How to Create Power BI Visual Reports with Real-Time ClickTime Data
Use CData Power BI Connectors to visualize ClickTime data in Power BI.
-
Access Live Elorus Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Elorus data into the statistical analysis tools available in SAS JMP. This article shows how to use Elorus data in the Graph Builder and Query Builder.
-
Connect to Productboard Data from a Connection Pool in JBoss
Integrate Productboard data into Java servlets: Use the Management Console in JBoss to install the Productboard JDBC Driver.
-
Integrate Real-Time Access to RSS in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to RSS feeds in real time.
-
ETL Microsoft Entra ID in Oracle Data Integrator
This article shows how to transfer Microsoft Entra ID data into a data warehouse using Oracle Data Integrator.
-
Integrate Live Samanage Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Samanage data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect and Visualize Live Cvent Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Cvent data into the Databricks platform and create visualization dashboards with real-time Cvent data.
-
Feed Freshsales Data into FineReport
How to set Freshsales data as a JDBC data source in FineReport.
-
Automated Continuous SAP Ariba Source Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Amazon S3.
-
Use the CData Software ODBC Driver for Neo4J in MicroStrategy
Connect to Neo4J data in MicroStrategy Developer using the CData Software ODBC Driver for Neo4J.
-
How to connect SharePoint with Oracle Data through external lists
Provide Oracle data to SharePoint users as an external list.
-
Visualize Live Placid Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Placid data.
-
Work with Cvent Data in FoxPro
Load Cvent data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build ShipEngine-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ShipEngine data and build web apps with connectivity to live ShipEngine data.
-
Use Microsoft Copilot Studio to talk to your Cassandra 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 Cassandra data for you.
-
Create Informatica Mappings From/To a JDBC Data Source for Mocean
Create Mocean data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query Live JSON 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 JSON services through a conversational interface.
-
How to use SQLAlchemy ORM to access Google Contacts Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Contacts data.
-
Access Live Quickbase Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Quickbase data from your Excel spreadsheets.
-
Write a Simple Go Application to work with Eventbrite Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Eventbrite data.
-
Design BIRT Reports on Shortcut Data
Provide current Shortcut data to your embedded analytics.
-
Operational Reporting on Toggl Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Toggl data.
-
Create Webflow Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Webflow from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query, Visualize, and Share live Redis Data in Redash
Use CData Connect AI to connect to live Redis data in Redash for querying, visualizing, and sharing.
-
Working with Greenhouse Data in LINQPad
Execute LINQ queries to Greenhouse data in LINQPad.
-
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.
-
Choosing the Best Method to Connect Kintone to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Kintone data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Live Elasticsearch Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Elasticsearch data and integrate live Elasticsearch data into apps built in Microsoft Power Apps.
-
Connect to Float Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Float data in the Denodo Virtual DataPort Administrator.
-
Integrate Cvent Data in Pentaho Data Integration
Build ETL pipelines based on Cvent data in the Pentaho Data Integration tool.
-
Automate Microsoft Teams Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Teams data replication to Couchbase.
-
Query PostgreSQL Data as a MySQL Database in Node.js
Execute MySQL queries against PostgreSQL data from Node.js.
-
Use the CData Software ODBC Driver for Cvent in MicroStrategy Web
Connect to Cvent data in MicroStrategy Web using the CData Software ODBC Driver for Cvent.
-
Create Quickbase-Connected Business Apps in AppSheet
Connect to Quickbase Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Quickbase data.
-
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.
-
Connect to Aweber Data in DBArtisan
Use wizards in DBArtisan to configure Aweber data as a data source.
-
Create Apps from SAP SuccessFactors Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP SuccessFactors Data and build apps from live SAP SuccessFactors data in Qlik Sense Cloud.
-
Access Live Sage Cloud Accounting 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 Sage Cloud Accounting data through MCP integration.
-
Stream Browserless Data into Apache Kafka Topics
Access and stream Browserless data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build AI Agents with ConstantContact 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 ConstantContact data through CData Connect AI.
-
Access Postmark Data from MySQL in PHP
Connect to Postmark through the standard MySQL libraries in PHP.
-
A PostgreSQL Interface for Google Search Results using the CData ODBC Driver
Use the SQL Gateway and Google Search ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Power BI Reports on Real-Time Klaviyo Data
Use the CData ODBC Driver for Klaviyo to visualize Klaviyo data in Power BI Desktop.
-
Connect to Splunk Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Splunk data in Airbyte.
-
Manage Confluence Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Confluence.
-
Build Apps with Live ADP Data Using the Low-Code Development Platform of Mendix
Connect ADP data with Mendix to build apps using the CData JDBC Driver for ADP.
-
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 Microsoft Planner-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Planner data.
-
Integrating LangChain with Freshteam Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Freshteam data within automated workflows.
-
Create HelloSign Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time HelloSign data access from reports, embedded analytics, and more.
-
Analyze Contentful Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Contentful data with the CData JDBC Driver for Contentful.
-
Use the CData Software ODBC Driver for Pinecone in SAS for Real-Time Reporting and Analytics
Connect to real-time Pinecone data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Pinecone.
-
Automated Continuous RSS Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable RSS replication to Google BigQuery.
-
Publish Bullhorn CRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Bullhorn CRM data.
-
How to Build an ETL App for Hive Data in Python with CData Connect AI
Build ETL pipelines that read and write live Hive data in Python with petl and the CData Connect AI Python SDK.
-
Search External Egnyte Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Egnyte data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Egnyte Data objects that you can access from apps and the dashboard.
-
Integrate with live Jira Data in Jitterbit
Use CData Connect AI to connect to and integrate live Jira data in Jitterbit.
-
Automate OData Services Replication to Couchbase
Use CData Sync to Customize and automate OData services replication to Couchbase.
-
How to create Visio diagrams from Snowflake Data
Automatically update Snowflake data with the changes you make to Visio master shapes.
-
Prepare, Blend, and Analyze XML Data in Alteryx Designer (Connect AI)
Build workflows to access live XML data for self-service data analytics.
-
Build MVC Applications with Connectivity to Presto Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Presto from an ASP.NET MVC application.
-
Integrate with Attio Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Attio data to a JSON file on disk.
-
DataBind Controls to LaunchDarkly Data in Delphi
DataBind to LaunchDarkly data in Delphi with standard data access components and controls.
-
Natively Connect to ServiceDesk Plus Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ServiceDesk Plus data. Leverage the native support for ODBC in PHP.
-
Connect to Zoom Data from Crystal Reports
Use CData Connect AI to connect to and report on live Zoom data from Crystal Reports.
-
Integrate FreshBooks Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to FreshBooks data and integrate live FreshBooks data into your Power Automate tasks.
-
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.
-
Connect to Contentful Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Contentful data in the Denodo Virtual DataPort Administrator.
-
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.
-
Query, Visualize, and Share live iContact Data in Redash
Use CData Connect AI to connect to live iContact data in Redash for querying, visualizing, and sharing.
-
Migrating data from Presto to Snowflake using CData SSIS Components.
Easily push Presto data to Snowflake using the CData SSIS Tasks for Presto and Snowflake.
-
Use Dash to Build Web Apps on TaxJar Data via CData Connect AI
Build interactive Dash web apps on live TaxJar data using pandas and the CData Connect AI Python SDK.
-
Build Apps with Live Okta Data Using the Low-Code Development Platform of Mendix
Connect Okta data with Mendix to build apps using the CData JDBC Driver for Okta.
-
Automated Continuous Quickbase Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Quickbase replication to Apache Cassandra.
-
Connect to and Visualize Live GitHub Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live GitHub data.
-
Integrating Claude Code with Shippo Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Shippo data within assisted coding and automated development workflows.
-
Create Dynamic ClickTime Grids Using the Infragistics XamDataGrid
Learn how you can connect ClickTime to Infragistics XamDataGrid to build dynamic grids.
-
Bidirectional Access to SingleStore Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SingleStore data in Filemaker Pro for Mac or Windows.
-
DataBind Controls to CloudConvert Data in Delphi
DataBind to CloudConvert data in Delphi with standard data access components and controls.
-
Integrating LlamaIndex with Tavily Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Tavily data in real time.
-
Getting Started with the CData Power BI Connector for Mistral AI
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create SAP Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP data access from reports, embedded analytics, and more.
-
Automate Egnyte Data Replication to Azure Synapse
Use CData Sync to customize and automate Egnyte data replication to Azure Synapse.
-
Create Data Visualizations in Cognos BI with Google Analytics Data
Access Google Analytics data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Pipeline CRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Apache Kafka.
-
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.
-
Use the CData Software JDBC Driver for Zoho Books in MicroStrategy Desktop
Connect to Zoho Books data in MicroStrategy Desktop using the CData Software JDBC Driver for Zoho Books.
-
Create Reports from Google Directory Data in Looker Studio
Use CData Connect AI to gain access to live Google Directory data and create custom reports in Looker Studio.
-
Campaigner Reporting in OBIEE with the Campaigner JDBC Driver
Deploy the Campaigner JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Power BI XMLA Data in Jaspersoft Studio
Execute SQL to remote Power BI XMLA data in Jaspersoft Studio.
-
Work with Live Salesforce Data in Power Query
Use CData Connect AI to connect to Salesforce data and work with live Salesforce data in Microsoft Power Query.
-
Connecting Mastra with ZohoPeople 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 ZohoPeople data, no replication required.
-
Automate Insightly Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Insightly data from PowerShell? This article demonstrates how to utilize the Insightly Cmdlets for tasks like connecting to Insightly data, automating operations, downloading data, and more.
-
Natively Connect to Bitbucket Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Bitbucket data. Leverage the native support for ODBC in PHP.
-
Query Live Lakebase 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 Lakebase data directly from the development environment.
-
Connect and Visualize Live Amazon S3 Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Amazon S3 data into the Databricks platform and create visualization dashboards with real-time Amazon S3 data.