CData Software - Knowledge Base
Recent Articles
-
Build SQL Analysis Services-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SQL Analysis Services data and build web apps with connectivity to live SQL Analysis Services data.
-
Access Marketo Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Marketo data from your Oracle system.
-
Migrating data from AgileCRM to Google BigQuery using CData SSIS Components.
Easily push AgileCRM data to Google BigQuery using the CData SSIS Tasks for AgileCRM and Google BigQuery.
-
How to Connect to Live SAP Netweaver Gateway Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP Netweaver Gateway data securely in real time.
-
Seamlessly Bring FHIR Data into Retool Using CData Connect AI
Integrate FHIR data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating DocuSign Data in Talend Cloud Data Management Platform
Connect DocuSign Data with Talend Cloud Data Management Platform using the CData JDBC Driver for DocuSign.
-
Automated Continuous Amplitude Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Amplitude replication to Azure SQL Database.
-
Query Coinbase Data as a MySQL Database in Node.js
Execute MySQL queries against Coinbase data from Node.js.
-
Create Informatica Mappings From/To an ODBC Data Source for Factorial
Create an ODBC connection to Factorial in Informatica and browse and transfer Factorial data.
-
Establish a Live Connection with Highrise Data using Tableau Bridge
The CData ODBC Driver for Highrise enables you to integrate live Highrise data into Tableau Cloud dashboards using the Tableau Bridge.
-
Manage Presto Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Presto.
-
Query Presto Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Presto entities in PHP by modeling them as objects.
-
Connect to Typeform Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Typeform data in Airbyte.
-
Connect to Salesloft Data in ACL Analytics
Connect to Salesloft data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Salesloft data.
-
Build Apps with Live Pipeliner CRM Data Using the Low-Code Development Platform of Mendix
Connect Pipeliner CRM data with Mendix to build apps using the CData API Driver for JDBC.
-
Back Up Omnisend data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Omnisend data data.
-
How to Connect to & Open Nuclia Data in Microsoft Excel
This article uses the CData ODBC driver for Nuclia to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Edit and Search External Presto Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Presto data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Presto Data objects that you can access from apps and the dashboard.
-
Connecting GenSpark with Kafka Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Kafka data without any replication or custom integration required.
-
Getting Started with the CData ODBC Driver for Access
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Access.
-
Connect to Microsoft Ads Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Microsoft Ads Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Bitbucket Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Bitbucket data from Informatica Cloud.
-
Choosing the Best Method to Connect Sage 200 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sage 200 data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Scrapfly Data from MySQL in Amazon QuickSight
Connect to Scrapfly and build visualizations of Scrapfly data using a MySQL Connection in Amazon QuickSight.
-
How to Query Live SQL Server Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SQL Server data data in natural language using Python.
-
Use the CData Software JDBC Driver for Databricks in MicroStrategy Web
Connect to Databricks data in MicroStrategy Web using the CData Software JDBC Driver for Databricks.
-
Connect to and Query MariaDB Data in QlikView over ODBC
Create data visualizations with MariaDB data in QlikView.
-
Rapidly Develop LeadDesk-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by LeadDesk.
-
Integrate RabbitMQ Data in Pentaho Data Integration
Build ETL pipelines based on RabbitMQ data in the Pentaho Data Integration tool.
-
Getting Started with the CData JDBC Driver for Moosend
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Moosend.
-
Automated Continuous Vault CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Vault CRM replication to delimited files (CSV/TSV).
-
Create Guru Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Guru data access from reports, embedded analytics, and more.
-
Connect to REST Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for REST data.
-
Bridge Square Connectivity with Apache NiFi
Access and process Square data in Apache NiFi using the CData JDBC Driver.
-
Connect Omnisend to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Omnisend data using the CData Python MCP Server.
-
Integrating Cursor with Short.io 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 Work with Exact Online Data in AWS Glue Jobs Using JDBC
Connect to Exact Online from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Close
Provide connectivity to Close data through an SAP BusinessObjects universe.
-
DataBind Controls to Marketo Data in Delphi
DataBind to Marketo data in Delphi with standard data access components and controls.
-
Create Informatica Mappings From/To an ODBC Data Source for SFTP
Create an ODBC connection to SFTP in Informatica and browse and transfer SFTP data.
-
Integrating Wrike Data in Talend Cloud Data Management Platform
Connect Wrike Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to and Visualize Live Google Ad Manager Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Ad Manager data.
-
Integrate Live Samanage Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Samanage data from within the IDE.
-
Build Apps with Live Cosmos DB data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Cosmos DB data into the Adalo platform and build custom mobile and web applications with real-time Cosmos DB data.
-
Integrate Google's Vertex AI Agent with Live Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Spark data within intelligent workflows.
-
Create Dynamic Azure Data Catalog Grids Using the Infragistics XamDataGrid
Learn how you can connect Azure Data Catalog to Infragistics XamDataGrid to build dynamic grids.
-
Access Cassandra Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Cassandra data from your Oracle system.
-
How to connect Amazon QuickSight to Presto Data
Create a connection to Presto data in CData Connect AI and insert Presto data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Shortcut Data from HeidiSQL
Use CData Connect AI to connect to and query live Shortcut data from HeidiSQL.
-
Use Azure AI Foundry to Talk to Your Workday 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 Workday data for you.
-
Use the CData Software ODBC Driver for Box in MicroStrategy
Connect to Box data in MicroStrategy Developer using the CData Software ODBC Driver for Box.
-
Query Pinterest Data as a MySQL Database in Node.js
Execute MySQL queries against Pinterest data from Node.js.
-
Connect to Facebook Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Facebook.
-
Build Data Flows from HubDB to SQL Server using SSIS
Easily back up HubDB data to SQL Server using the SSIS components for HubDB.
-
Integrating Claude Code with Workday Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Workday data within assisted coding and automated development workflows.
-
Integrating GitHub Copilot with Typeform 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.
-
Getting Started with the CData Tableau Connector for Mixpanel
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Trigger Zoho Projects IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Zoho Projects with standard wizards in Logic Apps.
-
Automated Continuous Miro Replication to SingleStore
Use CData Sync for automated, continuous, customizable Miro replication to SingleStore.
-
Trigger Jira Assets IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Jira Assets with standard wizards in Logic Apps.
-
Integrate with LinkedIn Ads Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy LinkedIn Ads data to a JSON file on disk.
-
Connect to Confluence Data from a Connection Pool in JBoss
Integrate Confluence data into Java servlets: Use the Management Console in JBoss to install the Confluence JDBC Driver.
-
Create Shortcut-Connected Dashboards in Grafana
Connect to Shortcut Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Shortcut data.
-
Automated Mailjet Data Replication to Teradata
Use CData Sync to Customize and automate Mailjet data replication to Teradata.
-
How to Connect Flowise AI Agents to Live Amazon DynamoDB 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 Amazon DynamoDB data without replication.
-
Connect to CircleCI Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for CircleCI and the SQL Gateway to access CircleCI data from Google Apps Script.
-
Stream Sentry Data into Apache Kafka Topics
Access and stream Sentry data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect Amazon QuickSight to HubSpot Data
Create a connection to HubSpot data in CData Connect AI and insert HubSpot data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to use SQLAlchemy ORM to access Apify Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Apify data.
-
Integrate Wrike with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Wrike with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Wrike data.
-
Replicate Multiple Dynamics 365 Accounts
Replicate multiple Dynamics 365 accounts to one or many databases.
-
Working with Apollo Data in LINQPad
Execute LINQ queries to Apollo data in LINQPad.
-
Use the CData Software JDBC Driver for Epicor Kinetic in MicroStrategy
Connect to Epicor Kinetic data in MicroStrategy Developer using the CData Software JDBC Driver for Epicor Kinetic.
-
Automated Continuous Parquet Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Parquet replication to delimited files (CSV/TSV).
-
Publish Crystal Reports on Workday Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Workday data.
-
Integrate OpenCode with Live Reckon Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Reckon data from within your AI coding agent.
-
Build Agents in Relevance AI with Access to Live RSS Feeds via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on RSS feeds within intelligent agent workflows.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Cloudant
Provide connectivity to Cloudant data through an SAP BusinessObjects universe.
-
Build LinkedIn-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to LinkedIn data and build web apps with connectivity to live LinkedIn data.
-
Create CapsuleCRM Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time CapsuleCRM data access from reports, embedded analytics, and more.
-
Access Live Pinterest Data in AWS Lambda
Connect to live Pinterest data in AWS Lambda using the CData JDBC Driver.
-
How to create Visio diagrams from Databricks Data
Automatically update Databricks data with the changes you make to Visio master shapes.
-
Visualize Figshare Data in Tableau
The CData ODBC driver for Figshare enables you integrate Figshare data into Tableau dashboards.
-
How to integrate Metabase with PolarTeamPro Data
Use CData Connect AI to connect to live PolarTeamPro data and create an interactive dashboard in Metabase from PolarTeamPro data.
-
Build Neo4J-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Neo4J Data and create custom apps in Mendix.
-
Analyze Live Samanage Data in SAS Viya
Use CData Connect AI to connect to Samanage data from SAS Viya and deploy self-service analytics using live Samanage data.
-
Write a Simple Go Application to work with SAP SuccessFactors LMS Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP SuccessFactors LMS data.
-
Automate Teamwork Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Teamwork data from PowerShell? This article demonstrates how to utilize the Teamwork Cmdlets for tasks like connecting to Teamwork data, automating operations, downloading data, and more.
-
Use CData Connect AI to Access Zuora Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Zuora data in the Power Pivot business intelligence tool.
-
Integrate Devin with Live BambooHR Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live BambooHR data.
-
How to Connect to Live Oracle Sales Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Oracle Sales data for you.
-
Connect to and Query Pipeline CRM Data in QlikView over ODBC
Create data visualizations with Pipeline CRM data in QlikView.
-
Use the CData Software ODBC Driver for Notion in SAS for Real-Time Reporting and Analytics
Connect to real-time Notion data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Notion.
-
Create Dashboards and Visualize Live Zuora Data in Geckoboard
Use CData Connect AI to connect to live Zuora data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connecting Mastra with Kafka 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 Kafka data, no replication required.
-
Connect to and Query Tickspot Data in QlikView over ODBC
Create data visualizations with Tickspot data in QlikView.
-
Replicate Nuclia Data to Multiple Databases
Replicate Nuclia data to disparate databases with a point-and-click configuration.
-
Query Pipeliner CRM Data in ColdFusion
Write standard ColdFusion data access code to connect to Pipeliner CRM data.
-
Create OData-Connected Dashboards in Grafana
Connect to OData Services via CData Connect AI in Grafana and create custom business dashboards with real-time access to OData services.
-
Create Avalara AvaTax Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Avalara AvaTax from PowerBI.com to create Power BI Dataflows with real-time data.