CData Software - Knowledge Base
Recent Articles
-
DataBind Controls to Stack Exchange Data in C++Builder
DataBind to Stack Exchange data in C++Builder with standard components and controls.
-
Integrate SFTP with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SFTP with External Services.
-
Integrate Google Campaign Manager 360 with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Campaign Manager 360 with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Campaign Manager 360 data.
-
Integrating LlamaIndex with Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Cvent data in real time.
-
MongoDB Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on MongoDB facts in real time.
-
Connect Close to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Close data using the CData Python MCP Server.
-
Object-Relational Mapping (ORM) with Auth0 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 Auth0 data into a Java-based ORM framework, Hibernate.
-
Build Semantic Layer Views for SAP Ariba Source Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP Ariba Source data.
-
Build EnterpriseDB-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live EnterpriseDB data and build EnterpriseDB-connected web apps with Axios.
-
Build a Singer.io Tap for Accelo With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Accelo data using the CData Python Connector.
-
Connect to SFTP Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SFTP as an External Source in Dremio.
-
Replicate Marketo Data from PowerShell
Write a quick PowerShell script to query Marketo data. Use connectivity to the live data to replicate Marketo data to SQL Server.
-
Integrating Cursor with Lakebase 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.
-
Connect Contentful Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Contentful data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Migrating data from PabblySubscriptions to Google BigQuery using CData SSIS Components.
Easily push PabblySubscriptions data to Google BigQuery using the CData SSIS Tasks for PabblySubscriptions and Google BigQuery.
-
Use the CData ODBC Driver for Klaviyo in Microsoft Power Query
You can use the CData Klaviyo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Klaviyo data into Microsoft Power Query.
-
Work with SAP SuccessFactors LMS Data in FoxPro
Load SAP SuccessFactors LMS data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build MYOB AccountRight-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to MYOB AccountRight data and build web apps with connectivity to live MYOB AccountRight data.
-
Build a Simple VCL Application for Samanage Data
How to build a simple VCL Application to view Samanage data in RAD Studio using the CData ODBC Driver for Samanage.
-
Access Live Tickspot Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Tickspot data into the statistical analysis tools available in SAS JMP. This article shows how to use Tickspot data in the Graph Builder and Query Builder.
-
Integrating Claude Code CLI with Productboard 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 Highrise-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Highrise Data and create custom apps in Mendix.
-
Build Amazon Marketplace Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Amazon Marketplace data and build visualizations in Tableau.
-
Automate AdRoll Data Replication to Couchbase
Use CData Sync to Customize and automate AdRoll data replication to Couchbase.
-
Connecting Pipedream with SageHR Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on SageHR data in real time.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to delimited files (CSV/TSV).
-
Enable the Jira JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Jira data.
-
Connect to Timely 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 Timely and work with Timely data in your FileMaker application.
-
Integrate Google's Antigravity Agent with Live Discord Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Discord data using the Model Context Protocol.
-
Integrate Live CockroachDB 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 CockroachDB data from within the IDE.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Google BigQuery.
-
Publish Crystal Reports on Outreach.io Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Outreach.io data.
-
How to Seamlessly Import ZohoExpense Data into IBM SPSS Modeler
Integrate ZohoExpense data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automate Pinecone Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Pinecone data from PowerShell? This article demonstrates how to utilize the Pinecone Cmdlets for tasks like connecting to Pinecone data, automating operations, downloading data, and more.
-
Create Reports with ChargeOver Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ChargeOver data.
-
Query OneNote Data as a MySQL Database in Node.js
Execute MySQL queries against OneNote data from Node.js.
-
Automate CampaignMonitor Data Replication to SAP HANA
Use CData Sync to customize and automate CampaignMonitor data replication to SAP HANA.
-
Building Dynamic Web Pages with SAP Fieldglass Data Using AngularJS
Create single-page applications with live connectivity to SAP Fieldglass using the CData API Server.
-
Analyze Live Raisers Edge NXT Data in SAS Viya
Use CData Connect AI to connect to Raisers Edge NXT data from SAS Viya and deploy self-service analytics using live Raisers Edge NXT data.
-
Automated Continuous Dynamics 365 Business Central Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to PostgreSQL.
-
How to Work with Impala Data in ETL Validator JDBC
Connect to Impala from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Cline with Live Sage 300 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Sage 300 data from within your IDE.
-
Connect and Query Live Azure Synapse Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Azure Synapse data into Databricks and enable direct, live querying and analysis without replication.
-
Use Agno to Talk to Your TaxJar 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 TaxJar data for you.
-
Visualize Perigon Data in Sisense
Create an ElastiCube in Sisense app with access to Perigon data.
-
Build Adobe Analytics-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Adobe Analytics data and build Adobe Analytics-connected web apps with Axios.
-
How to Visualize Rebilly Data in Python with pandas
Use pandas and other modules to analyze and visualize live Rebilly data in Python.
-
Validate Phoenix Data with QuerySurge
Access and validate Phoenix data in QuerySurge using the CData JDBC Driver.
-
Build Couchbase Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Couchbase data and build visualizations in Tableau.
-
Automated Continuous Dynamics CRM Replication to MySQL
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to MySQL.
-
Automated Continuous Jumpseller Replication to MySQL
Use CData Sync for automated, continuous, customizable Jumpseller replication to MySQL.
-
Visualize SAP Concur Data in TIBCO Spotfire through OData
Integrate SAP Concur data into dashboards in TIBCO Spotfire.
-
Validate WooCommerce Data with QuerySurge
Access and validate WooCommerce data in QuerySurge using the CData JDBC Driver.
-
Access Live ShipStation Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ShipStation data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query CampaignMonitor Data through ODBC in Node.js
Use node-odbc to execute SQL queries against CampaignMonitor data from Node.js.
-
Access Live XML Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live XML data through MCP integration.
-
Import Real-Time Rebilly Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Rebilly data in ColdFusion.
-
How to Access Datadog Data Using Entity Framework
This article shows how to access Datadog data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous SpaceX Replication to SingleStore
Use CData Sync for automated, continuous, customizable SpaceX replication to SingleStore.
-
Back Up Chargebee data 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 Chargebee data data.
-
Automated Continuous SparkPost Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SparkPost replication to Amazon Redshift.
-
Connect to Cassandra Data from AWS Glue
Use CData Connect AI to gain access to live Cassandra data from your AWS Glue jobs.
-
Automated Continuous Microsoft Exchange Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to Apache Cassandra.
-
How to Connect Sage 200 Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Sage 200 data in real time using natural language.
-
Connect to Greenhouse Data in RazorSQL
Connect to Greenhouse from wizards and query Greenhouse data from the GUI in the RazorSQL database management tool.
-
Query Sybase IQ Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Sybase IQ entities in PHP by modeling them as objects.
-
How to Query OneNote Data in MySQL Workbench
Execute MySQL queries against live OneNote data from MySQL Workbench.
-
Access SAP Netweaver Gateway 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 SAP Netweaver Gateway data.
-
How to work with Freshservice Data in Apache Spark using SQL
Access and process Freshservice Data in Apache Spark using the CData Software JDBC Driver.
-
Connect Gumroad to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Gumroad with IBM WebSphere for seamless data integration and connectivity.
-
Replicate PayPal Data to Multiple Databases via the CData Sync CLI
Replicate PayPal data to disparate databases with a single configuration.
-
Connect to and Visualize Live Elorus Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Elorus data.
-
Oracle Eloqua Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Oracle Eloqua data through CData Connect AI using different applications and tools.
-
Use CData Connect AI to Access IBM Informix Data in Microsoft Power Pivot
Use CData Connect AI to connect to live IBM Informix data in the Power Pivot business intelligence tool.
-
Connecting Agentforce with Neo4J Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Neo4J data for you.
-
How to Build an ETL App for ZohoExpense Data in Python with CData
Create ETL applications and real-time data pipelines for ZohoExpense data in Python with petl.
-
Connect to AlloyDB Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for AlloyDB Data and connect to AlloyDB data in Akorbi Digital RunMyProcess.
-
How to work with RSS Feeds in Apache Spark using SQL
Access and process RSS Feeds in Apache Spark using the CData Software JDBC Driver.
-
Analyze SageHR Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SageHR from Power Pivot. You will use the Table Import Wizard to load SageHR data. You can visually build the import query or use any SQL supported by the driver.
-
DataBind Charts to Salesloft Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Salesloft data 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 Dash to Build Web Apps on Act-On Data via CData Connect AI
Build interactive Dash web apps on live Act-On data using pandas and the CData Connect AI Python SDK.
-
Automated Continuous Splunk Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Splunk replication to Apache Kafka.
-
Automate Pipedrive Data Replication to SAP HANA
Use CData Sync to customize and automate Pipedrive data replication to SAP HANA.
-
How to create ScrapingBee federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ScrapingBee data in MySQL .
-
Connecting Agentforce with Typeform Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Typeform data for you.
-
Automate ZohoPeople Data Replication to Azure Synapse
Use CData Sync to customize and automate ZohoPeople data replication to Azure Synapse.
-
Build Zoho Projects-Connected Apps in Choreo
Use CData Connect AI to connect to Zoho Projects Data from Choreo and build custom apps using live Zoho Projects data.
-
Consume Access OData Feeds in PowerBuilder
This article demonstrates how to consume Access data as OData feeds from PowerBuilder using the API Server.
-
Configure the CData JDBC Driver for ZohoInvoice in a Connection Pool in Tomcat
Connect to ZohoInvoice data from a connection pool in Tomcat.
-
Using the CData Software ODBC Driver for SAP ByDesign in PyCharm
Connect to SAP ByDesign as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP ByDesign.
-
Use the CData SSIS Components to Insert New or Update Existing Avalara AvaTax Records from SQL Server
Easily push SQL Server data to Avalara AvaTax using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Avalara AvaTax or update existing records with data from a SQL Server database.
-
Create SSAS Tabular Models from HelloSign Data
How to build a SQL Server Analysis Service Tabular Model from HelloSign data using CData drivers.
-
Integrating Claude Code CLI with SAS Data Sets 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.
-
Connect to Salesforce Pardot Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce Pardot and the Script function in FileMaker Pro to connect to Salesforce Pardot and work with Salesforce Pardot data in your FileMaker application.
-
Connect to Live Asana Data in MicroStrategy through CData Connect AI
Create a live connection to Asana Data in CData Connect AI and connect to your Asana data from MicroStrategy.
-
How to Connect to Live Elasticsearch Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Elasticsearch data securely in real time.
-
Connect to Dotmailer Data in DBeaver
Use the CData ODBC Driver to connect to Dotmailer data in DBeaver.
-
Use Biml to Build SSIS Tasks to Replicate Dropbox Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Dropbox data to SQL Server.
-
Connect to Guru Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Guru Data and connect to Guru data in Akorbi Digital RunMyProcess.
-
Use Dash to Build to Web Apps on Zoho Books Data
Create Python applications that use pandas and Dash to build Zoho Books-connected web apps.