CData Software - Knowledge Base
Recent Articles
-
Build Microsoft Entra ID-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Entra ID data.
-
Replicate Multiple Shippo Accounts
Replicate multiple Shippo accounts to one or many databases.
-
Create SAP Netweaver Gateway-Connected Nintex Workflows
Use CData Connect AI to connect to SAP Netweaver Gateway Data from Nintex Workflow Cloud and build custom workflows using live SAP Netweaver Gateway data.
-
Interact with Live API Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live API data.
-
A PostgreSQL Interface for Gmail Data using the CData ODBC Driver
Use the SQL Gateway and Gmail ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use Dash to Build to Web Apps on eBay Data
Create Python applications that use pandas and Dash to build eBay-connected web apps.
-
Connect to ShipEngine Data in ACL Analytics
Connect to ShipEngine data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to ShipEngine data.
-
Automated Continuous iContact Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable iContact replication to Azure SQL Database.
-
Connect to JSON Services as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live JSON services.
-
Integrating Boomi Agentstudio with Google Spanner Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Spanner data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Easily Query Dynamics CRM Data in OpenOffice Base
Connect to Dynamics CRM data in OpenOffice Base using the CData ODBC Driver for Dynamics CRM and generate reports with live data insights.
-
Build Presto Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Presto data and build visualizations in Tableau.
-
Integrating Cursor with Azure Analysis Services 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.
-
Integrating Kiro with Cassandra 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 Connect to Live AfterShip Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your AfterShip data for you.
-
LINQ to Tally 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 Tally Data Provider.
-
Replicate Multiple Amazon DynamoDB Accounts via the CData Sync CLI
Replicate multiple Amazon DynamoDB accounts to one or many databases.
-
Create Google Spanner Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Spanner from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to integrate Metabase with Sybase Data
Use CData Connect AI to connect to live Sybase data and create an interactive dashboard in Metabase from Sybase data.
-
Access Auth0 Data from MySQL in Amazon QuickSight
Connect to Auth0 and build visualizations of Auth0 data using a MySQL Connection in Amazon QuickSight.
-
Use the CData ODBC Driver for JobNimbus from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for JobNimbus to connect to JobNimbus data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring JobNimbus data in Excel.
-
Connect to Azure DevOps Data from Crystal Reports
Use CData Connect AI to connect to and report on live Azure DevOps data from Crystal Reports.
-
Load FTP Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load FTP data to a database.
-
Connect to Microsoft Entra ID Data in Google Apps Script via Connect AI
Use CData Connect AI to access Microsoft Entra ID data in Google Apps Script.
-
Create Shortcut-Connected Nintex Workflows
Use CData Connect AI to connect to Shortcut Data from Nintex Workflow Cloud and build custom workflows using live Shortcut data.
-
Automated Continuous SharePoint Excel Services Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Google Cloud SQL.
-
Publish YouTube Analytics-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live YouTube Analytics data.
-
Create Power BI Reports on Real-Time Smartsheet Data
Use the CData ODBC Driver for Smartsheet to visualize Smartsheet data in Power BI Desktop.
-
Integrate HBase Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live HBase data from Informatica Cloud.
-
Import and Visualize Egnyte Data in Power View
Create data visualizations based on Egnyte data in Excel.
-
Use the CData Software ODBC Driver for EmailOctopus in MicroStrategy Desktop
Connect to EmailOctopus data in MicroStrategy Desktop using the CData Software ODBC Driver for EmailOctopus.
-
Integrating Cursor with REST 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 connect PolyBase to MariaDB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live MariaDB data.
-
Visualize FormSite Data in TIBCO Spotfire through ADO.NET
Integrate FormSite data into dashboards in TIBCO Spotfire.
-
Model, Search, and Visualize Live Oracle HCM Cloud Data in ThoughtSpot
Use CData Connect AI to connect to live Oracle HCM Cloud data for modeling, searching, and visualizing.
-
DataBind Charts to Dynamics NAV Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Dynamics NAV data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Connect to WooCommerce Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live WooCommerce data.
-
How to Seamlessly Import Exa Data into IBM SPSS Modeler
Integrate Exa data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connecting Agentforce with ZohoDesk Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your ZohoDesk data for you.
-
Create GetResponse-Connected Dashboards in Grafana
Connect to GetResponse Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to GetResponse data.
-
Connect to Live Bullhorn CRM Data in MicroStrategy through CData Connect AI
Create a live connection to Bullhorn CRM Data in CData Connect AI and connect to your Bullhorn CRM data from MicroStrategy.
-
Build Apps with Live Exa data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Exa data into the Adalo platform and build custom mobile and web applications with real-time Exa data.
-
Process & Analyze Azure Synapse Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Azure Synapse Data.
-
Analyze MongoDB Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze MongoDB data in Microsoft R Open.
-
Query Okta Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Okta entities in PHP by modeling them as objects.
-
Create SSAS Tabular Models from Webflow Data
How to build a SQL Server Analysis Service Tabular Model from Webflow data using CData drivers.
-
Getting Started with the CData Power BI Connector for Placid
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build Data Flows from LaunchDarkly to SQL Server using SSIS
Easily back up LaunchDarkly data to SQL Server using the SSIS components for LaunchDarkly.
-
Connect to Eventbrite Data in HULFT Integrate
Connect to Eventbrite as a JDBC data source in HULFT Integrate
-
Integrate with live Cosmos DB Data in Jitterbit
Use CData Connect AI to connect to and integrate live Cosmos DB data in Jitterbit.
-
Connecting Mastra with ServiceNow 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 ServiceNow data, no replication required.
-
Automated Continuous Asana Replication to MySQL
Use CData Sync for automated, continuous, customizable Asana replication to MySQL.
-
Provide OData Services of Oracle SCM Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Oracle SCM data by developing a WCF Service Application.
-
Replicate Multiple Workable Accounts via the CData Sync CLI
Replicate multiple Workable accounts to one or many databases.
-
Integrate Open WebUI with Live YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live YouTube Analytics data from within the chat interface.
-
Query Live SAP Ariba Source 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 SAP Ariba Source data directly from the development environment.
-
Integrate Goose with Live NetSuite SuiteAnalytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live NetSuite SuiteAnalytics data from within the local AI agent.
-
Access Live Salesforce Marketing Data in Coginiti Pro
Connect to and query live Salesforce Marketing data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Stream Gong Data into Apache Kafka Topics
Access and stream Gong data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Avro Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Avro to connect to Avro data and execute queries in PowerBuilder.
-
Connect to Customer.io Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Customer.io.
-
Visualize Live Sage 200 Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Sage 200 data into custom reports in Power BI.
-
Create Reports with Gong Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Gong data.
-
How to Connect DBeaver to Elasticsearch via a JDBC Driver
Manage Elasticsearch data with visual tools in DBeaver like the query browser.
-
Choosing the Best Method to Connect Dynamics CRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Dynamics CRM data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use JayDeBeApi to access MailChimp Data in Python
Use standard Python scripting and the development environment of your choice to access live MailChimp data.
-
Automated Continuous Retently Replication to MongoDB
Use CData Sync for automated, continuous, customizable Retently replication to MongoDB.
-
Analyze Quickbase Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Quickbase data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate with live FHIR Data in Jitterbit
Use CData Connect AI to connect to and integrate live FHIR data in Jitterbit.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MailerSend
Provide connectivity to MailerSend data through an SAP BusinessObjects universe.
-
Use the CData Software ODBC Driver for FreshBooks in MicroStrategy Web
Connect to FreshBooks data in MicroStrategy Web using the CData Software ODBC Driver for FreshBooks.
-
Connect and Visualize Live Odoo Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Odoo data into the Databricks platform and create visualization dashboards with real-time Odoo data.
-
Automated Continuous Printful Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Printful replication to PostgreSQL.
-
Build Phoenix-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Phoenix data and build web apps with connectivity to live Phoenix data.
-
Automated Continuous Sage Intacct Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Google Cloud SQL.
-
Connect to Couchbase Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Couchbase data.
-
Connect to Pipeliner CRM Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Pipeliner CRM to connect to Pipeliner CRM data and execute queries in PowerBuilder.
-
Connect to HubDB Data in ACL Analytics
Connect to HubDB data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to HubDB data.
-
Getting Started with the CData Connect AI Python SDK for Adobe Target
Install the CData Connect AI Python SDK to read live Adobe Target data with standard DB-API 2.0 Python code.
-
Natively Connect to Sage 200 Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Sage 200 data. Leverage the native support for ODBC in PHP.
-
Integrating GitHub Copilot with Redis 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 Mixpanel Data in JReport Designer
Create charts and reports based on Mixpanel data in JReport Designer.
-
Bidirectional Access to Presto Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Presto data in Filemaker Pro for Mac or Windows.
-
Integrate Cline with Live Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Oracle SCM data from within your IDE.
-
Build Automated Xero-Connected Workflows in Zapier
Use CData Connect AI to connect to live Xero data and build automated workflows in Zapier.
-
Connect to PDFMonkey from Asprova with CData Software ODBC Driver for PDFMonkey
This article shows how to connect faster to PDFMonkey data from Asprova.
-
Analyze Everhour Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Everhour data with the CData JDBC Driver for Everhour.
-
Visualize Raisers Edge NXT Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Raisers Edge NXT data.
-
Getting Started with the CData Power BI Connector for WooCommerce
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for WooCommerce.
-
Connect to Tickspot Data in JRuby
Create a simple JRuby app with access to live Tickspot data.
-
How to connect Amazon QuickSight to Azure DevOps Data
Create a connection to Azure DevOps data in CData Connect AI and insert Azure DevOps data into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Exact Online Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Exact Online data access from reports, embedded analytics, and more.
-
Connect to CockroachDB Data in Aqua Data Studio
Access CockroachDB data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Live ShipEngine Data in PostGresSQL Interface through CData Connect AI
Create a live connection to ShipEngine in CData Connect AI and connect to your ShipEngine data from PostgreSQL.
-
Integrating Freshteam Data in Talend Cloud Data Management Platform
Connect Freshteam Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Publish Crystal Reports on Oracle HCM Cloud Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Oracle HCM Cloud data.
-
How to create an RPA flow for Humanity Data in UiPath Studio
Use the Humanity ODBC Driver to create workflows that access real-time Humanity data without any coding.
-
Integrating Claude Code with PingOne Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on PingOne data within assisted coding and automated development workflows.
-
How to Seamlessly Import Teradata Data into IBM SPSS Modeler
Integrate Teradata data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Amazon S3 Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Amazon S3 data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.