CData Software - Knowledge Base
Recent Articles
-
How to Connect the Power BI Service to Gmail: Complete Guide
Connect to the CData Software Power BI Connector for Gmail from PowerBI.com to provide real-time Gmail data across the organization.
-
Build Charts with CircleCI Data in Clear Analytics
Create dynamic charts and perform analytics based on CircleCI data in Clear Analytics.
-
Create Power BI Reports on Real-Time BambooHR Data
Use the CData ODBC Driver for BambooHR to visualize BambooHR data in Power BI Desktop.
-
Build Semantic Layer Views for Mailjet Data in APOS Live Data Gateway
Use the CData Connector for Mailjet in APOS Live Data Gateway to build Semantic Layer Views for Mailjet data.
-
Build a PostgreSQL Interface for Jira Assets Data using the CData JDBC Driver
Use the Remoting features of the Jira Assets JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Gumloop with SAP Ariba Procurement Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP Ariba Procurement data within automated workflows.
-
Connect to SAP Business One Data in DBArtisan
Use wizards in DBArtisan to configure SAP Business One data as a data source.
-
Integrating GitHub Copilot with Stripe 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.
-
How to Work with Outlook Data in AWS Glue Jobs Using JDBC
Connect to Outlook from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Visualize Act CRM Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Act CRM data in Python.
-
Bridge Workday Connectivity with Apache NiFi
Access and process Workday data in Apache NiFi using the CData JDBC Driver.
-
Create Amazon S3-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Amazon S3 Data from Klipfolio and build custom visualizations using live Amazon S3 data.
-
Migrating data from Coinbase to Snowflake using CData SSIS Components.
Easily push Coinbase data to Snowflake using the CData SSIS Tasks for Coinbase and Snowflake.
-
Use the CData Software ODBC Driver for Jira in SAS for Real-Time Reporting and Analytics
Connect to real-time Jira data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Jira.
-
Replicate Multiple CouchDB Accounts
Replicate multiple CouchDB accounts to one or many databases.
-
Automated Continuous FreeAgent Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable FreeAgent replication to Apache Cassandra.
-
How to Connect to Live Google Calendar Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Google Calendar data for you.
-
Use Grok to Talk to Your eBay 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 eBay data for you.
-
Integrate Cursor with Live Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Oracle Eloqua data from within the editor.
-
How to Work with Bitly Data in ETL Validator JDBC
Connect to Bitly from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Data Flows from SQL Server to Bitbucket through SSIS
Easily push SQL Server data to Bitbucket using the CData SSIS Tasks for Bitbucket.
-
Visualize Live QuickBooks Online Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live QuickBooks Online data.
-
How to import Acumatica Data into Apache Solr
Use the CData Software JDBC Driver for Acumatica in Data Import Handler and create an automated import of Acumatica data to Apache Solr Enterprise Search platform.
-
Build Semantic Layer Views for ActiveCampaign Data in APOS Live Data Gateway
Use the CData Connector for ActiveCampaign in APOS Live Data Gateway to build Semantic Layer Views for ActiveCampaign data.
-
Automated Continuous Mailgun Replication to SingleStore
Use CData Sync for automated, continuous, customizable Mailgun replication to SingleStore.
-
Feed ElevenLabs Data into FineReport
How to set ElevenLabs data as a JDBC data source in FineReport.
-
Use Dash to Build Web Apps on Microsoft Planner Data via CData Connect AI
Build interactive Dash web apps on live Microsoft Planner data using pandas and the CData Connect AI Python SDK.
-
Integrating Cursor with Productboard 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.
-
Build a Singer.io Tap for MarkLogic With the CData Python Connector
Learn how to easily build a Singer.io Tap for live MarkLogic data using the CData Python Connector.
-
Query Cloudant Data in DataGrip
Create a Data Source for Cloudant in DataGrip and use SQL to query live Cloudant data.
-
Integrate Monday.com Data in the Pentaho Report Designer
Publish reports based on Monday.com data in the Pentaho BI tool.
-
Automated Continuous Timely Replication to Snowflake
Use CData Sync for automated, continuous, customizable Timely replication to Snowflake.
-
Build Dashboards with Odoo Data in Dundas BI
Create dynamic dashboards and perform analytics based on Odoo data in Dundas BI.
-
Connecting GenSpark with Google Calendar Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Google Calendar data without any replication or custom integration required.
-
Integrate Real-Time Access to Oracle in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Oracle data in real time.
-
Use Dash to Build Web Apps on Slack Data via CData Connect AI
Build interactive Dash web apps on live Slack data using pandas and the CData Connect AI Python SDK.
-
Build a Singer.io Tap for Freshsales With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Freshsales data using the CData Python Connector.
-
Analyze Live Email Data in SAS Viya
Use CData Connect AI to connect to Email data from SAS Viya and deploy self-service analytics using live Email data.
-
Replicate Sentry Data to Multiple Databases
Replicate Sentry data to disparate databases with a point-and-click configuration.
-
Connect to Real-Time Helpscout Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Helpscout data in Power Apps.
-
How to work with BigQuery Data in Apache Spark using SQL
Access and process BigQuery Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Microsoft Exchange Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft Exchange data in the Denodo Virtual DataPort Administrator.
-
How to Connect the Power BI Service to OpenWeatherMap: Complete Guide
Connect to the CData Software Power BI Connector for OpenWeatherMap from PowerBI.com to provide real-time OpenWeatherMap data across the organization.
-
Connect to Exact Online Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Exact Online Data and connect to Exact Online data in Akorbi Digital RunMyProcess.
-
Load Azure Table Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Azure Table data to a database.
-
How to Create Power BI Visual Reports with Real-Time Rootly Data
Use CData Power BI Connectors to visualize Rootly data in Power BI.
-
Connect Bitbucket Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Bitbucket data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
DataBind Charts to Quickbase Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Quickbase data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Automate VWO Data Replication to Azure Data Lake
Use CData Sync to customize and automate VWO data replication to Azure Data Lake.
-
Analyze Attio Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Attio data and visualize Attio data in SAP Analytics Cloud.
-
Integrate Live Microsoft Ads Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft Ads data to Blue Prism using the CData ODBC Driver for Microsoft Ads to create automated workflows for repetitive business tasks.
-
Configure the CData JDBC Driver for Google Spanner in a Connection Pool in Tomcat
Connect to Google Spanner data from a connection pool in Tomcat.
-
Automated Continuous PolarTeamPro Replication to MongoDB
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to MongoDB.
-
Use Dash to Build to Web Apps on MongoDB Data
Create Python applications that use pandas and Dash to build MongoDB-connected web apps.
-
Build Data Flows from SQL Server to XML through SSIS
Easily push SQL Server data to XML using the CData SSIS Tasks for XML.
-
Integrate Goose with Live Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Salesforce data from within the local AI agent.
-
Operational Reporting on Zoom Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Zoom data.
-
Access Live ServiceNow Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ServiceNow data from your Google Sheets.
-
Integrate Cursor with Live Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Gong data from within the editor.
-
Integrate Trae with Live DB2 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live DB2 data from within the AI-powered IDE.
-
Connect to Oracle Eloqua Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Oracle Eloqua Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Highrise Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Highrise and the Script function in FileMaker Pro to connect to Highrise and work with Highrise data in your FileMaker application.
-
Build Semantic Layer Views for CloudConvert Data in APOS Live Data Gateway
Use the CData Connector for CloudConvert in APOS Live Data Gateway to build Semantic Layer Views for CloudConvert data.
-
How to connect to Exa Data with Squirrel SQL client
Connect to Exa data and execute queries in the Squirrel SQL Client.
-
Automated Continuous Google Ad Manager Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to SQLite.
-
Visualize Xero Data in Sisense
Create an ElastiCube in Sisense app with access to Xero data.
-
Analyze SAP SuccessFactors Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP SuccessFactors data and visualize live SAP SuccessFactors data in Infragistics Reveal.
-
Visualize Live SageHR Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SageHR data.
-
Migrating data from Outlook to Databricks using CData SSIS Components.
Easily push Outlook data to Databricks using the CData SSIS Tasks for Outlook and Databricks.
-
How to use SQLAlchemy ORM to access Okta Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Okta data.
-
Integrate Live ServiceNow Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to ServiceNow data and integrate live ServiceNow data into apps built in Microsoft Power Apps.
-
How to Seamlessly Import CSV Data into IBM SPSS Modeler
Integrate CSV data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build a PostgreSQL Interface for CSV Data using the CData JDBC Driver
Use the Remoting features of the CSV JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Create Power BI Visual Reports with Real-Time Phoenix Data
Use CData Power BI Connectors to visualize Phoenix data in Power BI.
-
Connect to ZohoInvoice Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ZohoInvoice data in the Denodo Virtual DataPort Administrator.
-
Integrating Codex with AdRoll 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.
-
Analyze SAP Hybris C4C Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP Hybris C4C data and visualize live SAP Hybris C4C data in Infragistics Reveal.
-
View Reports on Real-Time Anaplan Data in Power BI Report Server
Use the CData ODBC Driver for Anaplan to visualize Anaplan data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build a Simple VCL Application for Humanity Data
How to build a simple VCL Application to view Humanity data in RAD Studio using the CData ODBC Driver for Humanity.
-
Create Reports from ServiceDesk Plus Data in Looker Studio
Use CData Connect AI to gain access to live ServiceDesk Plus data and create custom reports in Looker Studio.
-
Automated Continuous Spark Replication to Oracle
Use CData Sync for automated, continuous, customizable Spark replication to Oracle.
-
Connect to Real-Time Google Cloud Storage Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Cloud Storage and Dataflow to import and use Google Cloud Storage data in Power Apps.
-
Integrating LlamaIndex with Mailjet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Mailjet data in real time.
-
How to Connect to Live Salesforce CRM Analytics 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 Salesforce CRM Analytics data for you.
-
Getting Started with the CData Python Connector for Reply.io
Learn to install and license the CData Python Connector and configure a connection to live Reply.io data.
-
Create Informatica Mappings From/To a JDBC Data Source for Adobe Experience Manager
Create Adobe Experience Manager data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect to Google Translate Data from Spring Boot
Connect to Google Translate in a Spring Boot Application using the CData API Driver for JDBC
-
Use Dash to Build to Web Apps on Blackbaud FE NXT Data
Create Python applications that use pandas and Dash to build Blackbaud FE NXT-connected web apps.
-
Build Oracle-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Oracle data and build web apps with connectivity to live Oracle data.
-
Automated Continuous Dynamics NAV Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to IBM DB2.
-
How to connect Amazon QuickSight to Monday.com Data
Create a connection to Monday.com data in CData Connect AI and insert Monday.com data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Google Calendar Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Calendar data and integrate live Google Calendar data into your Power Automate tasks.
-
Automated Continuous WooCommerce Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable WooCommerce replication to Google BigQuery.
-
Automated Continuous Planio Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Planio data replication to OneLake in Microsoft Fabric.
-
Replicate SQL Server Data in Heroku for Use in Salesforce Connect
Replicate SQL Server data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Theia IDE with Live Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Oracle data from within the development environment.
-
Choosing the Best Method to Connect Acumatica to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Acumatica data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live Pipeline CRM Data in Coginiti Pro
Connect to and query live Pipeline CRM data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Using Cookie-Based Authentication with the CData SharePoint Data Provider.
The SharePoint Data Provider offers connectivity with an on-premise SharePoint Server as well as SharePoint Online and Office 365. This walk-through demonstrates how to properly authenticate and connect to SharePoint Online / Office 365.
-
Automated Continuous JSON Replication to Snowflake
Use CData Sync for automated, continuous, customizable JSON replication to Snowflake.