CData Software - Knowledge Base
Recent Articles
-
Bidirectional Access to Mailjet Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Mailjet in Filemaker Pro for Mac or Windows.
-
Connect to LinkedIn Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with LinkedIn Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect the Power BI Service to SAP SuccessFactors LMS: Complete Guide
Connect to the CData Software Power BI Connector for SAP SuccessFactors LMS from PowerBI.com to provide real-time SAP SuccessFactors LMS across the organization.
-
Replicate Amplitude Data to Multiple Databases via the CData Sync CLI
Replicate Amplitude to disparate databases with a single configuration.
-
How to connect to Amplitude Data in DBVisualizer
Integrate Amplitude with visual data analysis tools and data connection wizards in DBVisualizer
-
How to import Clio Data into Apache Solr
Use the CData Software JDBC Driver for Clio in Data Import Handler and create an automated import of Clio to Apache Solr Enterprise Search platform.
-
Integrate Coda Data in the Pentaho Report Designer
Publish reports based on Coda in the Pentaho BI tool.
-
How to connect to Front Data from Spring Boot
Connect to Front in a Spring Boot Application using the CData API Driver for JDBC
-
Analyze Factorial Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Factorial with the CData JDBC Driver for Factorial.
-
Connect to Active Directory Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Getting Started with the CData Python Connector for MongoDB
Learn to install and license the CData Python Connector
-
ETL GitHub in Oracle Data Integrator
This article shows how to transfer GitHub into a data warehouse using Oracle Data Integrator.
-
Create Timely Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Timely data access from reports, embedded analytics, and more.
-
How to Connect DBeaver to Gorgias via a JDBC Driver
Manage Gorgias with visual tools in DBeaver like the query browser.
-
Connect Telegram to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Telegram using the CData Python MCP Server.
-
Connect Avaza to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Avaza using the CData Python MCP Server.
-
Connect to TigerGraph from a Connection Pool in WebLogic
Use the CData JDBC Driver for TigerGraph to connect to TigerGraph from Web applications running on WebLogic.
-
Connect to Mistral AI from a Connection Pool in WebLogic
Use the CData JDBC Driver for Mistral AI to connect to Mistral AI from Web applications running on WebLogic.
-
DataBind Optimizely Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Optimizely to a chart.
-
Consume Hive OData Feeds in PowerBuilder
This article demonstrates how to consume Apache Hive as OData feeds from PowerBuilder using the API Server.
-
Build Automated Workflows with Live Xero Data in Workato
Use CData Connect AI to connect to live Xero Accounting and build automated workflows in Workato.
-
How to connect and process Microsoft Excel Online from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Excel Online.
-
Analyze Basecamp Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Basecamp in Microsoft R Open.
-
Connect FreshBooks Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your FreshBooks using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to and Query Dynamics NAV Data in QlikView over ODBC
Create data visualizations with Microsoft Dynamics NAV in QlikView.
-
Getting Started with the CData ADO.NET Provider for Avaza
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Replicate Multiple Twilio Accounts
Replicate multiple Twilio accounts to one or many databases.
-
Integrating Claude Code CLI with Slack 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.
-
Automated Continuous Recurly Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Recurly replication to Apache Kafka.
-
Integrate MySQL Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to MySQL and integrate live MySQL into your Power Automate tasks.
-
Integrating OpenCode Terminal with Amazon S3 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.
-
Connect to Mailjet Data in RazorSQL
Connect to Mailjet from wizards and query Mailjet from the GUI in the RazorSQL database management tool.
-
DataBind Controls to Sugar CRM Data in Delphi
DataBind to Sugar CRM in Delphi with standard data access components and controls.
-
How to connect PolyBase to Oracle Financials Cloud
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle Financials Cloud.
-
Query Hacker News Data as a MySQL Database in Node.js
Execute MySQL queries against Hacker News from Node.js.
-
Connect to AlloyDB Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with AlloyDB Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect to & Open Browserless Data in Microsoft Excel
This article uses the CData ODBC driver for Browserless to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to and Query Zendesk Data in QlikView over ODBC
Create data visualizations with Zendesk in QlikView.
-
Connect to GraphQL Data in JRuby
Create a simple JRuby app with access to live GraphQL.
-
Integrate with Greenplum Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Pivotal GreenPlum to a JSON file on disk.
-
Access Live Sentry Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Sentry into the statistical analysis tools available in SAS JMP. This article shows how to use Sentry in the Graph Builder and Query Builder.
-
DataBind Controls to Recurly Data in Delphi
DataBind to Recurly in Delphi with standard data access components and controls.
-
Connect to Campaigner Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Campaigner using standard SQL.
-
How to Connect to Timely Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Timely. Leverage the pyodbc module for ODBC in Python.
-
Add Act-On Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Act-On with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to OnePageCrm from a Connection Pool in WebLogic
Use the CData JDBC Driver for OnePageCrm to connect to OnePageCrm from Web applications running on WebLogic.
-
Create Dynamic Access Grids Using the Infragistics XamDataGrid
Learn how you can connect Access to Infragistics XamDataGrid to build dynamic grids.
-
How to create RSS federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for RSS Feeds in MySQL .
-
Connect to OneNote Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft OneNote.
-
Deploy the ADO.NET Provider for SAS Data Sets on an SSRS Report Server
Connect to SAS Data Sets from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to Intercom Data in Ruby
Connect to Intercom in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
DataBind Controls to Rebilly Data in Delphi
DataBind to Rebilly in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for Epicor Kinetic in SAS for Real-Time Reporting and Analytics
Connect to real-time Epicor Kinetic in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Epicor Kinetic.
-
Create Shopify-Connected Dashboards in Grafana
Connect to Shopify Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Shopify.
-
Use Biml to Build SSIS Tasks to Replicate Grafana Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Grafana to SQL Server.
-
Build Apps with Live ZeroBounce Data Using the Low-Code Development Platform of Mendix
Connect ZeroBounce with Mendix to build apps using the CData API Driver for JDBC.
-
Enable the Front JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Front.
-
Extract, Transform, and Load ShipEngine Data in Informatica PowerCenter
Create a simple Workflow for ShipEngine in Informatica PowerCenter.
-
Automate Flowlu Data Replication to Azure Synapse
Use CData Sync to customize and automate Flowlu replication to Azure Synapse.
-
Access Sugar CRM Data from MySQL in PHP
Connect to Sugar CRM through the standard MySQL libraries in PHP.
-
Access Live Epicor Kinetic Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Epicor Kinetic data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build a PostgreSQL Interface for Adobe Analytics Data using the CData JDBC Driver
Use the Remoting features of the Adobe Analytics JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze OData Services in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze OData in Microsoft R Open.
-
Getting Started with the CData Python Connector for Webex
Learn to install and license the CData Python Connector
-
How to Connect to & Open OneNote Data in Microsoft Excel
This article uses the CData ODBC driver for OneNote to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Data Visualizations in Cognos BI with JSON Services
Access JSON as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Query Zendesk Data as a SQL Server Database in Node.js
Execute SQL Server queries against Zendesk from Node.js.
-
Add Airtable Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Airtable with the Informatica Enterprise Data Catalog to classify and organize data.
-
Publish Reports with Amplitude Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Amplitude.
-
Manage Mocean Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Mocean.
-
How to Work with Xero Data in AWS Glue Jobs Using JDBC
Connect to Xero from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData Software ODBC Driver for Outreach.io in SAS for Real-Time Reporting and Analytics
Connect to real-time Outreach.io in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Outreach.io.
-
How to connect to Jumpseller Data from IntelliJ
Integrate connectivity to Jumpseller with wizards in IntelliJ.
-
Migrating data from Procore to Snowflake using CData SSIS Components.
Easily push Procore to Snowflake using the CData SSIS Tasks for Procore and Snowflake.
-
Integrate Live SAP Concur Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP Concur and integrate live SAP Concur into apps built in Microsoft Power Apps.
-
Getting Started with the CData Excel Add-In for Helpscout
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Helpscout.
-
Replicate Multiple ConvertKit Accounts
Replicate multiple ConvertKit accounts to one or many databases.
-
Integrating Antigravity CLI with Power BI XMLA via CData CLI
Connect Power BI XMLA to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Query Figshare Data in MySQL Workbench
Execute MySQL queries against live Figshare from MySQL Workbench.
-
Analyze Vercel Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Vercel from Power Pivot. You will use the Table Import Wizard to load Vercel. You can visually build the import query or use any SQL supported by the driver.
-
Build Visualizations of CSV Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of CSV/TSV Files in Birst.
-
How to Easily Query Google Directory Data in OpenOffice Base
Connect to Google Directory data in OpenOffice Base using the CData ODBC Driver for Google Directory and generate reports with live data insights.
-
How to Connect DBeaver to Mode via a JDBC Driver
Manage Mode with visual tools in DBeaver like the query browser.
-
DataBind Controls to Aha! Data in C++Builder
DataBind to Aha! in C++Builder with standard components and controls.
-
Automated Continuous Certinia Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Certinia replication to AlloyDB.
-
Use the CData Software ODBC Driver for SparkPost in MicroStrategy
Connect to SparkPost in MicroStrategy Developer using the CData Software ODBC Driver for SparkPost.
-
Visualize SuiteCRM Data in Tableau
The CData ODBC driver for SuiteCRM enables you integrate SuiteCRM into Tableau dashboards.
-
Create Data Visualizations in Cognos BI with Outlook Data
Access Outlook as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Publish QuickBooks Time-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live QuickBooks Time.
-
Automated Continuous Everhour Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Everhour replication to Amazon S3.
-
Integrating Boomi Agentstudio with Box Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Box, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build OneNote-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for OneNote to explore live OneNote Data in Cursor to assist with building OneNote-powered applications.
-
Build AI Agents with FreshBooks Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live FreshBooks through CData Connect AI.
-
Work with Neo4J Data in FoxPro
Load Neo4J into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Pipedrive in SpagoBI
Create reports featuring live Pipedrive in SpagoBI Studio. Host Pipedrive reports on SpagoBI Server.
-
Build AI/ML Models with Live Presto Data using Dataiku
Connect Presto Data with Dataiku using the CData JDBC Driver for Presto.
-
Integrate SQL Analysis Services Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SQL Analysis Services and integrate live SQL Analysis Services into your Power Automate tasks.
-
Automated Continuous ShipStation Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ShipStation replication to Azure SQL Database.
-
Connect to BenchmarkEmail Data in DBeaver
Use the CData ODBC Driver to connect to BenchmarkEmail in DBeaver.
-
Use Dash to Build to Web Apps on EmailOctopus Data
Create Python applications that use pandas and Dash to build EmailOctopus-connected web apps.