CData Software - Knowledge Base
Recent Articles
-
Visualize Amazon Athena Data in Sisense
Create an ElastiCube in Sisense app with access to Amazon Athena.
-
Excel Spreadsheet Automation on Act CRM Data with the QUERY Formula
Pull data from Act CRM, automate spreadsheets, and more with the QUERY formula.
-
Analyze HubSpot Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of HubSpot and visualize HubSpot in SAP Analytics Cloud.
-
Connect to Impala from a Connection Pool in WebLogic
Use the CData JDBC Driver for Impala to connect to Apache Impala from Web applications running on WebLogic.
-
Integrate Blackbaud FE NXT Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Blackbaud FE NXT and integrate live Blackbaud FE NXT into your Power Automate tasks.
-
Automated Continuous Twitter Ads Replication to SQL Server
Use CData Sync for automated, continuous, customizable Twitter Ads replication to SQL Server.
-
How to integrate Teradata with Apache Airflow
Access and process Teradata in Apache Airflow using the CData JDBC Driver.
-
Connect to Klipfolio Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Klipfolio in the Denodo Virtual DataPort Administrator.
-
Connect to PivotalTracker Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for PivotalTracker and the SQL Gateway to access PivotalTracker from Google Apps Script.
-
Build MarkLogic Visualizations in Tableau Cloud
Use CData Connect AI to connect to live MarkLogic and build visualizations in Tableau Cloud.
-
Query Sage Intacct Data as a MySQL Database in Node.js
Execute MySQL queries against Sage Intacct from Node.js.
-
How to Connect DBeaver to SQL Server via a JDBC Driver
Manage Microsoft SQL Server with visual tools in DBeaver like the query browser.
-
Getting Started with the CData ADO.NET Provider for FreshBooks
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Work with Suadeo Data in FoxPro
Load Suadeo into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Multiple EnterpriseDB Accounts via the CData Sync CLI
Replicate multiple EnterpriseDB accounts to one or many databases.
-
Analyze JSON Services in Infragistics Reveal
Use the CData API Server to create an OData API on top of JSON and visualize live JSON in Infragistics Reveal.
-
Connect to Zoho Projects Data in Claris FileMaker Pro
Use the CData ODBC Driver for Zoho Projects in FileMaker Pro to connect to Zoho Projects and work with Zoho Projects in your FileMaker applications.
-
Automate Exa Data Replication to Azure Synapse
Use CData Sync to customize and automate Exa replication to Azure Synapse.
-
Connect to Telegram Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Telegram and work with Telegram in your FileMaker applications.
-
How to import Google Ad Manager Data into Apache Solr
Use the CData Software JDBC Driver for Google Ad Manager in Data Import Handler and create an automated import of Google Ad Manager to Apache Solr Enterprise Search platform.
-
Automated Continuous Zuora Replication to MySQL
Use CData Sync for automated, continuous, customizable Zuora replication to MySQL.
-
Work with Cosmos DB Data in FoxPro
Load Azure Cosmos DB into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use Biml to Build SSIS Tasks to Replicate Cosmos DB Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Azure Cosmos DB to SQL Server.
-
Use Biml to Build SSIS Tasks to Replicate Placid Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Placid to SQL Server.
-
Connect to Supabase in SpagoBI
Create reports featuring live Supabase in SpagoBI Studio. Host Supabase reports on SpagoBI Server.
-
Connect to Reply.io Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Reply.io as an External Source in Dremio.
-
Connect to Real-Time BigCommerce Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for BigCommerce and Dataflow to import and use BigCommerce in Power Apps.
-
Automated Continuous SAP HANA Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP HANA replication to MySQL.
-
Back Up Keap 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 Keap data.
-
Integrating Boomi Agentstudio with ServiceNow Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to ServiceNow, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access Live Delighted Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Delighted into the statistical analysis tools available in SAS JMP. This article shows how to use Delighted in the Graph Builder and Query Builder.
-
Build Adobe Analytics Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Adobe Analytics and build visualizations in Tableau Cloud.
-
Use Microsoft Copilot Studio to talk to your FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your FHIR for you.
-
Build Microsoft Exchange Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft Exchange and build visualizations in Tableau.
-
Getting Started with the CData JDBC Driver for Amazon Marketplace
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Amazon Marketplace.
-
How to Connect to & Open Klipfolio Data in Microsoft Excel
This article uses the CData ODBC driver for Klipfolio to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to connect to Oracle Data from Spring Boot
Connect to Oracle in a Spring Boot Application using the CData JDBC Driver for Oracle
-
Work with Testmonitor Data in FoxPro
Load Testmonitor into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to CampaignMonitor from a Connection Pool in WebLogic
Use the CData JDBC Driver for CampaignMonitor to connect to CampaignMonitor from Web applications running on WebLogic.
-
Manage SageHR Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SageHR.
-
How to Analyze YouTube Audience Retention Data in Excel with CData
Seamlessly analyze and visualize YouTube audience retention data directly in Excel using the CData Excel Add-In.
-
Access Live SAP Concur Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SAP Concur data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Access Live BigQuery Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live BigQuery data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create Dynamic xBase Grids Using the Infragistics XamDataGrid
Learn how you can connect xBase to Infragistics XamDataGrid to build dynamic grids.
-
How to Connect to Live Oracle Eloqua Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Oracle Eloqua through natural language.
-
Create Data Visualizations in Cognos BI with Sendwithus Data
Access Sendwithus as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Rapidly Develop Reply.io-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 Reply.io.
-
Connect to PingOne Data in Jaspersoft Studio
Execute SQL to remote PingOne in Jaspersoft Studio.
-
Build Dashboards with ZohoExpense Data in Dundas BI
Create dynamic dashboards and perform analytics based on ZohoExpense in Dundas BI.
-
Create SSAS Tabular Models from Instagram Data
How to build a SQL Server Analysis Service Tabular Model from Instagram using CData drivers.
-
How to use SQLAlchemy ORM to access ConvertKit Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ConvertKit.
-
Build Zendesk-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Zendesk Data from Zoho Analytics and import live Zendesk.
-
Visualize Spotify Data in TIBCO Spotfire through ADO.NET
Integrate Spotify into dashboards in TIBCO Spotfire.
-
Analyze SAP Ariba Procurement Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP Ariba Procurement and visualize live SAP Ariba Procurement in Infragistics Reveal.
-
Viewing SparkPost Data in RAD Studio Data Explorer
How to view SparkPost in RAD Studio Data Explorer using the CData ODBC Driver for SparkPost.
-
DataBind SAP HANA XS Advanced Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP HANA XS Advanced with the DevExpress Windows Forms and Web controls to provide SAP HANA XS Advanced to a chart.
-
How to Build an ETL App for Stack Exchange Data in Python with CData
Create ETL applications and real-time data pipelines for Stack Exchange in Python with petl.
-
Use Grok to Talk to Your QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your QuickBooks Time for you.
-
Automated Continuous Airtable Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Airtable replication to Azure SQL Database.
-
Stream Reckon Data into Apache Kafka Topics
Access and stream Reckon in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Vault CRM Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Veeva Vault & Vault CRM through CData Connect AI using different applications and tools.
-
Deploy the ADO.NET Provider for Mailjet on an SSRS Report Server
Connect to Mailjet from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Use the CData Software JDBC Driver for ConstantContact in MicroStrategy Web
Connect to ConstantContact in MicroStrategy Web using the CData Software JDBC Driver for ConstantContact.
-
Working with HDFS Data in LINQPad
Execute LINQ queries to Apache HDFS in LINQPad.
-
Connect to Azure Data Lake Storage Data in JRuby
Create a simple JRuby app with access to live Azure Data Lake Storage.
-
Deploy the ADO.NET Provider for BigCommerce on an SSRS Report Server
Connect to BigCommerce from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Natively Connect to Figshare Data in PHP
The CData ODBC driver for Figshare enables you to create PHP applications with connectivity to Figshare. Leverage the native support for ODBC in PHP.
-
Connect to Sentry Data in CloverDX (formerly CloverETL)
Transfer Sentry using the visual workflow in the CloverDX data integration tool.
-
Extract, Transform, and Load Mode Data in Informatica PowerCenter
Create a simple Workflow for Mode in Informatica PowerCenter.
-
Connect to PivotalTracker Data in NetBeans
Connect to PivotalTracker in NetBeans with the data source configuration wizard.
-
Build Data Flows from SQL Server to Basecamp through SSIS
Easily push SQL Server data to Basecamp using the CData SSIS Tasks for Basecamp.
-
Access Live Oracle HCM Cloud Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Oracle HCM Cloud from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
ETL Google Ads in Oracle Data Integrator
This article shows how to transfer Google Ads into a data warehouse using Oracle Data Integrator.
-
Natively Connect to SurveyMonkey Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SurveyMonkey. Leverage the native support for ODBC in PHP.
-
Build a Simple VCL Application for Avalara AvaTax Data
How to build a simple VCL Application to view Avalara AvaTax in RAD Studio using the CData ODBC Driver for Avalara AvaTax.
-
Connect to Tavily Data from a Connection Pool in JBoss
Integrate Tavily into Java servlets: Use the Management Console in JBoss to install the Tavily JDBC Driver.
-
Use Agno to Talk to Your QuickBooks Online 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 QuickBooks Online for you.
-
Replicate Todoist Data from PowerShell
Write a quick PowerShell script to query Todoist. Use connectivity to the live data to replicate Todoist to SQL Server.
-
Integrate eBay with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate eBay with External Services.
-
Connect to Bright Data Data from PowerBuilder via JDBC
This article demonstrates how to access Bright Data from PowerBuilder using the Bright Data JDBC Driver.
-
DataBind Controls to Tanda Data in C++Builder
DataBind to Tanda in C++Builder with standard components and controls.
-
Access Couchbase 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 Couchbase.
-
Access Aweber Data from MySQL in PHP
Connect to Aweber through the standard MySQL libraries in PHP.
-
How to connect and process Microsoft SharePoint from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft SharePoint.
-
How to Connect to Live LinkedIn Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live LinkedIn securely in real time.
-
Automated Continuous Attio Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Attio replication to Apache Cassandra.
-
Connect to Live Azure Table Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Azure Table in CData Connect AI and connect to your Azure Table Storage from PostgreSQL.
-
Visualize Phoenix Data in Tableau
The CData ODBC driver for Phoenix enables you integrate Apache Phoenix into Tableau dashboards.
-
How to load Adobe Analytics data into Elasticsearch via Logstash
Introducing a simple method to load Adobe Analytics data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect and process Twitter Ads from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Twitter Ads.
-
How to Easily Query Oracle Financials Cloud Data in OpenOffice Base
Connect to Oracle Financials Cloud data in OpenOffice Base using the CData ODBC Driver for Oracle Financials Cloud and generate reports with live data insights.
-
How to connect and process Guru from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Guru.
-
Build Charts with IBM Cloud Object Storage Data in Clear Analytics
Create dynamic charts and perform analytics based on IBM Cloud Object Storage in Clear Analytics.
-
DataBind Mixpanel Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Mixpanel to a chart.
-
Create Data Visualizations Based On Adobe Analytics Data in Mode
Use CData Connect AI to connect to Adobe Analytics Data from Mode and build visualizations using live
-
Integrate Live Mocean Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Mocean to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating LangGraph with Procore Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Procore within automated workflows.
-
Integrate Spotify Data in the Pentaho Report Designer
Publish reports based on Spotify in the Pentaho BI tool.
-
Build Apps with Live Adobe Commerce in Adalo using CData Connect AI
Use CData Connect AI to integrate live Adobe Commerce into the Adalo platform and build custom mobile and web applications with real-time Adobe Commerce.
-
Integrate Mailjet Data in the Pentaho Report Designer
Publish reports based on Mailjet in the Pentaho BI tool.