CData Software - Knowledge Base

Recent Articles

---

• «
• 1026
• 1027
• 1028
• 1029
• 1030
• 1031
• 1032
• 1033
• 1034
• 1035
• »

• Automated Continuous Act CRM Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Act CRM replication to Google Cloud SQL.

• Connect to Instagram Data in RapidMiner

  Integrate Instagram with standard components and data source configuration wizards in RapidMiner Studio.

• Use the CData ODBC Driver for Google Sheets in Microsoft Power Query

  You can use the CData Google Sheets ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Sheets into Microsoft Power Query.

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

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

• Integrating Cursor CLI with MongoDB 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 the CData API Server to Access SQL Analysis Services Data in Microsoft PowerPivot

  Use the CData API Server to connect to live SQL Analysis Services in the Power Pivot business intelligence tool.

• Build a Simple VCL Application for Raisers Edge NXT Data

  How to build a simple VCL Application to view Raisers Edge NXT in RAD Studio using the CData ODBC Driver for Raisers Edge NXT.

• Connect to Elasticsearch Data from a Connection Pool in Jetty

  The Elasticsearch JDBC Driver supports connection pooling: This article shows how to connect faster to Elasticsearch from Web apps in Jetty.

• Analyze Email Data with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Email from Power Pivot. You will use the Table Import Wizard to load Email. You can visually build the import query or use any SQL supported by the driver.

• Load Oracle Data to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Oracle Database to a database.

• Query ServiceDesk Plus Data in DataGrip

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

• Natively Connect to Azure Table Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Azure Table Storage. Leverage the native support for ODBC in PHP.

• Create Notion Dataflows on PowerBI.com

  Connect to the CData Power BI Connector for Notion from PowerBI.com to create Power BI Dataflows with real-time data.

• Bidirectional Access to Contentful Data from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Contentful in Filemaker Pro for Mac or Windows.

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

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

• Edit and Search External Oracle SCM Objects in Salesforce Connect

  Use CData Connect AI to securely provide OData feeds of Oracle SCM to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Oracle SCM Data objects that you can access from apps and the dashboard.

• Integrating LlamaIndex with Microsoft Ads Data via CData Connect AI

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

• LINQ to SAP Ariba Source 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 Ariba Source Data Provider.

• Validate Bright Data Data with QuerySurge

  Access and validate Bright Data in QuerySurge using the CData JDBC Driver.

• How to Query Live Splunk Data in Claude Desktop

  Connect to and query live Splunk Data in Claude Desktop using CData MCP Server.

• Query MySQL Data using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume MySQL entities in PHP by modeling them as objects.

• Connect to JobNimbus Data as an External Source in Dremio

  Use the CData JDBC Driver to connect to JobNimbus as an External Source in Dremio.

• How to create Procore federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Procore in MySQL .

• Automated Continuous Excel Online Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Excel Online replication to Snowflake.

• Connect to Demio Data in Aqua Data Studio

  Access Demio from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Create Dynamic Paddle Grids Using the Infragistics XamDataGrid

  Learn how you can connect Paddle to Infragistics XamDataGrid to build dynamic grids.

• Replicate Salesforce CRM Analytics Data in Heroku for Use in Salesforce Connect

  Replicate Salesforce CRM Analytics to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Access Live Google Ad Manager Data in Roo Code via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Google Ad Manager through MCP integration.

• View Reports on Real-Time Authorize.Net Data in Power BI Report Server

  Use the CData ODBC Driver for Authorize.Net to visualize Authorize.Net in Power BI Desktop and then publish them to Power BI Report Server.

• Integrating Claude Code with Phoenix Data via CData Connect AI

  Leverage CData Connect AI to enable Claude Code to securely access and act on Apache Phoenix within assisted coding and automated development workflows.

• How to connect to Freshsales Data with Squirrel SQL client

  Connect to Freshsales and execute queries in the Squirrel SQL Client.

• Connect to Greenplum Data in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Greenplum and the SQL Gateway to access Pivotal GreenPlum from Google Apps Script.

• How to Easily Query Neo4J Data in OpenOffice Base

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

• Build SAP Concur-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP Concur.

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

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

• Connect to Live Zoho Inventory Data in PostGresSQL Interface through CData Connect AI

  Create a live connection to Zoho Inventory in CData Connect AI and connect to your Zoho Inventory from PostgreSQL.

• Analyze AlloyDB Data in Infragistics Reveal

  Use CData Connect AI to create on OData API on top of Google AlloyDB and visualize live Google AlloyDB in Infragistics Reveal.

• How to update Blackbaud FE NXT from Excel

  This article explains how to transfer data from Excel to Blackbaud FE NXT using the Excel Add-In for Blackbaud FE NXT.

• Automated Continuous Ontraport Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Ontraport replication to Azure SQL Database.

• How to Connect to Live SAP Ariba Source Data in Mistral AI Workflows

  Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SAP Ariba Source without replication.

• Connect to Dropbox in SpagoBI

  Create reports featuring live Dropbox in SpagoBI Studio. Host Dropbox reports on SpagoBI Server.

• How to Connect to Live Monday.com 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 Monday.com for you.

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

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

• Integrate Goose with Live Act CRM Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Act CRM from within the local AI agent.

• Create SSAS Tabular Models from Microsoft OneDrive Data

  How to build a SQL Server Analysis Service Tabular Model from Microsoft OneDrive using CData drivers.

• Build Data Flows from Google Sheets to SQL Server using SSIS

  Easily back up Google Sheets to SQL Server using the SSIS components for Google Sheets.

• Use Grok to Talk to Your SingleStore Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SingleStore for you.

• Create Informatica Mappings From/To a JDBC Data Source for HubDB

  Create HubDB data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Create Informatica Mappings From/To an ODBC Data Source for Brex

  Create an ODBC connection to Brex in Informatica and browse and transfer Brex.

• Visualize SingleStore Data in TIBCO Spotfire through ADO.NET

  Integrate SingleStore into dashboards in TIBCO Spotfire.

• How to connect to Harvest Data in DBVisualizer

  Integrate Harvest with visual data analysis tools and data connection wizards in DBVisualizer

• Configure the CData JDBC Driver for Templated in a Connection Pool in Tomcat

  Connect to Templated from a connection pool in Tomcat.

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

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

• Build Semantic Layer Views for Front Data in APOS Live Data Gateway

  Use the CData Connector for Front in APOS Live Data Gateway to build Semantic Layer Views for Front.

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

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

• Design BIRT Reports on ClickTime Data

  Provide current ClickTime to your embedded analytics.

• A PostgreSQL Interface for Customer.io Data (MySQL Remoting via JDBC)

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

• Getting Started with the CData Python Connector for Freshteam

  Learn to install and license the CData Python Connector

• Automated Klaviyo Data Replication to Teradata

  Use CData Sync to Customize and automate Klaviyo replication to Teradata.

• Access Live LinkedIn Ads Data in AWS Lambda (with IntelliJ IDEA)

  Connect to live LinkedIn Ads in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Connect to ScrapingBee Data in DBeaver

  Use the CData ODBC Driver to connect to ScrapingBee in DBeaver.

• Integrate Salesloft Data in Pentaho Data Integration

  Build ETL pipelines based on Salesloft in the Pentaho Data Integration tool.

• Automated Continuous Apify Replication to SQLite

  Use CData Sync for automated, continuous, customizable Apify replication to SQLite.

• DataBind Controls to Intercom Data in Delphi

  DataBind to Intercom in Delphi with standard data access components and controls.

• Automated Continuous Quickbase Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Quickbase replication to SingleStore.

• Access Live Facebook Ads Data in Coginiti Pro

  Connect to and query live Facebook Ads from the GUI in the Coginiti Pro: SQL Analytics Tool.

• How to Query Live SuiteCRM Data in Claude Desktop

  Connect to and query live SuiteCRM Data in Claude Desktop using CData MCP Server.

• Build AlloyDB-Connected Web Apps with Axios and CData Connect AI

  Use CData Connect AI to connect to live Google AlloyDB and build AlloyDB-connected web apps with Axios.

• Build a Singer.io Tap for Oracle Eloqua Reporting With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Oracle Eloqua Reporting data using

• Automated Continuous Notion Replication to MySQL

  Use CData Sync for automated, continuous, customizable Notion replication to MySQL.

• Build Semantic Layer Views for Azure Synapse Data in APOS Live Data Gateway

  Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Azure Synapse.

• How to Connect the Power BI Service to Jira Assets: Complete Guide

  Connect to the CData Software Power BI Connector for Jira Assets from PowerBI.com to provide real-time Jira Assets across the organization.

• Replicate ZohoDesk Data to Multiple Databases via the CData Sync CLI

  Replicate ZohoDesk to disparate databases with a single configuration.

• Natively Connect to Parquet Data in PHP

  The CData ODBC driver for Parquet enables you to create PHP applications with connectivity to Apache Parquet. Leverage the native support for ODBC in PHP.

• Use the CData ODBC Driver for Jira in Microsoft Power Query

  You can use the CData Jira ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Atlassian Jira into Microsoft Power Query.

• Connect Salesforce Pardot to AI Assistants With the CData Python MCP Server

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

• LINQ to Oracle Eloqua Reporting 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 Oracle Eloqua Reporting Data Provider.

• Use JayDeBeApi to access Azure DevOps Data in Python

  Use standard Python scripting and the development environment of your choice to access live Azure DevOps.

• Connect to Bullhorn CRM Data in Aqua Data Studio

  Access Bullhorn CRM from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Build Greenplum-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Pivotal GreenPlum and build web apps with connectivity to live Pivotal GreenPlum.

• Access Live Azure Table Data in Coginiti Pro

  Connect to and query live Azure Table Storage from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Automated Continuous Sugar CRM Replication to Oracle

  Use CData Sync for automated, continuous, customizable Sugar CRM replication to Oracle.

• How to use SQLAlchemy ORM to access Customer.io Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Customer.io.

• Bridge Moosend Connectivity with Apache NiFi

  Access and process Moosend in Apache NiFi using the CData JDBC Driver.

• How to integrate Metabase with ADP Data

  Use CData Connect AI to connect to live ADP and create an interactive dashboard in Metabase from ADP.

• Enable the Wave Financial JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Wave Financial.

• Use the CData ODBC Driver for Bugsnag in Microsoft Power Query

  You can use the CData Bugsnag ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Bugsnag into Microsoft Power Query.

• Import Instagram Data Using Azure Data Factory

  Use CData Connect AI to connect to Instagram Data from Azure Data Factory and import live Instagram.

• Use Manus AI to Talk to Your QuickBooks Time 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 QuickBooks Time.

• Analyze Sage Cloud Accounting Data in Infragistics Reveal

  Use CData Connect AI to create on OData API on top of Sage Business Cloud Accounting and visualize live Sage Business Cloud Accounting in Infragistics Reveal.

• How to Query Live Adobe Analytics Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Adobe Analytics data in natural language using Python.

• Automated Continuous SharePoint Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable SharePoint replication to Google BigQuery.

• DataBind Charts to WordPress Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to WordPress 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.

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

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

• Automated Continuous Recurly Replication to Oracle

  Use CData Sync for automated, continuous, customizable Recurly replication to Oracle.

• Perform Batch Operations with Hive Data in Apache NiFi

  Connect to Apache Hive and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Connect Mixpanel to IBM WebSphere Using the CData JDBC Driver

  Use the CData JDBC Driver to connect Mixpanel with IBM WebSphere for seamless data integration and connectivity.

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

  Build workflows to access live Discord for self-service data analytics.

• Publish Cassandra-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Apache Cassandra.

• Replicate Multiple Elorus Accounts via the CData Sync CLI

  Replicate multiple Elorus accounts to one or many databases.

• «
• 1026
• 1027
• 1028
• 1029
• 1030
• 1031
• 1032
• 1033
• 1034
• 1035
• »