CData Software - Knowledge Base
Recent Articles
-
How to Build an ETL App for Opsgenie Data in Python with CData
Create ETL applications and real-time data pipelines for Opsgenie in Python with petl.
-
Connect to SageHR Data in Jaspersoft Studio
Execute SQL to remote SageHR in Jaspersoft Studio.
-
Automated Continuous PivotalTracker Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable PivotalTracker replication to Google BigQuery.
-
Getting Started with the CData JDBC Driver for Float
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Float.
-
LINQ to FHIR 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 FHIR Data Provider.
-
Using the CData Software ODBC Driver for Neo4J in PyCharm
Connect to Neo4J as an ODBC data source in PyCharm using the CData Software ODBC Driver for Neo4J.
-
Create Datasets from CloudConvert in Domo Workbench and Build Visualizations of CloudConvert Data in Domo
Use the CData Software ODBC Driver for CloudConvert to create datasets from CloudConvert in Domo Workbench and then build visualizations in the Domo service.
-
Stream Jumpseller Data into Apache Kafka Topics
Access and stream Jumpseller in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Dynamic LinkedIn Grids Using the Infragistics XamDataGrid
Learn how you can connect LinkedIn to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous LinkedIn Replication to SQLite
Use CData Sync for automated, continuous, customizable LinkedIn replication to SQLite.
-
How to import Google Translate Data into Apache Solr
Use the CData Software JDBC Driver for Google Translate in Data Import Handler and create an automated import of Google Translate to Apache Solr Enterprise Search platform.
-
Integrate with HCL Domino Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy HCL Domino to a JSON file on disk.
-
Automate Azure Synapse Data Replication to Azure Data Lake
Use CData Sync to customize and automate Azure Synapse replication to Azure Data Lake.
-
Integrate Microsoft Planner Data in the Pentaho Report Designer
Publish reports based on Microsoft Planner in the Pentaho BI tool.
-
Integrate LibreChat with Live NetSuite SuiteAnalytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live NetSuite SuiteAnalytics from within the chat interface.
-
Connect to Zendesk Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zendesk using standard SQL.
-
Automated Continuous Salesforce CRM Analytics Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Azure SQL Database.
-
Integrating GitHub Copilot CLI with Amazon Athena 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 Reports with IBM Informix Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date IBM Informix.
-
Connect to BigCommerce Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time BigCommerce using standard SQL.
-
Connect to Zoho Recruit from Asprova with CData Software ODBC Driver for Zoho Recruit
This article shows how to connect faster to Zoho Recruit data from Asprova.
-
Connect to Aha! Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Aha! to connect to Aha! and execute queries in PowerBuilder.
-
How to connect Amazon QuickSight to Act CRM Data
Create a connection to Act CRM in CData Connect AI and insert Act CRM into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData Python Connector for Sendwithus
Learn to install and license the CData Python Connector
-
Automated Continuous Jodoo Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Jodoo replication to Amazon S3.
-
Working with LDAP Objects in LINQPad
Execute LINQ queries to LDAP in LINQPad.
-
Provide OData Services of SharePoint Excel Services Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SharePoint Excel Services by developing a WCF Service Application.
-
Automated Continuous Dotmailer Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Dotmailer replication to AlloyDB.
-
Analyze Todoist Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Todoist from Power Pivot. You will use the Table Import Wizard to load Todoist. You can visually build the import query or use any SQL supported by the driver.
-
Automate Amazon Athena Data Replication to Azure Synapse
Use CData Sync to customize and automate Amazon Athena replication to Azure Synapse.
-
Connect to Workday Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build MVC Applications with Connectivity to SAP Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP from an ASP.NET MVC application.
-
Connect to Wave Financial Data in Claris FileMaker Pro
Use the CData ODBC Driver for Wave Financial in FileMaker Pro to connect to Wave Financial and work with Wave Financial in your FileMaker applications.
-
Choosing the Best Method to Connect Avro to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Apache Avro from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Dataiku with Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Workday.
-
Connect to Zoho Creator Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Zoho Creator from Filemaker Pro on Mac.
-
Build Trello-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Trello.
-
Automated Continuous AgileCRM Replication to MongoDB
Use CData Sync for automated, continuous, customizable AgileCRM replication to MongoDB.
-
Access Datadog Data from MySQL in PHP
Connect to Datadog through the standard MySQL libraries in PHP.
-
Explore Geographical Relationships in Insightly Data with Power Map
Create data visualizations with Insightly in Power Map.
-
Build Chargebee-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Chargebee and build web apps with connectivity to live Chargebee.
-
Create Dynamic Tickspot Grids Using the Infragistics XamDataGrid
Learn how you can connect Tickspot to Infragistics XamDataGrid to build dynamic grids.
-
How to connect and process Square from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Square.
-
How to connect to Vimeo Data with Squirrel SQL client
Connect to Vimeo and execute queries in the Squirrel SQL Client.
-
How to Seamlessly Import Google Sheets Data into IBM SPSS Modeler
Integrate Google Sheets data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Enable the Microsoft Entra ID JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Entra ID.
-
How to integrate SFTP with Apache Airflow
Access and process SFTP in Apache Airflow using the CData JDBC Driver.
-
Connect to Active Directory Data from a Connection Pool in Jetty
The Active Directory JDBC Driver supports connection pooling: This article shows how to connect faster to Active Directory from Web apps in Jetty.
-
Analyze MariaDB Data in Looker
Use CData Connect AI to connect to MariaDB Data from Looker and build custom apps using live MariaDB.
-
Object-Relational Mapping (ORM) with RSS Feeds 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 RSS Feeds into a Java-based ORM framework, Hibernate.
-
Bridge Notion Connectivity with Apache NiFi
Access and process Notion in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Google Directory Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Directory replication to Amazon S3.
-
Process & Analyze Oracle Sales Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Oracle Sales Data.
-
Query Beeminder Data as a MySQL Database in Node.js
Execute MySQL queries against Beeminder from Node.js.
-
How to Visualize QuickBooks Online Data in Python with pandas
Use pandas and other modules to analyze and visualize live QuickBooks Online in Python.
-
How to publish and share Close Data dashboards with Tableau Server
The CData ODBC driver for Close enables you integrate Close into Tableau dashboards.
-
How to Connect to Live ActiveCampaign 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 ActiveCampaign without replication.
-
Replicate Cloudant Data to Multiple Databases via the CData Sync CLI
Replicate IBM Cloudant to disparate databases with a single configuration.
-
Automate Oracle HCM Cloud Data Replication to Azure Data Lake
Use CData Sync to customize and automate Oracle HCM Cloud replication to Azure Data Lake.
-
Getting Started with the CData Connect AI Python SDK for Procore
Install the CData Connect AI Python SDK to read and write live Procore with standard DB-API 2.0 Python code.
-
DataBind Charts to ChargeOver Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ChargeOver 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.
-
Integrate Open WebUI with Live SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SingleStore from within the chat interface.
-
Migrating data from Redis to Snowflake using CData SSIS Components.
Easily push Redis to Snowflake using the CData SSIS Tasks for Redis and Snowflake.
-
How to Easily Query Shortcut Data in OpenOffice Base
Connect to Shortcut data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automate SendPulse Data Replication to Couchbase
Use CData Sync to Customize and automate SendPulse replication to Couchbase.
-
Integrate Excel Online Data in the Pentaho Report Designer
Publish reports based on Microsoft Excel Online in the Pentaho BI tool.
-
Load Mixpanel Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Mixpanel to a database.
-
Build a PostgreSQL Interface for Procore Data using the CData JDBC Driver
Use the Remoting features of the Procore JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData SSIS Components for SAP HANA XS Advanced
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP HANA XS Advanced.
-
How to connect PolyBase to Chargebee
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Chargebee.
-
Getting Started with the CData ODBC Driver for Salesloft
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Salesloft.
-
How to import Mailgun Data into Apache Solr
Use the CData Software JDBC Driver for Mailgun in Data Import Handler and create an automated import of Mailgun to Apache Solr Enterprise Search platform.
-
Visualize ConstantContact Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ConstantContact.
-
Use the CData Software JDBC Driver for BambooHR in MicroStrategy Desktop
Connect to BambooHR in MicroStrategy Desktop using the CData Software JDBC Driver for BambooHR.
-
Create Adobe Analytics-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Adobe Analytics Data from Klipfolio and build custom visualizations using live Adobe Analytics.
-
Create Datasets from Helpscout in Domo Workbench and Build Visualizations of Helpscout Data in Domo
Use the CData Software ODBC Driver for Helpscout to create datasets from Helpscout in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Snowflake 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 Snowflake through MCP integration.
-
Automate Tasks in Power Automate Using the CData API Server
Automate ADP actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Access Live Vimeo Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Vimeo in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Query Live Wave Financial Data in Perplexity MacOS Desktop
Connect to and query live Wave Financial Data in Perplexity Desktop using CData MCP Server.
-
Automated Continuous Zoho Books Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Zoho Books replication to delimited files (CSV/TSV).
-
How to load ShipStation data into Elasticsearch via Logstash
Introducing a simple method to load ShipStation data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to and Query ClickUp Data in QlikView over ODBC
Create data visualizations with ClickUp in QlikView.
-
Automated Continuous Greenhouse Replication to Vertica
Use CData Sync for automated, continuous, customizable Greenhouse replication to Vertica.
-
Connect to QuickBooks Time Data in Claris FileMaker Pro
Use the CData ODBC Driver for QuickBooks Time in FileMaker Pro to connect to QuickBooks Time and work with QuickBooks Time in your FileMaker applications.
-
Write a Simple Go Application to work with Zoho Projects Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zoho Projects.
-
Migrating data from Twilio to Databricks using CData SSIS Components.
Easily push Twilio to Databricks using the CData SSIS Tasks for Twilio and Databricks.
-
Integrating GitHub Copilot CLI with SAP HANA 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 FreeAgent Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live FreeAgent data in natural language using Python.
-
Connect to Humanity Data in NetBeans
Connect to Humanity in NetBeans with the data source configuration wizard.
-
Connect to Auth0 from a Connection Pool in WebLogic
Use the CData JDBC Driver for Auth0 to connect to Auth0 from Web applications running on WebLogic.
-
Query, Visualize, and Share live ServiceNow Data in Redash
Use CData Connect AI to connect to live ServiceNow in Redash for querying, visualizing, and sharing.
-
Extract, Transform, and Load Microsoft Dataverse Data in Informatica PowerCenter
Create a simple Workflow for Microsoft Dataverse (CDS) in Informatica PowerCenter.
-
View Reports on Real-Time Insightly Data in Power BI Report Server
Use the CData ODBC Driver for Insightly to visualize Insightly in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize Live SharePoint Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft SharePoint into custom reports in Power BI.
-
A PostgreSQL Interface for Authorize.Net Data (MySQL Remoting via JDBC)
Use the Remoting features of the Authorize.Net JDBC Driver to create a PostgreSQL entry-point for data access.
-
Prepare, Blend, and Analyze Quaderno Data in Alteryx Designer (ODBC)
Build workflows to access live Quaderno for self-service data analytics.
-
Integrating Claude Code CLI with Front 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 Import Data from Cosmos DB into Google Sheets
Import Azure Cosmos DB into a Google spreadsheet that is automatically refreshed.
-
Create Stripe-Connected Business Apps in AppSheet
Connect to Stripe Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Stripe.