CData Software - Knowledge Base
Recent Articles
-
Connect to Neo4J Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Neo4J to connect to Neo4J data and execute queries in PowerBuilder.
-
Connect to Hubstaff Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Hubstaff data in the Denodo Virtual DataPort Administrator.
-
How to Seamlessly Import Sybase IQ Data into IBM SPSS Modeler
Integrate Sybase IQ data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Moosend Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Moosend data into the statistical analysis tools available in SAS JMP. This article shows how to use Moosend data in the Graph Builder and Query Builder.
-
Automated Continuous NetSuite Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable NetSuite replication to Amazon Redshift.
-
Create Dashboards and Visualize Live Dynamics NAV Data in Geckoboard
Use CData Connect AI to connect to live Dynamics NAV data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Replicate Optimizely Data to Multiple Databases
Replicate Optimizely data to disparate databases with a point-and-click configuration.
-
Build ServiceNow-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live ServiceNow data and build ServiceNow-connected web apps with Axios.
-
Import Real-Time Impala Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Impala data in ColdFusion.
-
Publish OData-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live OData services.
-
Replicate ConstantContact Data from PowerShell
Write a quick PowerShell script to query ConstantContact data. Use connectivity to the live data to replicate ConstantContact data to SQL Server.
-
How to Query Live Discourse Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Discourse data data in natural language using Python.
-
Deploy the ADO.NET Provider for Intercom on an SSRS Report Server
Connect to Intercom 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.
-
Enable the Vault CRM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Vault CRM data.
-
Manage Supabase Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Supabase.
-
Access Odoo 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 Odoo data.
-
Use the CData Software ODBC Driver for ShipEngine in MicroStrategy Web
Connect to ShipEngine data in MicroStrategy Web using the CData Software ODBC Driver for ShipEngine.
-
How to integrate Metabase with Amazon DynamoDB Data
Use CData Connect AI to connect to live Amazon DynamoDB data and create an interactive dashboard in Metabase from Amazon DynamoDB data.
-
Use the CData ODBC Driver for Lakebase from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Lakebase to connect to Lakebase data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Lakebase data in Excel.
-
Connect to Salesloft Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Salesloft Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Query Box Data as a MySQL Database in Node.js
Execute MySQL queries against Box data from Node.js.
-
Connect to ShipStation Data from Crystal Reports
Use CData Connect AI to connect to and report on live ShipStation data from Crystal Reports.
-
Build IBM Cloud Object Storage-Connected Apps in Choreo
Use CData Connect AI to connect to IBM Cloud Object Storage Data from Choreo and build custom apps using live IBM Cloud Object Storage data.
-
Connecting Mastra with QuickBooks Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time QuickBooks Online data, no replication required.
-
Working with Microsoft Planner Data in LINQPad
Execute LINQ queries to Microsoft Planner data in LINQPad.
-
Connect to Microsoft OneDrive 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 Microsoft OneDrive data.
-
Connect to ServiceDesk Plus Data in RazorSQL
Connect to ServiceDesk Plus from wizards and query ServiceDesk Plus data from the GUI in the RazorSQL database management tool.
-
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.
-
Integrating Codex with Hubstaff 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.
-
Replicate Multiple Tally Accounts via the CData Sync CLI
Replicate multiple Tally accounts to one or many databases.
-
How to connect to SAP BusinessObjects BI Data in DBVisualizer
Integrate SAP BusinessObjects BI data with visual data analysis tools and data connection wizards in DBVisualizer
-
Visualize Live Omnisend Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Omnisend data.
-
Automated Continuous SAP Concur Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP Concur replication to SingleStore.
-
Create PingOne-Connected Applications in Appsmith
Connect to PingOne Data via CData Connect AI in Appsmith and create custom business applications with real-time access to PingOne data.
-
Create a Data Access Object for Excel Data using JDBI
A brief overview of creating a SQL Object API for Excel data in JDBI.
-
Query Salesforce Data in DataGrip
Create a Data Source for Salesforce in DataGrip and use SQL to query live Salesforce data.
-
Build Pipelines with Live Avalara AvaTax Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Avalara AvaTax from Google Cloud Data Fusion, enabling the integration of live Avalara AvaTax data into the building and management of effective data pipelines.
-
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.
-
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.
-
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.
-
Publish Crystal Reports on CircleCI Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date CircleCI data.
-
Integrating Gumloop with Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Spark data within automated workflows.
-
Connect to LDAP Objects in NetBeans
Connect to LDAP objects in NetBeans with the data source configuration wizard.
-
Choosing the Best Method to Connect Anaplan to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Anaplan data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Choosing the Best Method to Connect Google Directory to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Directory data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
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.
-
Integrate Dify with Live CockroachDB 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 CockroachDB data.
-
Explore Geographical Relationships in Instantly Data with Power Map
Create data visualizations with Instantly data in Power Map.
-
Use Microsoft Copilot Studio to talk to your ZohoPeople Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your ZohoPeople data for you.
-
Natively Connect to Sybase IQ Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Sybase IQ data. Leverage the native support for ODBC in PHP.
-
Build Data Flows from Tickspot to SQL Server using SSIS
Easily back up Tickspot data to SQL Server using the SSIS components for Tickspot.
-
Build a PostgreSQL Interface for Cvent Data using the CData JDBC Driver
Use the Remoting features of the Cvent JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate ZeroBounce Data Replication to Azure Data Lake
Use CData Sync to customize and automate ZeroBounce data replication to Azure Data Lake.
-
Create a Data Access Object for Planio Data using JDBI
A brief overview of creating a SQL Object API for Planio data in JDBI.
-
Automated Continuous FHIR Replication to Vertica
Use CData Sync for automated, continuous, customizable FHIR replication to Vertica.
-
Analyze IBM Cloud Object Storage Data in Cognos Analytics
Use CData Connect AI to connect to IBM Cloud Object Storage Data from Cognos Analytics and analyze live IBM Cloud Object Storage data.
-
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.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Factorial
Provide connectivity to Factorial data through an SAP BusinessObjects universe.
-
Automated Continuous Todoist Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Todoist replication to Amazon Redshift.
-
Getting Started with the CData ODBC Driver for Presto
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Presto.
-
Query Perplexity Data as a MySQL Database in Node.js
Execute MySQL queries against Perplexity data from Node.js.
-
Automated Continuous LDAP Replication to Databricks
Use CData Sync for automated, continuous, customizable LDAP replication to Databricks.
-
How to Access Zoom Data Using Entity Framework
This article shows how to access Zoom data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Semantic Layer Views for Exa Data in APOS Live Data Gateway
Use the CData Connector for Exa in APOS Live Data Gateway to build Semantic Layer Views for Exa data.
-
Automate NASA Data Replication to Azure Synapse
Use CData Sync to customize and automate NASA data replication to Azure Synapse.
-
How to connect and process LightSpeedRetail data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live LightSpeedRetail data.
-
Connect to SendPulse Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SendPulse Data and connect to SendPulse data in Akorbi Digital RunMyProcess.
-
Integrating LangChain with ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on ActiveCampaign data within automated workflows.
-
Build Automated Workflows with Live Okta Data in Workato
Use CData Connect AI to connect to live Okta data and build automated workflows in Workato.
-
Access Live Workday Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Workday data from your Excel spreadsheets.
-
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.
-
Build Dropbox Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Dropbox data and build visualizations in Tableau.
-
Using the CData Software ODBC Driver for Wrike in PyCharm
Connect to Wrike as an ODBC data source in PyCharm using the CData Software ODBC Driver for Wrike.
-
Use Agno to Talk to Your Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Microsoft Planner data for you.
-
Object-Relational Mapping (ORM) with Templated 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 Templated data into a Java-based ORM framework, Hibernate.
-
Use Databricks Agent Bricks to Talk to Your Kintone Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Kintone data for you.
-
Edit and Search External Google Campaign Manager 360 Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Campaign Manager 360 data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Campaign Manager 360 Data objects that you can access from apps and the dashboard.
-
How to Build an ETL App for SparkPost Data in Python with CData
Create ETL applications and real-time data pipelines for SparkPost data in Python with petl.
-
Build Dashboards with CampaignMonitor Data in Dundas BI
Create dynamic dashboards and perform analytics based on CampaignMonitor data in Dundas BI.
-
Use Agno to Talk to Your Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Cosmos DB data for you.
-
How to Build an ETL App for Zoho Books Data in Python with CData
Create ETL applications and real-time data pipelines for Zoho Books data in Python with petl.
-
Connect to Freshteam Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Freshteam data.
-
DataBind Controls to Dynamics 365 Business Central Data in C++Builder
DataBind to Dynamics 365 Business Central data in C++Builder with standard components and controls.
-
Automate Dotmailer Data Replication to Azure Synapse
Use CData Sync to customize and automate Dotmailer data replication to Azure Synapse.
-
Bridge HubSpot Connectivity with Apache NiFi
Access and process HubSpot data in Apache NiFi using the CData JDBC Driver.
-
How to Connect Flowise AI Agents to Live SendPulse 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 SendPulse data without replication.
-
Automate Raisers Edge NXT Data Replication to SAP HANA
Use CData Sync to customize and automate Raisers Edge NXT data replication to SAP HANA.
-
Connect to Email Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Email data in the Denodo Virtual DataPort Administrator.
-
How to Connect DBeaver to AdRoll via a JDBC Driver
Manage AdRoll data with visual tools in DBeaver like the query browser.
-
Automated Continuous Samanage Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Samanage replication to Google BigQuery.
-
Publish Outreach.io-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Outreach.io data.
-
Integrate with Aha! Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Aha! data to a JSON file on disk.
-
How to Connect DBeaver to FreeAgent via a JDBC Driver
Manage FreeAgent data with visual tools in DBeaver like the query browser.
-
Connect to iContact Data in Google Apps Script via Connect AI
Use CData Connect AI to access iContact data in Google Apps Script.
-
Migrating data from Cohere to Snowflake using CData SSIS Components.
Easily push Cohere data to Snowflake using the CData SSIS Tasks for Cohere and Snowflake.
-
How to connect to Optimizely Data from IntelliJ
Integrate connectivity to Optimizely data with wizards in IntelliJ.
-
How to use SQLAlchemy ORM to access Pinecone Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Pinecone data.
-
Connect to and Visualize Live Google Campaign Manager 360 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Campaign Manager 360 data.
-
Build AI Agents with Anaplan 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 Anaplan data through CData Connect AI.