CData Software - Knowledge Base
Recent Articles
-
Automated Continuous WooCommerce Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable WooCommerce replication to delimited files (CSV/TSV).
-
Query Shortcut Data in ColdFusion
Write standard ColdFusion data access code to connect to Shortcut.
-
Create Datasets from Tavily in Domo Workbench and Build Visualizations of Tavily Data in Domo
Use the CData Software ODBC Driver for Tavily to create datasets from Tavily in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect to Live Amazon Marketplace 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 Amazon Marketplace without replication.
-
How to Connect to PayPal Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to PayPal. Leverage the pyodbc module for ODBC in Python.
-
Query REST Data in DataGrip
Create a Data Source for REST in DataGrip and use SQL to query live REST.
-
Connect to Perplexity Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Perplexity.
-
Analyze Phoenix Data in Cognos Analytics
Use CData Connect AI to connect to Phoenix Data from Cognos Analytics and analyze live Apache Phoenix.
-
How to Connect to & Open Bugsnag Data in Microsoft Excel
This article uses the CData ODBC driver for Bugsnag to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to EnterpriseDB Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for EnterpriseDB and the Script function in FileMaker Pro to connect to EnterpriseDB and work with EnterpriseDB in your FileMaker application.
-
Automated Continuous Mailgun Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Mailgun replication to Azure SQL Database.
-
Integrating Superchat Data in Talend Cloud Data Management Platform
Connect Superchat Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Query Live Factorial Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Factorial data in natural language using Python.
-
Query Hacker News Data in DataGrip
Create a Data Source for Hacker News in DataGrip and use SQL to query live Hacker News.
-
Publish Clockify-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Clockify.
-
Visualize Oracle SCM 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 Oracle SCM into TIBCO Spotfire.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Drip
Provide connectivity to Drip through an SAP BusinessObjects universe.
-
Connect to and Visualize Live Dropbox Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Dropbox.
-
Create a Data Access Object for PayPal Data using JDBI
A brief overview of creating a SQL Object API for PayPal in JDBI.
-
Creating Vertica-Connected Applications in Unqork
You can use CData Connect AI to feed Vertica to Unqork and build custom business apps.
-
Replicate Multiple ClickUp Accounts via the CData Sync CLI
Replicate multiple ClickUp accounts to one or many databases.
-
Bridge ZohoExpense Connectivity with Apache NiFi
Access and process ZohoExpense in Apache NiFi using the CData JDBC Driver.
-
Analyze Spark Data in Cognos Analytics
Use CData Connect AI to connect to Spark Data from Cognos Analytics and analyze live Apache Spark SQL.
-
Build MVC Applications with Connectivity to Amazon DynamoDB Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Amazon DynamoDB from an ASP.NET MVC application.
-
Connect to CouchDB Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Create SSAS Tabular Models from JobNimbus Data
How to build a SQL Server Analysis Service Tabular Model from JobNimbus using CData drivers.
-
Connect to DocuSign Data from a Connection Pool in Jetty
The DocuSign JDBC Driver supports connection pooling: This article shows how to connect faster to DocuSign from Web apps in Jetty.
-
Analyze Gumroad Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Gumroad from Power Pivot. You will use the Table Import Wizard to load Gumroad. You can visually build the import query or use any SQL supported by the driver.
-
Connect to SQL Analysis Services Data in RapidMiner
Integrate SQL Analysis Services with standard components and data source configuration wizards in RapidMiner Studio.
-
Build a PostgreSQL Interface for MailerSend Data using the CData JDBC Driver
Use the Remoting features of the MailerSend JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect PolyBase to Zoho Creator
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zoho Creator.
-
Stream Google Sheets Data into Apache Kafka Topics
Access and stream Google Sheets in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate with live Vertica Data in Jitterbit
Use CData Connect AI to connect to and integrate live Vertica in Jitterbit.
-
Build Apps with Live Blackbaud FE NXT Data Using the Low-Code Development Platform of Mendix
Connect Blackbaud FE NXT with Mendix to build apps using the CData JDBC Driver for Blackbaud FE NXT.
-
How to connect Amazon QuickSight to Couchbase Data
Create a connection to Couchbase in CData Connect AI and insert Couchbase into Amazon QuickSight SPICE to build interactive dashboards.
-
Automate Procore Data Replication to Azure Synapse
Use CData Sync to customize and automate Procore replication to Azure Synapse.
-
Perform Batch Operations with Oracle Sales Data in Apache NiFi
Connect to Oracle Sales and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect Redshift Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Amazon Redshift using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live QuickBooks Time Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate QuickBooks Time into the statistical analysis tools available in SAS JMP. This article shows how to use QuickBooks Time in the Graph Builder and Query Builder.
-
Access Live Oracle Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Oracle data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Design Square Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Square from mobile and tablet Power Apps.
-
Manage ZarMoney Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ZarMoney.
-
DataBind ConstantContact Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ConstantContact to a chart.
-
Build MYOB AccountRight Visualizations in Tableau Desktop
Use CData Connect AI to connect to live MYOB AccountRight and build visualizations in Tableau.
-
How to Build an ETL App for Google Cloud Storage Data in Python with CData
Create ETL applications and real-time data pipelines for Google Cloud Storage in Python with petl.
-
How to integrate Vault CRM with Apache Airflow
Access and process Veeva Vault & Vault CRM in Apache Airflow using the CData JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Cloud Storage
Provide connectivity to Google Cloud Storage through an SAP BusinessObjects universe.
-
Build Cloudant-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live IBM Cloudant.
-
Automate Opsgenie Data Replication to Couchbase
Use CData Sync to Customize and automate Opsgenie replication to Couchbase.
-
Access Placid Data from MySQL in Amazon QuickSight
Connect to Placid and build visualizations of Placid using a MySQL Connection in Amazon QuickSight.
-
Access Live DB2 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 IBM DB2 through MCP integration.
-
How to Query Live Salesloft Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Salesloft data in natural language using Python.
-
Create Dashboards and Visualize Live MySQL Data in Geckoboard
Use CData Connect AI to connect to live MySQL and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Analyze Google Directory Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Directory in Microsoft R Open.
-
Design BIRT Reports on Shopify Data
Provide current Shopify to your embedded analytics.
-
Replicate Multiple Reckon Accounts
Replicate multiple Reckon accounts to one or many databases.
-
Connect to Drift Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Drift in the Denodo Virtual DataPort Administrator.
-
Integrating LangGraph with LinkedIn Ads Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on LinkedIn Ads within automated workflows.
-
Integrate WooCommerce Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live WooCommerce from Informatica Cloud.
-
Automated Continuous Drift Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Drift replication to delimited files (CSV/TSV).
-
Integrating Codex CLI with Microsoft Dynamics 365 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 create EnterpriseDB federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for EnterpriseDB in MySQL .
-
Connect to PabblySubscriptions Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for PabblySubscriptions in the Denodo Virtual DataPort Administrator.
-
How to Build an ETL App for Office 365 Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Office 365 in Python with petl.
-
Analyze Gong Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Gong and visualize Gong in SAP Analytics Cloud.
-
How to connect to SurveyMonkey Data in DBVisualizer
Integrate SurveyMonkey with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData SSIS Components for Scrapfly
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Scrapfly.
-
Automated Continuous Google Sheets Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Sheets replication to Databricks.
-
Object-Relational Mapping (ORM) with Oracle SCM 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 Oracle SCM into a Java-based ORM framework, Hibernate.
-
Access Live Webex Data in Coginiti Pro
Connect to and query live Webex from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Publish Toggl-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Toggl.
-
Import and Visualize Testmonitor Data in Power View
Create data visualizations based on Testmonitor in Excel.
-
Process & Analyze Aweber Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Aweber Data.
-
Integrating Claude Code CLI with Authorize.Net 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 publish and share Teamgate Data dashboards with Tableau Server
The CData ODBC driver for Teamgate enables you integrate Teamgate into Tableau dashboards.
-
Connecting Pipedream with Jira Assets 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 Jira Assets data in real time.
-
Connect to Webflow Data in Aqua Data Studio
Access Webflow from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Visualize Deel 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 Deel into TIBCO Spotfire.
-
Deploy the ADO.NET Provider for Telegram on an SSRS Report Server
Connect to Telegram 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.
-
Build Certinia-Connected Apps in Choreo
Use CData Connect AI to connect to Certinia Data from Choreo and build custom apps using live Certinia.
-
Analyze Redis Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Redis and visualize live Redis in Infragistics Reveal.
-
Connect to DocuSign Data in RapidMiner
Integrate DocuSign with standard components and data source configuration wizards in RapidMiner Studio.
-
DataBind Controls to Auth0 Data in Delphi
DataBind to Auth0 in Delphi with standard data access components and controls.
-
Integrating Codex CLI with Google Ad Manager 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 LangChain with Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Certinia within automated workflows.
-
Automated Continuous Salesforce Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Salesforce replication to Amazon Redshift.
-
Connect to Pipeliner CRM Data in RapidMiner
Integrate Pipeliner CRM with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate with ChartMogul Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ChartMogul to a JSON file on disk.
-
Connect Teamgate to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Teamgate using the CData Python MCP Server.
-
Getting Started with the CData Tableau Connector for Discourse
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Query ConvertKit Data in DataGrip
Create a Data Source for ConvertKit in DataGrip and use SQL to query live ConvertKit.
-
Prepare, Blend, and Analyze Parquet Data in Alteryx Designer (ODBC)
Build workflows to access live Apache Parquet for self-service data analytics.
-
Integrate with MariaDB Data in JReport Designer
Create charts and reports based on MariaDB in JReport Designer.
-
How to create an RPA flow for Pinecone Data in UiPath Studio
Use the Pinecone ODBC Driver to create workflows that access real-time Pinecone without any coding.
-
How to Visualize HBase 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 Apache HBase in Python.
-
Getting Started with the CData Connect AI Python SDK for Cassandra
Install the CData Connect AI Python SDK to read and write live Apache Cassandra with standard DB-API 2.0 Python code.
-
How to Easily Query TigerGraph Data in OpenOffice Base
Connect to TigerGraph data in OpenOffice Base using the CData ODBC Driver for TigerGraph and generate reports with live data insights.
-
Automate CampaignMonitor Data Replication to Azure Data Lake
Use CData Sync to customize and automate CampaignMonitor replication to Azure Data Lake.
-
Use the CData Software ODBC Driver for PhantomBuster in SAS for Real-Time Reporting and Analytics
Connect to real-time PhantomBuster in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for PhantomBuster.
-
Query Zoho Books Data in DataGrip
Create a Data Source for Zoho Books in DataGrip and use SQL to query live Zoho Books.