CData Software - Knowledge Base

Recent Articles

---

• «
• 1197
• 1198
• 1199
• 1200
• 1201
• 1202
• 1203
• 1204
• 1205
• 1206
• »

• Excel Spreadsheet Automation on Coinbase Data with the QUERY Formula

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

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

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

• Access FormSite Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access FormSite from your Oracle system.

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

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

• Integrating Claude Code with Asana Data via CData Connect AI

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

• Work with Live Google Calendar Data in Power Query

  Use CData Connect AI to connect to Google Calendar and work with live Google Calendar in Microsoft Power Query.

• How to connect and process Drip from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Drip.

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

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

• Automated Continuous Zoho Inventory Replication to Vertica

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

• Excel Spreadsheet Automation on ConvertKit Data with the QUERY Formula

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

• Import and Visualize SpaceX Data in Power View

  Create data visualizations based on SpaceX in Excel.

• Bridge Pingdom Connectivity with Apache NiFi

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

• How to Visualize ServiceDesk Plus Data in Python with pandas

  Use pandas and other modules to analyze and visualize live ServiceDesk Plus in Python.

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

  Create a simple Workflow for Apache Avro in Informatica PowerCenter.

• How to update Sage Intacct from Excel

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

• How to connect to REST Data in DBVisualizer

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

• Use the CData Software JDBC Driver for ADP in MicroStrategy

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

• Connect to PingOne Data in the Denodo Platform

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

• Create Zoom-Connected Visualizations in Klipfolio

  Use CData Connect AI to connect to Zoom Data from Klipfolio and build custom visualizations using live Zoom.

• How to create Coinbase federated tables in MySQL

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

• Create Reports with Calendly Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Calendly.

• Integrate Open WebUI with Live HBase Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Apache HBase from within the chat interface.

• Connect to Real-Time LinkedIn Ads Data in Power Apps Using Dataflows to Build Custom Applications

  Use CData Power BI Connector for LinkedIn Ads and Dataflow to import and use LinkedIn Ads in Power Apps.

• Working with CouchDB Data in LINQPad

  Execute LINQ queries to Apache CouchDB in LINQPad.

• Connect to Live NetSuite SuiteAnalytics Data in PostGresSQL Interface through CData Connect AI

  Create a live connection to NetSuite SuiteAnalytics in CData Connect AI and connect to your NetSuite SuiteAnalytics from PostgreSQL.

• Build Visualizations of Azure Table Data in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Azure Table Storage in Birst.

• Act-On Data Cloud Connectivity

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

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

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

• Automate FreshBooks Data Replication to Azure Data Lake

  Use CData Sync to customize and automate FreshBooks replication to Azure Data Lake.

• Connect to Live Oracle HCM Cloud Data in MicroStrategy through CData Connect AI

  Create a live connection to Oracle HCM Cloud Data in CData Connect AI and connect to your Oracle HCM Cloud from MicroStrategy.

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

  Create an ODBC connection to Aha! in Informatica and browse and transfer Aha!.

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

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

• Automate Microsoft Planner Data Replication to Azure Data Lake

  Use CData Sync to customize and automate Microsoft Planner replication to Azure Data Lake.

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

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

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

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

• Bridge Postmark Connectivity with Apache NiFi

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

• Connect to Google Campaign Manager 360 Data from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Google Campaign Manager 360 to connect to Google Campaign Manager 360 and execute queries in PowerBuilder.

• Edit and Search External Amazon Athena Objects in Salesforce Connect

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

• How to Easily Query JotForm Data in OpenOffice Base

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

• Integrate with SAP Ariba Procurement Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live SAP Ariba Procurement in SnapLogic.

• Automated Continuous GraphQL Replication to Google Cloud SQL

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

• Create Power BI Reports on Real-Time Printful Data

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

• Integrate Live Outreach.io Data in the Windsurf IDE via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Windsurf

• ETL Pipedrive in Oracle Data Integrator

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

• Feed ConvertAPI Data into FineReport

  How to set ConvertAPI as a JDBC data source in FineReport.

• Connect to xBase Data in DBeaver

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

• Query SAP SuccessFactors LMS Data in ColdFusion

  Write standard ColdFusion data access code to connect to SAP SuccessFactors LMS.

• Publish Sybase IQ-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Sybase IQ.

• Create OData-Connected Nintex Workflows

  Use CData Connect AI to connect to OData Services from Nintex Workflow Cloud and build custom workflows using live OData.

• Connect to SAP Fieldglass Data in CloverDX (formerly CloverETL)

  Transfer SAP Fieldglass using the visual workflow in the CloverDX data integration tool.

• Replicate Multiple Supabase Accounts

  Replicate multiple Supabase accounts to one or many databases.

• Visualize Live Sage 300 Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Sage 300.

• Use the CData Software JDBC Driver for Todoist in MicroStrategy Desktop

  Connect to Todoist in MicroStrategy Desktop using the CData Software JDBC Driver for Todoist.

• Connect to Hive Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to Asana Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Access Ontraport Data in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Ontraport.

• Object-Relational Mapping (ORM) with Avro Data Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Apache Avro into a Java-based ORM framework, Hibernate.

• How to integrate MailerSend with Apache Airflow

  Access and process MailerSend in Apache Airflow using the CData JDBC Driver.

• Connect to LightSpeedRetail Data from a Connection Pool in JBoss

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

• Import Real-Time Scrapfly Data via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Scrapfly in ColdFusion.

• Create Datasets from LeadDesk in Domo Workbench and Build Visualizations of LeadDesk Data in Domo

  Use the CData Software ODBC Driver for LeadDesk to create datasets from LeadDesk in Domo Workbench and then build visualizations in the Domo service.

• Automated Continuous Vertica Replication to SQL Server

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

• Connect to Instantly Data in JRuby

  Create a simple JRuby app with access to live Instantly.

• DataBind Charts to Salesforce Pardot Data

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

• How to load RSS data into Elasticsearch via Logstash

  Introducing a simple method to load RSS data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Publish SAP-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live SAP ERP/NetWeaver.

• Integrate Cursor with Live Excel Online Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Microsoft Excel Online from within the editor.

• How to Access AfterShip Data Using Entity Framework

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

• Access Live Avalara AvaTax Data in Excel (Desktop) via Connect AI

  Use CData Connect AI to gain access to live Avalara AvaTax from your Excel spreadsheets.

• Access Live Klaviyo Data in Coginiti Pro

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

• Use Microsoft Copilot Studio to talk to your Sage Intacct Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Sage Intacct for you.

• Publish Egnyte-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Egnyte.

• Integrating Codex CLI with Vercel 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 Claude to Talk to Your MongoDB Data via CData Connect AI

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

• Edit and Search External Dropbox Objects in Salesforce Connect

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

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

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

• Build an OLAP Cube in SSAS from ChargeOver Data

  Establish a connection to ChargeOver data from SQL Server Analysis Services, and use the ChargeOver Data Provider to build OLAP cubes for use in analytics and reporting.

• Build Microsoft OneDrive Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live Microsoft OneDrive and build visualizations in Tableau.

• Easily Integrate Oracle Sales Data in Lazarus Pascal IDE

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

• Build Google Cloud Storage-Connected ETL Processes in Google Data Fusion

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

• Connect to Codat Data as an External Source in Dremio

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

• Integrate Theia IDE with Live Salesforce Marketing Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Theia IDE

• DataBind Controls to ServiceNow Data in Delphi

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

• Connect to Teamwork Data from PowerBuilder via JDBC

  This article demonstrates how to access Teamwork from PowerBuilder using the Teamwork JDBC Driver.

• Access GitLab Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live GitLab from HeidiSQL.

• Stream Tickspot Data into Apache Kafka Topics

  Access and stream Tickspot in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Replicate Reply.io Data from PowerShell

  Write a quick PowerShell script to query Reply.io. Use connectivity to the live data to replicate Reply.io to SQL Server.

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

  Connect to Certinia from a connection pool in Tomcat.

• Automated Continuous Amplitude Replication to MongoDB

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

• How to Create Power BI Visual Reports with Real-Time Amazon S3 Data

  Use CData Power BI Connectors to visualize Amazon S3 in Power BI.

• How to integrate Jira Assets with Apache Airflow

  Access and process Jira Assets in Apache Airflow using the CData JDBC Driver.

• Integrate with live Zoho Inventory Data in Jitterbit

  Use CData Connect AI to connect to and integrate live Zoho Inventory in Jitterbit.

• Migrating data from SAP to Snowflake using CData SSIS Components.

  Easily push SAP ERP/NetWeaver to Snowflake using the CData SSIS Tasks for SAP and Snowflake.

• Connect to Sage Cloud Accounting Data in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Sage Cloud Accounting and the SQL Gateway to access Sage Business Cloud Accounting from Google Apps Script.

• Connect to Paylocity Data in DBeaver

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

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

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

• DataBind Controls to Salesforce CRM Analytics Data in Delphi

  DataBind to Salesforce CRM Analytics in Delphi with standard data access components and controls.

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

  Create a simple Workflow for BigCommerce in Informatica PowerCenter.

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

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Amplitude

  Provide connectivity to Amplitude through an SAP BusinessObjects universe.

• «
• 1197
• 1198
• 1199
• 1200
• 1201
• 1202
• 1203
• 1204
• 1205
• 1206
• »