CData Software - Knowledge Base
Recent Articles
-
How to integrate Quaderno with Apache Airflow
Access and process Quaderno in Apache Airflow using the CData JDBC Driver.
-
How to Seamlessly Import Tickspot Data into IBM SPSS Modeler
Integrate Tickspot data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
A PostgreSQL Interface for Demio Data (MySQL Remoting via JDBC)
Use the Remoting features of the Demio JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Power BI Connector for Gmail
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Gmail.
-
How to Connect to ClickUp Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ClickUp. Leverage the pyodbc module for ODBC in Python.
-
How to Build an ETL App for EnterpriseDB Data in Python with CData
Create ETL applications and real-time data pipelines for EnterpriseDB in Python with petl.
-
Replicate Teamgate Data to Multiple Databases via the CData Sync CLI
Replicate Teamgate to disparate databases with a single configuration.
-
Access Live Presto 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 Presto through MCP integration.
-
How to Connect to Live Oracle HCM Cloud 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 Oracle HCM Cloud without replication.
-
Integrate Sugar CRM Data in Pentaho Data Integration
Build ETL pipelines based on Sugar CRM in the Pentaho Data Integration tool.
-
How to Visualize Workday Data in Python with pandas
Use pandas and other modules to analyze and visualize live Workday in Python.
-
LINQ to Oracle Financials Cloud Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Oracle Financials Cloud Data Provider.
-
Connect to Teradata Data in Claris FileMaker Pro
Use the CData ODBC Driver for Teradata in FileMaker Pro to connect to Teradata and work with Teradata in your FileMaker applications.
-
Visualize Live Amazon Marketplace Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Amazon Marketplace into custom reports in Power BI.
-
Create Power BI Reports on Real-Time Factorial Data
Use the CData ODBC Driver for Factorial to visualize Factorial in Power BI Desktop.
-
Query ClickUp Data in DataGrip
Create a Data Source for ClickUp in DataGrip and use SQL to query live ClickUp.
-
How to integrate Dynamics CRM with Apache Airflow
Access and process Microsoft Dynamics CRM in Apache Airflow using the CData JDBC Driver.
-
Access Live Greenhouse 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 Greenhouse through MCP integration.
-
Integrating Dataiku with Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Stripe.
-
Build Semantic Layer Views for TaxJar Data in APOS Live Data Gateway
Use the CData Connector for TaxJar in APOS Live Data Gateway to build Semantic Layer Views for TaxJar.
-
Operational Reporting on SAP Ariba Procurement Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP Ariba Procurement.
-
How to Build an ETL App for Qualaroo Data in Python with CData
Create ETL applications and real-time data pipelines for Qualaroo in Python with petl.
-
Object-Relational Mapping (ORM) with Box 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 Box into a Java-based ORM framework, Hibernate.
-
Query PostgreSQL Data in DataGrip
Create a Data Source for PostgreSQL in DataGrip and use SQL to query live PostgreSQL.
-
Migrating data from OpenWeatherMap to Google BigQuery using CData SSIS Components.
Easily push OpenWeatherMap to Google BigQuery using the CData SSIS Tasks for OpenWeatherMap and Google BigQuery.
-
Use the CData Software ODBC Driver for Act-On in SAS for Real-Time Reporting and Analytics
Connect to real-time Act-On in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Act-On.
-
Use Azure AI Foundry to Talk to Your SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SurveyMonkey for you.
-
Bind Live WooCommerce Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live WooCommerce data
-
How to connect to Typeform Data in DBVisualizer
Integrate Typeform with visual data analysis tools and data connection wizards in DBVisualizer
-
Build AI Agents with Greenplum 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 Pivotal GreenPlum through CData Connect AI.
-
How to Query Live Mailgun Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Mailgun data in natural language using Python.
-
How to Connect to Live Presto Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Presto for you.
-
Integrate with MailerSend Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy MailerSend to a JSON file on disk.
-
Build a Singer.io Tap for Couchbase With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Couchbase data using
-
Publish Basecamp-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Basecamp.
-
How to Work with GitHub Data in ETL Validator JDBC
Connect to GitHub from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Datasets from SFTP in Domo Workbench and Build Visualizations of SFTP Data in Domo
Use the CData Software ODBC Driver for SFTP to create datasets from SFTP in Domo Workbench and then build visualizations in the Domo service.
-
Write a Simple Go Application to work with Adobe Analytics Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Adobe Analytics.
-
Azure Data Lake Storage Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Azure Data Lake Storage 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 Exchange within intelligent workflows.
-
Build AI/ML Models with Live SAP SuccessFactors LMS Data using Dataiku
Connect SAP SuccessFactors LMS Data with Dataiku using the CData JDBC Driver for SAP SuccessFactors LMS.
-
Feed Yelp Data into FineReport
How to set Yelp as a JDBC data source in FineReport.
-
How to connect to Amazon Athena Data from Spring Boot
Connect to Amazon Athena in a Spring Boot Application using the CData JDBC Driver for Amazon Athena
-
Query QuickBooks Data in ColdFusion
Write standard ColdFusion data access code to connect to QuickBooks Desktop.
-
Getting Started with the CData Excel Add-In for CampaignMonitor
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for CampaignMonitor.
-
Visualize Live Pushbullet Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pushbullet using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Charts to Tally Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Tally ERP 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.
-
Object-Relational Mapping (ORM) with Klipfolio 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 Klipfolio into a Java-based ORM framework, Hibernate.
-
Import and Visualize Google Contacts Data in Power View
Create data visualizations based on Google Contacts in Excel.
-
Process & Analyze Nuclia Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Nuclia Data.
-
Connect to Greenplum Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Pivotal GreenPlum from Filemaker Pro on Mac.
-
Create Power BI Reports on Real-Time Amazon DynamoDB Data
Use the CData ODBC Driver for Amazon DynamoDB to visualize Amazon DynamoDB in Power BI Desktop.
-
Build Blackbaud FE NXT-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Blackbaud FE NXT Data from Zoho Analytics and import live Blackbaud FE NXT.
-
Use Agno to Talk to Your Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Exact Online for you.
-
Create Reports from Elasticsearch Data in Looker Studio
Use CData Connect AI to gain access to live Elasticsearch and create custom reports in Looker Studio.
-
Integrating Antigravity CLI with Salesforce Marketing Cloud via CData CLI
Connect Salesforce Marketing Cloud to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Vault CRM Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Veeva Vault & Vault CRM and build visualizations in Tableau Cloud.
-
Create Dynamic Pipeline CRM Grids Using the Infragistics XamDataGrid
Learn how you can connect Pipeline CRM to Infragistics XamDataGrid to build dynamic grids.
-
Connect to SAP BusinessObjects BI Data in NetBeans
Connect to SAP BusinessObjects BI in NetBeans with the data source configuration wizard.
-
Automated Continuous Clockify Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Clockify replication to Apache Kafka.
-
How to create an RPA flow for CircleCI Data in UiPath Studio
Use the CircleCI ODBC Driver to create workflows that access real-time CircleCI without any coding.
-
Extend Google Sheets with Elasticsearch Data
Make calls to Elasticsearch from Google Apps Script via the API Server.
-
Replicate Aweber Data from PowerShell
Write a quick PowerShell script to query Aweber. Use connectivity to the live data to replicate Aweber to SQL Server.
-
Migrating data from Basecamp to Snowflake using CData SSIS Components.
Easily push Basecamp to Snowflake using the CData SSIS Tasks for Basecamp and Snowflake.
-
Analyze SAP Netweaver Gateway Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP Netweaver Gateway and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Live Jira Assets 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 Jira Assets through MCP integration.
-
Connect to SAS xpt Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAS XPORT in Airbyte.
-
Build Apps with Live CouchDB Data Using the Low-Code Development Platform of Mendix
Connect Apache CouchDB with Mendix to build apps using the CData JDBC Driver for CouchDB.
-
Build Odoo-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Odoo to explore live Odoo Data in Gemini Code Assist to assist with building Odoo-powered applications.
-
Access Live Facebook Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Facebook from your Excel spreadsheets.
-
How to Work with ZohoExpense Data in AWS Glue Jobs Using JDBC
Connect to ZohoExpense from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Factorial Data in DBArtisan
Use wizards in DBArtisan to configure Factorial as a data source.
-
Automated Continuous Avalara AvaTax Replication to Databricks
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Databricks.
-
Explore Geographical Relationships in Microsoft Teams Data with Power Map
Create data visualizations with Microsoft Teams in Power Map.
-
Access Live Elasticsearch Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Elasticsearch into the statistical analysis tools available in SAS JMP. This article shows how to use Elasticsearch in the Graph Builder and Query Builder.
-
DataBind Controls to FreeAgent Data in Delphi
DataBind to FreeAgent in Delphi with standard data access components and controls.
-
Connect to Grafana Data from a Connection Pool in JBoss
Integrate Grafana into Java servlets: Use the Management Console in JBoss to install the Grafana JDBC Driver.
-
Integrate Live Certinia Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Certinia and integrate live Certinia into apps built in Microsoft Power Apps.
-
Connect to Sentry Data from PowerBuilder via JDBC
This article demonstrates how to access Sentry from PowerBuilder using the Sentry JDBC Driver.
-
Migrating data from Stripe to Google BigQuery using CData SSIS Components.
Easily push Stripe to Google BigQuery using the CData SSIS Tasks for Stripe and Google BigQuery.
-
Access Wistia Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Wistia from your Oracle system.
-
How to connect PolyBase to Hugging Face
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Hugging Face.
-
How to Query Live SAP SuccessFactors Data in Claude Desktop
Connect to and query live SAP SuccessFactors Data in Claude Desktop using CData MCP Server.
-
Getting Started with the CData ODBC Driver for Vimeo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Vimeo.
-
Connect to Todoist Data in Ruby
Connect to Todoist in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Automated Workflows with Live Square Data in Workato
Use CData Connect AI to connect to live Square and build automated workflows in Workato.
-
Create Data Visualizations Based On Acumatica Data in Mode
Use CData Connect AI to connect to Acumatica Data from Mode and build visualizations using live
-
How to import Oracle Eloqua Reporting Data into Apache Solr
Use the CData Software JDBC Driver for Oracle Eloqua Reporting in Data Import Handler and create an automated import of Oracle Eloqua Reporting to Apache Solr Enterprise Search platform.
-
DataBind Controls to Avro Data in C++Builder
DataBind to Apache Avro in C++Builder with standard components and controls.
-
Build Hacker News-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Hacker News and build web apps with connectivity to live Hacker News.
-
How to import Google Sheets Data into Apache Solr
Use the CData Software JDBC Driver for Google Sheets in Data Import Handler and create an automated import of Google Sheets to Apache Solr Enterprise Search platform.
-
Automated XML Data Replication to Teradata
Use CData Sync to Customize and automate XML Files replication to Teradata.
-
Integrating LangGraph with ServiceNow Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on ServiceNow within automated workflows.
-
Easily Integrate WordPress Data in Lazarus Pascal IDE
Learn how to easily integrate live WordPress in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize Live ChargeOver Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ChargeOver.
-
Connecting Moonlit Workflow with MarkLogic 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 MarkLogic in real time.
-
Replicate ConstantContact Data in Heroku for Use in Salesforce Connect
Replicate ConstantContact to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect to Bannerbear Data in DBVisualizer
Integrate Bannerbear with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData Excel Add-In for Xero
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Xero.
-
A PostgreSQL Interface for Exa Data (MySQL Remoting via JDBC)
Use the Remoting features of the Exa JDBC Driver to create a PostgreSQL entry-point for data access.