CData Software - Knowledge Base
Recent Articles
-
Natively Connect to Pipeline CRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Pipeline CRM data. Leverage the native support for ODBC in PHP.
-
Connect VWO Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your VWO data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Automated Workflows with Live Email Data in Workato
Use CData Connect AI to connect to live Email data and build automated workflows in Workato.
-
Automated Continuous Discourse Replication to Databricks
Use CData Sync for automated, continuous, customizable Discourse replication to Databricks.
-
Design BIRT Reports on Recurly Data
Provide current Recurly data to your embedded analytics.
-
Access Live Unbounce Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Unbounce data into the statistical analysis tools available in SAS JMP. This article shows how to use Unbounce data in the Graph Builder and Query Builder.
-
Replicate Google Drive Data from PowerShell
Write a quick PowerShell script to query Google Drive data. Use connectivity to the live data to replicate Google Drive data to SQL Server.
-
Integrating Dataiku with SageHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SageHR data.
-
Automated Continuous ZeroBounce Replication to Databricks
Use CData Sync for automated, continuous, customizable ZeroBounce replication to Databricks.
-
Automated Continuous Hive Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Hive replication to PostgreSQL.
-
Create a Data Access Object for Twitter Ads Data using JDBI
A brief overview of creating a SQL Object API for Twitter Ads data in JDBI.
-
Explore Geographical Relationships in Gong Data with Power Map
Create data visualizations with Gong data in Power Map.
-
How to Build an ETL App for Lakebase Data in Python with CData
Create ETL applications and real-time data pipelines for Lakebase data in Python with petl.
-
How to Query Live Zoho CRM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Zoho CRM data data in natural language using Python.
-
Automated Continuous Zoho CRM Replication to SQLite
Use CData Sync for automated, continuous, customizable Zoho CRM replication to SQLite.
-
Connect to and Visualize Live Zendesk Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zendesk data.
-
Replicate CapsuleCRM Data from PowerShell
Write a quick PowerShell script to query CapsuleCRM data. Use connectivity to the live data to replicate CapsuleCRM data to SQL Server.
-
Connect to SQL Server Data in RapidMiner
Integrate SQL Server data with standard components and data source configuration wizards in RapidMiner Studio.
-
Visualize SAS xpt 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 SAS xpt data into TIBCO Spotfire.
-
Build AI/ML Models with Live HelloSign Data using Dataiku
Connect HelloSign Data with Dataiku using the CData API Driver for JDBC.
-
Integrate Reply.io Data in Pentaho Data Integration
Build ETL pipelines based on Reply.io data in the Pentaho Data Integration tool.
-
Build Dashboards with Couchbase Data in DBxtra
Create dynamic dashboards and perform analytics based on Couchbase data in DBxtra.
-
Standards-Based Access to NoSQL Data Sources
Create a schema to access MongoDB objects from any CData driver technology.
-
Create Data Visualizations in Cognos BI with Neo4J Data
Access Neo4J data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Shopify 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 Shopify data.
-
Connect to Oracle HCM Cloud Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Oracle HCM Cloud Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Consume SurveyMonkey OData Feeds in PowerBuilder
This article demonstrates how to consume SurveyMonkey data as OData feeds from PowerBuilder using the API Server.
-
Use Dash to Build to Web Apps on Workable Data
Create Python applications that use pandas and Dash to build Workable-connected web apps.
-
Use CData Connect AI to Access Google Cloud Storage Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Cloud Storage data in the Power Pivot business intelligence tool.
-
Automate BenchmarkEmail Data Replication to SAP HANA
Use CData Sync to customize and automate BenchmarkEmail data replication to SAP HANA.
-
How to Connect DBeaver to ADP via a JDBC Driver
Manage ADP data with visual tools in DBeaver like the query browser.
-
Migrating data from Sendwithus to Google BigQuery using CData SSIS Components.
Easily push Sendwithus data to Google BigQuery using the CData SSIS Tasks for Sendwithus and Google BigQuery.
-
Connect to Amazon S3 Data in JRuby
Create a simple JRuby app with access to live Amazon S3 data.
-
Build Semantic Layer Views for Snowflake Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Snowflake data.
-
How to Connect to Live MariaDB Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your MariaDB data for you.
-
Getting Started with the CData Tableau Connector for Basecamp
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Basecamp.
-
Moving Data from SQL Server to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SQL Server data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Live Timely Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Timely data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating Claude Code CLI with FHIR 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.
-
Integrate Real-Time Access to Google Spanner in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Spanner data in real time.
-
Publish Reports with Freshservice Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Freshservice data.
-
Create Dashboards and Visualize Live PostgreSQL Data in Geckoboard
Use CData Connect AI to connect to live PostgreSQL data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Build an ETL App for OneNote Data in Python with CData Connect AI
Build ETL pipelines that read and write live OneNote data in Python with petl and the CData Connect AI Python SDK.
-
Acumatica Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Acumatica facts in real time.
-
How to Connect to Live Jira Assets Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Jira Assets data for you.
-
Connect to and Query LinkedIn Data in QlikView over ODBC
Create data visualizations with LinkedIn data in QlikView.
-
How to use SQLAlchemy ORM to access SAS xpt Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAS xpt data.
-
Access Live SAP Ariba Source 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 SAP Ariba Source data through MCP integration.
-
Deploy the ADO.NET Provider for MYOB AccountRight on an SSRS Report Server
Connect to MYOB AccountRight 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.
-
Automated Continuous Humanity Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Humanity replication to IBM DB2.
-
Excel Spreadsheet Automation on Freshteam Data with the QUERY Formula
Pull data from Freshteam, automate spreadsheets, and more with the QUERY formula.
-
How to Query Bugsnag Data in MySQL Workbench
Execute MySQL queries against live Bugsnag data from MySQL Workbench.
-
How to connect to Twilio Data with Squirrel SQL client
Connect to Twilio data and execute queries in the Squirrel SQL Client.
-
Build Timely-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Timely data and build Timely-connected web apps with Axios.
-
Import Salesforce Marketing Data Using Azure Data Factory
Use CData Connect AI to connect to Salesforce Marketing Data from Azure Data Factory and import live Salesforce Marketing data.
-
DataBind Controls to Google Spanner Data in C++Builder
DataBind to Google Spanner data in C++Builder with standard components and controls.
-
How to load Zoho Recruit data into Elasticsearch via Logstash
Introducing a simple method to load Zoho Recruit data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect to NetSuite Data with Squirrel SQL client
Connect to NetSuite data and execute queries in the Squirrel SQL Client.
-
Build a PostgreSQL Interface for Klipfolio Data using the CData JDBC Driver
Use the Remoting features of the Klipfolio JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Google Campaign Manager 360 Data in AWS Lambda
Connect to live Google Campaign Manager 360 data in AWS Lambda using the CData JDBC Driver.
-
Create Couchbase-Connected Dashboards in Grafana
Connect to Couchbase Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Couchbase data.
-
Automate Facebook Ads Data Replication to Couchbase
Use CData Sync to Customize and automate Facebook Ads data replication to Couchbase.
-
How to connect to Access Data from IntelliJ
Integrate connectivity to Access data with wizards in IntelliJ.
-
Enable the Exa JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Exa data.
-
Integrate Real-Time Access to Salesforce in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Salesforce data in real time.
-
Back Up Impala data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Impala. In this article, we will employ an SSIS workflow to populate a database with Impala data data.
-
Build AI/ML Models with Live Google Ads Data using Dataiku
Connect Google Ads Data with Dataiku using the CData JDBC Driver for Google Ads.
-
Integrate SAP SuccessFactors with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP SuccessFactors with External Services.
-
Analyze SuiteCRM Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SuiteCRM data with the CData JDBC Driver for SuiteCRM.
-
Choosing the Best Method to Connect Klipfolio to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Klipfolio data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use JayDeBeApi to access LDAP Objects in Python
Use standard Python scripting and the development environment of your choice to access live LDAP objects.
-
Automate Nuclia Data Replication to SAP HANA
Use CData Sync to customize and automate Nuclia data replication to SAP HANA.
-
How to integrate Metabase with NetSuite SuiteAnalytics Data
Use CData Connect AI to connect to live NetSuite SuiteAnalytics data and create an interactive dashboard in Metabase from NetSuite SuiteAnalytics data.
-
Connect to Hive Data in DBArtisan
Use wizards in DBArtisan to configure Hive data as a data source.
-
Integrate Real-Time Access to MongoDB in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to MongoDB data in real time.
-
Connect to HCL Domino Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time HCL Domino data using standard SQL.
-
Create Reports with Square Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Square data.
-
Feed Reckon Accounts Hosted Data into FineReport
How to set Reckon Accounts Hosted data as a JDBC data source in FineReport.
-
Perform Batch Operations with Splunk Data in Apache NiFi
Connect to Splunk data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Todoist Data in DBArtisan
Use wizards in DBArtisan to configure Todoist data as a data source.
-
How to publish and share Wave Financial Data dashboards with Tableau Server
The CData ODBC driver for Wave Financial enables you integrate Wave Financial data into Tableau dashboards.
-
How to Create Power BI Visual Reports with Real-Time Foursquare Data
Use CData Power BI Connectors to visualize Foursquare data in Power BI.
-
Use the CData Software ODBC Driver for ClickTime in MicroStrategy Desktop
Connect to ClickTime data in MicroStrategy Desktop using the CData Software ODBC Driver for ClickTime.
-
Connect to Live Amazon Marketplace Data in MicroStrategy through CData Connect AI
Create a live connection to Amazon Marketplace Data in CData Connect AI and connect to your Amazon Marketplace data from MicroStrategy.
-
Integrate CouchDB Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to CouchDB data and integrate live CouchDB data into your Power Automate tasks.
-
Integrate Cursor with Live Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Microsoft Teams data from within the editor.
-
How to Connect to Live Marketo Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Marketo data securely in real time.
-
Creating TaxJar-Connected Applications in Unqork
You can use CData Connect AI to feed TaxJar data to Unqork and build custom business apps.
-
Build Charts with ClickUp Data in Clear Analytics
Create dynamic charts and perform analytics based on ClickUp data in Clear Analytics.
-
Integrate Flowlu Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Flowlu data from Informatica Cloud.
-
Publish Reports with Okta Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Okta data.
-
Extract, Transform, and Load SAP SuccessFactors LMS Data in Informatica PowerCenter
Create a simple Workflow for SAP SuccessFactors LMS data in Informatica PowerCenter.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Stack Exchange
Provide connectivity to Stack Exchange data through an SAP BusinessObjects universe.
-
Working with Zoho Inventory Data in LINQPad
Execute LINQ queries to Zoho Inventory data in LINQPad.
-
How to work with OnePageCrm Data in Apache Spark using SQL
Access and process OnePageCrm Data in Apache Spark using the CData Software JDBC Driver.
-
Work with Exact Online Data in FoxPro
Load Exact Online data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Cursor with Float 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.
-
Create SSAS Tabular Models from SAP Ariba Procurement Data
How to build a SQL Server Analysis Service Tabular Model from SAP Ariba Procurement data using CData drivers.
-
Access Live Drip Data in Coginiti Pro
Connect to and query live Drip data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Real-Time Access to HubSpot in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to HubSpot data in real time.