CData Software - Knowledge Base
Recent Articles
-
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 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.
-
Integrating Antigravity CLI with SAP ERP/NetWeaver via CData CLI
Connect SAP ERP/NetWeaver 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 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 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.
-
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 and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for Yelp in MicroStrategy Web
Connect to Yelp 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 Amazon Redshift 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.
-
Easily Integrate Mocean Data in Lazarus Pascal IDE
Learn how to easily integrate live Mocean 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 for you.
-
Migrating data from Mocean to Snowflake using CData SSIS Components.
Easily push Mocean to Snowflake using the CData SSIS Tasks for Mocean and Snowflake.
-
Visualize Act-On Data in TIBCO Spotfire through ADO.NET
Integrate Act-On 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 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 in your FileMaker application.
-
Connect to ADP Data from AWS Glue
Use CData Connect AI to gain access to live ADP 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 in Power BI.
-
Use the CData Software ODBC Driver for Autopilot in MicroStrategy Web
Connect to Autopilot 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.
-
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 Apache Phoenix 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 Apache Kafka 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 into the statistical analysis tools available in SAS JMP. This article shows how to use SAP Business Warehouse in the Graph Builder and Query Builder.
-
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 from Google Apps Script.
-
Create SSAS Tabular Models from VWO Data
How to build a SQL Server Analysis Service Tabular Model from VWO 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 ERP/NetWeaver 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. 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 in Python.
-
Access Live ServiceNow Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to ServiceNow 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 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.
-
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 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
-
ETL Twitter Ads in Oracle Data Integrator
This article shows how to transfer Twitter Ads 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 Apache Phoenix.
-
Getting Started with the CData Python Connector for Outreach.io
Learn to install and license the CData Python Connector
-
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 using the CData Python MCP Server.
-
How to connect to Perigon Data in DBVisualizer
Integrate Perigon 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 in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Pingdom.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Azure Synapse to Power BI dashboards. Simply drag and drop Azure Synapse into data visuals on the Power BI canvas.
-
Explore Geographical Relationships in AdRoll Data with Power Map
Create data visualizations with AdRoll in Power Map.
-
Query Egnyte Data as a MySQL Database in Node.js
Execute MySQL queries against Egnyte 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 Amazon Redshift.
-
Automate Tasks in Power Automate Using the CData API Server
Automate ActiveCampaign actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connect to and Query Oracle Eloqua Reporting Data in QlikView over ODBC
Create data visualizations with Oracle Eloqua Reporting in QlikView.
-
How to Import Data from LinkedIn into Google Sheets
Import LinkedIn into a Google spreadsheet that is automatically refreshed.
-
Build SAS Data Sets-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SAS Data Sets to explore live SAS Data Sets Data in Gemini Code Assist to assist with building SAS Data Sets-powered applications.
-
Replicate Adobe Target Data from PowerShell
Write a quick PowerShell script to query Adobe Target. Use connectivity to the live data to replicate Adobe Target to SQL Server.
-
Access Live Cassandra Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache Cassandra 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 from Web applications running on WebLogic.
-
Build Dashboards with QuickBooks Online Data in DBxtra
Create dynamic dashboards and perform analytics based on QuickBooks Online 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.
-
Analyze Salesforce CRM Analytics Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Salesforce CRM Analytics and visualize Salesforce CRM Analytics 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.
-
Connect to Stripe Data in Google Apps Script via Connect AI
Use CData Connect AI to access Stripe 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 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, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to PostgreSQL Data in Aqua Data Studio
Access PostgreSQL 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 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zuora in Excel.
-
Integrate Live CapsuleCRM Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live CapsuleCRM 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 to a database.
-
Connect to Adobe Analytics Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Adobe Analytics 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 in MySQL .
-
Migrating data from Todoist to Google BigQuery using CData SSIS Components.
Easily push Todoist 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 Desktop 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 for you.
-
Automated Continuous SendPulse Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SendPulse replication to OneLake in Microsoft Fabric.
-
Create Twilio-Connected Dashboards in Grafana
Connect to Twilio Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Twilio.
-
How to Query Square Data in MySQL Workbench
Execute MySQL queries against live Square from MySQL Workbench.
-
Use Azure AI Foundry to Talk to Your Azure Analysis Services 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 Azure Analysis Services for you.
-
Connect to Amazon Athena Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Amazon Athena to connect to Amazon Athena and execute queries in PowerBuilder.
-
Automated Continuous Procore Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Procore replication to Google BigQuery.
-
Create Zoho CRM-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Zoho CRM Data from OutSystems and build custom enterprise apps using live Zoho CRM.
-
Build Semantic Layer Views for JobNimbus Data in APOS Live Data Gateway
Use the CData Connector for JobNimbus in APOS Live Data Gateway to build Semantic Layer Views for JobNimbus.
-
A PostgreSQL Interface for BigQuery Data using the CData ODBC Driver
Use the SQL Gateway and BigQuery ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating LangChain with Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Oracle SCM within automated workflows.
-
LINQ to Azure 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 Azure Analysis Services Data Provider.
-
Build Dashboards with EnterpriseDB Data in Dundas BI
Create dynamic dashboards and perform analytics based on EnterpriseDB in Dundas BI.
-
Use the CData Software JDBC Driver for CockroachDB in MicroStrategy
Connect to CockroachDB in MicroStrategy Developer using the CData Software JDBC Driver for CockroachDB.
-
Query JobNimbus Data in ColdFusion
Write standard ColdFusion data access code to connect to JobNimbus.
-
Publish FHIR-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live FHIR.
-
Import Real-Time Freshsales Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Freshsales in ColdFusion.
-
Connect to CampaignMonitor from Asprova with CData Software ODBC Driver for CampaignMonitor
This article shows how to connect faster to CampaignMonitor data from Asprova.
-
Build Dashboards with LaunchDarkly Data in DBxtra
Create dynamic dashboards and perform analytics based on LaunchDarkly in DBxtra.
-
Visualize Live SAP Business One Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Business One.
-
Configure the CData JDBC Driver for Copper in a Connection Pool in Tomcat
Connect to Copper from a connection pool in Tomcat.
-
How to Connect to Live Sage 200 Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Sage 200 for you.
-
Replicate Dotmailer Data in Heroku for Use in Salesforce Connect
Replicate Dotmailer to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Live Sybase IQ Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Sybase IQ and integrate live Sybase IQ into apps built in Microsoft Power Apps.