CData Software - Knowledge Base

Recent Articles

---

• «
• 1073
• 1074
• 1075
• 1076
• 1077
• 1078
• 1079
• 1080
• 1081
• 1082
• »

• Analyze OpenWeatherMap Data with Power Pivot

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

• Access Live Adobe Commerce Data in AWS Lambda

  Connect to live Adobe Commerce data in AWS Lambda using the CData JDBC Driver.

• Bidirectional Access to CockroachDB Data from FileMaker Pro

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

• Explore Geographical Relationships in Workable Data with Power Map

  Create data visualizations with Workable data in Power Map.

• Integrate Google's Antigravity Agent with Live Vault CRM Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Vault CRM data using the Model Context Protocol.

• Connect to Pushbullet Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Pushbullet.

• Query Simplesat Data through ODBC in Node.js

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

• Integrate with Freshdesk Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live Freshdesk data in SnapLogic.

• Connect to Tickspot Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Tickspot data in the Denodo Virtual DataPort Administrator.

• Access Live ZohoExpense Data in Excel 365 Online (Excel for the web)

  Connect to ZohoExpense data from Excel 365 Online (Excel for the web) with CData Connect AI.

• A PostgreSQL Interface for Adobe Target Data (MySQL Remoting via JDBC)

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

• Integrate with Raisers Edge NXT Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live Raisers Edge NXT data in SnapLogic.

• Visualize Live Google Cloud Storage Data in the Power BI Service

  Use CData Connect AI to connect to live Google Cloud Storage data and create custom reports in the Power BI Service through the On-Premises Gateway.

• Connect to CloudConvert Data from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for CloudConvert to connect to CloudConvert data and execute queries in PowerBuilder.

• Connect to SharePoint Excel Services Data in NetBeans

  Connect to SharePoint Excel Services data in NetBeans with the data source configuration wizard.

• Getting Started with the CData Python Connector for Recurly

  Learn to install and license the CData Python Connector and configure a connection to live Recurly data.

• Connect to Paymo Data in Jaspersoft Studio

  Execute SQL to remote Paymo data in Jaspersoft Studio.

• Integrate Trae with Live Snowflake Data via CData Connect AI

  Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Snowflake data from within the AI-powered IDE.

• Replicate Kintone Data in Heroku for Use in Salesforce Connect

  Replicate Kintone data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Analyze Live Zoho Inventory Data in SAS Viya

  Use CData Connect AI to connect to Zoho Inventory data from SAS Viya and deploy self-service analytics using live Zoho Inventory data.

• Automated Continuous EmailOctopus Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable EmailOctopus replication to AlloyDB.

• Automated Continuous Typeform Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Typeform replication to Apache Cassandra.

• Connect to PostgreSQL Data from PowerBuilder via ADO.NET

  This article demonstrates how to access PostgreSQL data from Appeon PowerBuilder using the CData ADO.NET Provider for PostgreSQL.

• How to import RabbitMQ Data into Apache Solr

  Use the CData Software JDBC Driver for RabbitMQ in Data Import Handler and create an automated import of RabbitMQ data to Apache Solr Enterprise Search platform.

• How to connect to Email Data from Spring Boot

  Connect to Email in a Spring Boot Application using the CData JDBC Driver for Email

• Create IBM Cloud Object Storage Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time IBM Cloud Object Storage data access from reports, embedded analytics, and more.

• Connect to Amplitude Data in RapidMiner

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

• Enable the Postmark JDBC Driver in KNIME

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

• Integrating Gumloop with ZohoPeople Data via CData Connect AI

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

• Build Couchbase-Connected ETL Processes in Google Data Fusion

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

• Search External Power BI XMLA Objects in Salesforce Connect

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

• Automated Continuous SendGrid Replication to Vertica

  Use CData Sync for automated, continuous, customizable SendGrid replication to Vertica.

• How to import Gmail Data into Apache Solr

  Use the CData Software JDBC Driver for Gmail in Data Import Handler and create an automated import of Gmail data to Apache Solr Enterprise Search platform.

• Extract, Transform, and Load Miro Data in Informatica PowerCenter

  Create a simple Workflow for Miro data in Informatica PowerCenter.

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

  Use the ODBC Driver for CockroachDB and the SQL Gateway to access CockroachDB data from Google Apps Script.

• Manage EnterpriseDB Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for EnterpriseDB.

• Connect and Visualize Live Bullhorn CRM Data in Databricks Lakehouse Federation with CData Connect AI

  Use CData Connect AI to integrate live Bullhorn CRM data into the Databricks platform and create visualization dashboards with real-time Bullhorn CRM data.

• How to integrate Metabase with Pipedrive Data

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

• Use the CData ODBC Driver for Apify from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Apify to connect to Apify data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apify data in Excel.

• Build MVC Applications with Connectivity to Cloudant Data

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Cloudant from an ASP.NET MVC application.

• Access Live Wistia Data in AWS Lambda

  Connect to live Wistia data in AWS Lambda using the CData JDBC Driver.

• Query Twitter Ads Data as a SQL Server Database in Node.js

  Execute SQL Server queries against Twitter Ads data from Node.js.

• Excel Spreadsheet Automation on Microsoft OneDrive Data with the QUERY Formula

  Pull data from Microsoft OneDrive, automate spreadsheets, and more with the QUERY formula.

• Working with CockroachDB Data in LINQPad

  Execute LINQ queries to CockroachDB data in LINQPad.

• Build CSV-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live CSV data.

• Automated Continuous CircleCI Replication to Databricks

  Use CData Sync for automated, continuous, customizable CircleCI replication to Databricks.

• Use Dash to Build to Web Apps on ServiceNow Data

  Create Python applications that use pandas and Dash to build ServiceNow-connected web apps.

• Create Power BI Reports on Real-Time Outlook Data

  Use the CData ODBC Driver for Outlook to visualize Outlook data in Power BI Desktop.

• How to import SQL Server Data into Apache Solr

  Use the CData Software JDBC Driver for SQL Server in Data Import Handler and create an automated import of SQL Server data to Apache Solr Enterprise Search platform.

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

• Automated Continuous NetSuite Replication to Google BigQuery

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

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

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

• Connect ZohoInvoice to IBM WebSphere Using the CData JDBC Driver

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

• Automated Continuous Instantly Replication to SQLite

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

• Connecting Pipedream with Greenplum Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Greenplum data in real time.

• Integrate with Airtable Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live Airtable data in SnapLogic.

• How to update Xero from Excel

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

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

  Use the ODBC Driver for Paylocity and the SQL Gateway to access Paylocity data from Google Apps Script.

• Use Biml to Build SSIS Tasks to Replicate Sage 200 Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Sage 200 data to SQL Server.

• Use Biml to Build SSIS Tasks to Replicate IBM Cloud Object Storage Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate IBM Cloud Object Storage data to SQL Server.

• Access Live Freshteam Data in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Freshteam data into the statistical analysis tools available in SAS JMP. This article shows how to use Freshteam data in the Graph Builder and Query Builder.

• How to connect SharePoint with Zoho CRM Data through external lists

  Provide Zoho CRM data to SharePoint users as an external list.

• Prepare, Blend, and Analyze ZohoPeople Data in Alteryx Designer (Connect AI)

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

• How to Build an ETL App for ServiceDesk Plus Data in Python with CData

  Create ETL applications and real-time data pipelines for ServiceDesk Plus data in Python with petl.

• Connect to PayPal Data in DBeaver

  Use the CData ODBC Driver to connect to PayPal data in DBeaver.

• Use Dash to Build Web Apps on Oracle SCM Data via CData Connect AI

  Build interactive Dash web apps on live Oracle SCM data using pandas and the CData Connect AI Python SDK.

• ETL SAP in Oracle Data Integrator

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

• Migrating data from LeadDesk to Google BigQuery using CData SSIS Components.

  Easily push LeadDesk data to Google BigQuery using the CData SSIS Tasks for LeadDesk and Google BigQuery.

• How to integrate Microsoft OneDrive with Apache Airflow

  Access and process Microsoft OneDrive data in Apache Airflow using the CData JDBC Driver.

• Build SingleStore Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live SingleStore data and build visualizations in Tableau Cloud.

• How to create Zoho Recruit federated tables in MySQL

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

• Automated Continuous Salesloft Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Salesloft replication to Amazon Redshift.

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

• Integrating OpenCode with SAP HANA XS Advanced 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 Access AgileCRM Data Using Entity Framework

  This article shows how to access AgileCRM data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

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

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

• Integrating Claude Code with Greenhouse Data via CData Connect AI

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

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

  Create PHP applications on Linux/UNIX machines with connectivity to Hive data. Leverage the native support for ODBC in PHP.

• Integrate Live Perigon Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Perigon data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.

• Integrate Power BI XMLA Data into Power Automate Desktop using CData Connect

  CData Connect for Power BI XMLA Data enables you to integrate Power BI XMLA data into workflows built using Microsoft Power Automate Desktop.

• Automated Continuous Recurly Replication to MongoDB

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

• Use CData Connect AI to Access Azure DevOps Data in Microsoft Power Pivot

  Use CData Connect AI to connect to live Azure DevOps data in the Power Pivot business intelligence tool.

• DataBind Charts to Adobe Experience Manager Data

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

• Migrating data from Harvest to Databricks using CData SSIS Components.

  Easily push Harvest data to Databricks using the CData SSIS Tasks for Harvest and Databricks.

• Analyze Mailjet Data in Cognos Analytics

  Use CData Connect AI to connect to Mailjet Data from Cognos Analytics and analyze live Mailjet data.

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

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

• Integrate with ZohoSubscriptions Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live ZohoSubscriptions data in SnapLogic.

• How to Connect Discord Data to Gemini Enterprise via CData Connect AI

  Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Discord data in real time using natural language.

• How to update Basecamp from Excel

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

• DataBind Telegram Data to the DevExpress Data Grid

  Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Telegram data to a chart.

• Automated Continuous ServiceNow Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable ServiceNow replication to Apache Kafka.

• How to Connect the Power BI Service to Printify: Complete Guide

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

• Visualize Vault 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 Vault CRM data into TIBCO Spotfire.

• Viewing Google Spanner Data in RAD Studio Data Explorer

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

• Analyze GitLab Data in R via JDBC

  Use standard R functions and the development environment of your choice to analyze GitLab data with the CData JDBC Driver for GitLab.

• Integrate Accelo with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Accelo with External Services.

• A PostgreSQL Interface for MessageBird Data (MySQL Remoting via JDBC)

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

• Query Sentry Data through ODBC in Node.js

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

• How to Easily Query Lakebase Data in OpenOffice Base

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

• Manage Exa Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Exa.

• «
• 1073
• 1074
• 1075
• 1076
• 1077
• 1078
• 1079
• 1080
• 1081
• 1082
• »