CData Software - Knowledge Base
Recent Articles
-
Use Claude to Talk to Your Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Google Search for you.
-
How to Visualize Planio Data in Python with pandas
Use pandas and other modules to analyze and visualize live Planio in Python.
-
Use Grok to Talk to Your Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Quickbase for you.
-
Integrate Real-Time Access to Sage Intacct in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Sage Intacct in real time.
-
Connect to Codat Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Codat.
-
Automated Continuous Microsoft OneLake Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to Amazon S3.
-
DataBind SharePoint Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SharePoint with the DevExpress Windows Forms and Web controls to provide Microsoft SharePoint to a chart.
-
Stream PolarTeamPro Data into Apache Kafka Topics
Access and stream PolarTeamPro in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Splunk Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Splunk in the Denodo Virtual DataPort Administrator.
-
How to Visualize Attio Data in Python with pandas
Use pandas and other modules to analyze and visualize live Attio in Python.
-
How to Import Data from Basecamp into Google Sheets
Import Basecamp into a Google spreadsheet that is automatically refreshed.
-
Automate ShipEngine Data Replication to SAP HANA
Use CData Sync to customize and automate ShipEngine replication to SAP HANA.
-
Design BIRT Reports on Salesloft Data
Provide current Salesloft to your embedded analytics.
-
Getting Started with the CData Power BI Connector for SparkPost
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automated Continuous QuickBooks Online Replication to SQLite
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to SQLite.
-
How to Connect to Live PayPal Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live PayPal securely in real time.
-
DataBind Controls to Short.io Data in C++Builder
DataBind to Short.io in C++Builder with standard components and controls.
-
Rapidly Develop SAP HANA-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 SAP HANA.
-
Connect Clio to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Clio using the CData Python MCP Server.
-
How to Connect the Power BI Service to SAP SuccessFactors: Complete Guide
Connect to the CData Software Power BI Connector for SAP SuccessFactors from PowerBI.com to provide real-time SAP SuccessFactors across the organization.
-
Integrate Clari Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Clari from Informatica Cloud.
-
SAP Fieldglass Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP Fieldglass through CData Connect AI using different applications and tools.
-
Use the CData Software ODBC Driver for BigCommerce in MicroStrategy Web
Connect to BigCommerce in MicroStrategy Web using the CData Software ODBC Driver for BigCommerce.
-
Visualize RSS Feeds in Sisense
Create an ElastiCube in Sisense app with access to RSS Feeds.
-
Automated Continuous Cvent Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Cvent replication to Apache Cassandra.
-
Use the CData ODBC Driver for ADP from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ADP to connect to ADP from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ADP in Excel.
-
Publish Mouseflow-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Mouseflow.
-
Import Azure Data Lake Storage Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Azure Data Lake Storage. In this article, you will use the OData format to import Azure Data Lake Storage into Microsoft Power Query.
-
Create Data Visualizations in Cognos BI with Mixpanel Data
Access Mixpanel as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Microsoft Planner Data from a Connection Pool in JBoss
Integrate Microsoft Planner into Java servlets: Use the Management Console in JBoss to install the Microsoft Planner JDBC Driver.
-
Use Dash to Build Web Apps on Facebook Ads Data via CData Connect AI
Build interactive Dash web apps on live Facebook Ads using pandas and the CData Connect AI Python SDK.
-
Integrate Eventbrite Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Eventbrite from Informatica Cloud.
-
DataBind Controls to Azure Data Catalog Data in C++Builder
DataBind to Azure Data Catalog in C++Builder with standard components and controls.
-
How to use SQLAlchemy ORM to access Cloudant Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of IBM Cloudant.
-
Import CockroachDB Data Using Azure Data Factory
Use CData Connect AI to connect to CockroachDB Data from Azure Data Factory and import live CockroachDB.
-
Access Live SurveyMonkey Data in AWS Lambda
Connect to live SurveyMonkey in AWS Lambda using the CData JDBC Driver.
-
Import LinkedIn Data Using Azure Data Factory
Use CData Connect AI to connect to LinkedIn Data from Azure Data Factory and import live LinkedIn.
-
Using the CData Software ODBC Driver for Asana in PyCharm
Connect to Asana as an ODBC data source in PyCharm using the CData Software ODBC Driver for Asana.
-
Build a Singer.io Tap for Retently With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Retently data using
-
How to Build an ETL App for Eventbrite Data in Python with CData
Create ETL applications and real-time data pipelines for Eventbrite in Python with petl.
-
How to Connect Freshservice 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 Freshservice data in real time using natural language.
-
Automated Continuous Access Replication to SQLite
Use CData Sync for automated, continuous, customizable Access replication to SQLite.
-
Automated Continuous SAP SuccessFactors Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to Snowflake.
-
How to Query Live MySQL Data in Perplexity MacOS Desktop
Connect to and query live MySQL Data in Perplexity Desktop using CData MCP Server.
-
Model, Search, and Visualize Live Amazon DynamoDB Data in ThoughtSpot
Use CData Connect AI to connect to live Amazon DynamoDB for modeling, searching, and visualizing.
-
Use the CData ODBC Driver for ZohoExpense from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ZohoExpense to connect to ZohoExpense from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ZohoExpense in Excel.
-
How to connect to Toggl Data from Spring Boot
Connect to Toggl in a Spring Boot Application using the CData API Driver for JDBC
-
Analyze TaxJar Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of TaxJar and visualize live TaxJar in Infragistics Reveal.
-
Connect to Oracle Eloqua in SpagoBI
Create reports featuring live Oracle Eloqua in SpagoBI Studio. Host Oracle Eloqua reports on SpagoBI Server.
-
How to Use a Microsoft Access Database to Update Highrise Data in Real Time
Update Highrise data by creating a linked table in Microsoft Access with the CData Highrise ODBC Driver.
-
FHIR Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on FHIR facts in real time.
-
Automated Continuous CampaignMonitor Replication to MySQL
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to MySQL.
-
How to Connect to HBase Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apache HBase. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Teamgate Replication to SQL Server
Use CData Sync for automated, continuous, customizable Teamgate replication to SQL Server.
-
Create Datasets from Cosmos DB in Domo Workbench and Build Visualizations of Cosmos DB Data in Domo
Use the CData Software ODBC Driver for Cosmos DB to create datasets from Azure Cosmos DB in Domo Workbench and then build visualizations in the Domo service.
-
Configure the CData JDBC Driver for SparkPost in a Connection Pool in Tomcat
Connect to SparkPost from a connection pool in Tomcat.
-
Access Live EnterpriseDB Data in TIBCO Data Virtualization
Use the EnterpriseDB Tibco DV Adapter to create a EnterpriseDB data source in TIBCO Data Virtualization Studio and gain access to live EnterpriseDB from your TDV Server.
-
Analyze Amazon DynamoDB Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Amazon DynamoDB in Microsoft R Open.
-
Connect to and Visualize Live Adobe Analytics Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Adobe Analytics.
-
Connect to Parquet Data from a Connection Pool in JBoss
Integrate Apache Parquet into Java servlets: Use the Management Console in JBoss to install the Parquet JDBC Driver.
-
Work with eBay Data in FoxPro
Load eBay into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query Zoho Projects Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Zoho Projects and perform CRUD operations on Zoho Projects from Node.js.
-
Visualize Live Cosmos DB Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Azure Cosmos DB using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Zoho CRM Data from a Connection Pool in JBoss
Integrate Zoho CRM into Java servlets: Use the Management Console in JBoss to install the Zoho CRM JDBC Driver.
-
How to Connect Flowise AI Agents to Live Instagram 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 Instagram without replication.
-
Productboard Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Productboard facts in real time.
-
Build Raisers Edge NXT-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Raisers Edge NXT Data and create custom apps in Bubble.
-
Create a Data Access Object for Outreach.io Data using JDBI
A brief overview of creating a SQL Object API for Outreach.io in JDBI.
-
Connect to Gmail Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Gmail in Airbyte.
-
Getting Started with the CData SSIS Components for ServiceNow
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ServiceNow.
-
Migrating data from Acumatica to Snowflake using CData SSIS Components.
Easily push Acumatica ERP to Snowflake using the CData SSIS Tasks for Acumatica and Snowflake.
-
Getting Started with the CData Tableau Connector for Simplesat
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Publish Figshare-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Figshare.
-
Use CData Connect AI to Access FreshBooks Data in Microsoft Power Pivot
Use CData Connect AI to connect to live FreshBooks in the Power Pivot business intelligence tool.
-
Build Zoho Inventory-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Zoho Inventory.
-
Automated Continuous Avalara AvaTax Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Google BigQuery.
-
Seamlessly Bring NetSuite SuiteAnalytics Data into Retool Using CData Connect AI
Integrate NetSuite SuiteAnalytics data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build an OLAP Cube in SSAS from Rebilly Data
Establish a connection to Rebilly data from SQL Server Analysis Services, and use the Rebilly Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData Connect AI Python SDK for Spark
Install the CData Connect AI Python SDK to read and write live Apache Spark SQL with standard DB-API 2.0 Python code.
-
Automated Continuous AdRoll Replication to Snowflake
Use CData Sync for automated, continuous, customizable AdRoll replication to Snowflake.
-
Build Sage Intacct-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Sage Intacct to explore live Sage Intacct Data in Claude Code to assist with building Sage Intacct-powered applications.
-
Automate Google Analytics Data Replication to Couchbase
Use CData Sync to Customize and automate Google Analytics replication to Couchbase.
-
Automate LinkedIn Ads Data Replication to Azure Synapse
Use CData Sync to customize and automate LinkedIn Ads replication to Azure Synapse.
-
How to Connect to Live Confluence Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Atlassian Confluence securely in real time.
-
Access Live Cloudant 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 IBM Cloudant through MCP integration.
-
Viewing Amazon S3 Data in RAD Studio Data Explorer
How to view Amazon S3 in RAD Studio Data Explorer using the CData ODBC Driver for Amazon S3.
-
Query, Visualize, and Share live Amazon Athena Data in Redash
Use CData Connect AI to connect to live Amazon Athena in Redash for querying, visualizing, and sharing.
-
Connect to DB2 Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for IBM DB2 in the Denodo Virtual DataPort Administrator.
-
Connect to SAP ByDesign Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Choosing the Best Method to Connect GetResponse to SQL Server: 5 Options Explained
Discover multiple ways to connect and use GetResponse from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live Discourse Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Discourse in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Migrating data from Pingdom to Google BigQuery using CData SSIS Components.
Easily push Pingdom to Google BigQuery using the CData SSIS Tasks for Pingdom and Google BigQuery.
-
Connect to Close 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 Close and work with Close in your FileMaker application.
-
Build MVC Applications with Connectivity to Teradata Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Teradata from an ASP.NET MVC application.
-
Automated Continuous ZohoPeople Replication to Databricks
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Databricks.
-
How to connect to Webex Data from IntelliJ
Integrate connectivity to Webex with wizards in IntelliJ.
-
Connecting Pipedream with Confluence 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 Confluence data in real time.
-
Use Dash to Build to Web Apps on Humanity Data
Create Python applications that use pandas and Dash to build Humanity-connected web apps.
-
Explore Geographical Relationships in Invoiced Data with Power Map
Create data visualizations with Invoiced in Power Map.
-
Create Salesforce Marketing Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Salesforce Marketing from PowerBI.com to create Power BI Dataflows with real-time data.