CData Software - Knowledge Base
Recent Articles
-
How to publish and share Discourse Data dashboards with Tableau Server
The CData ODBC driver for Discourse enables you integrate Discourse data into Tableau dashboards.
-
Create Informatica Mappings From/To an ODBC Data Source for Templated
Create an ODBC connection to Templated in Informatica and browse and transfer Templated data.
-
How to integrate Parallel with Apache Airflow
Access and process Parallel data in Apache Airflow using the CData JDBC Driver.
-
Create Active Directory-Connected Nintex Workflows
Use CData Connect AI to connect to Active Directory Data from Nintex Workflow Cloud and build custom workflows using live Active Directory data.
-
Connect to Pinecone Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Pinecone to connect to Pinecone data and execute queries in PowerBuilder.
-
Integrate with Foursquare Data in JReport Designer
Create charts and reports based on Foursquare data in JReport Designer.
-
Automate Discourse Data Replication to Azure Data Lake
Use CData Sync to customize and automate Discourse data replication to Azure Data Lake.
-
Automated Continuous QuickBooks Time Replication to Oracle
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Oracle.
-
How to load Perigon data into Elasticsearch via Logstash
Introducing a simple method to load Perigon data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Open WebUI with Live GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live GraphQL data from within the chat interface.
-
Connect Act-On Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Act-On data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to SAP BusinessObjects BI Data in RazorSQL
Connect to SAP BusinessObjects BI from wizards and query SAP BusinessObjects BI data from the GUI in the RazorSQL database management tool.
-
Integrating Dataiku with Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Cloudant data.
-
Automate Twilio Data Replication to Couchbase
Use CData Sync to Customize and automate Twilio data replication to Couchbase.
-
Deploy the ADO.NET Provider for SAP SuccessFactors LMS on an SSRS Report Server
Connect to SAP SuccessFactors LMS data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrating OpenCode with SAP HANA 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 Gumloop with Salesloft Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Salesloft data within automated workflows.
-
Integrating OpenCode with Unbounce 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.
-
Object-Relational Mapping (ORM) with Amazon DynamoDB 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 Amazon DynamoDB data into a Java-based ORM framework, Hibernate.
-
Access Live SAP SuccessFactors LMS Data in Coginiti Pro
Connect to and query live SAP SuccessFactors LMS data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to BenchmarkEmail Data in ACL Analytics
Connect to BenchmarkEmail data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to BenchmarkEmail data.
-
Validate Sentry Data with QuerySurge
Access and validate Sentry data in QuerySurge using the CData JDBC Driver.
-
Migrating data from Sybase IQ to Snowflake using CData SSIS Components.
Easily push Sybase IQ data to Snowflake using the CData SSIS Tasks for Sybase IQ and Snowflake.
-
Design BIRT Reports on Google Analytics Data
Provide current Google Analytics data to your embedded analytics.
-
Connecting Pipedream with ServiceDesk Plus Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on ServiceDesk Plus data in real time.
-
Building Dynamic Web Pages with Zoho Projects Data Using AngularJS
Create single-page applications with live connectivity to Zoho Projects using the CData API Server.
-
Create Toggl Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Toggl data access from reports, embedded analytics, and more.
-
Build Foursquare-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Foursquare data.
-
LINQ to Zoho Creator 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 Zoho Creator Data Provider.
-
Seamlessly Bring BambooHR Data into Retool Using CData Connect AI
Integrate BambooHR data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Natively Connect to Opsgenie Data in PHP
The CData ODBC driver for Opsgenie enables you to create PHP applications with connectivity to Opsgenie data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Opsgenie Replication to Vertica
Use CData Sync for automated, continuous, customizable Opsgenie replication to Vertica.
-
Use Dash to Build Web Apps on Grafana Data via CData Connect AI
Build interactive Dash web apps on live Grafana data using pandas and the CData Connect AI Python SDK.
-
Use Biml to Build SSIS Tasks to Replicate Tavily Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Tavily data to SQL Server.
-
Automate Google Analytics Data Replication to Azure Synapse
Use CData Sync to customize and automate Google Analytics data replication to Azure Synapse.
-
Automated Continuous Stack Exchange Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Stack Exchange replication to AlloyDB.
-
Build Rebilly-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Rebilly data and build web apps with connectivity to live Rebilly data.
-
Replicate Multiple SQL Server Accounts
Replicate multiple SQL Server accounts to one or many databases.
-
Build Charts with Act-On Data in Clear Analytics
Create dynamic charts and perform analytics based on Act-On data in Clear Analytics.
-
Automated Continuous BigCommerce Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable BigCommerce replication to Azure SQL Database.
-
Integrate with Phoenix Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Phoenix data to a JSON file on disk.
-
Migrating data from Anaplan to Snowflake using CData SSIS Components.
Easily push Anaplan data to Snowflake using the CData SSIS Tasks for Anaplan and Snowflake.
-
Connect to Google Search Results in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Search results in the Denodo Virtual DataPort Administrator.
-
Connect to Azure DevOps Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Azure DevOps data using standard SQL.
-
Natively Connect to Pinecone Data in PHP
The CData ODBC driver for Pinecone enables you to create PHP applications with connectivity to Pinecone data. Leverage the native support for ODBC in PHP.
-
Connect to Cosmos DB Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Cosmos DB Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate OpenCode with Live BigQuery Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live BigQuery data from within your AI coding agent.
-
Analyze Jira Assets Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Jira Assets data and visualize live Jira Assets data in Infragistics Reveal.
-
Getting Started with the CData Power BI Connector for Klipfolio
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrate Coda Data into Power Automate Desktop using CData Connect
CData Connect for Coda Data enables you to integrate Coda data into workflows built using Microsoft Power Automate Desktop.
-
How to Work with BigQuery Data in AWS Glue Jobs Using JDBC
Connect to BigQuery from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Write a Simple Go Application to work with Shopify Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Shopify data.
-
Create Dashboards and Visualize Live AlloyDB Data in Geckoboard
Use CData Connect AI to connect to live AlloyDB data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Live Helpscout Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Helpscout data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to ConstantContact Data from HeidiSQL
Use CData Connect AI to connect to and query live ConstantContact data from HeidiSQL.
-
Create Gorgias Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Gorgias from PowerBI.com to create Power BI Dataflows with real-time data.
-
Migrating data from Exa to Snowflake using CData SSIS Components.
Easily push Exa data to Snowflake using the CData SSIS Tasks for Exa and Snowflake.
-
Integrate Live Snowflake Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Snowflake data from within the IDE.
-
Connect to Zoho Inventory Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Zoho Inventory data in the Denodo Virtual DataPort Administrator.
-
Analyze LeadDesk Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze LeadDesk data with the CData JDBC Driver for LeadDesk.
-
Work with VWO Data in FoxPro
Load VWO data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Real-Time Access to Zoho Creator in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Zoho Creator data in real time.
-
Build a Simple VCL Application for PolarTeamPro Data
How to build a simple VCL Application to view PolarTeamPro data in RAD Studio using the CData ODBC Driver for PolarTeamPro.
-
Automated Continuous Dynamics CRM Replication to SQL Server
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to SQL Server.
-
Build Dashboards with ConstantContact Data in Dundas BI
Create dynamic dashboards and perform analytics based on ConstantContact data in Dundas BI.
-
Enable the Shopify JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Shopify data.
-
How to connect PolyBase to Perigon
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Perigon data.
-
Automated Continuous SAP Netweaver Gateway Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Vertica.
-
Automated Continuous Amazon DynamoDB Replication to MySQL
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to MySQL.
-
How to connect to Auth0 Data in DBVisualizer
Integrate Auth0 data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect to & Open Tickspot Data in Microsoft Excel
This article uses the CData ODBC driver for Tickspot to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Teamwork Reporting in OBIEE with the Teamwork JDBC Driver
Deploy the Teamwork JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to eBay from Asprova with CData Software ODBC Driver for eBay
This article shows how to connect faster to eBay data from Asprova.
-
Query Live Greenplum 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 Greenplum data directly from the development environment.
-
Query Dynamics 365 Business Central Data as a SQL Server Database in Node.js
Execute SQL Server queries against Dynamics 365 Business Central data from Node.js.
-
Analyze Shortcut Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Shortcut data and visualize Shortcut data in SAP Analytics Cloud.
-
Getting Started with the CData ADO.NET Provider for Moosend
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Use the CData ODBC Driver for Apollo in Microsoft Power Query
You can use the CData Apollo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apollo data into Microsoft Power Query.
-
Build Stripe-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Stripe data and build Stripe-connected web apps with Axios.
-
Connecting Agentforce with Freshteam 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 Freshteam data for you.
-
Getting Started with the CData Connect AI Python SDK for Amazon S3
Install the CData Connect AI Python SDK to read live Amazon S3 data with standard DB-API 2.0 Python code.
-
Build Pipelines with Live Azure Data Lake Storage Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Azure Data Lake Storage from Google Cloud Data Fusion, enabling the integration of live Azure Data Lake Storage data into the building and management of effective data pipelines.
-
Connect to Klipfolio Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Klipfolio and the SQL Gateway to access Klipfolio data from Google Apps Script.
-
Link ShipStation with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ShipStation data in Filemaker Pro for Mac or Windows.
-
Auth0 Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Auth0 facts in real time.
-
Excel Spreadsheet Automation on SAP Hybris C4C Data with the QUERY Formula
Pull data from SAP Hybris C4C, automate spreadsheets, and more with the QUERY formula.
-
Analyze LinkedIn Ads Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of LinkedIn Ads data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate FHIR Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live FHIR data from Informatica Cloud.
-
Visualize Microsoft OneDrive Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft OneDrive data into TIBCO Spotfire.
-
Automated Continuous Templated Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Templated replication to IBM DB2.
-
Viewing Blackbaud FE NXT Data in RAD Studio Data Explorer
How to view Blackbaud FE NXT data in RAD Studio Data Explorer using the CData ODBC Driver for Blackbaud FE NXT.
-
A Comparison of JDBC Drivers for MySQL
A performance comparison of the CData JDBC Driver for MySQL, the MySQL Connector/J, and the MariaDB Connector/J
-
Feed Strava Data into FineReport
How to set Strava data as a JDBC data source in FineReport.
-
A PostgreSQL Interface for Oracle Eloqua Data (MySQL Remoting via JDBC)
Use the Remoting features of the Oracle Eloqua JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Parallel in SAS for Real-Time Reporting and Analytics
Connect to real-time Parallel data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Parallel.
-
Visualize ShipStation Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ShipStation data.
-
Build Visualizations of Google Calendar Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Calendar data in Birst.
-
How to connect to Freshteam Data with Squirrel SQL client
Connect to Freshteam data and execute queries in the Squirrel SQL Client.
-
Connect to and Query Landbot Data in QlikView over ODBC
Create data visualizations with Landbot data in QlikView.
-
Operational Reporting on Unbounce Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Unbounce data.