CData Software - Knowledge Base
Recent Articles
-
Connect to Snowflake Data in DBeaver
Use the CData ODBC Driver to connect to Snowflake in DBeaver.
-
Visualize Live Front Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Front.
-
How to Visualize NetSuite 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 NetSuite CRM & ERP in Python.
-
Model Office 365 Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Office 365, enabling the direct import of real-time Microsoft Office 365.
-
Creating Presto-Connected Applications in Unqork
You can use CData Connect AI to feed Presto to Unqork and build custom business apps.
-
DataBind Clockify Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Clockify to a chart.
-
Access SAP Fieldglass Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP Fieldglass from HeidiSQL.
-
Use the CData Software JDBC Driver for XML in MicroStrategy Web
Connect to XML Files in MicroStrategy Web using the CData Software JDBC Driver for XML.
-
How to use SQLAlchemy ORM to access Amazon Athena Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Amazon Athena.
-
Visualize FHIR Data in TIBCO Spotfire through ADO.NET
Integrate FHIR into dashboards in TIBCO Spotfire.
-
Use the CData Software JDBC Driver for Smartsheet in MicroStrategy Desktop
Connect to Smartsheet in MicroStrategy Desktop using the CData Software JDBC Driver for Smartsheet.
-
Visualize Factorial Data in Tableau
The CData ODBC driver for Factorial enables you integrate Factorial into Tableau dashboards.
-
Add SpaceX Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SpaceX with the Informatica Enterprise Data Catalog to classify and organize data.
-
Provide OData Services of Figshare Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Figshare by developing a WCF Service Application.
-
Automated Continuous Drip Replication to SQLite
Use CData Sync for automated, continuous, customizable Drip replication to SQLite.
-
Replicate Multiple Rebilly Accounts
Replicate multiple Rebilly accounts to one or many databases.
-
Use the CData Software ODBC Driver for ZohoInvoice in SAS for Real-Time Reporting and Analytics
Connect to real-time ZohoInvoice in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ZohoInvoice.
-
How to Easily Query SingleStore Data in OpenOffice Base
Connect to SingleStore data in OpenOffice Base using the CData ODBC Driver for SingleStore and generate reports with live data insights.
-
Object-Relational Mapping (ORM) with Google Tasks 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 Google Tasks into a Java-based ORM framework, Hibernate.
-
Build a PostgreSQL Interface for Neo4J Data using the CData JDBC Driver
Use the Remoting features of the Neo4J JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous HubSpot Replication to SQL Server
Use CData Sync for automated, continuous, customizable HubSpot replication to SQL Server.
-
Build Visualizations of Stack Exchange Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Stack Exchange in Birst.
-
Access Stripe Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Stripe.
-
Add SuiteCRM Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SuiteCRM with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to import Google Forms Data into Apache Solr
Use the CData Software JDBC Driver for Google Forms in Data Import Handler and create an automated import of Google Forms to Apache Solr Enterprise Search platform.
-
Stream Splunk Data into Apache Kafka Topics
Access and stream Splunk in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build a Simple VCL Application for Zoho Projects Data
How to build a simple VCL Application to view Zoho Projects in RAD Studio using the CData ODBC Driver for Zoho Projects.
-
Connect to Microsoft Planner Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft Planner as a data source.
-
Moving Data from Invoiced to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Invoiced data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Visualize AlloyDB Data in Sisense
Create an ElastiCube in Sisense app with access to Google AlloyDB.
-
Connect to Dotmailer Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to create an RPA flow for Pipeliner CRM Data in UiPath Studio
Use the Pipeliner CRM ODBC Driver to create workflows that access real-time Pipeliner CRM without any coding.
-
Access Live FreeAgent Data in AWS Lambda
Connect to live FreeAgent in AWS Lambda using the CData JDBC Driver.
-
How to connect to Basecamp Data from Spring Boot
Connect to Basecamp in a Spring Boot Application using the CData JDBC Driver for Basecamp
-
Connect and Query Live SAP Concur Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAP Concur into Databricks
-
Connecting Agentforce with MySQL Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your MySQL for you.
-
Replicate Omnisend Data to Multiple Databases
Replicate Omnisend to disparate databases with a point-and-click configuration.
-
Create Reports with Paddle Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Paddle.
-
Integrate Salesloft Data in the Pentaho Report Designer
Publish reports based on Salesloft in the Pentaho BI tool.
-
Build Hive-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Apache Hive.
-
Manage Egnyte Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Egnyte.
-
Connect to Opsgenie Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Opsgenie as an External Source in Dremio.
-
Access Live Sage 200 Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Sage 200 from your Excel spreadsheets.
-
How to Connect to Dynamics NAV Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft Dynamics NAV. Leverage the pyodbc module for ODBC in Python.
-
Access Live DocuSign 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 DocuSign through MCP integration.
-
Viewing Google Analytics Data in RAD Studio Data Explorer
How to view Google Analytics in RAD Studio Data Explorer using the CData ODBC Driver for Google Analytics.
-
Explore Geographical Relationships in Phoenix Data with Power Map
Create data visualizations with Apache Phoenix in Power Map.
-
How to Work with SAP Ariba Procurement Data in ETL Validator JDBC
Connect to SAP Ariba Procurement from ETL Validator jobs using the CData Software JDBC Driver.
-
Working with Google Directory Data in LINQPad
Execute LINQ queries to Google Directory in LINQPad.
-
Access Live ClickTime Data in Coginiti Pro
Connect to and query live ClickTime from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Connect AI Python SDK for Authorize.Net
Install the CData Connect AI Python SDK to read and write live Authorize.Net with standard DB-API 2.0 Python code.
-
Automated Continuous Procore Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Procore replication to Google Cloud SQL.
-
Connect to Real-Time ZohoExpense Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ZohoExpense in Power Apps.
-
ETL Factorial in Oracle Data Integrator
This article shows how to transfer Factorial into a data warehouse using Oracle Data Integrator.
-
Analyze WooCommerce Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of WooCommerce and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
LINQ to Sage Intacct 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 Sage Intacct Data Provider.
-
How to Connect Flowise AI Agents to Live ShipStation Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live ShipStation without replication.
-
Automate Zoho Creator Data Replication to Azure Synapse
Use CData Sync to customize and automate Zoho Creator replication to Azure Synapse.
-
Access MailChimp Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for MailChimp.
-
Automate FreeAgent Data Replication to Azure Synapse
Use CData Sync to customize and automate FreeAgent replication to Azure Synapse.
-
How to connect to Jira Data with Squirrel SQL client
Connect to Atlassian Jira and execute queries in the Squirrel SQL Client.
-
Automated Continuous VWO Replication to Databricks
Use CData Sync for automated, continuous, customizable VWO replication to Databricks.
-
Explore Geographical Relationships in Azure Data Lake Storage Data with Power Map
Create data visualizations with Azure Data Lake Storage in Power Map.
-
Access Live Klipfolio Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Klipfolio in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Edit and Search External Slack Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Slack to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Slack Data objects that you can access from apps and the dashboard.
-
How to Access Live Testmonitor Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Testmonitor enables you to integrate Testmonitor into workflows built using Microsoft Power Automate Desktop.
-
Back Up Reckon to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Reckon. In this article, we will employ an SSIS workflow to populate a database with Reckon data.
-
Integrating Cursor CLI with Codat 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.
-
Build Dashboards with Suadeo Data in Dundas BI
Create dynamic dashboards and perform analytics based on Suadeo in Dundas BI.
-
PabblySubscriptions Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on PabblySubscriptions facts in real time.
-
How to Connect to Live Elasticsearch 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 Elasticsearch for you.
-
Access Live Lakebase Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Lakebase data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Easily Query Oracle Data in OpenOffice Base
Connect to Oracle data in OpenOffice Base using the CData ODBC Driver for Oracle and generate reports with live data insights.
-
Automate Azure Data Lake Storage Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Azure Data Lake Storage and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Use the CData Software ODBC Driver for Quaderno in MicroStrategy Web
Connect to Quaderno in MicroStrategy Web using the CData Software ODBC Driver for Quaderno.
-
Working with Shopify Data in LINQPad
Execute LINQ queries to Shopify in LINQPad.
-
Access Live IBM Cloud Object Storage Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to IBM Cloud Object Storage from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Oracle Financials Cloud from a Connection Pool in WebLogic
Use the CData JDBC Driver for Oracle Financials Cloud to connect to Oracle Financials Cloud from Web applications running on WebLogic.
-
Visualize Impala Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Apache Impala.
-
Automated Continuous Everhour Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Everhour replication to Google Cloud SQL.
-
Connect to Azure Table Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Azure Table and the Script function in FileMaker Pro to connect to Azure Table and work with Azure Table Storage in your FileMaker application.
-
Integrating Claude Code CLI with Cassandra 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.
-
Automate Quickbase Data Replication to Azure Synapse
Use CData Sync to customize and automate Quickbase replication to Azure Synapse.
-
Integrate LibreChat with Live Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Email from within the chat interface.
-
Automated Continuous Vertica Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Vertica replication to Apache Kafka.
-
Connect Azure Data Catalog to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Azure Data Catalog using the CData Python MCP Server.
-
Integrating Gumloop with Sage Cloud Accounting Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Sage Business Cloud Accounting within automated workflows.
-
Getting Started with the CData Connect AI Python SDK for OData
Install the CData Connect AI Python SDK to read and write live OData with standard DB-API 2.0 Python code.
-
CloudConvert Reporting in OBIEE with the CloudConvert JDBC Driver
Deploy the CloudConvert JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create PivotalTracker Dataflows on PowerBI.com
Connect to the CData Power BI Connector for PivotalTracker from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate with Act-On Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Act-On to a JSON file on disk.
-
Work with Oracle Eloqua Data in FoxPro
Load Oracle Eloqua into a FoxPro database. This article includes full code and a walk-through of the process.
-
Design BIRT Reports on SAP Data
Provide current SAP ERP/NetWeaver to your embedded analytics.
-
Migrating data from Codat to Databricks using CData SSIS Components.
Easily push Codat to Databricks using the CData SSIS Tasks for Codat and Databricks.
-
Create Dynamics 365-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Dynamics 365 Data from Klipfolio and build custom visualizations using live Microsoft Dynamics 365.
-
Use the CData Software JDBC Driver for Google Cloud Storage in MicroStrategy Web
Connect to Google Cloud Storage in MicroStrategy Web using the CData Software JDBC Driver for Google Cloud Storage.
-
How to connect and process Sage Business Cloud Accounting from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Sage Business Cloud Accounting.
-
Design BIRT Reports on Sugar CRM Data
Provide current Sugar CRM to your embedded analytics.
-
Integrating LangGraph with HBase Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Apache HBase within automated workflows.
-
How to Connect the Power BI Service to Gumroad: Complete Guide
Connect to the CData Software Power BI Connector for Gumroad from PowerBI.com to provide real-time Gumroad across the organization.