CData Software - Knowledge Base
Recent Articles
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Kintone
Provide connectivity to Kintone through an SAP BusinessObjects universe.
-
Build Visualizations of Qualaroo Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Qualaroo in Birst.
-
Use the CData Software JDBC Driver for Yelp in MicroStrategy
Connect to Yelp in MicroStrategy Developer using the CData Software JDBC Driver for Yelp.
-
Integrate LibreChat with Live SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft SharePoint from within the chat interface.
-
Build a Simple VCL Application for ClickUp Data
How to build a simple VCL Application to view ClickUp in RAD Studio using the CData ODBC Driver for ClickUp.
-
Access Live MailChimp Data in Coginiti Pro
Connect to and query live MailChimp from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Reply.io Data in CloverDX (formerly CloverETL)
Transfer Reply.io using the visual workflow in the CloverDX data integration tool.
-
Back Up SAP Business One to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Business One. In this article, we will employ an SSIS workflow to populate a database with SAP Business One data.
-
Feed Zoho Recruit Data into FineReport
How to set Zoho Recruit as a JDBC data source in FineReport.
-
Replicate Zoho Inventory Data in Heroku for Use in Salesforce Connect
Replicate Zoho Inventory to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Import IBM Informix Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access IBM Informix. In this article, you will use the OData format to import IBM Informix into Microsoft Power Query.
-
Visualize Facebook Data in Tableau
The CData ODBC driver for Facebook enables you integrate Facebook into Tableau dashboards.
-
Build Salesforce-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Salesforce to explore live Salesforce Data in Claude Code to assist with building Salesforce-powered applications.
-
Replicate ZohoSubscriptions Data from PowerShell
Write a quick PowerShell script to query ZohoSubscriptions. Use connectivity to the live data to replicate ZohoSubscriptions to SQL Server.
-
Use Databricks Agent Bricks to Talk to Your Phoenix Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Apache Phoenix for you.
-
Create Dynamics CRM-Connected Applications in Appsmith
Connect to Dynamics CRM Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Microsoft Dynamics CRM.
-
Build Amazon Athena Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Amazon Athena and build visualizations in Tableau Cloud.
-
Import FTP Data Using Azure Data Factory
Use CData Connect AI to connect to FTP Data from Azure Data Factory and import live FTP Servers.
-
Choosing the Best Method to Connect Teamwork to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Teamwork from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to Live Microsoft Dataverse Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Microsoft Dataverse (CDS) for you.
-
Build Cloudant-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Cloudant to explore live Cloudant Data in Gemini Code Assist to assist with building Cloudant-powered applications.
-
Connecting Agentforce with Procore 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 Procore for you.
-
How to Connect to Live Oracle 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 Oracle Database for you.
-
How to connect to Hubstaff Data from IntelliJ
Integrate connectivity to Hubstaff with wizards in IntelliJ.
-
Object-Relational Mapping (ORM) with NASA 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 NASA into a Java-based ORM framework, Hibernate.
-
Viewing AfterShip Data in RAD Studio Data Explorer
How to view AfterShip in RAD Studio Data Explorer using the CData ODBC Driver for AfterShip.
-
Visualize Live LionDesk Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live LionDesk.
-
Getting Started with the CData Python Connector for ZohoSubscriptions
Learn to install and license the CData Python Connector
-
Connect to Pinterest Data from a Connection Pool in JBoss
Integrate Pinterest into Java servlets: Use the Management Console in JBoss to install the Pinterest JDBC Driver.
-
Integrating LlamaIndex with Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Pivotal GreenPlum in real time.
-
Choosing the Best Method to Connect FreeAgent to SQL Server: 5 Options Explained
Discover multiple ways to connect and use FreeAgent from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Google Drive Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Drive facts in real time.
-
Integrating LangGraph with Google Drive Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Drive within automated workflows.
-
Connect to Webex Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Webex and the SQL Gateway to access Webex from Google Apps Script.
-
Create Informatica Mappings From/To an ODBC Data Source for Workable
Create an ODBC connection to Workable in Informatica and browse and transfer Workable.
-
Create Reports with Bannerbear Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bannerbear.
-
Integrating Boomi Agentstudio with BigQuery Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google BigQuery, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
LINQ to PagerDuty 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 PagerDuty Data Provider.
-
Integrate Live Monday.com Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Monday.com from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Monday.com.
-
Using the CData Software ODBC Driver for Salesforce in PyCharm
Connect to Salesforce as an ODBC data source in PyCharm using the CData Software ODBC Driver for Salesforce.
-
How to use SQLAlchemy ORM to access Trello Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Trello.
-
Access Live Postmark Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Postmark in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Pipedrive Data from Crystal Reports
Use CData Connect AI to connect to and report on live Pipedrive from Crystal Reports.
-
Use the CData Software ODBC Driver for Kintone in MicroStrategy
Connect to Kintone in MicroStrategy Developer using the CData Software ODBC Driver for Kintone.
-
Rapidly Develop Brex-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 Brex.
-
Model Elasticsearch Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Elasticsearch, enabling the direct import of real-time Elasticsearch.
-
Use Agno to Talk to Your Authorize.Net 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 Authorize.Net for you.
-
Analyze Coinbase Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Coinbase from Power Pivot. You will use the Table Import Wizard to load Coinbase. You can visually build the import query or use any SQL supported by the driver.
-
Connect to ZohoExpense Data in NetBeans
Connect to ZohoExpense in NetBeans with the data source configuration wizard.
-
Bridge Kafka Connectivity with Apache NiFi
Access and process Apache Kafka in Apache NiFi using the CData JDBC Driver.
-
Use Databricks Agent Bricks to Talk to Your Snapchat Ads Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Snapchat Ads for you.
-
How to Connect Flowise AI Agents to Live Oracle HCM Cloud 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 Oracle HCM Cloud without replication.
-
Automated Continuous Tickspot Replication to SingleStore
Use CData Sync for automated, continuous, customizable Tickspot replication to SingleStore.
-
Connect to Pinecone Data in JRuby
Create a simple JRuby app with access to live Pinecone.
-
Create Informatica Mappings From/To a JDBC Data Source for Discord
Create Discord data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Salesforce Marketing-Connected Apps in Choreo
Use CData Connect AI to connect to Salesforce Marketing Data from Choreo and build custom apps using live Salesforce Marketing Cloud.
-
Integrating Gumloop with Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Authorize.Net within automated workflows.
-
Connect to Google Calendar Data from PowerBuilder via JDBC
This article demonstrates how to access Google Calendar from PowerBuilder using the Google Calendar JDBC Driver.
-
How to load Printify data into Elasticsearch via Logstash
Introducing a simple method to load Printify data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData JDBC Driver for NASA
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for NASA.
-
Load DB2 Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load IBM DB2 to a database.
-
Build AI/ML Models with Live LinkedIn Ads Data using Dataiku
Connect LinkedIn Ads Data with Dataiku using the CData JDBC Driver for LinkedIn Ads.
-
Write a Simple Go Application to work with Webex Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Webex.
-
Extract, Transform, and Load Google Cloud Storage Data in Informatica PowerCenter
Create a simple Workflow for Google Cloud Storage in Informatica PowerCenter.
-
Write a Simple Go Application to work with Qualaroo Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Qualaroo.
-
Guru Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Guru facts in real time.
-
Access SendGrid Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SendGrid from your Oracle system.
-
Replicate MessageBird Data from PowerShell
Write a quick PowerShell script to query MessageBird. Use connectivity to the live data to replicate MessageBird to SQL Server.
-
How to Access Oracle Financials Cloud Data Using Entity Framework
This article shows how to access Oracle Financials Cloud using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Query Live SAP SuccessFactors LMS Data in Perplexity MacOS Desktop
Connect to and query live SAP SuccessFactors LMS Data in Perplexity Desktop using CData MCP Server.
-
Migrating data from Apollo to Databricks using CData SSIS Components.
Easily push Apollo to Databricks using the CData SSIS Tasks for Apollo and Databricks.
-
Automated Continuous Printify Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Printify replication to Google BigQuery.
-
Integrate Live Paylocity Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create a Data Access Object for Zendesk Data using JDBI
A brief overview of creating a SQL Object API for Zendesk in JDBI.
-
Integrate with Billsby Data in JReport Designer
Create charts and reports based on Billsby in JReport Designer.
-
Build Dashboards with Workday Data in DBxtra
Create dynamic dashboards and perform analytics based on Workday in DBxtra.
-
How to Import Data from Greenplum into Google Sheets
Import Pivotal GreenPlum into a Google spreadsheet that is automatically refreshed.
-
Connect to Amazon Athena Data from Crystal Reports
Use CData Connect AI to connect to and report on live Amazon Athena from Crystal Reports.
-
Automated Continuous Blackbaud FE NXT Replication to Vertica
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Vertica.
-
Create Power BI Reports on Real-Time Clockify Data
Use the CData ODBC Driver for Clockify to visualize Clockify in Power BI Desktop.
-
Connect to FreshBooks Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Bitly from Asprova with CData Software ODBC Driver for Bitly
This article shows how to connect faster to Bitly data from Asprova.
-
Build Odoo-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Odoo ERP.
-
Automated Continuous Delighted Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Delighted replication to Azure SQL Database.
-
Connect to Odoo Data in DBArtisan
Use wizards in DBArtisan to configure Odoo ERP as a data source.
-
Create Informatica Mappings From/To a JDBC Data Source for Hive
Create Hive data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Back Up Optimizely 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 Optimizely data.
-
Connect to Smartsheet Data in Ruby
Connect to Smartsheet in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Real-Time Access to Sybase in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Sybase in real time.
-
Automated Continuous SharePoint Replication to MySQL
Use CData Sync for automated, continuous, customizable SharePoint replication to MySQL.
-
Getting Started with the CData JDBC Driver for Eventbrite
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Eventbrite.
-
Connect to ZarMoney from a Connection Pool in WebLogic
Use the CData JDBC Driver for ZarMoney to connect to ZarMoney from Web applications running on WebLogic.
-
Access Live Onfleet Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Onfleet in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData ODBC Driver for Marketo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Marketo.
-
Easily Integrate Salesforce CRM Analytics Data in Lazarus Pascal IDE
Learn how to easily integrate live Salesforce CRM Analytics in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Analyze Oracle HCM Cloud Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Oracle HCM Cloud in Microsoft R Open.
-
Integrating Dataiku with OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft OneNote.
-
Access Live Adobe Target Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Adobe Target in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Impala 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 Apache Impala.
-
Connect to and Visualize Live SAP SuccessFactors LMS Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP SuccessFactors LMS.