CData Software - Knowledge Base
Recent Articles
-
Analyze Everhour Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Everhour with the CData JDBC Driver for Everhour.
-
Automated Continuous SurveyMonkey Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Azure SQL Database.
-
Connect to Highrise Data in ACL Analytics
Connect to Highrise CRM via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Highrise CRM.
-
How to Seamlessly Import IBM Cloud Object Storage Data into IBM SPSS Modeler
Integrate IBM Cloud Object Storage data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to integrate Metabase with SAP BusinessObjects BI Data
Use CData Connect AI to connect to live SAP BusinessObjects BI and create an interactive dashboard in Metabase from SAP BusinessObjects BI.
-
Automated Continuous DocuSign Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable DocuSign replication to PostgreSQL.
-
Object-Relational Mapping (ORM) with Google Spanner 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 Spanner into a Java-based ORM framework, Hibernate.
-
Access Live Bullhorn CRM Data in Coginiti Pro
Connect to and query live Bullhorn CRM from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Front 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 Front into TIBCO Spotfire.
-
How to Create Power BI Visual Reports with Real-Time Printful Data
Use CData Power BI Connectors to visualize Printful in Power BI.
-
Getting Started with the CData Power BI Connector for Sage Intacct
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Sage Intacct.
-
Rapidly Develop Mocean-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Mocean.
-
Use Dash to Build Web Apps on Azure Synapse Data via CData Connect AI
Build interactive Dash web apps on live Azure Synapse using pandas and the CData Connect AI Python SDK.
-
Connect to Airtable Data from HeidiSQL
Use CData Connect AI to connect to and query live Airtable from HeidiSQL.
-
How to Visualize AlloyDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google AlloyDB in Python.
-
Use Agno to Talk to Your Dropbox 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 Dropbox for you.
-
Connect to Microsoft Ads in SpagoBI
Create reports featuring live Microsoft Ads in SpagoBI Studio. Host Microsoft Ads reports on SpagoBI Server.
-
Automated Continuous LightSpeedRetail Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to Amazon Redshift.
-
Query IBM Informix Data through ODBC in Node.js
Use node-odbc to execute SQL queries against IBM Informix from Node.js.
-
How to connect PolyBase to Marketo
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Marketo.
-
Integrating Cursor CLI with Google Analytics 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.
-
Use JayDeBeApi to access AfterShip Data in Python
Use standard Python scripting and the development environment of your choice to access live AfterShip.
-
Connect to BigCommerce Data in RazorSQL
Connect to BigCommerce from wizards and query BigCommerce from the GUI in the RazorSQL database management tool.
-
How to integrate Dynamics 365 with Apache Airflow
Access and process Microsoft Dynamics 365 in Apache Airflow using the CData JDBC Driver.
-
Integrate Stripe Data into Power Automate Desktop using CData Connect
CData Connect for Stripe Data enables you to integrate Stripe into workflows built using Microsoft Power Automate Desktop.
-
Import and Visualize Freshteam Data in Power View
Create data visualizations based on Freshteam in Excel.
-
Query Delighted Data in DataGrip
Create a Data Source for Delighted in DataGrip and use SQL to query live Delighted.
-
Integrating Dataiku with Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Veeva Vault & Vault CRM.
-
Import FHIR Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access FHIR. In this article, you will use the OData format to import FHIR into Microsoft Power Query.
-
Automated Continuous Act-On Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Act-On replication to Apache Cassandra.
-
Build AI Agents with MarkLogic 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 MarkLogic through CData Connect AI.
-
Integrate with live Gong Data in Jitterbit
Use CData Connect AI to connect to and integrate live Gong in Jitterbit.
-
Use JayDeBeApi to access Neo4J Data in Python
Use standard Python scripting and the development environment of your choice to access live Neo4J.
-
Query Spark Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Apache Spark SQL from Node.js.
-
Moving Data from SageHR to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SageHR data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Stream Zoom Data into Apache Kafka Topics
Access and stream Zoom in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Getting Started with the CData ODBC Driver for Simplesat
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Simplesat.
-
Replicate Airtable Data from PowerShell
Write a quick PowerShell script to query Airtable. Use connectivity to the live data to replicate Airtable to SQL Server.
-
Access Live Amazon Marketplace Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Amazon Marketplace from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Live Chargebee Data in Coginiti Pro
Connect to and query live Chargebee from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Chargebee Reporting in OBIEE with the Chargebee JDBC Driver
Deploy the Chargebee JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Zoho Projects Data in Google Apps Script via Connect AI
Use CData Connect AI to access Zoho Projects in Google Apps Script.
-
Integrating OpenCode Terminal with Coda 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.
-
Automated Continuous Sage 300 Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Sage 300 replication to Google Cloud SQL.
-
Create Informatica Mappings From/To an ODBC Data Source for Dropbox
Create an ODBC connection to Dropbox in Informatica and browse and transfer Dropbox.
-
Automate Teradata Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Teradata and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Integrating Azure Data Lake Storage Data in Talend Cloud Data Management Platform
Connect Azure Data Lake Storage Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Azure Data Lake Storage.
-
Connect to Freshdesk from Asprova with CData Software ODBC Driver for Freshdesk
This article shows how to connect faster to Freshdesk data from Asprova.
-
DataBind Front Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Front to a chart.
-
How to work with Mocean Data in Apache Spark using SQL
Access and process Mocean Data in Apache Spark using the CData Software JDBC Driver.
-
Analyze Sage 300 Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Sage 300 with the CData JDBC Driver for Sage 300.
-
Access SAP Ariba Procurement Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP Ariba Procurement from HeidiSQL.
-
Visualize Live Power BI XMLA Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Power BI XMLA into custom reports in Power BI.
-
How to create an RPA flow for ZohoExpense Data in UiPath Studio
Use the ZohoExpense ODBC Driver to create workflows that access real-time ZohoExpense without any coding.
-
Process & Analyze Zoho CRM Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Zoho CRM Data.
-
Natively Connect to Retently Data in PHP
The CData ODBC driver for Retently enables you to create PHP applications with connectivity to Retently. Leverage the native support for ODBC in PHP.
-
Connect to Tavily Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Tavily in the Denodo Virtual DataPort Administrator.
-
Connect to SFTP Data in DBArtisan
Use wizards in DBArtisan to configure SFTP as a data source.
-
Access Live Amazon DynamoDB Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Amazon DynamoDB in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Publish Crystal Reports on Google Ads Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Ads.
-
Integrate with Live Phoenix Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Phoenix from the MuleSoft Anypoint Platform to integrate live Apache Phoenix into custom reports and dashboards.
-
Migrating data from Scrapfly to Databricks using CData SSIS Components.
Easily push Scrapfly to Databricks using the CData SSIS Tasks for Scrapfly and Databricks.
-
How to create Vimeo federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Vimeo in MySQL .
-
Connect to Suadeo Data in Jaspersoft Studio
Execute SQL to remote Suadeo in Jaspersoft Studio.
-
Analyze Cvent Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Cvent and visualize Cvent in SAP Analytics Cloud.
-
How to Visualize Nethunt Data in Python with pandas
Use pandas and other modules to analyze and visualize live Nethunt in Python.
-
Create WordPress-Connected Dashboards in Grafana
Connect to WordPress Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to WordPress.
-
Use Databricks Agent Bricks to Talk to Your Sage Cloud Accounting Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Sage Business Cloud Accounting for you.
-
Automated Continuous Google Sheets Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Sheets replication to Google BigQuery.
-
Analyze BigCommerce Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of BigCommerce and visualize live BigCommerce in Infragistics Reveal.
-
Query Grafana Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Grafana from Node.js.
-
How to connect to Email Data from IntelliJ
Integrate connectivity to Email with wizards in IntelliJ.
-
Import NetSuite Data Using Azure Data Factory
Use CData Connect AI to connect to NetSuite Data from Azure Data Factory and import live NetSuite CRM & ERP.
-
Use the CData Software ODBC Driver for Oracle Financials Cloud in MicroStrategy Web
Connect to Oracle Financials Cloud in MicroStrategy Web using the CData Software ODBC Driver for Oracle Financials Cloud.
-
Query Wrike Data in ColdFusion
Write standard ColdFusion data access code to connect to Wrike.
-
Use the CData Software ODBC Driver for ActiveCampaign in SAS for Real-Time Reporting and Analytics
Connect to real-time ActiveCampaign in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ActiveCampaign.
-
Automated Continuous Kafka Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Kafka replication to Amazon S3.
-
Connect to QuickBooks Data in DBArtisan
Use wizards in DBArtisan to configure QuickBooks Desktop as a data source.
-
Manage Dynamics 365 Business Central Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Dynamics 365 Business Central.
-
Getting Started with the CData Excel Add-In for Figshare
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Figshare.
-
Migrating data from Auth0 to Databricks using CData SSIS Components.
Easily push Auth0 to Databricks using the CData SSIS Tasks for Auth0 and Databricks.
-
Model Workday Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Workday, enabling the direct import of real-time Workday.
-
Visualize Sage Intacct Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Sage Intacct.
-
Automate Xero Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Xero Accounting and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to import HubSpot Data into Apache Solr
Use the CData Software JDBC Driver for HubSpot in Data Import Handler and create an automated import of HubSpot to Apache Solr Enterprise Search platform.
-
Query Omnisend Data in ColdFusion
Write standard ColdFusion data access code to connect to Omnisend.
-
Build BigQuery-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google BigQuery.
-
Connect to FreeAgent Data in RapidMiner
Integrate FreeAgent with standard components and data source configuration wizards in RapidMiner Studio.
-
Provide OData Services of Snowflake Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Snowflake by developing a WCF Service Application.
-
A PostgreSQL Interface for Google Calendar Data using the CData ODBC Driver
Use the SQL Gateway and Google Calendar ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect Amazon QuickSight to SAP Ariba Source Data
Create a connection to SAP Ariba Source in CData Connect AI and insert SAP Ariba Source into Amazon QuickSight SPICE to build interactive dashboards.
-
Natively Connect to ZohoSubscriptions Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ZohoSubscriptions. Leverage the native support for ODBC in PHP.
-
Create Zoho Projects Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Zoho Projects from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Live Snowflake Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Snowflake to Blue Prism using the CData ODBC Driver for Snowflake to create automated workflows for repetitive business tasks.
-
Build a Singer.io Tap for Drift With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Drift data using
-
Use CData Connect AI to Access Presto Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Presto in the Power Pivot business intelligence tool.
-
Build JSON-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to JSON and build web apps with connectivity to live JSON.
-
Automate Google Ads Data Replication to SAP HANA
Use CData Sync to customize and automate Google Ads replication to SAP HANA.
-
Access Google Translate Data from MySQL in Amazon QuickSight
Connect to Google Translate and build visualizations of Google Translate using a MySQL Connection in Amazon QuickSight.
-
Replicate Multiple Salesloft Accounts via the CData Sync CLI
Replicate multiple Salesloft accounts to one or many databases.