CData Software - Knowledge Base
Recent Articles
-
Access Live Highrise Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Highrise CRM from your Excel spreadsheets.
-
Access SAP Concur Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP Concur from your Oracle system.
-
Use the CData Software JDBC Driver for Avaza in MicroStrategy Desktop
Connect to Avaza in MicroStrategy Desktop using the CData Software JDBC Driver for Avaza.
-
Analyze Vercel Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Vercel in Microsoft R Open.
-
Integrate Clio Data in Pentaho Data Integration
Build ETL pipelines based on Clio in the Pentaho Data Integration tool.
-
Migrating data from Salesforce CRM Analytics to Google BigQuery using CData SSIS Components.
Easily push Salesforce CRM Analytics to Google BigQuery using the CData SSIS Tasks for Salesforce CRM Analytics and Google BigQuery.
-
Import Snapchat Ads Data Using Azure Data Factory
Use CData Connect AI to connect to Snapchat Ads Data from Azure Data Factory and import live Snapchat Ads.
-
Migrating data from WooCommerce to Snowflake using CData SSIS Components.
Easily push WooCommerce to Snowflake using the CData SSIS Tasks for WooCommerce and Snowflake.
-
Integrating Boomi Agentstudio with Cassandra Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Apache Cassandra, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrating Antigravity CLI with Harvest via CData CLI
Connect Harvest to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Migrating data from Campaigner to Databricks using CData SSIS Components.
Easily push Campaigner to Databricks using the CData SSIS Tasks for Campaigner and Databricks.
-
How to create Autopilot federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Autopilot in MySQL .
-
Access Live SAP Ariba Procurement Data in TIBCO Data Virtualization
Use the SAP Ariba Procurement Tibco DV Adapter to create a SAP Ariba Procurement data source in TIBCO Data Virtualization Studio and gain access to live SAP Ariba Procurement from your TDV Server.
-
Load Auth0 Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Auth0 to a database.
-
Connect to Zoho Books Data from PowerBuilder via JDBC
This article demonstrates how to access Zoho Books from PowerBuilder using the Zoho Books JDBC Driver.
-
Use CData Connect AI to Access PayPal Data in Microsoft Power Pivot
Use CData Connect AI to connect to live PayPal in the Power Pivot business intelligence tool.
-
Model Klaviyo Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Klaviyo, enabling the direct import of real-time Klaviyo.
-
Establish a Live Connection with Oracle Service Cloud Data using Tableau Bridge
The CData ODBC Driver for Oracle Service Cloud enables you to integrate live Oracle Service Cloud into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Webex Data in DBArtisan
Use wizards in DBArtisan to configure Webex as a data source.
-
Operational Reporting on Sage 300 Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Sage 300.
-
Visualize Oracle SCM Data in Tableau
The CData ODBC driver for Oracle SCM enables you integrate Oracle SCM into Tableau dashboards.
-
How to Query Codat Data in MySQL Workbench
Execute MySQL queries against live Codat from MySQL Workbench.
-
Automate Paylocity Data Replication to Azure Synapse
Use CData Sync to customize and automate Paylocity replication to Azure Synapse.
-
Automated Continuous Acumatica Replication to MongoDB
Use CData Sync for automated, continuous, customizable Acumatica replication to MongoDB.
-
Automated Datadog Data Replication to Teradata
Use CData Sync to Customize and automate Datadog replication to Teradata.
-
Build FTP Visualizations in Tableau Desktop
Use CData Connect AI to connect to live FTP Servers and build visualizations in Tableau.
-
How to create Visio diagrams from Cloudant Data
Automatically update IBM Cloudant with the changes you make to Visio master shapes.
-
Create a Data Access Object for Adobe Commerce Data using JDBI
A brief overview of creating a SQL Object API for Adobe Commerce in JDBI.
-
Connect to Humanity Data in RapidMiner
Integrate Humanity with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Microsoft Planner Replication to Databricks
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Databricks.
-
Excel Spreadsheet Automation on SAP BusinessObjects BI Data with the QUERY Formula
Pull data from SAP BusinessObjects BI, automate spreadsheets, and more with the QUERY formula.
-
How to connect to Guru Data in DBVisualizer
Integrate Guru with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze LDAP Objects in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of LDAP and visualize the live Objects in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Jira Assets Data in NetBeans
Connect to Jira Assets in NetBeans with the data source configuration wizard.
-
Integrate Cline with Live Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Zoho Books from within your IDE.
-
Integrating GitHub Copilot CLI with Zoho Recruit 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 connect to Redshift Data with Squirrel SQL client
Connect to Amazon Redshift and execute queries in the Squirrel SQL Client.
-
Use Dash to Build to Web Apps on Tanda Data
Create Python applications that use pandas and Dash to build Tanda-connected web apps.
-
How to Work with Asana Data in AWS Glue Jobs Using JDBC
Connect to Asana from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Query Pipedrive Data in MySQL Workbench
Execute MySQL queries against live Pipedrive from MySQL Workbench.
-
Bidirectional Access to GitHub Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate GitHub in Filemaker Pro for Mac or Windows.
-
Connect to Yelp Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build a Simple VCL Application for Codat Data
How to build a simple VCL Application to view Codat in RAD Studio using the CData ODBC Driver for Codat.
-
Build Apps with Live Salesloft Data Using the Low-Code Development Platform of Mendix
Connect Salesloft with Mendix to build apps using the CData JDBC Driver for Salesloft.
-
Back Up EnterpriseDB to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for EnterpriseDB. In this article, we will employ an SSIS workflow to populate a database with EnterpriseDB data.
-
Build Aha!-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Aha! and build web apps with connectivity to live Aha!.
-
Use the CData ODBC Driver for Superchat in Microsoft Power Query
You can use the CData Superchat ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Superchat into Microsoft Power Query.
-
How to Connect DBeaver to AlloyDB via a JDBC Driver
Manage Google AlloyDB with visual tools in DBeaver like the query browser.
-
Connect to Yelp Data in RazorSQL
Connect to Yelp from wizards and query Yelp from the GUI in the RazorSQL database management tool.
-
Bridge Dynamics 365 Business Central Connectivity with Apache NiFi
Access and process Dynamics 365 Business Central in Apache NiFi using the CData JDBC Driver.
-
How to Build an ETL App for ClickTime Data in Python with CData
Create ETL applications and real-time data pipelines for ClickTime in Python with petl.
-
Enable the Onfleet JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Onfleet.
-
Connect to Hubstaff Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Hubstaff and work with Hubstaff in your FileMaker applications.
-
Automated ZohoPeople Data Replication to Teradata
Use CData Sync to Customize and automate ZohoPeople replication to Teradata.
-
Use the CData API Server to Access Google Campaign Manager 360 Data in Microsoft PowerPivot
Use the CData API Server to connect to live Google Campaign Manager 360 in the Power Pivot business intelligence tool.
-
Establish a Live Connection with Discord Data using Tableau Bridge
The CData ODBC Driver for Discord enables you to integrate live Discord into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous SuiteCRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Apache Kafka.
-
Publish Deel-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Deel.
-
Object-Relational Mapping (ORM) with Flowlu 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 Flowlu into a Java-based ORM framework, Hibernate.
-
DataBind Reckon Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Reckon with the DevExpress Windows Forms and Web controls to provide Reckon to a chart.
-
Query Customer.io Data as a MySQL Database in Node.js
Execute MySQL queries against Customer.io from Node.js.
-
Integrating GitHub Copilot CLI with LightSpeedRetail 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 Dataiku with Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Oracle Financials Cloud.
-
How to connect to Splunk Data in DBVisualizer
Integrate Splunk with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Neo4J Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Neo4J in Airbyte.
-
Extract, Transform, and Load Amplitude Data in Informatica PowerCenter
Create a simple Workflow for Amplitude in Informatica PowerCenter.
-
Migrating data from Smartsheet to Databricks using CData SSIS Components.
Easily push Smartsheet to Databricks using the CData SSIS Tasks for Smartsheet and Databricks.
-
How to Work with Codat Data in ETL Validator JDBC
Connect to Codat from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Power BI Reports on Real-Time Pinecone Data
Use the CData ODBC Driver for Pinecone to visualize Pinecone in Power BI Desktop.
-
Build Apps with Live Workday in Adalo using CData Connect AI
Use CData Connect AI to integrate live Workday into the Adalo platform and build custom mobile and web applications with real-time Workday.
-
Connect to GraphQL Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for GraphQL and the SQL Gateway to access GraphQL from Google Apps Script.
-
Enable the Codat JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Codat.
-
Connect to Oracle Eloqua Reporting in SpagoBI
Create reports featuring live Oracle Eloqua Reporting in SpagoBI Studio. Host Oracle Eloqua Reporting reports on SpagoBI Server.
-
Automated Continuous Basecamp Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Basecamp replication to PostgreSQL.
-
Write a Simple Go Application to work with LinkedIn Ads Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to LinkedIn Ads.
-
Replicate Multiple WordPress Accounts via the CData Sync CLI
Replicate multiple WordPress accounts to one or many databases.
-
Instantly Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Instantly facts in real time.
-
Import Facebook Data Using Azure Data Factory
Use CData Connect AI to connect to Facebook Data from Azure Data Factory and import live Facebook.
-
Connect to Salesforce CRM Analytics Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Salesforce CRM Analytics in the Denodo Virtual DataPort Administrator.
-
LINQ to Zoho Books 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 Zoho Books Data Provider.
-
Connect to HCL Domino Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for HCL Domino and the Script function in FileMaker Pro to connect to HCL Domino and work with HCL Domino in your FileMaker application.
-
DataBind Sendwithus Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Sendwithus to a chart.
-
How to Access Live YouTube Analytics Data in Power Automate Desktop via ODBC
The CData ODBC Driver for YouTube Analytics enables you to integrate YouTube Analytics into workflows built using Microsoft Power Automate Desktop.
-
Create a Data Access Object for Azure Analysis Services Data using JDBI
A brief overview of creating a SQL Object API for Azure Analysis Services in JDBI.
-
Getting Started with the CData Power BI Connector for Hive
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Hive.
-
How to Connect Flowise AI Agents to Live SurveyMonkey 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 SurveyMonkey without replication.
-
Connect to BambooHR Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for BambooHR and the SQL Gateway to access BambooHR from Google Apps Script.
-
Connect to Live PostgreSQL Data in MicroStrategy through CData Connect AI
Create a live connection to PostgreSQL Data in CData Connect AI and connect to your PostgreSQL from MicroStrategy.
-
Access HubDB Data from MySQL in PHP
Connect to HubDB through the standard MySQL libraries in PHP.
-
How to import Twitter Ads Data into Apache Solr
Use the CData Software JDBC Driver for Twitter Ads in Data Import Handler and create an automated import of Twitter Ads to Apache Solr Enterprise Search platform.
-
Bridge SAP Ariba Procurement Connectivity with Apache NiFi
Access and process SAP Ariba Procurement in Apache NiFi using the CData JDBC Driver.
-
Replicate Webex Data from PowerShell
Write a quick PowerShell script to query Webex. Use connectivity to the live data to replicate Webex to SQL Server.
-
Query Google Tasks Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Tasks.
-
How to create an RPA flow for Azure Table Data in UiPath Studio
Use the Azure Table ODBC Driver to create workflows that access real-time Azure Table Storage without any coding.
-
Excel Spreadsheet Automation on SAP HANA Data with the QUERY Formula
Pull data from SAP HANA, automate spreadsheets, and more with the QUERY formula.
-
Connect to Helpscout Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Helpscout using standard SQL.
-
Build a Simple VCL Application for RabbitMQ Data
How to build a simple VCL Application to view RabbitMQ in RAD Studio using the CData ODBC Driver for RabbitMQ.
-
Build Automated Workflows with Live Oracle Financials Cloud Data in Workato
Use CData Connect AI to connect to live Oracle Financials Cloud and build automated workflows in Workato.
-
Trigger SAP Hybris C4C IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SAP Hybris C4C with standard wizards in Logic Apps.
-
Back Up Harvest to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Harvest data.