CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Float Replication to Oracle
Use CData Sync for automated, continuous, customizable Float replication to Oracle.
-
Deploy the ADO.NET Provider for OnePageCrm on an SSRS Report Server
Connect to OnePageCrm data 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.
-
Query, Visualize, and Share live Xero Data in Redash
Use CData Connect AI to connect to live Xero data in Redash for querying, visualizing, and sharing.
-
Connect to ShipStation Data from Crystal Reports
Use CData Connect AI to connect to and report on live ShipStation data from Crystal Reports.
-
Operational Reporting on Snowflake Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Snowflake data.
-
How to use SQLAlchemy ORM to access Aircall Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Aircall data.
-
Rapidly Develop Datadog-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 Datadog.
-
Couchbase Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Couchbase data through CData Connect AI using different applications and tools.
-
Automate CapsuleCRM Data Replication to Azure Synapse
Use CData Sync to customize and automate CapsuleCRM data replication to Azure Synapse.
-
How to connect PolyBase to Splunk
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Splunk data.
-
Connect and Query Live Zoho Projects Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Zoho Projects data into Databricks and enable direct, live querying and analysis without replication.
-
How to connect and process Google Sheets data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Sheets data.
-
Establish a Live Connection with Oracle Eloqua Data using Tableau Bridge
The CData ODBC Driver for Oracle Eloqua enables you to integrate live Oracle Eloqua data into Tableau Cloud dashboards using the Tableau Bridge.
-
Load Outreach.io Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Outreach.io data to a database.
-
Analyze Apollo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Apollo from Power Pivot. You will use the Table Import Wizard to load Apollo data. You can visually build the import query or use any SQL supported by the driver.
-
Analyze Auth0 Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Auth0 from Power Pivot. You will use the Table Import Wizard to load Auth0 data. You can visually build the import query or use any SQL supported by the driver.
-
Replicate Landbot Data from PowerShell
Write a quick PowerShell script to query Landbot data. Use connectivity to the live data to replicate Landbot data to SQL Server.
-
Visualize Access Data in Sisense
Create an ElastiCube in Sisense app with access to Access data.
-
Connect to Google Translate Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Translate as an External Source in Dremio.
-
Automated Kintone Data Replication to Teradata
Use CData Sync to Customize and automate Kintone data replication to Teradata.
-
Connect to Oracle HCM Cloud Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Oracle HCM Cloud.
-
Integrating Antigravity CLI with MariaDB data via CData CLI
Connect MariaDB data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating LangGraph with ZohoInvoice Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on ZohoInvoice data within automated workflows.
-
Access Live HDFS 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 HDFS data through MCP integration.
-
How to Connect DBeaver to Google Campaign Manager 360 via a JDBC Driver
Manage Google Campaign Manager 360 data with visual tools in DBeaver like the query browser.
-
Connect to Shippo Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Shippo Data and connect to Shippo data in Akorbi Digital RunMyProcess.
-
Integrate Supabase Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Supabase data and integrate live Supabase data into your Power Automate tasks.
-
Analyze Live Sage Intacct Data in SAS Viya
Use CData Connect AI to connect to Sage Intacct data from SAS Viya and deploy self-service analytics using live Sage Intacct data.
-
Prepare, Blend, and Analyze Retently Data in Alteryx Designer (ODBC)
Build workflows to access live Retently data for self-service data analytics.
-
Build Dashboards with Placid Data in Dundas BI
Create dynamic dashboards and perform analytics based on Placid data in Dundas BI.
-
Build Amazon S3-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Amazon S3 Data and create custom apps in Bubble.
-
Create Data Visualizations Based On Tally Data in Mode
Use CData Connect AI to connect to Tally Data from Mode and build visualizations using live Tally data.
-
Manage Accelo Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Accelo.
-
Build Data Flows from Tickspot to SQL Server using SSIS
Easily back up Tickspot data to SQL Server using the SSIS components for Tickspot.
-
Create Data Visualizations in Cognos BI with Onfleet Data
Access Onfleet data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Jumpseller-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Jumpseller data.
-
How to Easily Query SQL Server Data in OpenOffice Base
Connect to SQL Server data in OpenOffice Base using the CData ODBC Driver for SQL Server and generate reports with live data insights.
-
Build AdRoll-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to AdRoll data and build web apps with connectivity to live AdRoll data.
-
How to Connect DBeaver to Samanage via a JDBC Driver
Manage Samanage data with visual tools in DBeaver like the query browser.
-
Automate Bitly Data Replication to SAP HANA
Use CData Sync to customize and automate Bitly data replication to SAP HANA.
-
DataBind Controls to Outlook Data in Delphi
DataBind to Outlook data in Delphi with standard data access components and controls.
-
Automated Continuous SAP HANA Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP HANA replication to Oracle.
-
Connect to Real-Time Microsoft Teams Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Microsoft Teams and Dataflow to import and use Microsoft Teams data in Power Apps.
-
Integrating Claude Code CLI with Mouseflow 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.
-
Viewing Google Drive Data in RAD Studio Data Explorer
How to view Google Drive data in RAD Studio Data Explorer using the CData ODBC Driver for Google Drive.
-
How to Connect the Power BI Service to Samanage: Complete Guide
Connect to the CData Software Power BI Connector for Samanage from PowerBI.com to provide real-time Samanage data across the organization.
-
Connect to SAS xpt Data from PowerBuilder via JDBC
This article demonstrates how to access SAS xpt data from PowerBuilder using the SAS xpt JDBC Driver.
-
Load Aweber Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Aweber data to a database.
-
Connect to and Visualize Live Flowlu Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Flowlu data.
-
How to Work with Freshservice Data in AWS Glue Jobs Using JDBC
Connect to Freshservice from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Visualize Dropbox Data in Python with pandas
Use pandas and other modules to analyze and visualize live Dropbox data in Python.
-
Automated Continuous PolarTeamPro Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to PostgreSQL.
-
Automate Raisers Edge NXT Data Replication to SAP HANA
Use CData Sync to customize and automate Raisers Edge NXT data replication to SAP HANA.
-
Integrate Dify with Live Google Forms Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Google Forms data.
-
Access Live eBay Analytics Data in Coginiti Pro
Connect to and query live eBay Analytics data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Splunk Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Splunk data.
-
Connect to Dynamics CRM Data from a Connection Pool in JBoss
Integrate Dynamics CRM data into Java servlets: Use the Management Console in JBoss to install the Dynamics CRM JDBC Driver.
-
LINQ to SQL Analysis Services Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the SQL Analysis Services Data Provider.
-
Validate Trello Data with QuerySurge
Access and validate Trello data in QuerySurge using the CData JDBC Driver.
-
Integrating Kiro with Facebook Ads 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.
-
Choosing the Best Method to Connect Oracle SCM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Oracle SCM data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Mistral AI in SpagoBI
Create reports featuring live Mistral AI data in SpagoBI Studio. Host Mistral AI reports on SpagoBI Server.
-
How to connect to Freshsales Data in DBVisualizer
Integrate Freshsales data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build an OLAP Cube in SSAS from Templated Data
Establish a connection to Templated data data from SQL Server Analysis Services, and use the Templated Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Pinterest Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Pinterest replication to Amazon Redshift.
-
Establish a Live Connection with Mailgun Data using Tableau Bridge
The CData ODBC Driver for Mailgun enables you to integrate live Mailgun data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData ODBC Driver for XML in Microsoft Power Query
You can use the CData XML ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import XML data into Microsoft Power Query.
-
Visualize Live Confluence Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Confluence data.
-
Automated Continuous WooCommerce Replication to Databricks
Use CData Sync for automated, continuous, customizable WooCommerce replication to Databricks.
-
How to Connect to & Open Greenhouse Data in Microsoft Excel
This article uses the CData ODBC driver for Greenhouse to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Amazon S3 Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Amazon S3 data.
-
Getting Started with the CData ODBC Driver for Tally
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Tally.
-
Enable the Oracle HCM Cloud JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Oracle HCM Cloud data.
-
Migrating data from Okta to Google BigQuery using CData SSIS Components.
Easily push Okta data to Google BigQuery using the CData SSIS Tasks for Okta and Google BigQuery.
-
Build Epicor Kinetic Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Epicor Kinetic data and build visualizations in Tableau Cloud.
-
Integrate Live Spark Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Spark data and integrate live Spark data into apps built in Microsoft Power Apps.
-
Natively Connect to MessageBird Data in PHP
The CData ODBC driver for MessageBird enables you to create PHP applications with connectivity to MessageBird data. Leverage the native support for ODBC in PHP.
-
Analyze Google Forms Data in Looker
Use CData Connect AI to connect to Google Forms Data from Looker and build custom apps using live Google Forms data.
-
Automate Omnisend Data Replication to Azure Data Lake
Use CData Sync to customize and automate Omnisend data replication to Azure Data Lake.
-
Use Grok to Talk to Your Impala 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 Impala data for you.
-
Create a Data Access Object for Float Data using JDBI
A brief overview of creating a SQL Object API for Float data in JDBI.
-
Integrating LangGraph with SageHR Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SageHR data within automated workflows.
-
Access Live Smartsheet Data in AWS Lambda
Connect to live Smartsheet data in AWS Lambda using the CData JDBC Driver.
-
Natively Connect to NetSuite Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to NetSuite data. Leverage the native support for ODBC in PHP.
-
Analyze ShipStation Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ShipStation data and visualize live ShipStation data in Infragistics Reveal.
-
Connect to Procore Data in DBeaver
Use the CData ODBC Driver to connect to Procore data in DBeaver.
-
Automated Continuous GitHub Replication to Oracle
Use CData Sync for automated, continuous, customizable GitHub replication to Oracle.
-
Automated Continuous Airtable Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Airtable replication to PostgreSQL.
-
Connect to Planio Data in RapidMiner
Integrate Planio data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Dashboards and Visualize Live HubDB Data in Geckoboard
Use CData Connect AI to connect to live HubDB data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Live Cloudant Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Cloudant data from within the IDE.
-
Visualize Google Analytics Data in TIBCO Spotfire through OData
Integrate Google Analytics data into dashboards in TIBCO Spotfire.
-
How to Access Mailgun Data Using Entity Framework
This article shows how to access Mailgun data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData Tableau Connector for eBay
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for eBay.
-
Object-Relational Mapping (ORM) with Attio 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 Attio data into a Java-based ORM framework, Hibernate.
-
Integrate LibreChat with Live Dynamics 365 Business Central Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Dynamics 365 Business Central data from within the chat interface.
-
Use CData Connect AI to Access SurveyMonkey Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SurveyMonkey data in the Power Pivot business intelligence tool.
-
Automated Continuous Helpscout Replication to SQL Server
Use CData Sync for automated, continuous, customizable Helpscout replication to SQL Server.
-
How to connect to PabblySubscriptions Data with Squirrel SQL client
Connect to PabblySubscriptions data and execute queries in the Squirrel SQL Client.
-
Use the CData Software JDBC Driver for Sage Cloud Accounting in MicroStrategy Desktop
Connect to Sage Cloud Accounting data in MicroStrategy Desktop using the CData Software JDBC Driver for Sage Cloud Accounting.