CData Software - Knowledge Base

Recent Articles

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• »

• Back Up Outlook 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 Outlook data.

• Automate Teamgate Data Replication to Azure Synapse

  Use CData Sync to customize and automate Teamgate replication to Azure Synapse.

• How to Connect to Live Oracle Data in n8n Workflows and Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Oracle Database for you.

• Connect to Eventbrite Data from a Connection Pool in JBoss

  Integrate Eventbrite into Java servlets: Use the Management Console in JBoss to install the Eventbrite JDBC Driver.

• Analyze Zoho Creator Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Zoho Creator and visualize live Zoho Creator in Infragistics Reveal.

• Automate Google Ad Manager Data Replication to Couchbase

  Use CData Sync to Customize and automate Google Ad Manager replication to Couchbase.

• Analyze Act CRM Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Act CRM and visualize live Act CRM in Infragistics Reveal.

• Build Apps with Live Vercel Data Using the Low-Code Development Platform of Mendix

  Connect Vercel with Mendix to build apps using the CData API Driver for JDBC.

• Connect to Microsoft Entra ID Data from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Microsoft Entra ID to connect to Microsoft Entra ID and execute queries in PowerBuilder.

• Query Aweber Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against Aweber from Node.js.

• Use the CData Software ODBC Driver for ConvertAPI in SAS for Real-Time Reporting and Analytics

  Connect to real-time ConvertAPI in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ConvertAPI.

• Design BIRT Reports on SingleStore Data

  Provide current SingleStore to your embedded analytics.

• Use the CData Software ODBC Driver for PostgreSQL in SAS for Real-Time Reporting and Analytics

  Connect to real-time PostgreSQL in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for PostgreSQL.

• Create a Data Access Object for Google Contacts Data using JDBI

  A brief overview of creating a SQL Object API for Google Contacts in JDBI.

• DataBind Reckon Accounts Hosted Data to the DevExpress Data Grid

  Use the CData ADO.NET Provider for Reckon Accounts Hosted with the DevExpress Windows Forms and Web controls to provide Reckon Accounts Hosted to a chart.

• Choosing the Best Method to Connect Salesforce Marketing to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Salesforce Marketing Cloud from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• How to Visualize QuickBooks Online 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 QuickBooks Online in Python.

• Access Zoho Creator Data from MySQL in Amazon QuickSight

  Connect to Zoho Creator and build visualizations of Zoho Creator using a MySQL Connection in Amazon QuickSight.

• How to Access Live ZohoMarketingHub Data in Power Automate Desktop via ODBC

  The CData ODBC Driver for ZohoMarketingHub enables you to integrate ZohoMarketingHub into workflows built using Microsoft Power Automate Desktop.

• Create a Data Access Object for HubSpot Data using JDBI

  A brief overview of creating a SQL Object API for HubSpot in JDBI.

• How to Work with Discord Data in ETL Validator JDBC

  Connect to Discord from ETL Validator jobs using the CData Software JDBC Driver.

• Connect to Elasticsearch Data in Ruby

  Connect to Elasticsearch in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Integrate with Chargebee Data in JReport Designer

  Create charts and reports based on Chargebee in JReport Designer.

• Using the CData Software ODBC Driver for Notion in PyCharm

  Connect to Notion as an ODBC data source in PyCharm using the CData Software ODBC Driver for Notion.

• Getting Started with the CData Excel Add-In for Superchat

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Superchat.

• Getting Started with the CData Excel Add-In for ConvertKit

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ConvertKit.

• Build Automated Azure DevOps-Connected Workflows in Zapier

  Use CData Connect AI to connect to live Azure DevOps and build automated workflows in Zapier.

• Automated Continuous CockroachDB Replication to SQL Server

  Use CData Sync for automated, continuous, customizable CockroachDB replication to SQL Server.

• How to Use a Microsoft Access Database to Update ActiveCampaign Data in Real Time

  Update ActiveCampaign data by creating a linked table in Microsoft Access with the CData ActiveCampaign ODBC Driver.

• Visualize Act CRM Data in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Act CRM into TIBCO Spotfire.

• Automated Continuous SAP Ariba Procurement Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to IBM DB2.

• Build Dashboards with SAP HANA Data in DBxtra

  Create dynamic dashboards and perform analytics based on SAP HANA in DBxtra.

• Visualize OpenWeatherMap Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to OpenWeatherMap.

• How to Connect to & Open ConstantContact Data in Microsoft Excel

  This article uses the CData ODBC driver for ConstantContact to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• How to Connect to Impala Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Apache Impala. Leverage the pyodbc module for ODBC in Python.

• Create Power BI Reports on Real-Time Wave Financial Data

  Use the CData ODBC Driver for Wave Financial to visualize Wave Financial in Power BI Desktop.

• Connect to YouTube Analytics Data in ACL Analytics

  Connect to YouTube Analytics via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to YouTube Analytics.

• Automated Continuous Oracle Service Cloud Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Amazon S3.

• Use the CData Software JDBC Driver for Egnyte in MicroStrategy

  Connect to Egnyte in MicroStrategy Developer using the CData Software JDBC Driver for Egnyte.

• How to connect and process JDBC-ODBC Bridge from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live JDBC-ODBC Bridge.

• How to work with Kafka Data in Apache Spark using SQL

  Access and process Kafka Data in Apache Spark using the CData Software JDBC Driver.

• Easily Integrate Dynamics 365 Data in Lazarus Pascal IDE

  Learn how to easily integrate live Microsoft Dynamics 365 in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Query Google Drive Data as a MySQL Database in Node.js

  Execute MySQL queries against Google Drive from Node.js.

• Integrating LlamaIndex with Amazon Athena Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Amazon Athena in real time.

• Create a Data Access Object for Presto Data using JDBI

  A brief overview of creating a SQL Object API for Presto in JDBI.

• How to Easily Query Splunk Data in OpenOffice Base

  Connect to Splunk data in OpenOffice Base using the CData ODBC Driver for Splunk and generate reports with live data insights.

• Using the CData Software ODBC Driver for Spark in PyCharm

  Connect to Spark as an ODBC data source in PyCharm using the CData Software ODBC Driver for Spark.

• How to create an RPA flow for ActiveCampaign Data in UiPath Studio

  Use the ActiveCampaign ODBC Driver to create workflows that access real-time ActiveCampaign without any coding.

• Automated Continuous Cvent Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Cvent replication to Amazon S3.

• How to Import Data from Microsoft Entra ID into Google Sheets

  Import Microsoft Entra ID into a Google spreadsheet that is automatically refreshed.

• Build Jira Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live Atlassian Jira and build visualizations in Tableau.

• Connect Attio to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Attio using the CData Python MCP Server.

• Getting Started with the CData Tableau Connector for Intercom

  Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.

• Moving Data from Productboard to SQL Server Using Toad Data Point and CData ODBC Driver

  Query, export, and automate live Productboard data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.

• Minimum Requirements for CData API Server

  This page lists the minimum system requirements for using CData API Server.

• Deploy the ADO.NET Provider for Hugging Face on an SSRS Report Server

  Connect to Hugging Face 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 Sugar CRM Data through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with Sugar CRM Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Build Pipelines with Live YouTube Analytics Data in Google Cloud Data Fusion (via CData Connect AI)

  Use CData Connect AI to connect to YouTube Analytics from Google Cloud Data Fusion, enabling the integration of live YouTube Analytics into the building and management of effective data pipelines.

• How to Connect to Live Highrise Data from Claude Agent SDK (via CData Connect AI)

  Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Highrise CRM for you.

• Build Data Flows from Dynamics CRM to SQL Server using SSIS

  Easily back up Microsoft Dynamics CRM to SQL Server using the SSIS components for Dynamics CRM.

• Build AI/ML Models with Live Perigon Data using Dataiku

  Connect Perigon Data with Dataiku using the CData API Driver for JDBC.

• Query Live SAP HANA 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 HANA directly from the development environment.

• Getting Started with the CData Power BI Connector for Azure Synapse

  Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Azure Synapse.

• Build a Singer.io Tap for Toggl With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Toggl data using

• Build Data Flows from SQL Server to Redis through SSIS

  Easily push SQL Server data to Redis using the CData SSIS Tasks for Redis.

• Build Cloudant Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live IBM Cloudant and build visualizations in Tableau Cloud.

• How to create Visio diagrams from ADP Data

  Automatically update ADP with the changes you make to Visio master shapes.

• Build a PostgreSQL Interface for Apollo Data using the CData JDBC Driver

  Use the Remoting features of the Apollo JDBC Driver to create a PostgreSQL entry-point for data access.

• Build Pipelines with Live Snapchat Ads Data in Google Cloud Data Fusion (via CData Connect AI)

  Use CData Connect AI to connect to Snapchat Ads from Google Cloud Data Fusion, enabling the integration of live Snapchat Ads into the building and management of effective data pipelines.

• Replicate Multiple Snapchat Ads Accounts via the CData Sync CLI

  Replicate multiple Snapchat Ads accounts to one or many databases.

• Use the CData Software JDBC Driver for Gong in MicroStrategy

  Connect to Gong in MicroStrategy Developer using the CData Software JDBC Driver for Gong.

• Deploy the ADO.NET Provider for Short.io on an SSRS Report Server

  Connect to Short.io 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.

• How to Connect to Live Microsoft Teams Data from OpenAI Python Applications (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Microsoft Teams through natural language.

• Integrating OpenCode Terminal with Everhour 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 Import Data from Azure Analysis Services into Google Sheets

  Import Azure Analysis Services into a Google spreadsheet that is automatically refreshed.

• LINQ to Guru 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 Guru Data Provider.

• Create Data Visualizations Based On Impala Data in Mode

  Use CData Connect AI to connect to Impala Data from Mode and build visualizations using live

• Connect to and Visualize Live Reckon Accounts Hosted Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Reckon Accounts Hosted.

• How to Connect to CockroachDB Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to CockroachDB. Leverage the pyodbc module for ODBC in Python.

• Integrating Antigravity CLI with Beeminder via CData CLI

  Connect Beeminder to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.

• How to use SQLAlchemy ORM to access Twitter Ads Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Twitter Ads.

• How to Use a Microsoft Access Database to Update WordPress Data in Real Time

  Update WordPress data by creating a linked table in Microsoft Access with the CData WordPress ODBC Driver.

• Connect to Testmonitor Data in Jaspersoft Studio

  Execute SQL to remote Testmonitor in Jaspersoft Studio.

• Integrate with SharePoint Excel Services Data using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SharePoint Excel Services to a JSON file on disk.

• Viewing Google Calendar Data in RAD Studio Data Explorer

  How to view Google Calendar in RAD Studio Data Explorer using the CData ODBC Driver for Google Calendar.

• Connect to QuickBooks Online Data in DBArtisan

  Use wizards in DBArtisan to configure QuickBooks Online as a data source.

• Create a Data Access Object for FreeAgent Data using JDBI

  A brief overview of creating a SQL Object API for FreeAgent in JDBI.

• How to Build an ETL App for Cosmos DB Data in Python with CData Connect AI

  Build ETL pipelines that read and write live Azure Cosmos DB in Python with petl and the CData Connect AI Python SDK.

• Integrating Cursor CLI with Stack Exchange 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.

• Rapidly Develop HBase-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 HBase.

• Replicate Google Sheets Data to Multiple Databases

  Replicate Google Sheets to disparate databases with a point-and-click configuration.

• Build SharePoint-Connected Apps in Mendix

  Use CData Connect AI to create an OData feed for SharePoint Data and create custom apps in Mendix.

• Integrating Gumloop with OneNote Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft OneNote within automated workflows.

• Integrating Antigravity CLI with Outlook via CData CLI

  Connect Outlook to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.

• Apollo Data Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Apollo through CData Connect AI using different applications and tools.

• Query Smartsheet Data in DataGrip

  Create a Data Source for Smartsheet in DataGrip and use SQL to query live Smartsheet.

• Prepare, Blend, and Analyze Azure Table Data in Alteryx Designer (ODBC)

  Build workflows to access live Azure Table Storage for self-service data analytics.

• Getting Started with the CData ODBC Driver for Google Search

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Search.

• ETL MailChimp in Oracle Data Integrator

  This article shows how to transfer MailChimp into a data warehouse using Oracle Data Integrator.

• Integrating PabblySubscriptions Data in Talend Cloud Data Management Platform

  Connect PabblySubscriptions Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• »