CData Software - Knowledge Base
Recent Articles
-
Analyze Confluence Data in Cognos Analytics
Use CData Connect AI to connect to Confluence Data from Cognos Analytics and analyze live Atlassian Confluence.
-
Enable the Outlook JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Outlook.
-
Connecting Mastra with Act-On Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Act-On, no replication required.
-
Natively Connect to Cvent Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Cvent. Leverage the native support for ODBC in PHP.
-
Integrate Live Twilio Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Twilio and integrate live Twilio into apps built in Microsoft Power Apps.
-
Use Dash to Build to Web Apps on Trello Data
Create Python applications that use pandas and Dash to build Trello-connected web apps.
-
How to Connect to QuickBooks Time Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to QuickBooks Time. Leverage the pyodbc module for ODBC in Python.
-
How to work with Instagram Data in Apache Spark using SQL
Access and process Instagram Data in Apache Spark using the CData Software JDBC Driver.
-
Seamlessly Bring IBM Cloud Object Storage Data into Retool Using CData Connect AI
Integrate IBM Cloud Object Storage data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Connect to Live Microsoft Entra ID 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 Microsoft Entra ID through natural language.
-
Build a PostgreSQL Interface for Oracle Eloqua Reporting Data using the CData JDBC Driver
Use the Remoting features of the Oracle Eloqua Reporting JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Certinia Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Certinia as an External Source in Dremio.
-
Use the CData Software ODBC Driver for Dropbox in MicroStrategy Desktop
Connect to Dropbox in MicroStrategy Desktop using the CData Software ODBC Driver for Dropbox.
-
Connect to Freshdesk Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Freshdesk and the Script function in FileMaker Pro to connect to Freshdesk and work with Freshdesk in your FileMaker application.
-
Integrate Nuclia Data in the Pentaho Report Designer
Publish reports based on Nuclia in the Pentaho BI tool.
-
How to use SQLAlchemy ORM to access Ontraport Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Ontraport.
-
Viewing Dynamics 365 Business Central Data in RAD Studio Data Explorer
How to view Dynamics 365 Business Central in RAD Studio Data Explorer using the CData ODBC Driver for Dynamics 365 Business Central.
-
How to connect to Optimizely Data with Squirrel SQL client
Connect to Optimizely and execute queries in the Squirrel SQL Client.
-
Replicate Sage Cloud Accounting Data from PowerShell
Write a quick PowerShell script to query Sage Business Cloud Accounting. Use connectivity to the live data to replicate Sage Business Cloud Accounting to SQL Server.
-
Connect to Discourse Data in RazorSQL
Connect to Discourse from wizards and query Discourse from the GUI in the RazorSQL database management tool.
-
Query Salesforce Marketing Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Salesforce Marketing entities in PHP by modeling them as objects.
-
Use the CData ODBC Driver for AfterShip in Microsoft Power Query
You can use the CData AfterShip ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import AfterShip into Microsoft Power Query.
-
Connect to Dynamics CRM Data from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Dynamics CRM from HeidiSQL.
-
Configure the CData JDBC Driver for Dynamics NAV in a Connection Pool in Tomcat
Connect to Microsoft Dynamics NAV from a connection pool in Tomcat.
-
Analyze Google Directory Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google Directory and visualize live Google Directory in Infragistics Reveal.
-
Build Snowflake-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Snowflake Data from Zoho Analytics and import live Snowflake.
-
Create Informatica Mappings From/To a JDBC Data Source for MailChimp
Create MailChimp data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Natively Connect to Amazon S3 Data in PHP
The CData ODBC driver for Amazon S3 enables you to create PHP applications with connectivity to Amazon S3. Leverage the native support for ODBC in PHP.
-
Import eBay Data Using Azure Data Factory
Use CData Connect AI to connect to eBay Data from Azure Data Factory and import live eBay.
-
Create SSAS Tabular Models from Qualaroo Data
How to build a SQL Server Analysis Service Tabular Model from Qualaroo using CData drivers.
-
Connect to Toggl Data from a Connection Pool in JBoss
Integrate Toggl into Java servlets: Use the Management Console in JBoss to install the Toggl JDBC Driver.
-
Automated Continuous Airtable Replication to Oracle
Use CData Sync for automated, continuous, customizable Airtable replication to Oracle.
-
Connect to Salesloft Data in DBArtisan
Use wizards in DBArtisan to configure Salesloft as a data source.
-
Integrate with Slack Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Slack in SnapLogic.
-
Automated Continuous Cloudflare Replication to MongoDB
Use CData Sync for automated, continuous, customizable Cloudflare replication to MongoDB.
-
Integrate Freshsales with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Freshsales with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Freshsales.
-
Automated Continuous OneNote Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable OneNote replication to PostgreSQL.
-
Connect to LeadDesk Data from a Connection Pool in JBoss
Integrate LeadDesk into Java servlets: Use the Management Console in JBoss to install the LeadDesk JDBC Driver.
-
Connect to ZohoInvoice Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ZohoInvoice.
-
Automate EmailOctopus Data Replication to Couchbase
Use CData Sync to Customize and automate EmailOctopus replication to Couchbase.
-
Visualize SFTP Data in TIBCO Spotfire through ADO.NET
Integrate SFTP into dashboards in TIBCO Spotfire.
-
Automated Continuous HelloSign Replication to Databricks
Use CData Sync for automated, continuous, customizable HelloSign replication to Databricks.
-
Connecting Pipedream with Acumatica 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 Acumatica data in real time.
-
Create Invoiced Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Invoiced from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Live Simplesat Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Simplesat.
-
DataBind Charts to Moosend Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Moosend 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.
-
Automated Continuous Dynamics CRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to SingleStore.
-
Choosing the Best Method to Connect Outreach.io to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Outreach.io from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connecting Mastra with Avalara AvaTax Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Avalara AvaTax, no replication required.
-
Use Grok to Talk to Your Azure Table 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 Azure Table Storage for you.
-
Build Charts with Databricks Data in Clear Analytics
Create dynamic charts and perform analytics based on Databricks in Clear Analytics.
-
Analyze RSS Feeds with Power Pivot
This article walks you through the process of using the CData ODBC Driver for RSS from Power Pivot. You will use the Table Import Wizard to load RSS Feeds. You can visually build the import query or use any SQL supported by the driver.
-
Create Campaigner Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Campaigner data access from reports, embedded analytics, and more.
-
Automated Continuous Google Ad Manager Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Vertica.
-
Integrate Printify with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Printify with External Services.
-
Build MVC Applications with Connectivity to Printify Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Printify from an ASP.NET MVC application.
-
How to Connect to & Open Google Translate Data in Microsoft Excel
This article uses the CData ODBC driver for Google Translate to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to LaunchDarkly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for LaunchDarkly in the Denodo Virtual DataPort Administrator.
-
Analyze GitLab Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for GitLab from Power Pivot. You will use the Table Import Wizard to load GitLab. You can visually build the import query or use any SQL supported by the driver.
-
A PostgreSQL Interface for ClickUp Data using the CData ODBC Driver
Use the SQL Gateway and ClickUp ODBC Driver to create a PostgreSQL entry-point for data access.
-
Import and Visualize Eventbrite Data in Power View
Create data visualizations based on Eventbrite in Excel.
-
How to work with GetResponse Data in Apache Spark using SQL
Access and process GetResponse Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Zoho Books Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Zoho Books replication to Amazon S3.
-
Use the CData Software ODBC Driver for Coda in SAS for Real-Time Reporting and Analytics
Connect to real-time Coda in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Coda.
-
Create Informatica Mappings From/To a JDBC Data Source for Copper
Create Copper data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData Python Connector for Bitly
Learn to install and license the CData Python Connector
-
Back Up Azure DevOps to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Azure DevOps. In this article, we will employ an SSIS workflow to populate a database with Azure DevOps data.
-
DataBind Charts to Quaderno Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Quaderno 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.
-
Integrating Antigravity CLI with Sage Business Cloud Accounting via CData CLI
Connect Sage Business Cloud Accounting to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Analyze Stripe Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Stripe and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Publish Reports with JDBC-ODBC Bridge Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date JDBC-ODBC Bridge.
-
How to import WooCommerce Data into Apache Solr
Use the CData Software JDBC Driver for WooCommerce in Data Import Handler and create an automated import of WooCommerce to Apache Solr Enterprise Search platform.
-
Automate Printful Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Printful from PowerShell? This article demonstrates how to utilize the Printful Cmdlets for tasks like connecting to Printful, automating operations, downloading data, and more.
-
Use the CData Software JDBC Driver for Instantly in MicroStrategy Desktop
Connect to Instantly in MicroStrategy Desktop using the CData Software JDBC Driver for Instantly.
-
Feed Clio Data into FineReport
How to set Clio as a JDBC data source in FineReport.
-
Build Visualizations of Unbounce Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Unbounce in Birst.
-
How to Work with Adobe Commerce Data in AWS Glue Jobs Using JDBC
Connect to Adobe Commerce from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build AI/ML Models with Live Snowflake Data using Dataiku
Connect Snowflake Data with Dataiku using the CData JDBC Driver for Snowflake.
-
Automated Continuous Mode Replication to MySQL
Use CData Sync for automated, continuous, customizable Mode replication to MySQL.
-
Connect to ElevenLabs Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ElevenLabs to connect to ElevenLabs and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for OData in SAS for Real-Time Reporting and Analytics
Connect to real-time OData in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for OData.
-
How to create an RPA flow for Outreach.io Data in UiPath Studio
Use the Outreach.io ODBC Driver to create workflows that access real-time Outreach.io without any coding.
-
Query Microsoft Teams Data in ColdFusion
Write standard ColdFusion data access code to connect to Microsoft Teams.
-
Operational Reporting on WordPress Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote WordPress.
-
Create Data Visualizations in Cognos BI with BenchmarkEmail Data
Access BenchmarkEmail as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build a PostgreSQL Interface for XML Data using the CData JDBC Driver
Use the Remoting features of the XML JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create SendGrid-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SendGrid Data from Klipfolio and build custom visualizations using live SendGrid.
-
Integrating Boomi Agentstudio with HCL Domino Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to HCL Domino, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Visualize Elasticsearch Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Elasticsearch.
-
How to connect Amazon QuickSight to ADP Data
Create a connection to ADP in CData Connect AI and insert ADP into Amazon QuickSight SPICE to build interactive dashboards.
-
Query, Visualize, and Share live Couchbase Data in Redash
Use CData Connect AI to connect to live Couchbase in Redash for querying, visualizing, and sharing.
-
Access SAP Ariba Source 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 SAP Ariba Source.
-
Integrate with SAP Business One Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP Business One to a JSON file on disk.
-
Use the CData Software ODBC Driver for Access in MicroStrategy Desktop
Connect to Microsoft Access in MicroStrategy Desktop using the CData Software ODBC Driver for Access.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Marketo
Provide connectivity to Marketo through an SAP BusinessObjects universe.
-
Integrating Cursor CLI with Phoenix 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.
-
Edit and Search Google Contacts External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google Contacts to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Google Contacts objects that you can access from apps and the dashboard.
-
Import Google Directory Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google Directory. In this article, you will use the OData format to import Google Directory into Microsoft Power Query.
-
Access Live WordPress Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live WordPress from your Excel spreadsheets.
-
How to load Tanda data into Elasticsearch via Logstash
Introducing a simple method to load Tanda data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.