CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Dropbox Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Dropbox data in ColdFusion.
-
Build ShipStation-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to ShipStation Data from Zoho Analytics and import live ShipStation data.
-
Add Reckon Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Reckon with the Informatica Enterprise Data Catalog to classify and organize data.
-
Replicate Oracle Eloqua Data in Heroku for Use in Salesforce Connect
Replicate Oracle Eloqua data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Workday Data in HULFT Integrate
Connect to Workday as a JDBC data source in HULFT Integrate
-
Connect to Live Spark Data in MicroStrategy through CData Connect AI
Create a live connection to Spark Data in CData Connect AI and connect to your Spark data from MicroStrategy.
-
Build Apps with Live Omnisend Data Using the Low-Code Development Platform of Mendix
Connect Omnisend data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Oracle SCM Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Oracle SCM data.
-
Choosing the Best Method to Connect SpaceX to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SpaceX data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Live Campaigner Data in MicroStrategy through CData Connect AI
Create a live connection to Campaigner Data in CData Connect AI and connect to your Campaigner data from MicroStrategy.
-
Build Dashboards with Planio Data in DBxtra
Create dynamic dashboards and perform analytics based on Planio data in DBxtra.
-
How to Work with Box Data in ETL Validator JDBC
Connect to Box from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect PolyBase to Wave Financial
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Wave Financial data.
-
Build NetSuite-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live NetSuite data.
-
Create Power BI Reports on Real-Time Presto Data
Use the CData ODBC Driver for Presto to visualize Presto data in Power BI Desktop.
-
WooCommerce Reporting in OBIEE with the WooCommerce JDBC Driver
Deploy the WooCommerce JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Paylocity-Connected Apps in Choreo
Use CData Connect AI to connect to Paylocity Data from Choreo and build custom apps using live Paylocity data.
-
Connecting Agentforce with Zoho Books 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 Zoho Books data for you.
-
Work with Live Google Cloud Storage Data in Power Query
Use CData Connect AI to connect to Google Cloud Storage data and work with live Google Cloud Storage data in Microsoft Power Query.
-
Connect to Cvent Data in RazorSQL
Connect to Cvent from wizards and query Cvent data from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData SSIS Components for ShipStation
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ShipStation.
-
Automated Continuous Yelp Replication to Databricks
Use CData Sync for automated, continuous, customizable Yelp replication to Databricks.
-
Connect to Google Sheets Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Sheets data in the Denodo Virtual DataPort Administrator.
-
Getting Started with the CData Excel Add-In for NetSuite
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for NetSuite.
-
Build Quickbase-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Quickbase data.
-
Integrating Antigravity CLI with SAP data via CData CLI
Connect SAP data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous iContact Replication to SQL Server
Use CData Sync for automated, continuous, customizable iContact replication to SQL Server.
-
How to work with Microsoft Planner Data in Apache Spark using SQL
Access and process Microsoft Planner Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Monday.com Data in Google Apps Script via Connect AI
Use CData Connect AI to access Monday.com data in Google Apps Script.
-
Integrate Cursor with Live SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SendGrid data from within the editor.
-
Getting Started with the CData Power BI Connector for Teamwork
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automated Continuous Productboard Replication to Snowflake
Use CData Sync for automated, continuous, customizable Productboard replication to Snowflake.
-
Add Square Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Square with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Bitbucket Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Bitbucket to connect to Bitbucket data and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for Yelp in MicroStrategy Web
Connect to Yelp data in MicroStrategy Web using the CData Software ODBC Driver for Yelp.
-
Getting Started with the CData SSIS Components for Zuora
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Zuora.
-
Visualize Redshift Data in Tableau
The CData ODBC driver for Redshift enables you integrate Redshift data into Tableau dashboards.
-
Create Vertica-Connected Nintex Workflows
Use CData Connect AI to connect to Vertica Data from Nintex Workflow Cloud and build custom workflows using live Vertica data.
-
Easily Integrate Mocean Data in Lazarus Pascal IDE
Learn how to easily integrate live Mocean data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use Databricks Agent Bricks to Talk to Your Greenhouse Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Greenhouse data for you.
-
Integrate OpenCode with Live BenchmarkEmail Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live BenchmarkEmail data from within your AI coding agent.
-
Migrating data from Mocean to Snowflake using CData SSIS Components.
Easily push Mocean data to Snowflake using the CData SSIS Tasks for Mocean and Snowflake.
-
Visualize Act-On Data in TIBCO Spotfire through ADO.NET
Integrate Act-On data into dashboards in TIBCO Spotfire.
-
Connect to Real-Time Teamwork Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Teamwork data in Power Apps.
-
Connect to Shopify Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Shopify and the Script function in FileMaker Pro to connect to Shopify and work with Shopify data in your FileMaker application.
-
Connect to ADP Data from AWS Glue
Use CData Connect AI to gain access to live ADP data from your AWS Glue jobs.
-
How to Create Power BI Visual Reports with Real-Time Amplitude Data
Use CData Power BI Connectors to visualize Amplitude data in Power BI.
-
Use the CData Software ODBC Driver for Autopilot in MicroStrategy Web
Connect to Autopilot data in MicroStrategy Web using the CData Software ODBC Driver for Autopilot.
-
Using the CData Software ODBC Driver for Guru in PyCharm
Connect to Guru as an ODBC data source in PyCharm using the CData Software ODBC Driver for Guru.
-
Query Live Gmail Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Gmail data through a conversational interface.
-
Create Datasets from Phoenix in Domo Workbench and Build Visualizations of Phoenix Data in Domo
Use the CData Software ODBC Driver for Phoenix to create datasets from Phoenix data in Domo Workbench and then build visualizations in the Domo service.
-
Configure the CData JDBC Driver for Kafka in a Connection Pool in Tomcat
Connect to Kafka data from a connection pool in Tomcat.
-
Access Live SAP Business Warehouse Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP Business Warehouse data into the statistical analysis tools available in SAS JMP. This article shows how to use SAP Business Warehouse data in the Graph Builder and Query Builder.
-
Model, Search, and Visualize Live SageHR Data in ThoughtSpot
Use CData Connect AI to connect to live SageHR data for modeling, searching, and visualizing.
-
Connect to Adobe Experience Manager Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Adobe Experience Manager and the SQL Gateway to access Adobe Experience Manager data from Google Apps Script.
-
Create SSAS Tabular Models from VWO Data
How to build a SQL Server Analysis Service Tabular Model from VWO data using CData drivers.
-
Object-Relational Mapping (ORM) with SAP 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 SAP data into a Java-based ORM framework, Hibernate.
-
Analyze Teradata Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Teradata from Power Pivot. You will use the Table Import Wizard to load Teradata data. You can visually build the import query or use any SQL supported by the driver.
-
How to Visualize Google Calendar Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Calendar data in Python.
-
Access Live ServiceNow Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to ServiceNow data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Data Flows from MongoDB to SQL Server using SSIS
Easily back up MongoDB data to SQL Server using the SSIS components for MongoDB.
-
Build Semantic Layer Views for Freshservice Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Freshservice data.
-
Connect to Notion Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Notion data from Filemaker Pro on Mac.
-
Connect to Airtable Data from a Connection Pool in Jetty
The Airtable JDBC Driver supports connection pooling: This article shows how to connect faster to Airtable data from Web apps in Jetty.
-
Automated Continuous Excel Online Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Excel Online replication to Amazon Redshift.
-
Bind Live Azure Table Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Azure Table data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
ETL Twitter Ads in Oracle Data Integrator
This article shows how to transfer Twitter Ads data into a data warehouse using Oracle Data Integrator.
-
Build Phoenix-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Phoenix data.
-
Getting Started with the CData Python Connector for Outreach.io
Learn to install and license the CData Python Connector and configure a connection to live Outreach.io data.
-
Connect SAP Concur to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP Concur data using the CData Python MCP Server.
-
Build Perplexity-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Perplexity Data and create custom apps in Bubble.
-
How to connect to Perigon Data in DBVisualizer
Integrate Perigon data with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software ODBC Driver for Pingdom in SAS for Real-Time Reporting and Analytics
Connect to real-time Pingdom data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Pingdom.
-
Explore Geographical Relationships in AdRoll Data with Power Map
Create data visualizations with AdRoll data in Power Map.
-
Query Egnyte Data as a MySQL Database in Node.js
Execute MySQL queries against Egnyte data from Node.js.
-
Automated Continuous Freshservice Replication to SQLite
Use CData Sync for automated, continuous, customizable Freshservice replication to SQLite.
-
Create Redshift-Connected Nintex Workflows
Use CData Connect AI to connect to Redshift Data from Nintex Workflow Cloud and build custom workflows using live Redshift data.
-
Connect to and Query Oracle Eloqua Reporting Data in QlikView over ODBC
Create data visualizations with Oracle Eloqua Reporting data in QlikView.
-
Replicate Adobe Target Data from PowerShell
Write a quick PowerShell script to query Adobe Target data. Use connectivity to the live data to replicate Adobe Target data to SQL Server.
-
Access Live Cassandra Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Cassandra data from your Google Sheets.
-
Connect to Act CRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Act CRM to connect to Act CRM data from Web applications running on WebLogic.
-
Build Figshare-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Figshare Data and create custom apps in Mendix.
-
Build Dashboards with QuickBooks Online Data in DBxtra
Create dynamic dashboards and perform analytics based on QuickBooks Online data in DBxtra.
-
Integrate Bannerbear with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Bannerbear with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Bannerbear data.
-
Analyze Salesforce CRM Analytics Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Salesforce CRM Analytics data and visualize Salesforce CRM Analytics data in SAP Analytics Cloud.
-
Use JayDeBeApi to access BigCommerce Data in Python
Use standard Python scripting and the development environment of your choice to access live BigCommerce data.
-
Connect to Stripe Data in Google Apps Script via Connect AI
Use CData Connect AI to access Stripe data in Google Apps Script.
-
Choosing the Best Method to Connect Elorus to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Elorus data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Lakebase from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Lakebase data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to PostgreSQL Data in Aqua Data Studio
Access PostgreSQL data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData ODBC Driver for Zuora from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Zuora to connect to Zuora data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zuora data in Excel.
-
Integrate Live CapsuleCRM Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live CapsuleCRM data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Load MailChimp Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load MailChimp data to a database.
-
Connect to Adobe Analytics Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Adobe Analytics data in Airbyte.
-
Use the CData SSIS Components to Insert New or Update Existing Airtable Records from SQL Server
Easily push SQL Server data to Airtable using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Airtable or update existing records with data from a SQL Server database.
-
Automated Continuous SAP HANA Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP HANA replication to IBM DB2.
-
How to create Keap federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Keap data in MySQL .
-
Migrating data from Todoist to Google BigQuery using CData SSIS Components.
Easily push Todoist data to Google BigQuery using the CData SSIS Tasks for Todoist and Google BigQuery.
-
Visualize Live QuickBooks Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live QuickBooks data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Agno to Talk to Your Amazon Athena 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 Amazon Athena data for you.