CData Software - Knowledge Base
Recent Articles
-
Access QuickBooks Time Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access QuickBooks Time from your Oracle system.
-
How to use SQLAlchemy ORM to access MYOB AccountRight Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of MYOB AccountRight.
-
Extract, Transform, and Load Adobe Analytics Data in Informatica PowerCenter
Create a simple Workflow for Adobe Analytics in Informatica PowerCenter.
-
Integrating GitHub Copilot CLI with OpenWeatherMap 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.
-
Build FormSite-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to FormSite and build web apps with connectivity to live FormSite.
-
Create a Data Access Object for Amazon Marketplace Data using JDBI
A brief overview of creating a SQL Object API for Amazon Marketplace in JDBI.
-
Access Live ShipEngine Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ShipEngine into the statistical analysis tools available in SAS JMP. This article shows how to use ShipEngine in the Graph Builder and Query Builder.
-
Manage Aweber Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Aweber.
-
How to Work with MarkLogic Data in AWS Glue Jobs Using JDBC
Connect to MarkLogic from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData Software ODBC Driver for Lakebase in MicroStrategy Web
Connect to Lakebase in MicroStrategy Web using the CData Software ODBC Driver for Lakebase.
-
Connect to SAP Fieldglass Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Fieldglass and the Script function in FileMaker Pro to connect to SAP Fieldglass and work with SAP Fieldglass in your FileMaker application.
-
Use the CData Software ODBC Driver for Printify in SAS for Real-Time Reporting and Analytics
Connect to real-time Printify in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Printify.
-
Add Clockify Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Clockify with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automate Greenhouse Data Replication to Couchbase
Use CData Sync to Customize and automate Greenhouse replication to Couchbase.
-
Analyze SAP SuccessFactors LMS Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP SuccessFactors LMS and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Query Live Parquet Data in Claude Desktop
Connect to and query live Parquet Data in Claude Desktop using CData MCP Server.
-
Create Aircall Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Aircall data access from reports, embedded analytics, and more.
-
Automated Continuous Testmonitor Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Testmonitor replication to Azure SQL Database.
-
How to Seamlessly Import Sendwithus Data into IBM SPSS Modeler
Integrate Sendwithus data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access FreshBooks Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access FreshBooks from your Oracle system.
-
Model Amazon Athena Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Amazon Athena, enabling the direct import of real-time Amazon Athena.
-
Establish a Live Connection with Bitbucket Data using Tableau Bridge
The CData ODBC Driver for Bitbucket enables you to integrate live Bitbucket into Tableau Cloud dashboards using the Tableau Bridge.
-
Create Google Ad Manager-Connected Nintex Workflows
Use CData Connect AI to connect to Google Ad Manager Data from Nintex Workflow Cloud and build custom workflows using live Google Ad Manager.
-
Query, Visualize, and Share live YouTube Analytics Data in Redash
Use CData Connect AI to connect to live YouTube Analytics in Redash for querying, visualizing, and sharing.
-
How to Create Power BI Visual Reports with Real-Time LaunchDarkly Data
Use CData Power BI Connectors to visualize LaunchDarkly in Power BI.
-
Connect to Ontraport Data in Aqua Data Studio
Access Ontraport from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to SuiteCRM Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SuiteCRM as an External Source in Dremio.
-
Integrate Recurly Data in Pentaho Data Integration
Build ETL pipelines based on Recurly in the Pentaho Data Integration tool.
-
Replicate ZohoDesk Data from PowerShell
Write a quick PowerShell script to query ZohoDesk. Use connectivity to the live data to replicate ZohoDesk to SQL Server.
-
Connecting GenSpark with Dynamics 365 Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Microsoft Dynamics 365 without any replication or custom integration required.
-
Access Live Oracle Service Cloud Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Oracle Service Cloud through MCP integration.
-
Integrate Goose with Live Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Microsoft Dynamics CRM from within the local AI agent.
-
Visualize Excel Online Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft Excel Online.
-
Visualize Live SendGrid Data in the Power BI Service
Use CData Connect AI to connect to live SendGrid and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze SAP Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP from Power Pivot. You will use the Table Import Wizard to load SAP ERP/NetWeaver. You can visually build the import query or use any SQL supported by the driver.
-
Provide OData Services of SingleStore Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SingleStore by developing a WCF Service Application.
-
Query, Visualize, and Share live Blackbaud FE NXT Data in Redash
Use CData Connect AI to connect to live Blackbaud FE NXT in Redash for querying, visualizing, and sharing.
-
Access Live Google Cloud Storage Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Cloud Storage from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Feed Tavily Data into FineReport
How to set Tavily as a JDBC data source in FineReport.
-
Access Live Ontraport Data in AWS Lambda
Connect to live Ontraport in AWS Lambda using the CData JDBC Driver.
-
Build a Simple VCL Application for HDFS Data
How to build a simple VCL Application to view Apache HDFS in RAD Studio using the CData ODBC Driver for HDFS.
-
Visualize Teamgate Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Teamgate.
-
Natively Connect to Testmonitor Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Testmonitor. Leverage the native support for ODBC in PHP.
-
How to publish and share Excel Online Data dashboards with Tableau Server
The CData ODBC driver for Excel Online enables you integrate Microsoft Excel Online into Tableau dashboards.
-
Automate Oracle Data Replication to Couchbase
Use CData Sync to Customize and automate Oracle Database replication to Couchbase.
-
Connect to Calendly Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Calendly and work with Calendly in your FileMaker application.
-
Enable the MailChimp JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with MailChimp.
-
Integrate Amazon Marketplace with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Amazon Marketplace with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Amazon Marketplace.
-
Integrate Optimizely with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Optimizely with External Services.
-
Connect IBM Cloud Object Storage to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect IBM Cloud Object Storage with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software JDBC Driver for Printify in MicroStrategy
Connect to Printify in MicroStrategy Developer using the CData Software JDBC Driver for Printify.
-
Build Semantic Layer Views for Cosmos DB Data in APOS Live Data Gateway
Use the CData Connector for Cosmos DB in APOS Live Data Gateway to build Semantic Layer Views for Azure Cosmos DB.
-
Analyze Google Search Results in Cognos Analytics
Use CData Connect AI to connect to Google Search Results from Cognos Analytics and analyze live Google Search.
-
Connect to Raisers Edge NXT from Asprova with CData Software ODBC Driver for Raisers Edge NXT
This article shows how to connect faster to Raisers Edge NXT data from Asprova.
-
How to Connect to Google Forms Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Forms. Leverage the pyodbc module for ODBC in Python.
-
Visualize ActiveCampaign Data in TIBCO Spotfire through OData
Integrate ActiveCampaign into dashboards in TIBCO Spotfire.
-
Build Charts with PabblySubscriptions Data in Clear Analytics
Create dynamic charts and perform analytics based on PabblySubscriptions in Clear Analytics.
-
Access Oracle Eloqua Reporting Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Oracle Eloqua Reporting from HeidiSQL.
-
How to Access Live Azure Table Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Azure Table enables you to integrate Azure Table Storage into workflows built using Microsoft Power Automate Desktop.
-
Add Gorgias Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Gorgias with the Informatica Enterprise Data Catalog to classify and organize data.
-
Query Live SendGrid 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 SendGrid directly from the development environment.
-
Use Biml to Build SSIS Tasks to Replicate Klipfolio Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Klipfolio to SQL Server.
-
Connect to Instantly from Asprova with CData Software ODBC Driver for Instantly
This article shows how to connect faster to Instantly data from Asprova.
-
Work with Printful Data in FoxPro
Load Printful into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Salesforce Marketing 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 Salesforce Marketing Cloud.
-
Analyze Freshservice Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Freshservice and visualize Freshservice in SAP Analytics Cloud.
-
Automated Continuous Rebilly Replication to SingleStore
Use CData Sync for automated, continuous, customizable Rebilly replication to SingleStore.
-
Getting Started with the CData Power BI Connector for Keap
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to TigerGraph Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Visualize Live Act CRM Data in the Power BI Service
Use CData Connect AI to connect to live Act CRM and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Epicor Kinetic Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Epicor Kinetic in Airbyte.
-
Process & Analyze XML Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live XML Data.
-
Prepare, Blend, and Analyze SuiteCRM Data in Alteryx Designer (ODBC)
Build workflows to access live SuiteCRM for self-service data analytics.
-
How to connect PolyBase to Google Directory
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Directory.
-
Connect to Vimeo Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Vimeo using standard SQL.
-
Build MongoDB-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for MongoDB Data and create custom apps in Bubble.
-
Use Biml to Build SSIS Tasks to Replicate Sage 300 Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Sage 300 to SQL Server.
-
Integrate Klaviyo Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Klaviyo from Informatica Cloud.
-
Integrate Hubstaff Data in Pentaho Data Integration
Build ETL pipelines based on Hubstaff in the Pentaho Data Integration tool.
-
Connect to HubSpot Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live HubSpot.
-
Connect to Excel Online Data from Crystal Reports
Use CData Connect AI to connect to and report on live Microsoft Excel Online from Crystal Reports.
-
Extract, Transform, and Load Impala Data in Informatica PowerCenter
Create a simple Workflow for Apache Impala in Informatica PowerCenter.
-
A PostgreSQL Interface for Oracle HCM Cloud Data using the CData ODBC Driver
Use the SQL Gateway and Oracle HCM Cloud ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Use a Microsoft Access Database to Update Workday Data in Real Time
Update Workday data by creating a linked table in Microsoft Access with the CData Workday ODBC Driver.
-
Build AI/ML Models with Live Procore Data using Dataiku
Connect Procore Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous ZohoMarketingHub Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to Amazon S3.
-
Perform Batch Operations with Basecamp Data in Apache NiFi
Connect to Basecamp and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Create SSAS Tabular Models from Certinia Data
How to build a SQL Server Analysis Service Tabular Model from Certinia using CData drivers.
-
Build SharePoint-Connected Apps in Choreo
Use CData Connect AI to connect to SharePoint Data from Choreo and build custom apps using live Microsoft SharePoint.
-
How to Build an ETL App for Microsoft OneDrive Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft OneDrive in Python with petl.
-
Connect to SpaceX Data in Jaspersoft Studio
Execute SQL to remote SpaceX in Jaspersoft Studio.
-
Moving Data from Zoho Projects to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Zoho Projects data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to import SendGrid Data into Apache Solr
Use the CData Software JDBC Driver for SendGrid in Data Import Handler and create an automated import of SendGrid to Apache Solr Enterprise Search platform.
-
Query Brex Data as a MySQL Database in Node.js
Execute MySQL queries against Brex from Node.js.
-
Connect to Quickbase in SpagoBI
Create reports featuring live Quickbase in SpagoBI Studio. Host Quickbase reports on SpagoBI Server.
-
Automated Continuous Jira Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Jira replication to Apache Kafka.
-
Connect to LeadDesk Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to LeadDesk and work with LeadDesk in your FileMaker applications.
-
Bridge Salesforce Connectivity with Apache NiFi
Access and process Salesforce & Force.com in Apache NiFi using the CData JDBC Driver.
-
Validate QuickBooks Online Data with QuerySurge
Access and validate QuickBooks Online in QuerySurge using the CData JDBC Driver.
-
Integrating Supabase Data in Talend Cloud Data Management Platform
Connect Supabase Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.