CData Software - Knowledge Base
Recent Articles
-
Analyze Greenplum Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Pivotal GreenPlum and visualize live Pivotal GreenPlum in Infragistics Reveal.
-
Create SSAS Tabular Models from Snapchat Ads Data
How to build a SQL Server Analysis Service Tabular Model from Snapchat Ads using CData drivers.
-
How to Create Power BI Visual Reports with Real-Time MongoDB Data
Use CData Power BI Connectors to visualize MongoDB in Power BI.
-
How to Build an ETL App for Workday Data in Python with CData
Create ETL applications and real-time data pipelines for Workday in Python with petl.
-
Access Contentful Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Contentful from your Oracle system.
-
Build DB2-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for DB2 to explore live DB2 Data in Gemini Code Assist to assist with building DB2-powered applications.
-
How to Connect to AgileCRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to AgileCRM. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Eventbrite Replication to MySQL
Use CData Sync for automated, continuous, customizable Eventbrite replication to MySQL.
-
Migrating data from Webflow to Google BigQuery using CData SSIS Components.
Easily push Webflow to Google BigQuery using the CData SSIS Tasks for Webflow and Google BigQuery.
-
Analyze Chargebee Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Chargebee with the CData JDBC Driver for Chargebee.
-
Build MVC Applications with Connectivity to Google Contacts Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Contacts from an ASP.NET MVC application.
-
Create Data Visualizations Based On Epicor Kinetic Data in Mode
Use CData Connect AI to connect to Epicor Kinetic Data from Mode and build visualizations using live
-
Connect to Typeform 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 Typeform and work with Typeform in your FileMaker application.
-
Build Google Analytics-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Google Analytics Data and create custom apps in Bubble.
-
Design BIRT Reports on QuickBooks Data
Provide current QuickBooks Desktop to your embedded analytics.
-
Automated Continuous Freshteam Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Freshteam replication to OneLake in Microsoft Fabric.
-
Viewing Office 365 Data in RAD Studio Data Explorer
How to view Microsoft Office 365 in RAD Studio Data Explorer using the CData ODBC Driver for Office 365.
-
Connect to Recurly Data in NetBeans
Connect to Recurly in NetBeans with the data source configuration wizard.
-
Create Data Visualizations Based On Google Ad Manager Data in Mode
Use CData Connect AI to connect to Google Ad Manager Data from Mode and build visualizations using live
-
How to Connect to Gong Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Gong. Leverage the pyodbc module for ODBC in Python.
-
Connecting Moonlit Workflow with BambooHR 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 BambooHR in real time.
-
How to Create Power BI Visual Reports with Real-Time SpaceX Data
Use CData Power BI Connectors to visualize SpaceX in Power BI.
-
Connect to Unbounce Data in RazorSQL
Connect to Unbounce from wizards and query Unbounce from the GUI in the RazorSQL database management tool.
-
How to use SQLAlchemy ORM to access Demio Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Demio.
-
Create Reports with Sage Cloud Accounting Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sage Business Cloud Accounting.
-
Create SSAS Tabular Models from Figshare Data
How to build a SQL Server Analysis Service Tabular Model from Figshare using CData drivers.
-
Connect to Certinia Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Certinia in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Trello Replication to SQLite
Use CData Sync for automated, continuous, customizable Trello replication to SQLite.
-
Automated Continuous Adobe Analytics Replication to SQL Server
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to SQL Server.
-
Design BIRT Reports on Drift Data
Provide current Drift to your embedded analytics.
-
How to import Box Data into Apache Solr
Use the CData Software JDBC Driver for Box in Data Import Handler and create an automated import of Box to Apache Solr Enterprise Search platform.
-
Use the CData ODBC Driver for Harvest from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Harvest to connect to Harvest from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Harvest in Excel.
-
Use the CData ODBC Driver for SAP Business Warehouse from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP Business Warehouse to connect to SAP Business Warehouse from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP Business Warehouse in Excel.
-
Visualize Sage Cloud Accounting Data in Sisense
Create an ElastiCube in Sisense app with access to Sage Business Cloud Accounting.
-
Connect to and Query Nethunt Data in QlikView over ODBC
Create data visualizations with Nethunt in QlikView.
-
Integrating Kiro CLI with Harvest 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.
-
Migrating data from Salesloft to Google BigQuery using CData SSIS Components.
Easily push Salesloft to Google BigQuery using the CData SSIS Tasks for Salesloft and Google BigQuery.
-
Build Dashboards with Mouseflow Data in Dundas BI
Create dynamic dashboards and perform analytics based on Mouseflow in Dundas BI.
-
A PostgreSQL Interface for AgileCRM Data using the CData ODBC Driver
Use the SQL Gateway and AgileCRM ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Wrike Data in DBeaver
Use the CData ODBC Driver to connect to Wrike in DBeaver.
-
Use the CData Software ODBC Driver for Sugar CRM in MicroStrategy
Connect to Sugar CRM in MicroStrategy Developer using the CData Software ODBC Driver for Sugar CRM.
-
Replicate Multiple Nethunt Accounts
Replicate multiple Nethunt accounts to one or many databases.
-
Build Aweber-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Aweber and build web apps with connectivity to live Aweber.
-
Connect to Brex Data in RapidMiner
Integrate Brex with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Contacts
Create an ODBC connection to Google Contacts in Informatica and browse and transfer Google Contacts.
-
Automated Continuous Opsgenie Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Opsgenie replication to Amazon S3.
-
Publish Reports with REST Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date REST.
-
LINQ to Azure Synapse 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 Azure Synapse Data Provider.
-
Replicate Excel Online Data to Multiple Databases
Replicate Microsoft Excel Online to disparate databases with a point-and-click configuration.
-
Use the CData ODBC Driver for Authorize.Net from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Authorize.Net to connect to Authorize.Net from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Authorize.Net in Excel.
-
Viewing SAP HANA Data in RAD Studio Data Explorer
How to view SAP HANA in RAD Studio Data Explorer using the CData ODBC Driver for SAP HANA.
-
Easily Integrate Google Forms Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Forms in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Aha! Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Aha! replication to IBM DB2.
-
Connect to Elasticsearch from a Connection Pool in WebLogic
Use the CData JDBC Driver for Elasticsearch to connect to Elasticsearch from Web applications running on WebLogic.
-
Consume DB2 OData Feeds in PowerBuilder
This article demonstrates how to consume IBM DB2 as OData feeds from PowerBuilder using the API Server.
-
Load Sage 200 Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Sage 200 to a database.
-
Automated Continuous HDFS Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apache HDFS replication to OneLake in Microsoft Fabric.
-
Import Real-Time IBM Informix Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use IBM Informix in ColdFusion.
-
How to Connect to & Open Salesforce Data in Microsoft Excel
This article uses the CData ODBC driver for Salesforce to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Query Live SAP HANA XS Advanced Data in Claude Desktop
Connect to and query live SAP HANA XS Advanced Data in Claude Desktop using CData MCP Server.
-
Getting Started with the CData Connect AI Python SDK for Okta
Install the CData Connect AI Python SDK to read and write live Okta with standard DB-API 2.0 Python code.
-
Automated Continuous Datadog Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Datadog replication to PostgreSQL.
-
How to publish and share Attio Data dashboards with Tableau Server
The CData ODBC driver for Attio enables you integrate Attio into Tableau dashboards.
-
Process & Analyze Mailjet Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Mailjet Data.
-
Automated Continuous YouTube Analytics Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Apache Cassandra.
-
Use Microsoft Copilot Studio to talk to your Active Directory 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 Active Directory for you.
-
Excel Spreadsheet Automation on Google Search Results with the QUERY Formula
Pull data from Google Search, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Stripe Replication to SingleStore
Use CData Sync for automated, continuous, customizable Stripe replication to SingleStore.
-
Connect to SAP Fieldglass 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 SAP Fieldglass.
-
Access Live CircleCI Data in Coginiti Pro
Connect to and query live CircleCI from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live DB2 Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live IBM DB2 from your Google Sheets.
-
Integrate with Excel Online Data in JReport Designer
Create charts and reports based on Microsoft Excel Online in JReport Designer.
-
Integrate Real-Time Access to Azure Synapse in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Azure Synapse in real time.
-
Integrate with Google Spanner Data in JReport Designer
Create charts and reports based on Google Spanner in JReport Designer.
-
Visualize Live Excel Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Excel using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automate OData Services Replication to Azure Synapse
Use CData Sync to customize and automate OData replication to Azure Synapse.
-
Build Automated Workflows with Live CSV Data in Workato
Use CData Connect AI to connect to live CSV/TSV Files and build automated workflows in Workato.
-
Publish Crystal Reports on Codat Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Codat.
-
Access Live MYOB AccountRight Data in Excel 365 Online (Excel for the web)
Connect to MYOB AccountRight from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Validate Marketo Data with QuerySurge
Access and validate Marketo in QuerySurge using the CData JDBC Driver.
-
Integrate ServiceNow Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to ServiceNow and integrate live ServiceNow into your Power Automate tasks.
-
Build Google Drive-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Drive Data from Zoho Analytics and import live Google Drive.
-
Integrating ActiveCampaign Data in Talend Cloud Data Management Platform
Connect ActiveCampaign Data with Talend Cloud Data Management Platform using the CData JDBC Driver for ActiveCampaign.
-
Create a Data Access Object for Power BI XMLA Data using JDBI
A brief overview of creating a SQL Object API for Power BI XMLA in JDBI.
-
Process & Analyze GetResponse Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live GetResponse Data.
-
Build Semantic Layer Views for Typeform Data in APOS Live Data Gateway
Use the CData Connector for Typeform in APOS Live Data Gateway to build Semantic Layer Views for Typeform.
-
Publish Insightly-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Insightly.
-
Publish Qualaroo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Qualaroo.
-
Automated Continuous PolarTeamPro Replication to SQL Server
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to SQL Server.
-
Query ZarMoney Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ZarMoney from Node.js.
-
Build AI/ML Models with Live Postmark Data using Dataiku
Connect Postmark Data with Dataiku using the CData API Driver for JDBC.
-
Build Charts with Oracle Sales Data in Clear Analytics
Create dynamic charts and perform analytics based on Oracle Sales in Clear Analytics.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Jira
Provide connectivity to Atlassian Jira through an SAP BusinessObjects universe.
-
Getting Started with the CData Python Connector for Samanage
Learn to install and license the CData Python Connector
-
Use the CData Software JDBC Driver for Simplesat in MicroStrategy
Connect to Simplesat in MicroStrategy Developer using the CData Software JDBC Driver for Simplesat.
-
Analyze MySQL Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze MySQL in Microsoft R Open.
-
Connect to Google Ads Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Ads in Google Apps Script.
-
Publish Crystal Reports on Pinecone Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Pinecone.
-
Consume Snapchat Ads OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Snapchat Ads feeds that reflect any changes in SAP Lumira.
-
Use Azure AI Foundry to Talk to Your Google Analytics 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 Analytics for you.