CData Software - Knowledge Base
Recent Articles
-
Build MVC Applications with Connectivity to Pipeliner CRM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Pipeliner CRM from an ASP.NET MVC application.
-
How to Seamlessly Import Google Drive Data into IBM SPSS Modeler
Integrate Google Drive data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Back Up Apify 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 Apify data.
-
Connect SAP SuccessFactors LMS Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP SuccessFactors LMS using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Deploy the ADO.NET Provider for Oracle Eloqua on an SSRS Report Server
Connect to Oracle Eloqua 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.
-
Integrate Live Basecamp Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Basecamp and integrate live Basecamp into apps built in Microsoft Power Apps.
-
Access Live Shippo Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Shippo into the statistical analysis tools available in SAS JMP. This article shows how to use Shippo in the Graph Builder and Query Builder.
-
How to connect and process GitHub from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live GitHub.
-
Automated Continuous Outreach.io Replication to Databricks
Use CData Sync for automated, continuous, customizable Outreach.io replication to Databricks.
-
Build Sentry-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sentry.
-
Manage Coda Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Coda.
-
Visualize NetSuite Data in Sisense
Create an ElastiCube in Sisense app with access to NetSuite CRM & ERP.
-
Connect to Mailjet Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use CData Connect AI to Access LinkedIn Data in Microsoft Power Pivot
Use CData Connect AI to connect to live LinkedIn in the Power Pivot business intelligence tool.
-
Connect to Procore Data from HeidiSQL
Use CData Connect AI to connect to and query live Procore from HeidiSQL.
-
Connecting Moonlit Workflow with MySQL Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your MySQL in real time.
-
Connect to Contentful Data from PowerBuilder via ADO.NET
This article demonstrates how to access Contentful from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Work with Paylocity Data in AWS Glue Jobs Using JDBC
Connect to Paylocity from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Import Google Cloud Storage Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Cloud Storage Data and provide access to live Google Cloud Storage for custom reports in the Power BI Service.
-
How to connect and process FreeAgent from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live FreeAgent.
-
Query ZohoInvoice Data in ColdFusion
Write standard ColdFusion data access code to connect to ZohoInvoice.
-
How to Connect to Live Azure Table Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Azure Table Storage through natural language.
-
Create Vercel Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Vercel from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Live Jira Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Jira from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Atlassian Jira.
-
Automated Continuous Tickspot Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Tickspot replication to AlloyDB.
-
Work with Live YouTube Analytics Data in Power Query
Use CData Connect AI to connect to YouTube Analytics and work with live YouTube Analytics in Microsoft Power Query.
-
Create Azure Analysis Services-Connected Business Apps in AppSheet
Connect to Azure Analysis Services Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Azure Analysis Services.
-
Integrating Gumloop with PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on PayPal within automated workflows.
-
Automated Continuous Oracle SCM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle SCM replication to OneLake in Microsoft Fabric.
-
Connect to ServiceNow Data from a Connection Pool in Jetty
The ServiceNow JDBC Driver supports connection pooling: This article shows how to connect faster to ServiceNow from Web apps in Jetty.
-
Create Reports from Jira Data in Looker Studio
Use CData Connect AI to gain access to live Atlassian Jira and create custom reports in Looker Studio.
-
How to Access Sentry Data Using Entity Framework
This article shows how to access Sentry using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Dynamics NAV with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Dynamics NAV with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft Dynamics NAV.
-
A PostgreSQL Interface for Amplitude Data (MySQL Remoting via JDBC)
Use the Remoting features of the Amplitude JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Accelo Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Accelo and work with Accelo in your FileMaker applications.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live HubSpot using the Model Context Protocol.
-
Analyze Live Excel Online Data in SAS Viya
Use CData Connect AI to connect to Microsoft Excel Online from SAS Viya and deploy self-service analytics using live Microsoft Excel Online.
-
Use Manus AI to Talk to Your DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on IBM DB2.
-
Load Qualaroo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Qualaroo to a database.
-
Use the CData Software JDBC Driver for eBay Analytics in MicroStrategy Desktop
Connect to eBay Analytics in MicroStrategy Desktop using the CData Software JDBC Driver for eBay Analytics.
-
DataBind Controls to Stack Exchange Data in C++Builder
DataBind to Stack Exchange 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.
-
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 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 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 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.
-
Build EnterpriseDB-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live EnterpriseDB 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
-
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. Use connectivity to the live data to replicate Marketo to SQL Server.
-
Integrating Cursor CLI 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 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 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 into Microsoft Power Query.
-
How to Access Live SAS Data Sets Data in Visual Studio Code via Cline
Run CData MCP Server for SAS Data Sets on Windows Subsytem for Linux (WSL) and connect to live SAS Data Sets from the Cline extension in Visual Studio Code.
-
Work with SAP SuccessFactors LMS Data in FoxPro
Load SAP SuccessFactors LMS 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 and build web apps with connectivity to live MYOB AccountRight.
-
Build a Simple VCL Application for Samanage Data
How to build a simple VCL Application to view Samanage 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 into the statistical analysis tools available in SAS JMP. This article shows how to use Tickspot 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 and build visualizations in Tableau.
-
Automate AdRoll Data Replication to Couchbase
Use CData Sync to Customize and automate AdRoll replication to Couchbase.
-
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 Atlassian Jira.
-
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 in your FileMaker application.
-
Integrate Live CockroachDB Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
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.
-
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 from PowerShell? This article demonstrates how to utilize the Pinecone Cmdlets for tasks like connecting to Pinecone, 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.
-
Query OneNote Data as a MySQL Database in Node.js
Execute MySQL queries against Microsoft OneNote from Node.js.
-
Automate CampaignMonitor Data Replication to SAP HANA
Use CData Sync to customize and automate CampaignMonitor 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 from SAS Viya and deploy self-service analytics using live Raisers Edge NXT.
-
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.
-
Connect and Query Live Azure Synapse Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Azure Synapse into Databricks
-
Visualize Perigon Data in Sisense
Create an ElastiCube in Sisense app with access to Perigon.
-
Build Adobe Analytics-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Adobe Analytics 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 in Python.
-
Validate Phoenix Data with QuerySurge
Access and validate Apache Phoenix in QuerySurge using the CData JDBC Driver.
-
Build Couchbase Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Couchbase 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 into dashboards in TIBCO Spotfire.
-
Validate WooCommerce Data with QuerySurge
Access and validate WooCommerce in QuerySurge using the CData JDBC Driver.
-
Access Live ShipStation Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ShipStation 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 from Node.js.
-
Import Real-Time Rebilly Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Rebilly in ColdFusion.
-
How to Access Datadog Data Using Entity Framework
This article shows how to access Datadog 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 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.
-
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 Apache Cassandra 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.