CData Software - Knowledge Base

Recent Articles

---

• «
• 163
• 164
• 165
• 166
• 167
• 168
• 169
• 170
• 171
• 172
• »

• How to Connect to Live Asana Data from Sourcegraph Amp (via CData Connect AI)

  Integrate Sourcegraph Amp with CData Connect AI to query and manage live Asana securely in real time.

• AlloyDB Reporting and Star Schemas in OBIEE

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

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

  Create a simple Workflow for Front in Informatica PowerCenter.

• Build Data Flows from Copper to SQL Server using SSIS

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

• Natively Connect to Sentry Data in PHP

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

• Getting Started with the CData Power BI Connector for Oracle

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

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

• Import Real-Time Exact Online Data via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Exact Online in ColdFusion.

• Access Live Vault CRM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Veeva Vault & Vault CRM from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Build QuickBooks Time-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to QuickBooks Time and build web apps with connectivity to live QuickBooks Time.

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

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

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

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

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

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

• A PostgreSQL Interface for Sage Intacct Data using the CData ODBC Driver

  Use the SQL Gateway and Sage Intacct ODBC Driver to create a PostgreSQL entry-point for data access.

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

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

• Connect to Odoo Data from HeidiSQL

  Use CData Connect AI to connect to and query live Odoo ERP from HeidiSQL.

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

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

• Integrating GitHub Copilot CLI with Elasticsearch 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.

• Access Live BenchmarkEmail Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live BenchmarkEmail data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Automated Continuous Elasticsearch Replication to Databricks

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

• Automated Continuous Sage 200 Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Sage 200 replication to PostgreSQL.

• Use the CData ODBC Driver for IBM Informix from SharePoint Excel Services

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

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

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

• Automated Continuous Elorus Replication to SQLite

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

• Build MVC Applications with Connectivity to SuiteCRM Data

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

• Connect to Stack Exchange Data from Blazor Apps

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

• How to update Jira Assets from Excel

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

• Automated Continuous Salesforce Marketing Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Snowflake.

• Explore Geographical Relationships in Paymo Data with Power Map

  Create data visualizations with Paymo in Power Map.

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

  Use CData Connect AI to connect to live Gong in the Power Pivot business intelligence tool.

• Manage Avro Data in DBArtisan as a JDBC Source

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

• Work with Live HCL Domino Data in Power Query

  Use CData Connect AI to connect to HCL Domino and work with live HCL Domino in Microsoft Power Query.

• Visualize Excel Data in TIBCO Spotfire through OData

  Integrate Microsoft Excel into dashboards in TIBCO Spotfire.

• DataBind Controls to Amazon Marketplace Data in C++Builder

  DataBind to Amazon Marketplace in C++Builder with standard components and controls.

• Working with Stripe Data in LINQPad

  Execute LINQ queries to Stripe in LINQPad.

• Connect to Kintone Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to ConstantContact Data in DBArtisan

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

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

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

• How to Import Data from MailerLite into Google Sheets

  Import MailerLite into a Google spreadsheet that is automatically refreshed.

• Automated Continuous IBM Informix Replication to Databricks

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

• Connect to ZohoDesk Data in NetBeans

  Connect to ZohoDesk in NetBeans with the data source configuration wizard.

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

  Provide connectivity to Xero Accounting through an SAP BusinessObjects universe.

• Access Live Sage Cloud Accounting Data in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Sage Business Cloud Accounting from your Google Sheets.

• Integrate AlloyDB Data into Automated Tasks with Power Automate

  Use CData Connect AI to connect to Google AlloyDB and integrate live Google AlloyDB into your Power Automate tasks.

• Connect to and Visualize Live Toggl Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Toggl.

• Automated Continuous XML Replication to Azure SQL Database

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

• Connect to MySQL through SSH Using the Built-In Client

  A detailed overview of the SQL Gateway, its function, and its features.

• Import Reckon Accounts Hosted Data into the Power BI Service for Visualizations

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

• Operational Reporting on Twilio Data from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Twilio.

• Visualize BigCommerce Data in Sisense

  Create an ElastiCube in Sisense app with access to BigCommerce.

• Integrate Cursor with Live Trello Data via CData Connect AI

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

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

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

• Create Data Visualizations in Cognos BI with Shortcut Data

  Access Shortcut as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• How to connect to Apify Data from Spring Boot

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

• Getting Started with the CData SSIS Components for Supabase

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for Supabase.

• Use the CData API Server to Access Square Data in Microsoft PowerPivot

  Use the CData API Server to connect to live Square in the Power Pivot business intelligence tool.

• Integrate Live JSON Services into Blue Prism for Intelligent Robotic Process Automation (RPA)

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

• Edit and Search ActiveCampaign External Objects in Salesforce Connect (API Server)

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

• Model, Search, and Visualize Live Zoom Data in ThoughtSpot

  Use CData Connect AI to connect to live Zoom for modeling, searching, and visualizing.

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

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

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

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

• Query JSON Services in ColdFusion

  Write standard ColdFusion data access code to connect to JSON.

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

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

• Query Eventbrite Data through ODBC in Node.js

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

• Create Reports with Monday.com Data in SAP Crystal Reports

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

• Integrating Claude Code CLI with Sybase IQ 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.

• Access CampaignMonitor 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 CampaignMonitor.

• Establish a Live Connection with xBase Data using Tableau Bridge

  The CData ODBC Driver for xBase enables you to integrate live xBase into Tableau Cloud dashboards using the Tableau Bridge.

• Build SQL Server-Powered Applications in Cursor with CData MCP Server

  Use the CData MCP Server for SQL Server to explore live SQL Server Data in Cursor to assist with building SQL Server-powered applications.

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

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

• A PostgreSQL Interface for Amazon Athena Data using the CData ODBC Driver

  Use the SQL Gateway and Amazon Athena ODBC Driver to create a PostgreSQL entry-point for data access.

• How to create Visio diagrams from WooCommerce Data

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

• Automated Continuous GitLab Replication to Google BigQuery

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

• Build AI/ML Models with Live Amazon S3 Data using Dataiku

  Connect Amazon S3 Data with Dataiku using the CData JDBC Driver for Amazon S3.

• Connect to ZarMoney Data from PowerBuilder via ODBC

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

• Connect to Sage Intacct Data as an External Source in Dremio

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

• Integrate Amazon Athena with External Services using SnapLogic

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

• Connect to Egnyte Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Egnyte.

• Automate ClickTime Data Replication to Azure Synapse

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

• Automate Moosend Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Moosend and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• How to Visualize SAP Business Warehouse Data in Python with pandas

  Use pandas and other modules to analyze and visualize live SAP Business Warehouse in Python.

• Connect to Exact Online from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Exact Online to connect to Exact Online from Web applications running on WebLogic.

• How to connect to Sage Intacct Data from Spring Boot

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

• Analyze Outlook Data in R via JDBC

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

• Connect to Sage Intacct from Asprova with CData Software ODBC Driver for Sage Intacct

  This article shows how to connect faster to Sage Intacct data from Asprova.

• Connect to Zoho Inventory Data in Google Apps Script via Connect AI

  Use CData Connect AI to access Zoho Inventory in Google Apps Script.

• How to Access Dynamics 365 Business Central Data Using Entity Framework

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

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

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

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

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

• Trigger Xero IFTTT Flows in Azure App Service

  Automate IFTTT (if-this-then-that) workflows for Xero with standard wizards in Logic Apps.

• Automate Tasks in Power Automate Using the CData API Server

  Automate BigCommerce actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.

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

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

• How to Work with CampaignMonitor Data in ETL Validator JDBC

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

• Connect to ZohoDesk Data in Jaspersoft Studio

  Execute SQL to remote ZohoDesk in Jaspersoft Studio.

• Visualize Google Spanner Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Google Spanner.

• Connect to JSON from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from JSON, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Getting Started with the CData JDBC Driver for Humanity

  Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Humanity.

• Connect to Oracle Eloqua Reporting Data in Jaspersoft Studio

  Execute SQL to remote Oracle Eloqua Reporting in Jaspersoft Studio.

• Automate Sage 300 Data Replication to Azure Synapse

  Use CData Sync to customize and automate Sage 300 replication to Azure Synapse.

• Access Live Nuclia Data in AWS Lambda

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

• «
• 163
• 164
• 165
• 166
• 167
• 168
• 169
• 170
• 171
• 172
• »