CData Software - Knowledge Base
Recent Articles
-
Import Google Calendar Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Calendar Data and provide access to live Google Calendar for custom reports in the Power BI Service.
-
Automate Sybase Data Replication to Azure Synapse
Use CData Sync to customize and automate Sybase replication to Azure Synapse.
-
Create Data Visualizations in Cognos BI with Stripe Data
Access Stripe as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create a Data Access Object for Attio Data using JDBI
A brief overview of creating a SQL Object API for Attio in JDBI.
-
Connect to Demio from a Connection Pool in WebLogic
Use the CData JDBC Driver for Demio to connect to Demio from Web applications running on WebLogic.
-
How to Query Live GitHub Data in Perplexity MacOS Desktop
Connect to and query live GitHub Data in Perplexity Desktop using CData MCP Server.
-
How to Visualize LinkedIn Ads Data in Python with pandas
Use pandas and other modules to analyze and visualize live LinkedIn Ads in Python.
-
Connect to CampaignMonitor Data in DBArtisan
Use wizards in DBArtisan to configure CampaignMonitor as a data source.
-
Build an OLAP Cube in SSAS from Cassandra Data
Establish a connection to Apache Cassandra data from SQL Server Analysis Services, and use the Cassandra Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Splunk Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Splunk replication to Apache Cassandra.
-
Connect to Azure Data Lake Storage Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Azure Data Lake Storage to connect to Azure Data Lake Storage and execute queries in PowerBuilder.
-
Integrating LangChain with Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Azure Cosmos DB within automated workflows.
-
DataBind Controls to Mistral AI Data in C++Builder
DataBind to Mistral AI in C++Builder with standard components and controls.
-
Replicate Confluence Data from PowerShell
Write a quick PowerShell script to query Atlassian Confluence. Use connectivity to the live data to replicate Atlassian Confluence to SQL Server.
-
Use Manus AI to Talk to Your ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on ActiveCampaign.
-
Use the CData Software ODBC Driver for Avro in MicroStrategy
Connect to Apache Avro in MicroStrategy Developer using the CData Software ODBC Driver for Avro.
-
Bind Live NetSuite Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live NetSuite data
-
How to use SQLAlchemy ORM to access Adobe Analytics Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Adobe Analytics.
-
Connect to Azure Table Data in ACL Analytics
Connect to Azure Table Storage via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Azure Table Storage.
-
Integrating Antigravity CLI with Mode via CData CLI
Connect Mode to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
LINQ to SAP SuccessFactors 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 SAP SuccessFactors Data Provider.
-
How to Query Live WooCommerce Data in Perplexity MacOS Desktop
Connect to and query live WooCommerce Data in Perplexity Desktop using CData MCP Server.
-
Getting Started with the CData JDBC Driver for PolarTeamPro
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for PolarTeamPro.
-
How to connect to Auth0 Data with Squirrel SQL client
Connect to Auth0 and execute queries in the Squirrel SQL Client.
-
Explore Geographical Relationships in Square Data with Power Map
Create data visualizations with Square in Power Map.
-
Import Real-Time Qualaroo Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Qualaroo in ColdFusion.
-
Build Visualizations of SAS xpt Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAS XPORT in Birst.
-
LINQ to OpenWeatherMap 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 OpenWeatherMap Data Provider.
-
Connect to Hive Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Apache Hive.
-
Use the CData ODBC Driver for Templated in Microsoft Power Query
You can use the CData Templated ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Templated into Microsoft Power Query.
-
Publish Humanity-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Humanity.
-
Using the CData Software ODBC Driver for Reckon in PyCharm
Connect to Reckon as an ODBC data source in PyCharm using the CData Software ODBC Driver for Reckon.
-
Automated Oracle SCM Data Replication to Teradata
Use CData Sync to Customize and automate Oracle SCM replication to Teradata.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed HubSpot to Power BI dashboards. Simply drag and drop HubSpot into data visuals on the Power BI canvas.
-
Choosing the Best Method to Connect PagerDuty to SQL Server: 5 Options Explained
Discover multiple ways to connect and use PagerDuty from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
LINQ to Flowlu 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 Flowlu Data Provider.
-
Connect to and Visualize Live Eventbrite Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Eventbrite.
-
Access Live API 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 API through MCP integration.
-
Automated Clari Data Replication to Teradata
Use CData Sync to Customize and automate Clari replication to Teradata.
-
Viewing Adobe Experience Manager Data in RAD Studio Data Explorer
How to view Adobe Experience Manager in RAD Studio Data Explorer using the CData ODBC Driver for Adobe Experience Manager.
-
Analyze Pinterest Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Pinterest from Power Pivot. You will use the Table Import Wizard to load Pinterest. You can visually build the import query or use any SQL supported by the driver.
-
Analyze SAS Data Sets Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAS Data Sets with the CData JDBC Driver for SAS Data Sets.
-
How to create an RPA flow for Okta Data in UiPath Studio
Use the Okta ODBC Driver to create workflows that access real-time Okta without any coding.
-
Build Data Flows from SQL Server to Box through SSIS
Easily push SQL Server data to Box using the CData SSIS Tasks for Box.
-
Use the CData SSIS Components to Insert New or Update Existing XML Records from SQL Server
Easily push SQL Server data to XML using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into XML or update existing records with data from a SQL Server database.
-
How to update Cosmos DB from Excel
This article explains how to transfer data from Excel to Cosmos DB using the Excel Add-In for Cosmos DB.
-
Connecting Mastra with Airtable 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 Airtable, no replication required.
-
Automated Continuous ZohoSubscriptions Replication to Databricks
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Databricks.
-
Automated Continuous Snapchat Ads Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to AlloyDB.
-
Natively Connect to Discourse Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Discourse. Leverage the native support for ODBC in PHP.
-
Automated Continuous Zoho Books Replication to Databricks
Use CData Sync for automated, continuous, customizable Zoho Books replication to Databricks.
-
Integrating Vault CRM Data in Talend Cloud Data Management Platform
Connect Vault CRM Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Vault CRM.
-
Automated Continuous Microsoft Teams Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to delimited files (CSV/TSV).
-
Integrating GitHub Copilot CLI with Salesforce CRM Analytics 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.
-
Build Dashboards with Outreach.io Data in DBxtra
Create dynamic dashboards and perform analytics based on Outreach.io in DBxtra.
-
Import YouTube Analytics Data Using Azure Data Factory
Use CData Connect AI to connect to YouTube Analytics Data from Azure Data Factory and import live YouTube Analytics.
-
How to Easily Query Access Data in OpenOffice Base
Connect to Access data in OpenOffice Base using the CData ODBC Driver for Access and generate reports with live data insights.
-
Moving Data from Mouseflow to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Mouseflow data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Brex Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Brex facts in real time.
-
Use the CData Software ODBC Driver for Acumatica in MicroStrategy
Connect to Acumatica ERP in MicroStrategy Developer using the CData Software ODBC Driver for Acumatica.
-
Connect to Oracle Financials Cloud Data in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle Financials Cloud in FileMaker Pro to connect to Oracle Financials Cloud and work with Oracle Financials Cloud in your FileMaker applications.
-
Replicate Multiple Sage Intacct Accounts
Replicate multiple Sage Intacct accounts to one or many databases.
-
Consume Salesloft OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Salesloft feeds that reflect any changes in SAP Lumira.
-
How to Connect to & Open Notion Data in Microsoft Excel
This article uses the CData ODBC driver for Notion to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Analyze SAP Fieldglass Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Fieldglass in Microsoft R Open.
-
DataBind JobNimbus Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide JobNimbus to a chart.
-
Automated Continuous Drift Replication to MySQL
Use CData Sync for automated, continuous, customizable Drift replication to MySQL.
-
Integrating CouchDB Data in Talend Cloud Data Management Platform
Connect CouchDB Data with Talend Cloud Data Management Platform using the CData JDBC Driver for CouchDB.
-
Write a Simple Go Application to work with Reckon Accounts Hosted Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Reckon Accounts Hosted.
-
Write a Simple Go Application to work with Smartsheet Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Smartsheet.
-
Build a PostgreSQL Interface for Google Contacts Data using the CData JDBC Driver
Use the Remoting features of the Google Contacts JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Shopify Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Shopify in SnapLogic.
-
How to Connect to Scrapfly Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Scrapfly. Leverage the pyodbc module for ODBC in Python.
-
Integrating Cursor CLI with Brex 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.
-
Use Azure AI Foundry to Talk to Your Act CRM 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 Act CRM for you.
-
Natively Connect to Placid Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Placid. Leverage the native support for ODBC in PHP.
-
Publish Google Forms-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Forms.
-
Connect to LightSpeedRetail Data in DBeaver
Use the CData ODBC Driver to connect to LightSpeedRetail in DBeaver.
-
Integrate Cursor with Live Tally Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Tally ERP from within the editor.
-
How to Connect to Helpscout Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Helpscout. Leverage the pyodbc module for ODBC in Python.
-
Integrating Kiro CLI with ConvertKit 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.
-
Connect to ShipStation Data in Claris FileMaker Pro
Use the CData ODBC Driver for ShipStation in FileMaker Pro to connect to ShipStation and work with ShipStation in your FileMaker applications.
-
How to Visualize EnterpriseDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live EnterpriseDB in Python.
-
Natively Connect to Asana Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Asana. Leverage the native support for ODBC in PHP.
-
Create Salesforce Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Salesforce from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate ConvertKit with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ConvertKit with External Services.
-
Automated Continuous Databricks Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Databricks replication to Azure SQL Database.
-
Connect to Placid from a Connection Pool in WebLogic
Use the CData JDBC Driver for Placid to connect to Placid from Web applications running on WebLogic.
-
Automate Elasticsearch Data Replication to Couchbase
Use CData Sync to Customize and automate Elasticsearch replication to Couchbase.
-
Connect to ElevenLabs Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ElevenLabs.
-
Automated Continuous MySQL Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable MySQL replication to Azure SQL Database.
-
Bridge Suadeo Connectivity with Apache NiFi
Access and process Suadeo in Apache NiFi using the CData JDBC Driver.
-
Integrate Open WebUI with Live Office 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft Office 365 from within the chat interface.
-
Connect to Amazon Athena Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Amazon Athena and the Script function in FileMaker Pro to connect to Amazon Athena and work with Amazon Athena in your FileMaker application.
-
Work with Cohere Data in FoxPro
Load Cohere into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Unbounce Data in HULFT Integrate
Connect to Unbounce as a JDBC data source in HULFT Integrate
-
Query BambooHR Data in ColdFusion
Write standard ColdFusion data access code to connect to BambooHR.
-
Connect to Printify Data from a Connection Pool in JBoss
Integrate Printify into Java servlets: Use the Management Console in JBoss to install the Printify JDBC Driver.
-
Connect to Jodoo Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automate Google Campaign Manager 360 Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Google Campaign Manager 360 and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.