CData Software - Knowledge Base

Recent Articles

---

• «
• 1064
• 1065
• 1066
• 1067
• 1068
• 1069
• 1070
• 1071
• 1072
• 1073
• »

• Automated Continuous SuiteCRM Replication to Google Cloud SQL

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

• Using the CData Software ODBC Driver for Wave Financial in PyCharm

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

• Connect to Twilio Data in RapidMiner

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

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

• Build Apps with Live Monday.com Data Using the Low-Code Development Platform of Mendix

  Connect Monday.com with Mendix to build apps using the CData JDBC Driver for Monday.com.

• Integrate with Google Ads Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live Google Ads in SnapLogic.

• Create a Data Access Object for Google Tasks Data using JDBI

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

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

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

• Automate EnterpriseDB Data Replication to Azure Data Lake

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

• Query Xero Data as a MySQL Database in Node.js

  Execute MySQL queries against Xero Accounting from Node.js.

• Visualize MarkLogic Data in TIBCO Spotfire through OData

  Integrate MarkLogic into dashboards in TIBCO Spotfire.

• Seamlessly Bring Cloudant Data into Retool Using CData Connect AI

  Integrate Cloudant data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.

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

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

• How to Connect DBeaver to SFTP via a JDBC Driver

  Manage SFTP with visual tools in DBeaver like the query browser.

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

• Create Dynamic SAP Netweaver Gateway Grids Using the Infragistics XamDataGrid

  Learn how you can connect SAP Netweaver Gateway to Infragistics XamDataGrid to build dynamic grids.

• Perform Batch Operations with Freshdesk Data in Apache NiFi

  Connect to Freshdesk and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Analyze SharePoint Excel Services Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of SharePoint Excel Services and visualize live SharePoint Excel Services in Infragistics Reveal.

• Connect to Klaviyo Data from HeidiSQL

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

• Operational Reporting on Exa Data from Spotfire Server

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

• Integrating GitHub Data in Talend Cloud Data Management Platform

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

• Build Visualizations of QuickBooks Data in Birst

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

• Bridge Beeminder Connectivity with Apache NiFi

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

• Connect and Query Live BambooHR Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live BambooHR into Databricks

• Getting Started with the CData Python Connector for SAP Ariba Source

  Learn to install and license the CData Python Connector

• Feed Gorgias Data into FineReport

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

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

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

• Enable the Google Campaign Manager 360 JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Google Campaign Manager 360.

• How to connect to TigerGraph Data with Squirrel SQL client

  Connect to TigerGraph and execute queries in the Squirrel SQL Client.

• Build Dashboards with MailChimp Data in Dundas BI

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

• Consume Epicor Kinetic OData Feeds in PowerBuilder

  This article demonstrates how to consume Epicor Kinetic as OData feeds from PowerBuilder using the API Server.

• Access OnePageCrm Data as a Remote Oracle Database

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

• Access Freshteam Data from MySQL in Amazon QuickSight

  Connect to Freshteam and build visualizations of Freshteam using a MySQL Connection in Amazon QuickSight.

• Work with Live Freshdesk Data in Power Query

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

• Bidirectional Access to Bullhorn CRM Data from FileMaker Pro

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

• Integrate with Klaviyo Data using Apache Camel2

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

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

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

• Integrating OpenCode Terminal with Microsoft Entra ID 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 PDFMonkey Data from PowerBuilder via ODBC

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

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

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

• Connect to Azure Data Catalog Data as an External Source in Dremio

  Use the CData JDBC Driver to connect to Azure Data Catalog as an External Source in Dremio.

• Query Retently Data in DataGrip

  Create a Data Source for Retently in DataGrip and use SQL to query live Retently.

• Use Azure AI Foundry to Talk to Your Shopify Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Shopify for you.

• Using the CData Software ODBC Driver for Redis in PyCharm

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

• Connect to xBase from a Connection Pool in WebLogic

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

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

• How to Connect to Azure DevOps Data in Using Python: 6 Steps

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

• Seamlessly Bring Marketo Data into Retool Using CData Connect AI

  Integrate Marketo data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.

• Viewing Google Ads Data in RAD Studio Data Explorer

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

• Build Pipelines with Live Zoom Data in Google Cloud Data Fusion (via CData Connect AI)

  Use CData Connect AI to connect to Zoom from Google Cloud Data Fusion, enabling the integration of live Zoom into the building and management of effective data pipelines.

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

  Create an ODBC connection to Amplitude in Informatica and browse and transfer Amplitude.

• Integrate with Samanage Data using Apache Camel2

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

• Build Brex-Connected Web Apps in Servoy

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

• Use JayDeBeApi to access Instantly Data in Python

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

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

  Connect Databricks with Mendix to build apps using the CData JDBC Driver for Databricks.

• Create Zoho Creator-Connected Enterprise Applications in OutSystems

  Use CData Connect AI to connect to Zoho Creator Data from OutSystems and build custom enterprise apps using live Zoho Creator.

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

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

• How to Query Live QuickBooks Online Data in Perplexity MacOS Desktop

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

• Automated Continuous Pinterest Replication to Local Delimited Files

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

• Integrate with Avro Data using Apache Camel2

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

• Connect to Zendesk Data as a SQL Server Linked Server

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

• Connect to Amazon Athena Data as an External Data Source using PolyBase

  Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Amazon Athena.

• How to connect and process Sentry from Azure Databricks

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

• Integrate Intercom Data in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Intercom from Informatica Cloud.

• How to integrate Slack with Apache Airflow

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

• DataBind Controls to Redshift Data in Delphi

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

• How to Easily Query Perplexity Data in OpenOffice Base

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

• Power AI Workflows with SQL Server 2025 And CData Sync

  Learn how SQL Server 2025’s new AI features such as native vector support transform AI workflows. Then, how to use CData Sync alongside SQl Server 2025 to load enterprise data, build embeddings, and power semantic search and RAG pipelines fast.

• Integrate Exact Online Data into Power Automate Desktop using CData Connect

  CData Connect for Exact Online Data enables you to integrate Exact Online into workflows built using Microsoft Power Automate Desktop.

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

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

• Automated Continuous Greenplum Replication to Oracle

  Use CData Sync for automated, continuous, customizable Greenplum replication to Oracle.

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

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

• Analyze Google Ad Manager Data with Power Pivot

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

• Automated Continuous Azure Blob Storage Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to SQL Server.

• Migrating data from Google Contacts to Snowflake using CData SSIS Components.

  Easily push Google Contacts to Snowflake using the CData SSIS Tasks for Google Contacts and Snowflake.

• Getting Started with the CData ODBC Driver for Azure DevOps

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

• Integrate with live SAP BusinessObjects BI Data in Jitterbit

  Use CData Connect AI to connect to and integrate live SAP BusinessObjects BI in Jitterbit.

• How to connect to Zuora Data with Squirrel SQL client

  Connect to Zuora and execute queries in the Squirrel SQL Client.

• Build Automated Workflows with Live QuickBooks Time Data in Workato

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

• Build Google Drive-Connected Apps in Bubble

  Use CData Connect AI to create an OData feed for Google Drive Data and create custom apps in Bubble.

• How to Query LightSpeedRetail Data in MySQL Workbench

  Execute MySQL queries against live LightSpeedRetail from MySQL Workbench.

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

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

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

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

• Rapidly Develop ShipStation-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 ShipStation.

• How to Seamlessly Import BigCommerce Data into IBM SPSS Modeler

  Integrate BigCommerce data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Getting Started with the CData SSIS Components for Microsoft Entra ID

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for Microsoft Entra ID.

• DataBind Charts to Webflow Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Webflow 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 Work with Browserless Data in ETL Validator JDBC

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

• Automate Microsoft Exchange Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Microsoft Exchange from PowerShell? This article demonstrates how to utilize the Microsoft Exchange Cmdlets for tasks like connecting to Microsoft Exchange, automating operations, downloading data, and more.

• Automate Shopify Data Replication to Azure Data Lake

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

• Build Power BI XMLA-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Power BI XMLA.

• Automated Continuous Paylocity Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Paylocity replication to Amazon S3.

• Working with Tanda Data in LINQPad

  Execute LINQ queries to Tanda in LINQPad.

• How to Connect to Live Shopify Data from OpenAI Python Applications (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Shopify through natural language.

• How to Connect to Live SAS xpt Data in n8n Workflows and Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SAS XPORT for you.

• Consume Amazon Athena OData Feeds in PowerBuilder

  This article demonstrates how to consume Amazon Athena as OData feeds from PowerBuilder using the API Server.

• DataBind Controls to Oracle Data in C++Builder

  DataBind to Oracle Database in C++Builder with standard components and controls.

• How to Work with Oracle Sales Data in AWS Glue Jobs Using JDBC

  Connect to Oracle Sales from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Publish PDFMonkey-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live PDFMonkey.

• Building Dynamic Web Pages with Cvent Data Using AngularJS

  Create single-page applications with live connectivity to Cvent using the CData API Server.

• «
• 1064
• 1065
• 1066
• 1067
• 1068
• 1069
• 1070
• 1071
• 1072
• 1073
• »