CData Software - Knowledge Base
Recent Articles
-
Integrate CockroachDB Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to CockroachDB and integrate live CockroachDB into your Power Automate tasks.
-
Automated Continuous Exact Online Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Exact Online replication to OneLake in Microsoft Fabric.
-
Create Apps from Neo4J Data in Qlik Sense Cloud
Use CData Connect AI to connect to Neo4J Data and build apps from live Neo4J in Qlik Sense Cloud.
-
Back Up Brex to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Brex data.
-
Build AI Agents with Dynamics CRM Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Microsoft Dynamics CRM through CData Connect AI.
-
Enable the Excel JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Excel.
-
Using the CData Software ODBC Driver for Adobe Commerce in PyCharm
Connect to Adobe Commerce as an ODBC data source in PyCharm using the CData Software ODBC Driver for Adobe Commerce.
-
Getting Started with the CData SSIS Components for LeadDesk
Complete guide to installing, licensing, and connecting with the CData SSIS Components for LeadDesk.
-
Access Airtable Data from MySQL in Amazon QuickSight
Connect to Airtable and build visualizations of Airtable using a MySQL Connection in Amazon QuickSight.
-
Use the CData Software ODBC Driver for ShipStation in MicroStrategy Desktop
Connect to ShipStation in MicroStrategy Desktop using the CData Software ODBC Driver for ShipStation.
-
Add Coda Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Coda with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live Google Cloud Storage Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google Cloud Storage into the statistical analysis tools available in SAS JMP. This article shows how to use Google Cloud Storage in the Graph Builder and Query Builder.
-
Connect to Microsoft OneDrive Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft OneDrive from Appeon PowerBuilder using the CData ADO.NET Provider for Microsoft OneDrive.
-
ETL TigerGraph in Oracle Data Integrator
This article shows how to transfer TigerGraph into a data warehouse using Oracle Data Integrator.
-
Bridge Typeform Connectivity with Apache NiFi
Access and process Typeform in Apache NiFi using the CData JDBC Driver.
-
ZeroBounce Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ZeroBounce facts in real time.
-
Getting Started with the CData ADO.NET Provider for Datadog
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Extract, Transform, and Load Snapchat Ads Data in Informatica PowerCenter
Create a simple Workflow for Snapchat Ads in Informatica PowerCenter.
-
Publish Spark-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Apache Spark SQL.
-
How to connect to Quickbase Data with Squirrel SQL client
Connect to Quickbase and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData ODBC Driver for Sage Cloud Accounting
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Sage Cloud Accounting.
-
Build AI/ML Models with Live Recurly Data using Dataiku
Connect Recurly Data with Dataiku using the CData API Driver for JDBC.
-
Use the CData API Server to Access Anaplan Data in Microsoft PowerPivot
Use the CData API Server to connect to live Anaplan in the Power Pivot business intelligence tool.
-
Automated Continuous Opsgenie Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Opsgenie replication to AlloyDB.
-
Write a Simple Go Application to work with eBay Analytics Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to eBay Analytics.
-
Build Apps with Live Trello in Adalo using CData Connect AI
Use CData Connect AI to integrate live Trello into the Adalo platform and build custom mobile and web applications with real-time Trello.
-
Connecting GenSpark with SAP Ariba Procurement Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP Ariba Procurement without any replication or custom integration required.
-
Automated Continuous RSS Replication to IBM DB2
Use CData Sync for automated, continuous, customizable RSS replication to IBM DB2.
-
Build Semantic Layer Views for Azure Synapse Data in APOS Live Data Gateway
Use the CData Connector for Azure Synapse in APOS Live Data Gateway to build Semantic Layer Views for Azure Synapse.
-
Integrate Real-Time Access to NetSuite in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to NetSuite CRM & ERP in real time.
-
Visualize Live Snowflake Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Snowflake.
-
Access Live Microsoft OneDrive Data in Excel 365 Online (Excel for the web)
Connect to Microsoft OneDrive from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Visualize Tally 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 Tally ERP in Python.
-
Process & Analyze Okta Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Okta Data.
-
Object-Relational Mapping (ORM) with Customer.io 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 Customer.io into a Java-based ORM framework, Hibernate.
-
Connect to ChargeOver Data from a Connection Pool in Jetty
The ChargeOver JDBC Driver supports connection pooling: This article shows how to connect faster to ChargeOver from Web apps in Jetty.
-
Connect to MariaDB Data in JRuby
Create a simple JRuby app with access to live MariaDB.
-
Excel Spreadsheet Automation on Egnyte Data with the QUERY Formula
Pull data from Egnyte, automate spreadsheets, and more with the QUERY formula.
-
Build Semantic Layer Views for BenchmarkEmail Data in APOS Live Data Gateway
Use the CData Connector for BenchmarkEmail in APOS Live Data Gateway to build Semantic Layer Views for BenchmarkEmail.
-
Automated Continuous Supabase Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Supabase replication to Google BigQuery.
-
Integrating Codex CLI with Stripe 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 iContact Data in Coginiti Pro
Connect to and query live iContact from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Easily Query Square Data in OpenOffice Base
Connect to Square data in OpenOffice Base using the CData ODBC Driver for Square and generate reports with live data insights.
-
Access Live Freshteam Data in AWS Lambda
Connect to live Freshteam in AWS Lambda using the CData JDBC Driver.
-
Prepare, Blend, and Analyze Google Analytics Data in Alteryx Designer (Connect AI)
Build workflows to access live Google Analytics for self-service data analytics.
-
Create Reports from Presto Data in Looker Studio
Use CData Connect AI to gain access to live Presto and create custom reports in Looker Studio.
-
Working with Tavily Data in LINQPad
Execute LINQ queries to Tavily in LINQPad.
-
DataBind Charts to GraphQL Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to GraphQL 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.
-
Analyze iContact Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze iContact with the CData JDBC Driver for iContact.
-
Integrate Live Browserless Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Browserless to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Connect to Live GraphQL 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 GraphQL without replication.
-
Integrating Cursor CLI with Clari 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 Real-Time Amazon Athena Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Amazon Athena and Dataflow to import and use Amazon Athena in Power Apps.
-
Create Data Visualizations Based On GitLab Data in Mode
Use CData Connect AI to connect to GitLab Data from Mode and build visualizations using live
-
Replicate TaxJar Data to Multiple Databases via the CData Sync CLI
Replicate TaxJar to disparate databases with a single configuration.
-
Connect to ServiceNow Data in Jaspersoft Studio
Execute SQL to remote ServiceNow in Jaspersoft Studio.
-
Access Live FreshBooks Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live FreshBooks from your Excel spreadsheets.
-
Use the CData API Server to Access SAP HANA Data in Microsoft PowerPivot
Use the CData API Server to connect to live SAP HANA in the Power Pivot business intelligence tool.
-
Connect to ZohoInvoice Data from PowerBuilder via ADO.NET
This article demonstrates how to access ZohoInvoice from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use the CData ODBC Driver for Act CRM in Microsoft Power Query
You can use the CData Act CRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Act CRM into Microsoft Power Query.
-
Use ChatGPT to Talk to Your SAP Hybris C4C 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 SAP Hybris C4C for you.
-
Create Datasets from JSON in Domo Workbench and Build Visualizations of JSON Services in Domo
Use the CData Software ODBC Driver for JSON to create datasets from JSON in Domo Workbench and then build visualizations in the Domo service.
-
Consume SAP SuccessFactors OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP SuccessFactors feeds that reflect any changes in SAP Lumira.
-
Create Sybase IQ Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Sybase IQ data access from reports, embedded analytics, and more.
-
Moving Data from DocuSign to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live DocuSign data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating LangChain with SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SAP Business One within automated workflows.
-
How to Easily Query iContact Data in OpenOffice Base
Connect to iContact data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Visualize Amazon DynamoDB 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 Amazon DynamoDB into TIBCO Spotfire.
-
How to Query Live SAP Ariba Procurement Data in Perplexity MacOS Desktop
Connect to and query live SAP Ariba Procurement Data in Perplexity Desktop using CData MCP Server.
-
Operational Reporting on ConvertKit Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ConvertKit.
-
Create a Data Access Object for Azure Synapse Data using JDBI
A brief overview of creating a SQL Object API for Azure Synapse in JDBI.
-
Connect to Shortcut Data from PowerBuilder via JDBC
This article demonstrates how to access Shortcut from PowerBuilder using the Shortcut JDBC Driver.
-
Connect to Salesforce Pardot Data from HeidiSQL
Use CData Connect AI to connect to and query live Salesforce Pardot from HeidiSQL.
-
Replicate Dynamics NAV Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft Dynamics NAV to disparate databases with a single configuration.
-
Visualize Sage 200 Data in TIBCO Spotfire through OData
Integrate Sage 200 into dashboards in TIBCO Spotfire.
-
Query HelloSign Data in DataGrip
Create a Data Source for HelloSign in DataGrip and use SQL to query live HelloSign.
-
Connect to TaxJar Data from a Connection Pool in JBoss
Integrate TaxJar into Java servlets: Use the Management Console in JBoss to install the TaxJar JDBC Driver.
-
Excel Spreadsheet Automation on ClickUp Data with the QUERY Formula
Pull data from ClickUp, automate spreadsheets, and more with the QUERY formula.
-
How to connect to Mailjet Data from Spring Boot
Connect to Mailjet in a Spring Boot Application using the CData API Driver for JDBC
-
Build MVC Applications with Connectivity to Confluence Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Confluence from an ASP.NET MVC application.
-
How to Create Power BI Visual Reports with Real-Time Reckon Data
Use CData Power BI Connectors to visualize Reckon in Power BI.
-
Create Data Visualizations in Cognos BI with Optimizely Data
Access Optimizely as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to MailerSend Data in DBeaver
Use the CData ODBC Driver to connect to MailerSend in DBeaver.
-
Build Charts with Twitter Ads Data in Clear Analytics
Create dynamic charts and perform analytics based on Twitter Ads in Clear Analytics.
-
Publish Adobe Target-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Adobe Target.
-
Build MVC Applications with Connectivity to AgileCRM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access AgileCRM from an ASP.NET MVC application.
-
ETL Invoiced in Oracle Data Integrator
This article shows how to transfer Invoiced into a data warehouse using Oracle Data Integrator.
-
DataBind Controls to GetResponse Data in C++Builder
DataBind to GetResponse in C++Builder with standard components and controls.
-
Use the CData Software ODBC Driver for PabblySubscriptions in MicroStrategy
Connect to PabblySubscriptions in MicroStrategy Developer using the CData Software ODBC Driver for PabblySubscriptions.
-
Build an OLAP Cube in SSAS from Clari Data
Establish a connection to Clari data from SQL Server Analysis Services, and use the Clari Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Google Sheets Data from HeidiSQL
Use CData Connect AI to connect to and query live Google Sheets from HeidiSQL.
-
Connecting GenSpark with Splunk Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Splunk without any replication or custom integration required.
-
Connect to ShipStation Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ShipStation in the Denodo Virtual DataPort Administrator.
-
Access Stack Exchange Data from MySQL in Amazon QuickSight
Connect to Stack Exchange and build visualizations of Stack Exchange using a MySQL Connection in Amazon QuickSight.
-
Extract, Transform, and Load SAP Business Warehouse Data in Informatica PowerCenter
Create a simple Workflow for SAP Business Warehouse in Informatica PowerCenter.
-
Integrating Codex CLI with Todoist 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 Mistral AI Data from MySQL in PHP
Connect to Mistral AI through the standard MySQL libraries in PHP.
-
Analyze Live Confluence Data in SAS Viya
Use CData Connect AI to connect to Atlassian Confluence from SAS Viya and deploy self-service analytics using live Atlassian Confluence.
-
Connect to Typeform Data in DBeaver
Use the CData ODBC Driver to connect to Typeform in DBeaver.
-
Integrate with Bitly Data in JReport Designer
Create charts and reports based on Bitly in JReport Designer.