CData Software - Knowledge Base
Recent Articles
-
Build Semantic Layer Views for QuickBooks Online Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for QuickBooks Online.
-
A PostgreSQL Interface for SendInBlue Data using the CData ODBC Driver
Use the SQL Gateway and SendInBlue ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Oracle Service Cloud Data in DBArtisan
Use wizards in DBArtisan to configure Oracle Service Cloud as a data source.
-
Add Procore Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Procore with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Google Forms Data in CloverDX (formerly CloverETL)
Transfer Google Forms using the visual workflow in the CloverDX data integration tool.
-
Integrate with Live Cosmos DB Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Cosmos DB from the MuleSoft Anypoint Platform to integrate live Azure Cosmos DB into custom reports and dashboards.
-
Connect Paymo to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Paymo with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Optimizely Replication to SQLite
Use CData Sync for automated, continuous, customizable Optimizely replication to SQLite.
-
Automated Continuous Calendly Replication to MongoDB
Use CData Sync for automated, continuous, customizable Calendly replication to MongoDB.
-
How to integrate CloudConvert with Apache Airflow
Access and process CloudConvert in Apache Airflow using the CData JDBC Driver.
-
Connect to Bugsnag 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 Bugsnag and work with Bugsnag in your FileMaker application.
-
Access Live Opsgenie Data in Coginiti Pro
Connect to and query live Opsgenie from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Power BI Reports on Real-Time Chargebee Data
Use the CData ODBC Driver for Chargebee to visualize Chargebee in Power BI Desktop.
-
Migrating data from PolarTeamPro to Snowflake using CData SSIS Components.
Easily push PolarTeamPro to Snowflake using the CData SSIS Tasks for PolarTeamPro and Snowflake.
-
Replicate Multiple Google Directory Accounts
Replicate multiple Google Directory accounts to one or many databases.
-
Getting Started with the CData JDBC Driver for Drip
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Drip.
-
How to create XML federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for XML Files in MySQL .
-
How to Work with Scrapfly Data in ETL Validator JDBC
Connect to Scrapfly from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Live SAP Ariba Source Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP Ariba Source using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous LinkedIn Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable LinkedIn replication to Google BigQuery.
-
Automated Continuous Nethunt Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Nethunt replication to Azure SQL Database.
-
Analyze OData Services in Cognos Analytics
Use CData Connect AI to connect to OData Services from Cognos Analytics and analyze live OData.
-
How to Connect to & Open Typeform Data in Microsoft Excel
This article uses the CData ODBC driver for Typeform to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Dynamics 365 Business Central-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Dynamics 365 Business Central and build web apps with connectivity to live Dynamics 365 Business Central.
-
Integrating OpenCode Terminal with SAP SuccessFactors 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 ShipStation With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ShipStation data using
-
Access Zoho Recruit Data from MySQL in Amazon QuickSight
Connect to Zoho Recruit and build visualizations of Zoho Recruit using a MySQL Connection in Amazon QuickSight.
-
Query Sugar CRM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Sugar CRM from Node.js.
-
Getting Started with the CData SSIS Components for Excel
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Excel.
-
Write a Simple Go Application to work with Strava Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Strava.
-
Replicate Multiple Monday.com Accounts
Replicate multiple Monday.com accounts to one or many databases.
-
Access Live Microsoft Planner Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Planner in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Datasets from Reply.io in Domo Workbench and Build Visualizations of Reply.io Data in Domo
Use the CData Software ODBC Driver for Reply.io to create datasets from Reply.io in Domo Workbench and then build visualizations in the Domo service.
-
Integrate iContact Data in the Pentaho Report Designer
Publish reports based on iContact in the Pentaho BI tool.
-
Provide OData Services of Bright Data Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Bright Data by developing a WCF Service Application.
-
Rapidly Develop Qualaroo-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 Qualaroo.
-
How to connect and process Retently from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Retently.
-
Connect to and Query Cloudflare Data in QlikView over ODBC
Create data visualizations with Cloudflare in QlikView.
-
Analyze Basecamp Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Basecamp and visualize live Basecamp in Infragistics Reveal.
-
Integrate Live Zoho Projects Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Using the CData Software ODBC Driver for CouchDB in PyCharm
Connect to CouchDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for CouchDB.
-
Automated Continuous Bannerbear Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Bannerbear replication to Amazon Redshift.
-
Stream Notion Data into Apache Kafka Topics
Access and stream Notion in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Jira Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Atlassian Jira and integrate live Atlassian Jira into your Power Automate tasks.
-
How to Visualize MailChimp Data in Python with pandas
Use pandas and other modules to analyze and visualize live MailChimp in Python.
-
How to Work with Suadeo Data in AWS Glue Jobs Using JDBC
Connect to Suadeo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Accelo Replication to MySQL
Use CData Sync for automated, continuous, customizable Accelo replication to MySQL.
-
Automate Zoho CRM Data Replication to Azure Synapse
Use CData Sync to customize and automate Zoho CRM replication to Azure Synapse.
-
Integrating Antigravity CLI with BambooHR via CData CLI
Connect BambooHR to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating Gumloop with Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Shopify within automated workflows.
-
Prepare, Blend, and Analyze Drip Data in Alteryx Designer (ODBC)
Build workflows to access live Drip for self-service data analytics.
-
LDAP Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on LDAP facts in real time.
-
Getting Started with the CData Excel Add-In for SAP Business One
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP Business One.
-
Build Semantic Layer Views for Oracle HCM Cloud Data in APOS Live Data Gateway
Use the CData Connector for Oracle HCM Cloud in APOS Live Data Gateway to build Semantic Layer Views for Oracle HCM Cloud.
-
Getting Started with the CData JDBC Driver for Pinecone
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Pinecone.
-
Access Mistral AI Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Mistral AI from HeidiSQL.
-
Replicate Multiple Jira Assets Accounts
Replicate multiple Jira Assets accounts to one or many databases.
-
Connect to Epicor Kinetic Data in DBeaver
Use the CData ODBC Driver to connect to Epicor Kinetic in DBeaver.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SAP Netweaver Gateway to Power BI dashboards. Simply drag and drop SAP Netweaver Gateway into data visuals on the Power BI canvas.
-
Automated Continuous Slack Replication to Snowflake
Use CData Sync for automated, continuous, customizable Slack replication to Snowflake.
-
Build Dashboards with Google Directory Data in DBxtra
Create dynamic dashboards and perform analytics based on Google Directory in DBxtra.
-
Migrating data from Gumroad to Databricks using CData SSIS Components.
Easily push Gumroad to Databricks using the CData SSIS Tasks for Gumroad and Databricks.
-
Build Apps with Live Egnyte Data Using the Low-Code Development Platform of Mendix
Connect Egnyte with Mendix to build apps using the CData API Driver for JDBC.
-
Query ClickTime Data as a MySQL Database in Node.js
Execute MySQL queries against ClickTime from Node.js.
-
Getting Started with the CData SSIS Components for EnterpriseDB
Complete guide to installing, licensing, and connecting with the CData SSIS Components for EnterpriseDB.
-
Natively Connect to ClickUp Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ClickUp. Leverage the native support for ODBC in PHP.
-
How to integrate Metabase with Google Calendar Data
Use CData Connect AI to connect to live Google Calendar and create an interactive dashboard in Metabase from Google Calendar.
-
Foursquare Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Foursquare facts in real time.
-
Visualize Live Microsoft Exchange Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Exchange into custom reports in Power BI.
-
Replicate SAP SuccessFactors Data in Heroku for Use in Salesforce Connect
Replicate SAP SuccessFactors to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Vimeo Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Vimeo from Informatica Cloud.
-
Integrate ZohoPeople with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ZohoPeople with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ZohoPeople.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Microsoft SQL Server using the Model Context Protocol.
-
How to Build an ETL App for Slack Data in Python with CData Connect AI
Build ETL pipelines that read and write live Slack in Python with petl and the CData Connect AI Python SDK.
-
Integrate with Spotify Data in JReport Designer
Create charts and reports based on Spotify in JReport Designer.
-
Automated Continuous Smartsheet Replication to MySQL
Use CData Sync for automated, continuous, customizable Smartsheet replication to MySQL.
-
Create Apps from Google Sheets Data in Qlik Sense Cloud
Use CData Connect AI to connect to Google Sheets Data and build apps from live Google Sheets in Qlik Sense Cloud.
-
Explore Geographical Relationships in ZendeskSell Data with Power Map
Create data visualizations with ZendeskSell in Power Map.
-
Integrating Pinterest Data in Talend Cloud Data Management Platform
Connect Pinterest Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Pinterest.
-
Build a PostgreSQL Interface for ConstantContact Data using the CData JDBC Driver
Use the Remoting features of the ConstantContact JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to integrate Metabase with SAP ByDesign Data
Use CData Connect AI to connect to live SAP Business ByDesign and create an interactive dashboard in Metabase from SAP Business ByDesign.
-
Automated Continuous Opsgenie Replication to MongoDB
Use CData Sync for automated, continuous, customizable Opsgenie replication to MongoDB.
-
Automated Continuous Oracle HCM Cloud Replication to Vertica
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Vertica.
-
Create Dashboards and Visualize Live SAP HANA Data in Geckoboard
Use CData Connect AI to connect to live SAP HANA and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Google Search to Power BI dashboards. Simply drag and drop Google Search into data visuals on the Power BI canvas.
-
How to Connect DBeaver to AfterShip via a JDBC Driver
Manage AfterShip with visual tools in DBeaver like the query browser.
-
Access Azure Table Data from MySQL in Amazon QuickSight
Connect to Azure Table and build visualizations of Azure Table Storage using a MySQL Connection in Amazon QuickSight.
-
How to Query Live NASA Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live NASA data in natural language using Python.
-
View Reports on Real-Time Clio Data in Power BI Report Server
Use the CData ODBC Driver for Clio to visualize Clio in Power BI Desktop and then publish them to Power BI Report Server.
-
How to import Hive Data into Apache Solr
Use the CData Software JDBC Driver for Hive in Data Import Handler and create an automated import of Apache Hive to Apache Solr Enterprise Search platform.
-
Analyze SAP SuccessFactors Data in Cognos Analytics
Use CData Connect AI to connect to SAP SuccessFactors Data from Cognos Analytics and analyze live SAP SuccessFactors.
-
Establish a Live Connection with AgileCRM Data using Tableau Bridge
The CData ODBC Driver for AgileCRM enables you to integrate live AgileCRM into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect to Oracle Financials Cloud Data in DBVisualizer
Integrate Oracle Financials Cloud with visual data analysis tools and data connection wizards in DBVisualizer
-
How to publish and share Codat Data dashboards with Tableau Server
The CData ODBC driver for Codat enables you integrate Codat into Tableau dashboards.
-
Automate Shippo Data Replication to Couchbase
Use CData Sync to Customize and automate Shippo replication to Couchbase.
-
Extend Google Sheets with SharePoint Data
Make calls to SharePoint from Google Apps Script via the API Server.
-
Use Biml to Build SSIS Tasks to Replicate ZohoInvoice Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ZohoInvoice to SQL Server.
-
Automated Continuous Shortcut Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Shortcut replication to OneLake in Microsoft Fabric.
-
Access EmailOctopus 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 EmailOctopus.
-
Moving Data from Sage Cloud Accounting to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Sage Cloud Accounting data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.