CData Software - Knowledge Base
Recent Articles
-
Automated Continuous PivotalTracker Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable PivotalTracker replication to Apache Kafka.
-
Connect to Zoho Books Data in RapidMiner
Integrate Zoho Books with standard components and data source configuration wizards in RapidMiner Studio.
-
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.
-
How to connect to Amplitude Data in DBVisualizer
Integrate Amplitude with visual data analysis tools and data connection wizards in DBVisualizer
-
Extend Google Sheets with Paylocity Data
Make calls to Paylocity from Google Apps Script via the API Server.
-
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
-
ETL GitHub in Oracle Data Integrator
This article shows how to transfer GitHub into a data warehouse using Oracle Data Integrator.
-
Use the CData Software JDBC Driver for VWO in MicroStrategy Desktop
Connect to VWO in MicroStrategy Desktop using the CData Software JDBC Driver for VWO.
-
Build a PostgreSQL Interface for QuickBooks Online Data using the CData JDBC Driver
Use the Remoting features of the QuickBooks Online JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Live Nuclia Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Nuclia to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build Office 365-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Office 365 to explore live Office 365 Data in Gemini Code Assist to assist with building Office 365-powered applications.
-
Integrate Zendesk Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Zendesk and integrate live Zendesk into your Power Automate tasks.
-
Create Freshsales Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Freshsales data access from reports, embedded analytics, and more.
-
Connect to Strava Data from PowerBuilder via ADO.NET
This article demonstrates how to access Strava from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
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.
-
Create Reports from OData Services in Looker Studio
Use CData Connect AI to gain access to live OData and create custom reports in Looker Studio.
-
Import Paddle Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Paddle. In this article, you will use the OData format to import Paddle into Microsoft Power Query.
-
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.
-
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.
-
How to Import Data from Recurly into Google Sheets
Import Recurly into a Google spreadsheet that is automatically refreshed.
-
Provide OData Services of Smartsheet Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Smartsheet by developing a WCF Service Application.
-
How to publish and share Vault CRM Data dashboards with Tableau Server
The CData ODBC driver for Vault CRM enables you integrate Veeva Vault & Vault CRM into Tableau dashboards.
-
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.
-
Automated Continuous Snapchat Ads Replication to Snowflake
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Snowflake.
-
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.
-
Migrating data from Google Search to Databricks using CData SSIS Components.
Easily push Google Search to Databricks using the CData SSIS Tasks for Google Search and Databricks.
-
Create a Data Access Object for Box Data using JDBI
A brief overview of creating a SQL Object API for Box in JDBI.
-
View Reports on Real-Time SharePoint Data in Power BI Report Server
Use the CData ODBC Driver for SharePoint to visualize Microsoft SharePoint in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect PolyBase to Salesforce Pardot
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Salesforce Pardot.
-
Connect to GraphQL Data in JRuby
Create a simple JRuby app with access to live GraphQL.
-
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 Zoho Inventory Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoho Inventory and the SQL Gateway to access Zoho Inventory from Google Apps Script.
-
Use the CData Software ODBC Driver for Bitly in MicroStrategy
Connect to Bitly in MicroStrategy Developer using the CData Software ODBC Driver for Bitly.
-
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.
-
Build Data Flows from SQL Server to REST through SSIS
Easily push SQL Server data to REST using the CData SSIS Tasks for REST.
-
Connect to Procore Data in CloverDX (formerly CloverETL)
Transfer Procore using the visual workflow in the CloverDX data integration tool.
-
Access Live Zoho Books Data in Coginiti Pro
Connect to and query live Zoho Books from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Salesforce Marketing-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Salesforce Marketing Cloud.
-
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.
-
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.
-
Build Recurly-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Recurly Data in GitHub Copilot to assist with building Recurly-powered applications.
-
DataBind Shopify Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Shopify with the DevExpress Windows Forms and Web controls to provide Shopify to a chart.
-
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.
-
Automated Continuous Freshsales Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Freshsales replication to PostgreSQL.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed EnterpriseDB to Power BI dashboards. Simply drag and drop EnterpriseDB into data visuals on the Power BI canvas.
-
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.
-
Access Live Email Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Email from your Excel spreadsheets.
-
Connect and Visualize Live Tally Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Tally ERP into the Databricks platform and create visualization dashboards with real-time Tally ERP.
-
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.
-
Automated Continuous Aha! Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Aha! replication to Google Cloud SQL.
-
Excel Spreadsheet Automation on Jira Assets Data with the QUERY Formula
Pull data from Jira Assets, automate spreadsheets, and more with the QUERY formula.
-
Query Zendesk Data as a SQL Server Database in Node.js
Execute SQL Server queries against Zendesk from Node.js.
-
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.
-
Rapidly Develop Delighted-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Delighted.
-
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.
-
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.
-
Connect to Grafana Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
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.
-
Connect Factorial Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Factorial using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Work with Helpscout Data in FoxPro
Load Helpscout into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous MailerLite Replication to IBM DB2
Use CData Sync for automated, continuous, customizable MailerLite replication to IBM DB2.
-
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.
-
Connect to Wrike Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Create Power BI Visual Reports with Real-Time SAP ByDesign Data
Use CData Power BI Connectors to visualize SAP Business ByDesign in Power BI.
-
DataBind Controls to Aha! Data in C++Builder
DataBind to Aha! in C++Builder with standard components and controls.
-
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.
-
Integrate Excel Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Excel from Informatica Cloud.
-
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.
-
Create Dropbox-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Dropbox Data from OutSystems and build custom enterprise apps using live Dropbox.
-
Use JayDeBeApi to access SageHR Data in Python
Use standard Python scripting and the development environment of your choice to access live SageHR.
-
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 Toggl 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 Toggl and work with Toggl in your FileMaker application.
-
Create Power BI Reports on Real-Time Oracle Financials Cloud Data
Use the CData ODBC Driver for Oracle Financials Cloud to visualize Oracle Financials Cloud in Power BI Desktop.
-
Connect to Pipedrive in SpagoBI
Create reports featuring live Pipedrive in SpagoBI Studio. Host Pipedrive reports on SpagoBI Server.
-
Getting Started with the CData ODBC Driver for SAP Business One
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP Business One.
-
Manage Google Directory Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Directory.
-
Automated Continuous ShipStation Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ShipStation replication to Azure SQL Database.
-
Use Dash to Build to Web Apps on Factorial Data
Create Python applications that use pandas and Dash to build Factorial-connected web apps.
-
How to Query Live OpenWeatherMap Data in Claude Desktop
Connect to and query live OpenWeatherMap Data in Claude Desktop using CData MCP Server.