CData Software - Knowledge Base

Recent Articles

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• »

• Build Visualizations of Rebilly Data in Birst

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

• Query ConstantContact Data in DataGrip

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

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

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

• How to Query Live PayPal Data in Perplexity MacOS Desktop

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

• How to Connect to Amazon S3 Data in Using Python: 6 Steps

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

• Getting Started with the CData ODBC Driver for Greenplum

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

• Visualize Omnisend Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Omnisend.

• Connect to Quickbase Data from PowerBuilder via ODBC

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

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

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

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

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

• Automated SAP SuccessFactors Data Replication to Teradata

  Use CData Sync to Customize and automate SAP SuccessFactors replication to Teradata.

• Using the CData Software ODBC Driver for Oracle Eloqua Reporting in PyCharm

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

• Create LinkedIn Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time LinkedIn data access from reports, embedded analytics, and more.

• Connect and Query Live Azure DevOps Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live Azure DevOps into Databricks

• Establish a Live Connection with Excel Data using Tableau Bridge

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

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

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

• Connecting Agentforce with Xero Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Xero Accounting for you.

• Connect to Pingdom Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Pingdom from Appeon PowerBuilder using the CData API Driver for ADO.NET.

• Access Google Search Results 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 Google Search.

• Automated Continuous SAP HANA XS Advanced Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Google BigQuery.

• Use ChatGPT to Talk to Your Zoho Creator Data via CData Connect AI

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

• Model Adobe Analytics Data Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and Adobe Analytics, enabling the direct import of real-time Adobe Analytics.

• Automate MessageBird Integration Tasks from PowerShell

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

• Connect SAP BusinessObjects BI Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your SAP BusinessObjects BI using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Import and Visualize Salesforce Marketing Data in Power View

  Create data visualizations based on Salesforce Marketing Cloud in Excel.

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

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

• Getting Started with the CData Python Connector for Zoho Creator

  Learn to install and license the CData Python Connector

• How to Connect to Live CSV Data in Mistral AI Workflows

  Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live CSV/TSV Files without replication.

• Connect to ChargeOver Data from PowerBuilder via ADO.NET

  This article demonstrates how to access ChargeOver from Appeon PowerBuilder using the CData API Driver for ADO.NET.

• Add AdRoll Data to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for AdRoll with the Informatica Enterprise Data Catalog to classify and organize data.

• Visualize Short.io Data in TIBCO Spotfire through ADO.NET

  Integrate Short.io into dashboards in TIBCO Spotfire.

• Automated Continuous Email Replication to SQLite

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

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

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

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

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

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

• Build Visualizations of Delighted Data in Birst

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

• Operational Reporting on Suadeo Data from Spotfire Server

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

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

• Integrating Codex CLI with Bannerbear 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 Biml to Build SSIS Tasks to Replicate ZarMoney Data to SQL Server

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

• Use Microsoft Copilot Studio to talk to your Zuora 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 Zuora for you.

• Connect to eBay from Excel & GoogleSheets!

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

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

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

• How to integrate Metabase with Azure DevOps Data

  Use CData Connect AI to connect to live Azure DevOps and create an interactive dashboard in Metabase from Azure DevOps.

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

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

• Build Close-Powered Applications in GitHub Copilot with CData MCP Server

  Use the CData API Driver for MCP Server to explore live Close Data in GitHub Copilot to assist with building Close-powered applications.

• Integrating Dataiku with Adobe Analytics Data via CData Connect AI

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

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

• Connect to Authorize.Net Data from a Connection Pool in JBoss

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

• Analyze Asana Data in R via JDBC

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

• Access Live Sage 200 Data in AWS Lambda

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

• How to Easily Query ClickTime Data in OpenOffice Base

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

• Getting Started with the CData Python Connector for Spark

  Learn to install and license the CData Python Connector

• Create SSAS Tabular Models from IBM Informix Data

  How to build a SQL Server Analysis Service Tabular Model from IBM Informix using CData drivers.

• Slack Reporting and Star Schemas in OBIEE

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

• Integrate with ADP Data using Apache Camel2

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

• Access ElevenLabs Data from MySQL in HeidiSQL

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

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

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

• Integrate Theia IDE with Live Blackbaud FE NXT Data via CData Connect AI

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

• How to connect SharePoint with Rebilly Data through external lists

  Provide Rebilly to SharePoint users as an external list.

• Connect to Browserless Data in CloverDX (formerly CloverETL)

  Transfer Browserless using the visual workflow in the CloverDX data integration tool.

• Integrating GitHub Copilot CLI with SpaceX 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 Easily Query Pinterest Data in OpenOffice Base

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

• Build SAP Netweaver Gateway-Connected Apps in Mendix

  Use CData Connect AI to create an OData feed for SAP Netweaver Gateway Data and create custom apps in Mendix.

• How to Connect DBeaver to SAP Concur via a JDBC Driver

  Manage SAP Concur with visual tools in DBeaver like the query browser.

• Automate LaunchDarkly Data Replication to Couchbase

  Use CData Sync to Customize and automate LaunchDarkly replication to Couchbase.

• How to Access Testmonitor Data Using Entity Framework

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

• Bind Live Avro Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Avro data

• Consume Recurly OData Feeds in PowerBuilder

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

• Access Live Twilio Data in SAS JMP via ODBC

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

• How to integrate Metabase with Amazon Marketplace Data

  Use CData Connect AI to connect to live Amazon Marketplace and create an interactive dashboard in Metabase from Amazon Marketplace.

• Replicate SAP HANA Data to Multiple Databases via the CData Sync CLI

  Replicate SAP HANA to disparate databases with a single configuration.

• ETL Parquet in Oracle Data Integrator

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

• How to Work with Active Directory Data in ETL Validator JDBC

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

• Access Gong Data as a Remote Oracle Database

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

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

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

• Build Power BI XMLA-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live Power BI XMLA.

• DataBind Controls to Beeminder Data in Delphi

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

• How to Access Front Data Using Entity Framework

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

• DataBind Controls to Microsoft OneDrive Data in C++Builder

  DataBind to Microsoft OneDrive in C++Builder with standard components and controls.

• Connect to Oracle Sales Data in DBeaver

  Use the CData ODBC Driver to connect to Oracle Sales in DBeaver.

• Create Power BI Reports on Real-Time Act CRM Data

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

• Automated Continuous Zendesk Replication to PostgreSQL

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

• How to Work with Teradata Data in ETL Validator JDBC

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

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

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

• Connect to Smartsheet Data in Claris FileMaker Pro

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

• Integrate Dynamics 365 Business Central Data in Pentaho Data Integration

  Build ETL pipelines based on Dynamics 365 Business Central in the Pentaho Data Integration tool.

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

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

• Automated Continuous Box Replication to MySQL

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

• Build MVC Applications with Connectivity to Miro Data

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

• Use JayDeBeApi to access Quickbase Data in Python

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

• Connect to Adobe Analytics in SpagoBI

  Create reports featuring live Adobe Analytics in SpagoBI Studio. Host Adobe Analytics reports on SpagoBI Server.

• Use the CData Software ODBC Driver for Microsoft Dataverse in MicroStrategy Web

  Connect to Microsoft Dataverse (CDS) in MicroStrategy Web using the CData Software ODBC Driver for Microsoft Dataverse.

• Create Apps from IBM Cloud Object Storage Data in Qlik Sense Cloud

  Use CData Connect AI to connect to IBM Cloud Object Storage Data and build apps from live IBM Cloud Object Storage in Qlik Sense Cloud.

• Access Live Zoho Creator Data in Roo Code via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Zoho Creator through MCP integration.

• How to work with SendInBlue Data in Apache Spark using SQL

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

• Visualize Live Planio Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Planio.

• How to Visualize SAP ByDesign Data in Python with pandas

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

• Replicate Bitly Data from PowerShell

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

• Publish eBay-Connected Dashboards in Tableau Server

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

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• »