CData Software - Knowledge Base

Recent Articles

---

• «
• 1331
• 1332
• 1333
• 1334
• 1335
• 1336
• 1337
• 1338
• 1339
• 1340
• »

• Automated Continuous Wave Financial Replication to Google Cloud SQL

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

• How to create Visio diagrams from Reckon Data

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

• Integrating Kiro CLI with Insightly 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.

• Getting Started with the CData Power BI Connector for Dynamics NAV

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

• Query Excel Online Data in DataGrip

  Create a Data Source for Excel Online in DataGrip and use SQL to query live Microsoft Excel Online.

• Getting Started with the CData Connect AI Python SDK for Sage 200

  Install the CData Connect AI Python SDK to read and write live Sage 200 with standard DB-API 2.0 Python code.

• Integrating Claude Code with QuickBooks Online Data via CData Connect AI

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

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

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

• Publish Sybase IQ-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Sybase IQ.

• Integrating Claude Code CLI with ClickTime 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 Real-Time Hive Data in Power Apps Using Dataflows to Build Custom Applications

  Use CData Power BI Connector for Hive and Dataflow to import and use Apache Hive in Power Apps.

• Connect to Delighted Data in Aqua Data Studio

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

• Build Automated Workflows with Live ShipStation Data in Workato

  Use CData Connect AI to connect to live ShipStation and build automated workflows in Workato.

• View Reports on Real-Time Bannerbear Data in Power BI Report Server

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

• Excel Spreadsheet Automation on Azure Data Lake Storage Data with the QUERY Formula

  Pull data from Azure Data Lake Storage, automate spreadsheets, and more with the QUERY formula.

• Getting Started with the CData Tableau Connector for ShipEngine

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

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

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

  Connect live Sage 200 to Blue Prism using the CData ODBC Driver for Sage 200 to create automated workflows for repetitive business tasks.

• Automate CData Connect AI Data Replication to Azure Synapse

  Use CData Sync to customize and automate CData Connect AI replication to Azure Synapse.

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

• Extract, Transform, and Load Azure Synapse Data in Informatica PowerCenter

  Create a simple Workflow for Azure Synapse in Informatica PowerCenter.

• How to Work with Guru Data in ETL Validator JDBC

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

• Use the CData SSIS Components to Insert New or Update Existing ADP Records from SQL Server

  Easily push SQL Server data to ADP using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into ADP or update existing records with data from a SQL Server database.

• Natively Connect to Pushbullet Data in PHP

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

• How to connect and process Suadeo from Azure Databricks

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

• Build Apps with Live Kintone in Adalo using CData Connect AI

  Use CData Connect AI to integrate live Kintone into the Adalo platform and build custom mobile and web applications with real-time Kintone.

• How to Access Live Elasticsearch Data in Visual Studio Code via Cline

  Run CData MCP Server for Elasticsearch on Windows Subsytem for Linux (WSL) and connect to live Elasticsearch from the Cline extension in Visual Studio Code.

• Using the CData Software ODBC Driver for Office 365 in PyCharm

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

• Query, Visualize, and Share live DB2 Data in Redash

  Use CData Connect AI to connect to live IBM DB2 in Redash for querying, visualizing, and sharing.

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

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

• Integrating Antigravity CLI with Microsoft Dynamics 365 via CData CLI

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

• Visualize Live SAP HANA XS Advanced Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live SAP HANA XS Advanced.

• Visualize Live Oracle SCM Data in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live Oracle SCM into custom reports in Power BI.

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

• Connect to and Query ZohoInvoice Data in QlikView over ODBC

  Create data visualizations with ZohoInvoice in QlikView.

• How to Connect Flowise AI Agents to Live Google Calendar Data via CData Connect AI

  Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Google Calendar without replication.

• Build Presto-Powered Applications in Gemini Code Assist with CData MCP Server

  Use the CData MCP Server for Presto to explore live Presto Data in Gemini Code Assist to assist with building Presto-powered applications.

• Publish MailChimp-Connected Dashboards in Tableau Server

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

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

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

• Automated Continuous ClickUp Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable ClickUp replication to delimited files (CSV/TSV).

• Connect to Zoom Data in Google Apps Script via Connect AI

  Use CData Connect AI to access Zoom in Google Apps Script.

• Connect to Paddle Data in Claris FileMaker Pro

  Use the CData API Driver for ODBC in FileMaker Pro to connect to Paddle and work with Paddle in your FileMaker applications.

• Create Oracle HCM Cloud-Connected Visualizations in Klipfolio

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

• Connect to Samanage Data in JRuby

  Create a simple JRuby app with access to live Samanage.

• A PostgreSQL Interface for SAP BusinessObjects BI Data (MySQL Remoting via JDBC)

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

• Automated Azure DevOps Data Replication to Teradata

  Use CData Sync to Customize and automate Azure DevOps replication to Teradata.

• Create a Data Access Object for Zoom Data using JDBI

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

• DataBind Toggl Data to the DevExpress Data Grid

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

• Analyze Cassandra Data in Cognos Analytics

  Use CData Connect AI to connect to Cassandra Data from Cognos Analytics and analyze live Apache Cassandra.

• How to work with Google Directory Data in Apache Spark using SQL

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

• Connect to XML Data from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time XML Files using standard SQL.

• Create Trello-Connected Dashboards in Grafana

  Connect to Trello Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Trello.

• Automated Continuous Pinterest Replication to SingleStore

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

• Process & Analyze Pushbullet Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Pushbullet Data.

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

  Use CData Connect AI to integrate live Microsoft Dataverse (CDS) into the Databricks platform and create visualization dashboards with real-time Microsoft Dataverse (CDS).

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

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

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

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

• Exa Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Exa facts in real time.

• Query Kintone Data through ODBC in Node.js

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

• Integrating Pipeliner CRM Data in Talend Cloud Data Management Platform

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

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

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

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

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

• Visualize Live Dynamics 365 Data of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Microsoft Dynamics 365 using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Automated Continuous Mailjet Replication to MySQL

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

• Create Power BI Reports on Real-Time Freshdesk Data

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

• DataBind Shortcut Data to the DevExpress Data Grid

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

• Automated Continuous Databricks Replication to AlloyDB

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

• Connect to Guru Data in Jaspersoft Studio

  Execute SQL to remote Guru in Jaspersoft Studio.

• Integrating Codex CLI with CapsuleCRM 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.

• Automated Continuous Azure Data Catalog Replication to SQLite

  Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to SQLite.

• Import Real-Time LDAP Objects via JDBC in ColdFusion to Build Applications

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

• Integrating Instantly Data in Talend Cloud Data Management Platform

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

• How to Work with Salesforce Data 360 Data in AWS Glue Jobs Using JDBC

  Connect to Salesforce Data 360 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Create Datadog Dataflows on PowerBI.com

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

• Connect to Supabase Data Using the Script Function in Claris FileMaker Pro

  Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Supabase and work with Supabase in your FileMaker application.

• Integrate Sugar CRM with External Services using SnapLogic

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

• Integrate with Adobe Analytics Data using Apache Camel2

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

• Write a Simple Go Application to work with Gmail Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Gmail.

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

• Access Live Billsby Data in SAS JMP via ODBC

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

• Excel Spreadsheet Automation on PingOne Data with the QUERY Formula

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

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

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

• Import DB2 Data into the Power BI Service for Visualizations

  Use CData Connect AI to connect to DB2 Data and provide access to live IBM DB2 for custom reports in the Power BI Service.

• Connect to Jira Assets Data as a SQL Server Linked Server

  Use CData Connect AI to create a linked server for live Jira Assets.

• Access Oracle Financials Cloud Data from MySQL in PHP

  Connect to Oracle Financials Cloud through the standard MySQL libraries in PHP.

• Bidirectional Access to REST Data from FileMaker Pro

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

• Access Live Oracle Eloqua Data in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Oracle Eloqua from your Excel spreadsheets.

• Natively Connect to PDFMonkey Data in PHP

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

• Connect to LinkedIn Ads Data in CloverDX (formerly CloverETL)

  Transfer LinkedIn Ads using the visual workflow in the CloverDX data integration tool.

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

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

• Connect to Sentry Data in DBArtisan

  Use wizards in DBArtisan to configure Sentry as a data source.

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

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

• Access Live SFTP Data in AWS Lambda

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Webflow

  Provide connectivity to Webflow through an SAP BusinessObjects universe.

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

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

• Use the CData Software ODBC Driver for Mocean in MicroStrategy Web

  Connect to Mocean in MicroStrategy Web using the CData Software ODBC Driver for Mocean.

• Edit and Search SAS Data Sets External Objects in Salesforce Connect (API Server)

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

• Access Brex Data from MySQL in HeidiSQL

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

• How to Query Live Klaviyo Data in Claude Desktop

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

• View Reports on Real-Time Samanage Data in Power BI Report Server

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

• «
• 1331
• 1332
• 1333
• 1334
• 1335
• 1336
• 1337
• 1338
• 1339
• 1340
• »