CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Box Replication to MySQL
Use CData Sync for automated, continuous, customizable Box replication to MySQL.
-
Import and Visualize MySQL Data in Power View
Create data visualizations based on MySQL in Excel.
-
Getting Started with the CData ODBC Driver for MailerLite
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for MailerLite.
-
How to connect to SAP Business One Data with Squirrel SQL client
Connect to SAP Business One and execute queries in the Squirrel SQL Client.
-
Use JayDeBeApi to access Paymo Data in Python
Use standard Python scripting and the development environment of your choice to access live Paymo.
-
Create Apps from IBM Cloud Object Storage Data in Qlik Sense Cloud
Use CData Connect AI to connect to IBM Cloud Object Storage Data and build apps from live IBM Cloud Object Storage in Qlik Sense Cloud.
-
Access Live Zoho Creator 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 Zoho Creator through MCP integration.
-
Use the CData Software ODBC Driver for AgileCRM in SAS for Real-Time Reporting and Analytics
Connect to real-time AgileCRM in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for AgileCRM.
-
How to Work with CapsuleCRM Data in AWS Glue Jobs Using JDBC
Connect to CapsuleCRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Analyze Airtable Data in Cognos Analytics
Use CData Connect AI to connect to Airtable Data from Cognos Analytics and analyze live Airtable.
-
How to work with SendInBlue Data in Apache Spark using SQL
Access and process SendInBlue Data in Apache Spark using the CData Software JDBC Driver.
-
DataBind Controls to LeadDesk Data in C++Builder
DataBind to LeadDesk in C++Builder with standard components and controls.
-
How to Visualize SAP ByDesign Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP Business ByDesign in Python.
-
Automated Continuous Aweber Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Aweber replication to Apache Kafka.
-
Connect to Nuclia Data in JRuby
Create a simple JRuby app with access to live Nuclia.
-
Publish eBay-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live eBay.
-
Automate SAP Hybris C4C Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP Hybris C4C replication to Azure Synapse.
-
Create Data Visualizations in Cognos BI with BambooHR Data
Access BambooHR as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Visualize Testmonitor Data in Python with pandas
Use pandas and other modules to analyze and visualize live Testmonitor in Python.
-
Migrating data from Zoho CRM to Snowflake using CData SSIS Components.
Easily push Zoho CRM to Snowflake using the CData SSIS Tasks for Zoho CRM and Snowflake.
-
How to Access Live Clio Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Clio enables you to integrate Clio into workflows built using Microsoft Power Automate Desktop.
-
Build Apps with Live Demio Data Using the Low-Code Development Platform of Mendix
Connect Demio with Mendix to build apps using the CData API Driver for JDBC.
-
Prepare, Blend, and Analyze Workday Data in Alteryx Designer (ODBC)
Build workflows to access live Workday for self-service data analytics.
-
Connect to ServiceDesk Plus Data in RapidMiner
Integrate ServiceDesk Plus with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous SharePoint Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SharePoint replication to AlloyDB.
-
Integrating PivotalTracker Data in Talend Cloud Data Management Platform
Connect PivotalTracker Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Back Up ShipEngine to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with ShipEngine data.
-
Build an OLAP Cube in SSAS from Missive Data
Establish a connection to Missive data from SQL Server Analysis Services, and use the Missive Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Amazon Marketplace Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to Google BigQuery.
-
How to import CockroachDB Data into Apache Solr
Use the CData Software JDBC Driver for CockroachDB in Data Import Handler and create an automated import of CockroachDB to Apache Solr Enterprise Search platform.
-
Integrate Live GitLab Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to GitLab and integrate live GitLab into apps built in Microsoft Power Apps.
-
How to Build an ETL App for Cosmos DB Data in Python with CData
Create ETL applications and real-time data pipelines for Azure Cosmos DB in Python with petl.
-
Migrating data from Datadog to Google BigQuery using CData SSIS Components.
Easily push Datadog to Google BigQuery using the CData SSIS Tasks for Datadog and Google BigQuery.
-
Build GitHub-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live GitHub.
-
Automated Continuous Front Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Front replication to IBM DB2.
-
How to Query Live Amazon S3 Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Amazon S3 data in natural language using Python.
-
Use the CData ODBC Driver for VWO in Microsoft Power Query
You can use the CData VWO ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import VWO into Microsoft Power Query.
-
Visualize Cvent Data in TIBCO Spotfire through ADO.NET
Integrate Cvent into dashboards in TIBCO Spotfire.
-
Query SAP ByDesign Data in DataGrip
Create a Data Source for SAP ByDesign in DataGrip and use SQL to query live SAP Business ByDesign.
-
Integrate with Live FHIR Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to FHIR from the MuleSoft Anypoint Platform to integrate live FHIR into custom reports and dashboards.
-
DataBind Charts to PostgreSQL Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to PostgreSQL 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.
-
Use the CData Software JDBC Driver for Delighted in MicroStrategy Web
Connect to Delighted in MicroStrategy Web using the CData Software JDBC Driver for Delighted.
-
Provide OData Services of Drip Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Drip by developing a WCF Service Application.
-
Integrate Open WebUI with Live Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Slack from within the chat interface.
-
Analyze MYOB AccountRight Data in Looker
Use CData Connect AI to connect to MYOB AccountRight Data from Looker and build custom apps using live MYOB AccountRight.
-
Integrate Live Oracle Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Oracle from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Oracle Database.
-
Automated Continuous Mouseflow Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Mouseflow replication to Apache Kafka.
-
Excel Spreadsheet Automation on Oracle HCM Cloud Data with the QUERY Formula
Pull data from Oracle HCM Cloud, automate spreadsheets, and more with the QUERY formula.
-
How to Build an ETL App for Oracle Data in Python with CData Connect AI
Build ETL pipelines that read and write live Oracle Database in Python with petl and the CData Connect AI Python SDK.
-
Replicate Humanity Data in Heroku for Use in Salesforce Connect
Replicate Humanity to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Visualize eBay Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load eBay into TIBCO Spotfire.
-
Moving Data from Timely to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Timely data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automate Salesforce CRM Analytics Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Salesforce CRM Analytics from PowerShell? This article demonstrates how to utilize the Salesforce CRM Analytics Cmdlets for tasks like connecting to Salesforce CRM Analytics, automating operations, downloading data, and more.
-
How to Visualize WooCommerce Data in Python with pandas
Use pandas and other modules to analyze and visualize live WooCommerce in Python.
-
Create Datasets from Couchbase in Domo Workbench and Build Visualizations of Couchbase Data in Domo
Use the CData Software ODBC Driver for Couchbase to create datasets from Couchbase in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Printful Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Printful in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software ODBC Driver for Mixpanel in SAS for Real-Time Reporting and Analytics
Connect to real-time Mixpanel in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Mixpanel.
-
Replicate Multiple MYOB AccountRight Accounts
Replicate multiple MYOB AccountRight accounts to one or many databases.
-
How to import Wave Financial Data into Apache Solr
Use the CData Software JDBC Driver for Wave Financial in Data Import Handler and create an automated import of Wave Financial to Apache Solr Enterprise Search platform.
-
How to connect to LionDesk Data in DBVisualizer
Integrate LionDesk with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Reports with Oracle Sales Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Sales.
-
A PostgreSQL Interface for Zoho Books Data using the CData ODBC Driver
Use the SQL Gateway and Zoho Books ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Amazon Athena in SpagoBI
Create reports featuring live Amazon Athena in SpagoBI Studio. Host Amazon Athena reports on SpagoBI Server.
-
Automated Continuous Egnyte Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Egnyte replication to Amazon S3.
-
How to connect PolyBase to QuickBooks Online
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live QuickBooks Online.
-
Use Dash to Build Web Apps on Google Sheets Data via CData Connect AI
Build interactive Dash web apps on live Google Sheets using pandas and the CData Connect AI Python SDK.
-
Analyze Google Ad Manager Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Ad Manager and visualize Google Ad Manager in SAP Analytics Cloud.
-
Integrate Snowflake with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Snowflake with External Services.
-
How to Connect to Live Slack Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Slack for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Auth0
Provide connectivity to Auth0 through an SAP BusinessObjects universe.
-
Automated Continuous Oracle Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle Database replication to OneLake in Microsoft Fabric.
-
Manage Jira Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Jira.
-
How to Build an ETL App for Jira Data in Python with CData
Create ETL applications and real-time data pipelines for Atlassian Jira in Python with petl.
-
Integrating Azure DevOps Data in Talend Cloud Data Management Platform
Connect Azure DevOps Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Azure DevOps.
-
Connect to MarkLogic Data in ACL Analytics
Connect to MarkLogic via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to MarkLogic.
-
Replicate Multiple API Accounts
Replicate multiple API accounts to one or many databases.
-
Integrate with Teamwork Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Teamwork to a JSON file on disk.
-
Use the CData API Server to Access Zuora Data in Microsoft PowerPivot
Use the CData API Server to connect to live Zuora in the Power Pivot business intelligence tool.
-
Integrating Gumloop with CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Apache CouchDB within automated workflows.
-
Access Live Dynamics 365 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 Microsoft Dynamics 365 through MCP integration.
-
Publish Procore-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Procore.
-
DataBind Controls to Drift Data in Delphi
DataBind to Drift in Delphi with standard data access components and controls.
-
How to create an RPA flow for MariaDB Data in UiPath Studio
Use the MariaDB ODBC Driver to create workflows that access real-time MariaDB without any coding.
-
How to create an RPA flow for FreeAgent Data in UiPath Studio
Use the FreeAgent ODBC Driver to create workflows that access real-time FreeAgent without any coding.
-
Replicate Multiple xBase Accounts via the CData Sync CLI
Replicate multiple xBase accounts to one or many databases.
-
How to Connect Flowise AI Agents to Live Microsoft Ads Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Microsoft Ads without replication.
-
Create SSAS Tabular Models from SFTP Data
How to build a SQL Server Analysis Service Tabular Model from SFTP using CData drivers.
-
Load MarkLogic Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load MarkLogic to a database.
-
Replicate Multiple Google Contacts Accounts
Replicate multiple Google Contacts accounts to one or many databases.
-
How to connect to Trello Data with Squirrel SQL client
Connect to Trello and execute queries in the Squirrel SQL Client.
-
How to load ClickUp data into Elasticsearch via Logstash
Introducing a simple method to load ClickUp data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Add ConvertKit Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ConvertKit with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Semantic Layer Views for ZohoExpense Data in APOS Live Data Gateway
Use the CData Connector for ZohoExpense in APOS Live Data Gateway to build Semantic Layer Views for ZohoExpense.
-
Stream Google Ads Data into Apache Kafka Topics
Access and stream Google Ads in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Migrating data from RabbitMQ to Google BigQuery using CData SSIS Components.
Easily push RabbitMQ to Google BigQuery using the CData SSIS Tasks for RabbitMQ and Google BigQuery.
-
Viewing Opsgenie Data in RAD Studio Data Explorer
How to view Opsgenie in RAD Studio Data Explorer using the CData ODBC Driver for Opsgenie.
-
Smartsheet Reporting in OBIEE with the Smartsheet JDBC Driver
Deploy the Smartsheet JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Moving Data from ConstantContact to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ConstantContact data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect to Live Hive Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Apache Hive for you.
-
Object-Relational Mapping (ORM) with Foursquare Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Foursquare into a Java-based ORM framework, Hibernate.