CData Software - Knowledge Base
Recent Articles
-
Integrate Elorus Data in Pentaho Data Integration
Build ETL pipelines based on Elorus in the Pentaho Data Integration tool.
-
Access Live HCL Domino 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 HCL Domino through MCP integration.
-
Enable the CircleCI JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with CircleCI.
-
Integrate Zoho CRM Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zoho CRM from Informatica Cloud.
-
How to import Jira Assets Data into Apache Solr
Use the CData Software JDBC Driver for Jira Assets in Data Import Handler and create an automated import of Jira Assets to Apache Solr Enterprise Search platform.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Calendar
Provide connectivity to Google Calendar through an SAP BusinessObjects universe.
-
Analyze Kafka Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Apache Kafka with the CData JDBC Driver for Kafka.
-
Connect to Parquet Data in DBArtisan
Use wizards in DBArtisan to configure Apache Parquet as a data source.
-
How to use SQLAlchemy ORM to access AgileCRM Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of AgileCRM.
-
Moving Data from Cvent to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Cvent data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
A PostgreSQL Interface for Avaza Data using the CData ODBC Driver
Use the SQL Gateway and Avaza ODBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData JDBC Driver for SAS xpt
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAS xpt.
-
How to publish and share Google Sheets Data dashboards with Tableau Server
The CData ODBC driver for Google Sheets enables you integrate Google Sheets into Tableau dashboards.
-
Build Visualizations of Rebilly Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Rebilly in Birst.
-
Configure the CData JDBC Driver for Paylocity in a Connection Pool in Tomcat
Connect to Paylocity from a connection pool in Tomcat.
-
How to Connect DBeaver to Sage Intacct via a JDBC Driver
Manage Sage Intacct with visual tools in DBeaver like the query browser.
-
Integrating OpenCode Terminal with Aweber 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 Live PayPal Data in Perplexity MacOS Desktop
Connect to and query live PayPal Data in Perplexity Desktop using CData MCP Server.
-
Build Semantic Layer Views for Billsby Data in APOS Live Data Gateway
Use the CData Connector for Billsby in APOS Live Data Gateway to build Semantic Layer Views for Billsby.
-
Getting Started with the CData Excel Add-In for Salesforce Marketing
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Salesforce Marketing.
-
Getting Started with the CData ODBC Driver for Greenplum
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Greenplum.
-
How to Connect the Power BI Service to Salesforce: Complete Guide
Connect to the CData Software Power BI Connector for Salesforce from PowerBI.com to provide real-time Salesforce & Force.com across the organization.
-
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.
-
Publish Everhour-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Everhour.
-
Build Visualizations of ZeroBounce Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ZeroBounce in Birst.
-
Integrating SAP Concur Data in Talend Cloud Data Management Platform
Connect SAP Concur Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP Concur.
-
How to connect and process Microsoft Dynamics 365 from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Dynamics 365.
-
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.
-
Feed Facebook Ads Data into FineReport
How to set Facebook Ads as a JDBC data source in FineReport.
-
Automated SAP SuccessFactors Data Replication to Teradata
Use CData Sync to Customize and automate SAP SuccessFactors replication to Teradata.
-
DataBind Salesforce Data 360 Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Salesforce Data 360 with the DevExpress Windows Forms and Web controls to provide Salesforce Data 360 to a chart.
-
Connect to Microsoft OneDrive Data in Aqua Data Studio
Access Microsoft OneDrive from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Intercom Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Intercom from your Oracle system.
-
Automated Continuous SQL Server Replication to MySQL
Use CData Sync for automated, continuous, customizable SQL Server replication to MySQL.
-
Connect to Paylocity Data from PowerBuilder via JDBC
This article demonstrates how to access Paylocity from PowerBuilder using the Paylocity JDBC Driver.
-
How to Work with Short.io Data in ETL Validator JDBC
Connect to Short.io from ETL Validator jobs using the CData Software JDBC Driver.
-
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.
-
Integrate with Google Forms Data in JReport Designer
Create charts and reports based on Google Forms in JReport Designer.
-
Automated Continuous Oracle Financials Cloud Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Amazon Redshift.
-
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.
-
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.
-
ETL Access in Oracle Data Integrator
This article shows how to transfer Microsoft Access into a data warehouse using Oracle Data Integrator.
-
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.
-
Query Teamgate Data in DataGrip
Create a Data Source for Teamgate in DataGrip and use SQL to query live Teamgate.
-
Connect to Acumatica Data from AWS Glue
Use CData Connect AI to gain access to live Acumatica ERP from your AWS Glue jobs.
-
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.
-
Visualize Short.io Data in TIBCO Spotfire through ADO.NET
Integrate Short.io into dashboards in TIBCO Spotfire.
-
Automated Continuous Google Sheets Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Sheets replication to SingleStore.
-
Operational Reporting on Suadeo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Suadeo.
-
How to connect to PostgreSQL Data with Squirrel SQL client
Connect to PostgreSQL and execute queries in the Squirrel SQL Client.
-
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.
-
How to Work with Yelp Data in ETL Validator JDBC
Connect to Yelp from ETL Validator jobs using the CData Software JDBC Driver.
-
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.
-
Create Apps from Acumatica Data in Qlik Sense Cloud
Use CData Connect AI to connect to Acumatica Data and build apps from live Acumatica ERP in Qlik Sense Cloud.
-
Validate Google Contacts Data with QuerySurge
Access and validate Google Contacts in QuerySurge using the CData JDBC Driver.
-
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!
-
Prepare, Blend, and Analyze Sybase IQ Data in Alteryx Designer (ODBC)
Build workflows to access live Sybase IQ for self-service data analytics.
-
Trigger Oracle IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Oracle with standard wizards in Logic Apps.
-
Connecting Moonlit Workflow with FreshBooks 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 FreshBooks in real time.
-
Prepare, Blend, and Analyze Pinterest Data in Alteryx Designer (ODBC)
Build workflows to access live Pinterest for self-service data analytics.
-
Connect to Dynamics CRM Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Dynamics CRM as an External Source in Dremio.
-
Access Live Sage 200 Data in AWS Lambda
Connect to live Sage 200 in AWS Lambda using the CData JDBC Driver.
-
How to connect and process Typeform from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Typeform.
-
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 Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft OneNote within intelligent workflows.
-
Access ElevenLabs Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ElevenLabs from HeidiSQL.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Procore
Provide connectivity to Procore through an SAP BusinessObjects universe.
-
Explore Geographical Relationships in SAS xpt Data with Power Map
Create data visualizations with SAS XPORT in Power Map.
-
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.
-
Analyze MYOB AccountRight Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of MYOB AccountRight and visualize live MYOB AccountRight in Infragistics Reveal.
-
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.
-
Getting Started with the CData Excel Add-In for HDFS
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for HDFS.
-
Integrate with SurveyMonkey Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SurveyMonkey to a JSON file on disk.
-
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.
-
Automate LaunchDarkly Data Replication to Couchbase
Use CData Sync to Customize and automate LaunchDarkly replication to Couchbase.
-
Bind Live Avro Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Avro data
-
Build QuickBooks Online-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for QuickBooks Online to explore live QuickBooks Online Data in Gemini Code Assist to assist with building QuickBooks Online-powered applications.
-
Feed Eventbrite Data into FineReport
How to set Eventbrite as a JDBC data source in FineReport.
-
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.
-
Prepare, Blend, and Analyze LinkedIn Ads Data in Alteryx Designer (ODBC)
Build workflows to access live LinkedIn Ads for self-service data analytics.
-
Replicate Multiple Toggl Accounts via the CData Sync CLI
Replicate multiple Toggl accounts to one or many databases.
-
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.
-
Automated Continuous Cloudant Replication to MySQL
Use CData Sync for automated, continuous, customizable Cloudant replication to MySQL.
-
Getting Started with the CData Power BI Connector for Contentful
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Enable the Gorgias JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Gorgias.
-
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.
-
Use the CData Software ODBC Driver for Google Ads in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Ads in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Ads.
-
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.
-
How to create an RPA flow for QuickBooks Online Data in UiPath Studio
Use the QuickBooks Online ODBC Driver to create workflows that access real-time QuickBooks Online without any coding.
-
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.
-
Connect to CockroachDB Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time CockroachDB using standard SQL.