CData Software - Knowledge Base
Recent Articles
-
Integrating Gumloop with Okta Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Okta within automated workflows.
-
Query SAP Ariba Source Data in DataGrip
Create a Data Source for SAP Ariba Source in DataGrip and use SQL to query live SAP Ariba Source.
-
How to Connect DBeaver to Jodoo via a JDBC Driver
Manage Jodoo with visual tools in DBeaver like the query browser.
-
Build BambooHR-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live BambooHR and build BambooHR-connected web apps with Axios.
-
Connect to Office 365 Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Microsoft Office 365.
-
How to connect to Odoo Data from IntelliJ
Integrate connectivity to Odoo ERP with wizards in IntelliJ.
-
How to Connect to Live Cosmos DB 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 Azure Cosmos DB through natural language.
-
Create Dynamic Printful Grids Using the Infragistics XamDataGrid
Learn how you can connect Printful to Infragistics XamDataGrid to build dynamic grids.
-
Getting Started with the CData Python Connector for Mailjet
Learn to install and license the CData Python Connector
-
Use the CData API Server to Access Google Cloud Storage Data in Microsoft PowerPivot
Use the CData API Server to connect to live Google Cloud Storage in the Power Pivot business intelligence tool.
-
How to Access Live SQL Server Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SQL Server enables you to integrate Microsoft SQL Server into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData Python Connector for Gmail
Learn to install and license the CData Python Connector
-
Analyze ShipStation Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ShipStation from Power Pivot. You will use the Table Import Wizard to load ShipStation. You can visually build the import query or use any SQL supported by the driver.
-
How to connect to PayPal Data with Squirrel SQL client
Connect to PayPal and execute queries in the Squirrel SQL Client.
-
Working with Factorial Data in LINQPad
Execute LINQ queries to Factorial in LINQPad.
-
Publish Reports with Okta Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Okta.
-
Create Data Visualizations in Cognos BI with LaunchDarkly Data
Access LaunchDarkly as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Access Replication to MySQL
Use CData Sync for automated, continuous, customizable Access replication to MySQL.
-
Work with Exact Online Data in FoxPro
Load Exact Online into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Data Visualizations Based On Google Cloud Storage Data in Mode
Use CData Connect AI to connect to Google Cloud Storage Data from Mode and build visualizations using live
-
How to Easily Query Toggl Data in OpenOffice Base
Connect to Toggl data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Publish SAP Hybris C4C-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP Hybris C4C.
-
Bridge Snapchat Ads Connectivity with Apache NiFi
Access and process Snapchat Ads in Apache NiFi using the CData JDBC Driver.
-
Connect to PDFMonkey Data from PowerBuilder via JDBC
This article demonstrates how to access PDFMonkey from PowerBuilder using the PDFMonkey JDBC Driver.
-
Connect to GitHub Data in DBeaver
Use the CData ODBC Driver to connect to GitHub in DBeaver.
-
How to connect SharePoint with Amazon Athena Data through external lists
Provide Amazon Athena to SharePoint users as an external list.
-
Connect to Planio Data in JRuby
Create a simple JRuby app with access to live Planio.
-
How to Work with Samanage Data in AWS Glue Jobs Using JDBC
Connect to Samanage from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate LeadDesk with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate LeadDesk with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to LeadDesk.
-
Use the CData Software JDBC Driver for Egnyte in MicroStrategy Web
Connect to Egnyte in MicroStrategy Web using the CData Software JDBC Driver for Egnyte.
-
How to connect to Gumroad Data from Spring Boot
Connect to Gumroad in a Spring Boot Application using the CData API Driver for JDBC
-
Analyze Live Azure Analysis Services Data in SAS Viya
Use CData Connect AI to connect to Azure Analysis Services from SAS Viya and deploy self-service analytics using live Azure Analysis Services.
-
How to Access Live Workday Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Workday enables you to integrate Workday into workflows built using Microsoft Power Automate Desktop.
-
Access Live Google Calendar Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Google Calendar through MCP integration.
-
Use the CData ODBC Driver for EnterpriseDB in Microsoft Power Query
You can use the CData EnterpriseDB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import EnterpriseDB into Microsoft Power Query.
-
Create a Data Access Object for ZohoSubscriptions Data using JDBI
A brief overview of creating a SQL Object API for ZohoSubscriptions in JDBI.
-
Build Google Ad Manager-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Google Ad Manager to explore live Google Ad Manager Data in Claude Code to assist with building Google Ad Manager-powered applications.
-
Import Klaviyo Data Using Azure Data Factory
Use CData Connect AI to connect to Klaviyo Data from Azure Data Factory and import live Klaviyo.
-
Connect to Vault CRM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Veeva Vault & Vault CRM using standard SQL.
-
Automated Continuous XML Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable XML Files replication to OneLake in Microsoft Fabric.
-
Automate REST Integration Tasks from PowerShell
Are you in search of a quick and easy way to access REST from PowerShell? This article demonstrates how to utilize the REST Cmdlets for tasks like connecting to REST, automating operations, downloading data, and more.
-
Connect to Real-Time Elorus Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Elorus in Power Apps.
-
Operational Reporting on Close Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Close.
-
Use the CData ODBC Driver for SAP Business One from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP Business One to connect to SAP Business One from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP Business One in Excel.
-
Extend Google Sheets with Lakebase Data
Make calls to Lakebase from Google Apps Script via the API Server.
-
Connect to Avro 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 Apache Avro.
-
How to create an RPA flow for Gmail Data in UiPath Studio
Use the Gmail ODBC Driver to create workflows that access real-time Gmail without any coding.
-
A PostgreSQL Interface for BambooHR Data using the CData ODBC Driver
Use the SQL Gateway and BambooHR ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Mailjet in MicroStrategy Desktop
Connect to Mailjet in MicroStrategy Desktop using the CData Software ODBC Driver for Mailjet.
-
Connect to Vimeo Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Vimeo and work with Vimeo in your FileMaker application.
-
Use Dash to Build Web Apps on SAP Business One Data via CData Connect AI
Build interactive Dash web apps on live SAP Business One using pandas and the CData Connect AI Python SDK.
-
Create Reckon Accounts Hosted Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Reckon Accounts Hosted from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Data Flows from Google Tasks to SQL Server using SSIS
Easily back up Google Tasks to SQL Server using the SSIS components for Google Tasks.
-
Create Informatica Mappings From/To an ODBC Data Source for AgileCRM
Create an ODBC connection to AgileCRM in Informatica and browse and transfer AgileCRM.
-
Validate ElevenLabs Data with QuerySurge
Access and validate ElevenLabs in QuerySurge using the CData JDBC Driver.
-
Write a Simple Go Application to work with ScrapingBee Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ScrapingBee.
-
Replicate Multiple Teamgate Accounts via the CData Sync CLI
Replicate multiple Teamgate accounts to one or many databases.
-
Access Live Sybase IQ Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Sybase IQ through MCP integration.
-
Bridge Recurly Connectivity with Apache NiFi
Access and process Recurly in Apache NiFi using the CData JDBC Driver.
-
DataBind Controls to Mode Data in Delphi
DataBind to Mode in Delphi with standard data access components and controls.
-
SuiteCRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SuiteCRM facts in real time.
-
Viewing SAP HANA XS Advanced Data in RAD Studio Data Explorer
How to view SAP HANA XS Advanced in RAD Studio Data Explorer using the CData ODBC Driver for SAP HANA XS Advanced.
-
Use the CData Software JDBC Driver for Twitter Ads in MicroStrategy
Connect to Twitter Ads in MicroStrategy Developer using the CData Software JDBC Driver for Twitter Ads.
-
Connect to ChargeOver Data in DBArtisan
Use wizards in DBArtisan to configure ChargeOver as a data source.
-
Connecting Pipedream with SQL Server Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on SQL Server data in real time.
-
Use Dash to Build to Web Apps on NASA Data
Create Python applications that use pandas and Dash to build NASA-connected web apps.
-
Create Lakebase-Connected Applications in Appsmith
Connect to Lakebase Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Lakebase.
-
Connect to Real-Time Pingdom Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Pingdom in Power Apps.
-
How to Import Data from SQL Analysis Services into Google Sheets
Import SQL Analysis Services into a Google spreadsheet that is automatically refreshed.
-
Facebook Reporting in OBIEE with the Facebook JDBC Driver
Deploy the Facebook JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Asana Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Asana replication to Apache Kafka.
-
Automated Continuous Cloudflare Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Cloudflare replication to Azure SQL Database.
-
Build MVC Applications with Connectivity to OpenWeatherMap Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access OpenWeatherMap from an ASP.NET MVC application.
-
Choosing the Best Method to Connect Greenhouse to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Greenhouse from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous AfterShip Replication to SQL Server
Use CData Sync for automated, continuous, customizable AfterShip replication to SQL Server.
-
Integrate with Office 365 Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Microsoft Office 365 in SnapLogic.
-
Add Sentry Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Sentry with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect to Pingdom Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Pingdom. Leverage the pyodbc module for ODBC in Python.
-
Create a Data Access Object for Toggl Data using JDBI
A brief overview of creating a SQL Object API for Toggl in JDBI.
-
Connect to SAS Data Sets Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SAS Data Sets Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build SAS xpt-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAS xpt Data and create custom apps in Bubble.
-
Automated Continuous Dotmailer Replication to SingleStore
Use CData Sync for automated, continuous, customizable Dotmailer replication to SingleStore.
-
Connect to Excel Online Data from a Connection Pool in Jetty
The Excel Online JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Excel Online from Web apps in Jetty.
-
Connect to Exa Data from PowerBuilder via ADO.NET
This article demonstrates how to access Exa from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Validate Workable Data with QuerySurge
Access and validate Workable in QuerySurge using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Tanda in MicroStrategy Web
Connect to Tanda in MicroStrategy Web using the CData Software JDBC Driver for Tanda.
-
Connect to FreeAgent Data in NetBeans
Connect to FreeAgent in NetBeans with the data source configuration wizard.
-
How to create Visio diagrams from Microsoft Dataverse Data
Automatically update Microsoft Dataverse (CDS) with the changes you make to Visio master shapes.
-
Integrate Cursor with Live SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP Business ByDesign from within the editor.
-
Access Pipedrive Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Pipedrive from HeidiSQL.
-
Build Apps with Live Microsoft Excel Online in Adalo using CData Connect AI
Use CData Connect AI to integrate live Microsoft Excel Online into the Adalo platform and build custom mobile and web applications with real-time Microsoft Excel Online.
-
Query Suadeo Data in DataGrip
Create a Data Source for Suadeo in DataGrip and use SQL to query live Suadeo.
-
Automated Continuous GitHub Replication to IBM DB2
Use CData Sync for automated, continuous, customizable GitHub replication to IBM DB2.
-
Visualize WordPress Data in Sisense
Create an ElastiCube in Sisense app with access to WordPress.
-
Create Data Visualizations in Cognos BI with Paddle Data
Access Paddle as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software ODBC Driver for Eventbrite in MicroStrategy Web
Connect to Eventbrite in MicroStrategy Web using the CData Software ODBC Driver for Eventbrite.
-
Access Live Azure Data Catalog Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Azure Data Catalog into the statistical analysis tools available in SAS JMP. This article shows how to use Azure Data Catalog in the Graph Builder and Query Builder.
-
Analyze Couchbase Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Couchbase and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Oracle HCM Cloud Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Oracle HCM Cloud Data and connect to Oracle HCM Cloud in Akorbi Digital RunMyProcess.
-
Bidirectional Access to Timely Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Timely in Filemaker Pro for Mac or Windows.