CData Software - Knowledge Base

Recent Articles

---

• «
• 1113
• 1114
• 1115
• 1116
• 1117
• 1118
• 1119
• 1120
• 1121
• 1122
• »

• Manage Adobe Experience Manager Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Adobe Experience Manager.

• Use Biml to Build SSIS Tasks to Replicate Avro Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Apache Avro to SQL Server.

• Integrate with Typeform Data in JReport Designer

  Create charts and reports based on Typeform in JReport Designer.

• Visualize Live MySQL Data of Power BI Report Builder in Power BI Service

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

• Connect to NetSuite SuiteAnalytics from Excel & GoogleSheets!

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

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

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

• Getting Started with the CData ODBC Driver for Postmark

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Postmark.

• Integrating LangChain with Microsoft Entra ID Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft Entra ID within automated workflows.

• Integrating OpenCode Terminal with SAP Ariba Source 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 Delighted Data from MySQL in HeidiSQL

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

• Automated Continuous ConvertKit Replication to SQLite

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

• Access Apollo Data from MySQL in PHP

  Connect to Apollo through the standard MySQL libraries in PHP.

• Automated Continuous Paymo Replication to PostgreSQL

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

• Integrate Nethunt Data in the Pentaho Report Designer

  Publish reports based on Nethunt in the Pentaho BI tool.

• Work with Live Exact Online Data in Power Query

  Use CData Connect AI to connect to Exact Online and work with live Exact Online in Microsoft Power Query.

• Use Dash to Build to Web Apps on Zoho Recruit Data

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

• Integrating Kiro CLI with HDFS 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 Query Chargebee Data in MySQL Workbench

  Execute MySQL queries against live Chargebee from MySQL Workbench.

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

• How to Connect to & Open Act-On Data in Microsoft Excel

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

• Load XML Data to a Database Using Embulk

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

• Build Data Flows from Marketo to SQL Server using SSIS

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

• DataBind Charts to SAP Ariba Procurement Data

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

• Connect to Wistia Data in Jaspersoft Studio

  Execute SQL to remote Wistia in Jaspersoft Studio.

• Build Visualizations of MYOB AccountRight Data in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of MYOB AccountRight in Birst.

• Design BIRT Reports on ZohoSubscriptions Data

  Provide current ZohoSubscriptions to your embedded analytics.

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

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

• How to Visualize Greenplum Data in Python with pandas via CData Connect AI

  Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Pivotal GreenPlum in Python.

• Build Charts with DB2 Data in Clear Analytics

  Create dynamic charts and perform analytics based on IBM DB2 in Clear Analytics.

• Access Live Azure Synapse Data in Coginiti Pro

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

• Connect to HDFS Data in NetBeans

  Connect to Apache HDFS in NetBeans with the data source configuration wizard.

• Integrating Dataiku with Azure DevOps Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Azure DevOps.

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

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

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

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

• Integrating Antigravity CLI with LightSpeedRetail via CData CLI

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

• Automated Continuous Sage 300 Replication to Databricks

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

• Integrating Antigravity CLI with Microsoft Entra ID via CData CLI

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

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

  Connect to FHIR from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Viewing PagerDuty Data in RAD Studio Data Explorer

  How to view PagerDuty in RAD Studio Data Explorer using the CData ODBC Driver for PagerDuty.

• How to Query Live Microsoft Teams Data in Perplexity MacOS Desktop

  Connect to and query live Microsoft Teams Data in Perplexity Desktop using CData MCP Server.

• Explore Geographical Relationships in JSON Services with Power Map

  Create data visualizations with JSON in Power Map.

• Automated Continuous Discord Replication to Snowflake

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

• Object-Relational Mapping (ORM) with Dotmailer 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 Dotmailer into a Java-based ORM framework, Hibernate.

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

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

• DataBind Controls to Grafana Data in Delphi

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

• Use JayDeBeApi to access LinkedIn Ads Data in Python

  Use standard Python scripting and the development environment of your choice to access live LinkedIn Ads.

• Rapidly Develop Avaza-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Avaza.

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

  Easily push Apache Impala to Google BigQuery using the CData SSIS Tasks for Impala and Google BigQuery.

• Use Claude to Talk to Your Sage Cloud Accounting 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 Sage Business Cloud Accounting for you.

• Getting Started with the CData Power BI Connector for SAP Ariba Procurement

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

• Build a Simple VCL Application for Browserless Data

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

• How to Query Live Epicor Kinetic Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Epicor Kinetic data in natural language using Python.

• Connect to Shortcut Data in Jaspersoft Studio

  Execute SQL to remote Shortcut in Jaspersoft Studio.

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Blackbaud FE NXT using the Model Context Protocol.

• Connect to Amazon Athena from Excel & GoogleSheets!

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

• Build a PostgreSQL Interface for Exa Data using the CData JDBC Driver

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

• DataBind Charts to SAS Data Sets Data

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

• Back Up Odoo ERP to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Odoo. In this article, we will employ an SSIS workflow to populate a database with Odoo ERP data.

• Use Biml to Build SSIS Tasks to Replicate Amazon DynamoDB Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Amazon DynamoDB to SQL Server.

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

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

• Connect to Hugging Face in SpagoBI

  Create reports featuring live Hugging Face in SpagoBI Studio. Host Hugging Face reports on SpagoBI Server.

• How to use SQLAlchemy ORM to access Vault CRM Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Veeva Vault & Vault CRM.

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

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

• Work with Basecamp Data in FoxPro

  Load Basecamp into a FoxPro database. This article includes full code and a walk-through of the process.

• Create SSAS Tabular Models from Sage 200 Data

  How to build a SQL Server Analysis Service Tabular Model from Sage 200 using CData drivers.

• Analyze Sage 200 Data in R via JDBC

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

• Create Reports with ServiceNow Data in SAP Crystal Reports

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

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

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

• Integrate Cursor with Live ShipStation Data via CData Connect AI

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

• Use Claude to Talk to Your DocuSign 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 DocuSign for you.

• Connecting Moonlit Workflow with Gmail Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Gmail in real time.

• How to use SQLAlchemy ORM to access YouTube Analytics Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of YouTube Analytics.

• Connect to iContact Data in RapidMiner

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

• Feed XML Data into FineReport

  How to set XML Files as a JDBC data source in FineReport.

• Connect to Salesforce CRM Analytics Data in DBArtisan

  Use wizards in DBArtisan to configure Salesforce CRM Analytics as a data source.

• Automated Continuous SingleStore Replication to IBM DB2

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

• Build Apollo-Connected Web Apps in Servoy

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

• Getting Started with the CData JDBC Driver for OneNote

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

• Getting Started with the CData Python Connector for Power BI XMLA

  Learn to install and license the CData Python Connector

• Use the CData Software ODBC Driver for Google Translate in MicroStrategy Desktop

  Connect to Google Translate in MicroStrategy Desktop using the CData Software ODBC Driver for Google Translate.

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

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

• Automate Presto Data Replication to Azure Data Lake

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

• Access Live Clio Data in AWS Lambda

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

• Create SSAS Tabular Models from Sugar CRM Data

  How to build a SQL Server Analysis Service Tabular Model from Sugar CRM using CData drivers.

• Import Phoenix Data into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apache Phoenix. In this article, you will use the OData format to import Apache Phoenix into Microsoft Power Query.

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

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

• Create Acumatica-Connected Dashboards in Grafana

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

• Getting Started with the CData Power BI Connector for Stack Exchange

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

• Query Live Azure Data Lake Storage Data in Zed Editor via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Azure Data Lake Storage directly from the development environment.

• Connect to Dynamics CRM Data in Aqua Data Studio

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

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

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

• Validate Smartsheet Data with QuerySurge

  Access and validate Smartsheet in QuerySurge using the CData JDBC Driver.

• Build Dashboards with Toggl Data in Dundas BI

  Create dynamic dashboards and perform analytics based on Toggl in Dundas BI.

• Connect to Acumatica Data from Crystal Reports

  Use CData Connect AI to connect to and report on live Acumatica ERP from Crystal Reports.

• Build Procore-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to Procore Data from Zoho Analytics and import live Procore.

• Publish Unbounce-Connected Dashboards in Tableau Server

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

• Getting Started with the CData Tableau Connector for SingleStore

  Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SingleStore.

• How to Query Live SAP Data in Perplexity MacOS Desktop

  Connect to and query live SAP Data in Perplexity Desktop using CData MCP Server.

• Automated Continuous Exact Online Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Exact Online replication to IBM DB2.

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

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

• «
• 1113
• 1114
• 1115
• 1116
• 1117
• 1118
• 1119
• 1120
• 1121
• 1122
• »