CData Software - Knowledge Base
Recent Articles
-
How to integrate Metabase with Sage Cloud Accounting Data
Use CData Connect AI to connect to live Sage Business Cloud Accounting and create an interactive dashboard in Metabase from Sage Business Cloud Accounting.
-
Build Semantic Layer Views for Azure Table Data in APOS Live Data Gateway
Use the CData Connector for Azure Table in APOS Live Data Gateway to build Semantic Layer Views for Azure Table Storage.
-
How to Create Power BI Visual Reports with Real-Time Tickspot Data
Use CData Power BI Connectors to visualize Tickspot in Power BI.
-
Automated Continuous Act-On Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Act-On replication to Azure SQL Database.
-
How to Work with Azure Data Lake Storage Data in AWS Glue Jobs Using JDBC
Connect to Azure Data Lake Storage from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Toggl Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Toggl facts in real time.
-
How to create Placid federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Placid in MySQL .
-
Access Live eBay Analytics Data in Coginiti Pro
Connect to and query live eBay Analytics from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Greenplum Data in Google Apps Script via Connect AI
Use CData Connect AI to access Pivotal GreenPlum in Google Apps Script.
-
Connect to Avalara AvaTax Data from HeidiSQL
Use CData Connect AI to connect to and query live Avalara AvaTax from HeidiSQL.
-
Connect to ZeroBounce Data in NetBeans
Connect to ZeroBounce in NetBeans with the data source configuration wizard.
-
Integrating OpenCode Terminal with Strava 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.
-
Connect and Visualize Live FTP Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live FTP Servers into the Databricks platform and create visualization dashboards with real-time FTP Servers.
-
How to Access Quickbase Data Using Entity Framework
This article shows how to access Quickbase using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Add Zendesk Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Zendesk with the Informatica Enterprise Data Catalog to classify and organize data.
-
LINQ to SQL Analysis Services 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 SQL Analysis Services Data Provider.
-
Integrate AlloyDB Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google AlloyDB from Informatica Cloud.
-
Import Acumatica Data Using Azure Data Factory
Use CData Connect AI to connect to Acumatica Data from Azure Data Factory and import live Acumatica ERP.
-
Use the CData Software ODBC Driver for Telegram in SAS for Real-Time Reporting and Analytics
Connect to real-time Telegram in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Telegram.
-
Integrate BigCommerce with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate BigCommerce with External Services.
-
Connect to Mistral AI in SpagoBI
Create reports featuring live Mistral AI in SpagoBI Studio. Host Mistral AI reports on SpagoBI Server.
-
Integrate YouTube Analytics Data in the Pentaho Report Designer
Publish reports based on YouTube Analytics in the Pentaho BI tool.
-
Connect to SharePoint Excel Services Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SharePoint Excel Services and the SQL Gateway to access SharePoint Excel Services from Google Apps Script.
-
Use the CData Software JDBC Driver for Elasticsearch in MicroStrategy
Connect to Elasticsearch in MicroStrategy Developer using the CData Software JDBC Driver for Elasticsearch.
-
Connect to Webex from a Connection Pool in WebLogic
Use the CData JDBC Driver for Webex to connect to Webex from Web applications running on WebLogic.
-
How to load Demio data into Elasticsearch via Logstash
Introducing a simple method to load Demio data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Visualize Google Ads Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Ads in Python.
-
Getting Started with the CData SSIS Components for Recurly
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Recurly.
-
Visualize Live Confluence Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Atlassian Confluence.
-
Connect to Adobe Target Data from PowerBuilder via JDBC
This article demonstrates how to access Adobe Target from PowerBuilder using the Adobe Target JDBC Driver.
-
Use the CData Software ODBC Driver for SparkPost in MicroStrategy Web
Connect to SparkPost in MicroStrategy Web using the CData Software ODBC Driver for SparkPost.
-
Connect to Amazon S3 Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Amazon S3.
-
Build Semantic Layer Views for Unbounce Data in APOS Live Data Gateway
Use the CData Connector for Unbounce in APOS Live Data Gateway to build Semantic Layer Views for Unbounce.
-
Visualize Live Microsoft OneDrive Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft OneDrive.
-
Automated Continuous ZohoMarketingHub Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to AlloyDB.
-
Build Epicor Kinetic Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Epicor Kinetic and build visualizations in Tableau Cloud.
-
Integrating Claude Code with Amazon Marketplace Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Amazon Marketplace within assisted coding and automated development workflows.
-
Automated Continuous Microsoft OneLake Replication to MongoDB
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to MongoDB.
-
Use the CData Software ODBC Driver for Close in MicroStrategy Desktop
Connect to Close in MicroStrategy Desktop using the CData Software ODBC Driver for Close.
-
Automate Omnisend Data Replication to Azure Data Lake
Use CData Sync to customize and automate Omnisend replication to Azure Data Lake.
-
Automated Continuous Zendesk Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Zendesk replication to Apache Cassandra.
-
Building Dynamic Web Pages with Google Sheets Data Using AngularJS
Create single-page applications with live connectivity to Google Sheets using the CData API Server.
-
Connect to CircleCI Data from PowerBuilder via JDBC
This article demonstrates how to access CircleCI from PowerBuilder using the CircleCI JDBC Driver.
-
Automated Continuous Recurly Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Recurly replication to Google Cloud SQL.
-
Connect to Sybase Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Sybase.
-
Connect to and Query Snowflake Data in QlikView over ODBC
Create data visualizations with Snowflake in QlikView.
-
Integrating LangGraph with Greenplum Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Pivotal GreenPlum within automated workflows.
-
Create SAS Data Sets-Connected Applications in Appsmith
Connect to SAS Data Sets Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAS Data Sets.
-
Replicate Multiple CapsuleCRM Accounts
Replicate multiple CapsuleCRM accounts to one or many databases.
-
Query Klaviyo Data in ColdFusion
Write standard ColdFusion data access code to connect to Klaviyo.
-
Use Azure AI Foundry to Talk to Your Sugar CRM 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 Sugar CRM for you.
-
Object-Relational Mapping (ORM) with Attio 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 Attio into a Java-based ORM framework, Hibernate.
-
Build a Singer.io Tap for Redis With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Redis data using
-
Integrate Opsgenie with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Opsgenie with External Services.
-
Import BambooHR Data Using Azure Data Factory
Use CData Connect AI to connect to BambooHR Data from Azure Data Factory and import live BambooHR.
-
Replicate Multiple Amplitude Accounts via the CData Sync CLI
Replicate multiple Amplitude accounts to one or many databases.
-
Integrating Antigravity CLI with Scrapfly via CData CLI
Connect Scrapfly to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to connect and process Oracle SCM from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle SCM.
-
Automated Continuous Workday Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Workday replication to Amazon Redshift.
-
Build Workable-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Workable.
-
Extract, Transform, and Load Contentful Data in Informatica PowerCenter
Create a simple Workflow for Contentful in Informatica PowerCenter.
-
Automated Continuous Power BI XMLA Replication to MySQL
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to MySQL.
-
How to Connect to Live SAP HANA Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP HANA securely in real time.
-
Replicate Multiple Supabase Accounts via the CData Sync CLI
Replicate multiple Supabase accounts to one or many databases.
-
Visualize Elasticsearch Data in Tableau
The CData ODBC driver for Elasticsearch enables you integrate Elasticsearch into Tableau dashboards.
-
Connect to Tickspot Data in NetBeans
Connect to Tickspot in NetBeans with the data source configuration wizard.
-
Migrating data from Zendesk to Google BigQuery using CData SSIS Components.
Easily push Zendesk to Google BigQuery using the CData SSIS Tasks for Zendesk and Google BigQuery.
-
Connect to Sage 300 Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Sage 300.
-
Integrate with Trello Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Trello in SnapLogic.
-
Import Real-Time Paylocity Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Paylocity in ColdFusion.
-
ETL BigQuery in Oracle Data Integrator
This article shows how to transfer Google BigQuery into a data warehouse using Oracle Data Integrator.
-
Integrate JDBC-ODBC Bridge Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live JDBC-ODBC Bridge from Informatica Cloud.
-
Create Sage 200-Connected Business Apps in AppSheet
Connect to Sage 200 Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Sage 200.
-
Connect to Amazon S3 Data in ACL Analytics
Connect to Amazon S3 via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Amazon S3.
-
Connect to SAP ByDesign Data in JRuby
Create a simple JRuby app with access to live SAP Business ByDesign.
-
How to Connect to LaunchDarkly Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to LaunchDarkly. Leverage the pyodbc module for ODBC in Python.
-
How to Easily Query Phoenix Data in OpenOffice Base
Connect to Phoenix data in OpenOffice Base using the CData ODBC Driver for Phoenix and generate reports with live data insights.
-
Replicate Multiple SuiteCRM Accounts via the CData Sync CLI
Replicate multiple SuiteCRM accounts to one or many databases.
-
Integrating GitHub Copilot CLI with Microsoft Ads 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.
-
Model Asana Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Asana, enabling the direct import of real-time Asana.
-
Automated Continuous ActiveCampaign Replication to MySQL
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to MySQL.
-
Create Dashboards and Visualize Live Gmail Data in Geckoboard
Use CData Connect AI to connect to live Gmail and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use the CData Software ODBC Driver for Impala in SAS for Real-Time Reporting and Analytics
Connect to real-time Apache Impala in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Impala.
-
Prepare, Blend, and Analyze Pipedrive Data in Alteryx Designer (ODBC)
Build workflows to access live Pipedrive for self-service data analytics.
-
Integrating SageHR Data in Talend Cloud Data Management Platform
Connect SageHR Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to ADP Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for ADP and the Script function in FileMaker Pro to connect to ADP and work with ADP in your FileMaker application.
-
View Reports on Real-Time Gmail Data in Power BI Report Server
Use the CData ODBC Driver for Gmail to visualize Gmail in Power BI Desktop and then publish them to Power BI Report Server.
-
Replicate Multiple Oracle Eloqua Reporting Accounts via the CData Sync CLI
Replicate multiple Oracle Eloqua Reporting accounts to one or many databases.
-
Import Real-Time Google Calendar Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Calendar in ColdFusion.
-
Build Apps with Live IBM Informix Data Using the Low-Code Development Platform of Mendix
Connect IBM Informix with Mendix to build apps using the CData JDBC Driver for IBM Informix.
-
Back Up SAP BusinessObjects BI to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP BusinessObjects BI. In this article, we will employ an SSIS workflow to populate a database with SAP BusinessObjects BI data.
-
Easily Integrate Short.io Data in Lazarus Pascal IDE
Learn how to easily integrate live Short.io in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating Codex CLI with SAP Business One 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.
-
Explore Geographical Relationships in AlloyDB Data with Power Map
Create data visualizations with Google AlloyDB in Power Map.
-
Use the CData Software JDBC Driver for Contentful in MicroStrategy Web
Connect to Contentful in MicroStrategy Web using the CData Software JDBC Driver for Contentful.
-
How to Query Live Box Data in Perplexity MacOS Desktop
Connect to and query live Box Data in Perplexity Desktop using CData MCP Server.
-
Build Dashboards with JobNimbus Data in DBxtra
Create dynamic dashboards and perform analytics based on JobNimbus in DBxtra.
-
Prepare, Blend, and Analyze Dynamics 365 Business Central Data in Alteryx Designer (Connect AI)
Build workflows to access live Dynamics 365 Business Central for self-service data analytics.
-
Build Apps with Live Box Data Using the Low-Code Development Platform of Mendix
Connect Box with Mendix to build apps using the CData JDBC Driver for Box.
-
LINQ to Brex 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 Brex Data Provider.