CData Software - Knowledge Base
Recent Articles
-
Build a Simple VCL Application for Clari Data
How to build a simple VCL Application to view Clari in RAD Studio using the CData ODBC Driver for Clari.
-
Automated Continuous FHIR Replication to AlloyDB
Use CData Sync for automated, continuous, customizable FHIR replication to AlloyDB.
-
Choosing the Best Method to Connect Coda to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Coda from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to GetResponse 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 GetResponse and work with GetResponse in your FileMaker application.
-
Connect and Visualize Live Active Directory Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Active Directory into the Databricks platform and create visualization dashboards with real-time Active Directory.
-
Connect to CockroachDB Data in Jaspersoft Studio
Execute SQL to remote CockroachDB in Jaspersoft Studio.
-
Connect to Sage Cloud Accounting Data in NetBeans
Connect to Sage Business Cloud Accounting in NetBeans with the data source configuration wizard.
-
How to connect Amazon QuickSight to Tally Data
Create a connection to Tally ERP in CData Connect AI and insert Tally ERP into Amazon QuickSight SPICE to build interactive dashboards.
-
Import and Visualize SageHR Data in Power View
Create data visualizations based on SageHR in Excel.
-
Use the CData Software ODBC Driver for Paddle in MicroStrategy Desktop
Connect to Paddle in MicroStrategy Desktop using the CData Software ODBC Driver for Paddle.
-
Use Dash to Build to Web Apps on Redis Data
Create Python applications that use pandas and Dash to build Redis-connected web apps.
-
Connecting Agentforce with Cassandra 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 Apache Cassandra for you.
-
How to Seamlessly Import Mailgun Data into IBM SPSS Modeler
Integrate Mailgun data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate SuiteCRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SuiteCRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SuiteCRM.
-
How to Connect to Live HCL Domino Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your HCL Domino for you.
-
Automated Continuous Splunk Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Splunk replication to AlloyDB.
-
Use the CData SSIS Components to Insert New or Update Existing HBase Records from SQL Server
Easily push SQL Server data to HBase using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into HBase or update existing records with data from a SQL Server database.
-
Create Datasets from SAP Ariba Procurement in Domo Workbench and Build Visualizations of SAP Ariba Procurement Data in Domo
Use the CData Software ODBC Driver for SAP Ariba Procurement to create datasets from SAP Ariba Procurement in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Google Tasks Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Tasks replication to Snowflake.
-
Feed Twilio Data into FineReport
How to set Twilio as a JDBC data source in FineReport.
-
Connect to Jira Assets Data in DBArtisan
Use wizards in DBArtisan to configure Jira Assets as a data source.
-
Operational Reporting on Gmail Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Gmail.
-
Query Cassandra Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Cassandra entities in PHP by modeling them as objects.
-
Connect to Workday from Asprova with CData Software ODBC Driver for Workday
This article shows how to connect faster to Workday data from Asprova.
-
Object-Relational Mapping (ORM) with SharePoint 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 Microsoft SharePoint into a Java-based ORM framework, Hibernate.
-
Build Agents in Relevance AI with Access to Live CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Apache CouchDB within intelligent agent workflows.
-
Query SAP ByDesign Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP Business ByDesign.
-
Natively Connect to Samanage Data in PHP
The CData ODBC driver for Samanage enables you to create PHP applications with connectivity to Samanage. Leverage the native support for ODBC in PHP.
-
Build a Simple VCL Application for MailChimp Data
How to build a simple VCL Application to view MailChimp in RAD Studio using the CData ODBC Driver for MailChimp.
-
Create Gong-Connected Business Apps in AppSheet
Connect to Gong Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Gong.
-
Automated Continuous GitHub Replication to SQLite
Use CData Sync for automated, continuous, customizable GitHub replication to SQLite.
-
Back Up Mouseflow 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 Mouseflow data.
-
Integrating OpenWeatherMap Data in Talend Cloud Data Management Platform
Connect OpenWeatherMap Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Getting Started with the CData Excel Add-In for Epicor Kinetic
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Epicor Kinetic.
-
Integrate Goose with Live Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Xero Accounting from within the local AI agent.
-
Integrate with live Zoho Projects Data in Jitterbit
Use CData Connect AI to connect to and integrate live Zoho Projects in Jitterbit.
-
Build Salesforce Data 360-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Salesforce Data 360 to explore live Salesforce Data 360 Data in GitHub Copilot to assist with building Salesforce Data 360-powered applications.
-
Connect to DB2 Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for DB2 Data and connect to IBM DB2 in Akorbi Digital RunMyProcess.
-
Connect to Shopify Data in Aqua Data Studio
Access Shopify from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect the Power BI Service to Aweber: Complete Guide
Connect to the CData Software Power BI Connector for Aweber from PowerBI.com to provide real-time Aweber across the organization.
-
Import Sage Cloud Accounting Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Sage Business Cloud Accounting. In this article, you will use the OData format to import Sage Business Cloud Accounting into Microsoft Power Query.
-
Design BIRT Reports on Salesforce Marketing Data
Provide current Salesforce Marketing Cloud to your embedded analytics.
-
Access Live Pingdom Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Pingdom into the statistical analysis tools available in SAS JMP. This article shows how to use Pingdom in the Graph Builder and Query Builder.
-
Create Informatica Mappings From/To a JDBC Data Source for FTP
Create FTP data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to SAP SuccessFactors Data in CloverDX (formerly CloverETL)
Transfer SAP SuccessFactors using the visual workflow in the CloverDX data integration tool.
-
Use Microsoft Copilot Studio to talk to your Vertica 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 Vertica for you.
-
Configure the CData JDBC Driver for JSON in a Connection Pool in Tomcat
Connect to JSON from a connection pool in Tomcat.
-
How to Query Live Cosmos DB Data in Claude Desktop
Connect to and query live Cosmos DB Data in Claude Desktop using CData MCP Server.
-
Import Salesforce Data into Google Spreadsheets
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to get data from Salesforce (plus 80+ other sources). These endpoints expose data as OData, RSS, HTML, CSV, ATOM, SOAP, JSON, JSONP, and TSV. In this article, we will use the CSV format to import Salesforce data into a Google Spreadsheet.
-
Use Azure AI Foundry to Talk to Your AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Google AlloyDB for you.
-
Create Moosend Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Moosend from PowerBI.com to create Power BI Dataflows with real-time data.
-
DataBind Charts to Perplexity Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Perplexity 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.
-
Migrating data from Autopilot to Google BigQuery using CData SSIS Components.
Easily push Autopilot to Google BigQuery using the CData SSIS Tasks for Autopilot and Google BigQuery.
-
Work with PolarTeamPro Data in FoxPro
Load PolarTeamPro into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Google Cloud Storage Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Cloud Storage.
-
Automated Continuous Float Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Float replication to Amazon S3.
-
Connect to Pushbullet Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Pushbullet and work with Pushbullet in your FileMaker applications.
-
Connect to ScrapingBee Data in HULFT Integrate
Connect to ScrapingBee as a JDBC data source in HULFT Integrate
-
Create Reports with OpenWeatherMap Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date OpenWeatherMap.
-
Build MVC Applications with Connectivity to Oracle Service Cloud Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Oracle Service Cloud from an ASP.NET MVC application.
-
Use the CData Software JDBC Driver for BigCommerce in MicroStrategy
Connect to BigCommerce in MicroStrategy Developer using the CData Software JDBC Driver for BigCommerce.
-
How to Build an ETL App for ShipStation Data in Python with CData
Create ETL applications and real-time data pipelines for ShipStation in Python with petl.
-
Prepare, Blend, and Analyze MariaDB Data in Alteryx Designer (Connect AI)
Build workflows to access live MariaDB for self-service data analytics.
-
Access Live ActiveCampaign Data in AWS Lambda
Connect to live ActiveCampaign in AWS Lambda using the CData JDBC Driver.
-
Use the CData API Server to Access GitHub Data in Microsoft PowerPivot
Use the CData API Server to connect to live GitHub in the Power Pivot business intelligence tool.
-
DataBind Controls to MailerLite Data in Delphi
DataBind to MailerLite in Delphi with standard data access components and controls.
-
Visualize Outreach.io Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Outreach.io into TIBCO Spotfire.
-
Automated Continuous Azure Data Catalog Replication to SingleStore
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to SingleStore.
-
Analyze Google Ad Manager Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Ad Manager and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect Sage 300 to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Sage 300 with IBM WebSphere for seamless data integration and connectivity.
-
How to Easily Query Autopilot Data in OpenOffice Base
Connect to Autopilot data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate Live Impala Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create Power BI Reports on Real-Time Jira Data
Use the CData ODBC Driver for Jira to visualize Atlassian Jira in Power BI Desktop.
-
Connect to Microsoft Dataverse Data in HULFT Integrate
Connect to Microsoft Dataverse as a JDBC data source in HULFT Integrate
-
Access Apollo Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Apollo from HeidiSQL.
-
Build HCL Domino-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for HCL Domino to explore live HCL Domino Data in Gemini Code Assist to assist with building HCL Domino-powered applications.
-
Access Bullhorn CRM Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Bullhorn CRM from your Oracle system.
-
Use the CData Software ODBC Driver for Anaplan in MicroStrategy Web
Connect to Anaplan in MicroStrategy Web using the CData Software ODBC Driver for Anaplan.
-
Build ServiceNow-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for ServiceNow to explore live ServiceNow Data in Claude Code to assist with building ServiceNow-powered applications.
-
Connect to and Visualize Live SuiteCRM Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SuiteCRM.
-
Getting Started with the CData Tableau Connector for Wistia
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous CampaignMonitor Replication to Databricks
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Databricks.
-
Using the CData Software ODBC Driver for REST in PyCharm
Connect to REST as an ODBC data source in PyCharm using the CData Software ODBC Driver for REST.
-
Use the CData Software ODBC Driver for Twitter Ads in MicroStrategy Desktop
Connect to Twitter Ads in MicroStrategy Desktop using the CData Software ODBC Driver for Twitter Ads.
-
Connect to Microsoft Planner Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Create Datasets from HubDB in Domo Workbench and Build Visualizations of HubDB Data in Domo
Use the CData Software ODBC Driver for HubDB to create datasets from HubDB in Domo Workbench and then build visualizations in the Domo service.
-
Automate Facebook Data Replication to Azure Synapse
Use CData Sync to customize and automate Facebook replication to Azure Synapse.
-
Integrating LlamaIndex with Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Microsoft Planner in real time.
-
Visualize Redis Data in Sisense
Create an ElastiCube in Sisense app with access to Redis.
-
Use JayDeBeApi to access Harvest Data in Python
Use standard Python scripting and the development environment of your choice to access live Harvest.
-
Integrating Antigravity CLI with Ontraport via CData CLI
Connect Ontraport to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Autopilot Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Autopilot to connect to Autopilot and execute queries in PowerBuilder.
-
Create Apps from Oracle Financials Cloud Data in Qlik Sense Cloud
Use CData Connect AI to connect to Oracle Financials Cloud Data and build apps from live Oracle Financials Cloud in Qlik Sense Cloud.
-
How to Access Zoho Inventory Data Using Entity Framework
This article shows how to access Zoho Inventory using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use CData Connect AI to Access Confluence Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Atlassian Confluence in the Power Pivot business intelligence tool.
-
Create Data Visualizations in Cognos BI with MySQL Data
Access MySQL as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Publish Blackbaud FE NXT-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Blackbaud FE NXT.
-
Provide OData Services of GraphQL Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for GraphQL by developing a WCF Service Application.
-
Query Mixpanel Data as a MySQL Database in Node.js
Execute MySQL queries against Mixpanel from Node.js.
-
Build Semantic Layer Views for LinkedIn Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for LinkedIn.