CData Software - Knowledge Base
Recent Articles
-
Publish Copper-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Copper data.
-
Build Visualizations of Typeform Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Typeform data in Birst.
-
Use Dash to Build Web Apps on Redshift Data via CData Connect AI
Build interactive Dash web apps on live Redshift data using pandas and the CData Connect AI Python SDK.
-
Build Apps with Live Couchbase data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Couchbase data into the Adalo platform and build custom mobile and web applications with real-time Couchbase data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Pingdom
Provide connectivity to Pingdom data through an SAP BusinessObjects universe.
-
Access Live Slack Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Slack data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to work with Perigon Data in Apache Spark using SQL
Access and process Perigon Data in Apache Spark using the CData Software JDBC Driver.
-
Visualize Paymo Data in Sisense
Create an ElastiCube in Sisense app with access to Paymo data.
-
Validate Gong Data with QuerySurge
Access and validate Gong data in QuerySurge using the CData JDBC Driver.
-
Analyze Zoho Books Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zoho Books from Power Pivot. You will use the Table Import Wizard to load Zoho Books data. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData JDBC Driver for Impala
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Impala.
-
Natively Connect to Typeform Data in PHP
The CData ODBC driver for Typeform enables you to create PHP applications with connectivity to Typeform data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Cvent Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Cvent replication to PostgreSQL.
-
Migrating data from SparkPost to Snowflake using CData SSIS Components.
Easily push SparkPost data to Snowflake using the CData SSIS Tasks for SparkPost and Snowflake.
-
Connect to Microsoft Dataverse Data from a Connection Pool in JBoss
Integrate Microsoft Dataverse data into Java servlets: Use the Management Console in JBoss to install the Microsoft Dataverse JDBC Driver.
-
Connect to Amazon DynamoDB Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Amazon DynamoDB and the SQL Gateway to access Amazon DynamoDB data from Google Apps Script.
-
Import Zoho Inventory Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Zoho Inventory Data and provide access to live Zoho Inventory data for custom reports in the Power BI Service.
-
Creating Hive-Connected Applications in Unqork
You can use CData Connect AI to feed Hive data to Unqork and build custom business apps.
-
How to Connect the Power BI Service to Office 365: Complete Guide
Connect to the CData Software Power BI Connector for Office 365 from PowerBI.com to provide real-time Office 365 data across the organization.
-
Connecting Pipedream with Bright Data 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 Bright Data data in real time.
-
Create SSAS Tabular Models from Zoho Projects Data
How to build a SQL Server Analysis Service Tabular Model from Zoho Projects data using CData drivers.
-
Create a Data Access Object for Gorgias Data using JDBI
A brief overview of creating a SQL Object API for Gorgias data in JDBI.
-
DataBind Controls to SAP Ariba Procurement Data in C++Builder
DataBind to SAP Ariba Procurement data in C++Builder with standard components and controls.
-
Automated Continuous LaunchDarkly Replication to IBM DB2
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to IBM DB2.
-
Integrate Email with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Email with External Services.
-
Query Wave Financial Data as a SQL Server Database in Node.js
Execute SQL Server queries against Wave Financial data from Node.js.
-
How to load Neo4J data into Elasticsearch via Logstash
Introducing a simple method to load Neo4J data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Migrating data from SpaceX to Databricks using CData SSIS Components.
Easily push SpaceX data to Databricks using the CData SSIS Tasks for SpaceX and Databricks.
-
Build Dashboards with Bitbucket Data in DBxtra
Create dynamic dashboards and perform analytics based on Bitbucket data in DBxtra.
-
Bridge MailChimp Connectivity with Apache NiFi
Access and process MailChimp data in Apache NiFi using the CData JDBC Driver.
-
Build Optimizely-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Optimizely data and build web apps with connectivity to live Optimizely data.
-
Build Bannerbear-Connected Apps in Choreo
Use CData Connect AI to connect to Bannerbear Data from Choreo and build custom apps using live Bannerbear data.
-
Use JayDeBeApi to access Invoiced Data in Python
Use standard Python scripting and the development environment of your choice to access live Invoiced data.
-
Provide OData Services of FormSite Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for FormSite data by developing a WCF Service Application.
-
Replicate Multiple LinkedIn Ads Accounts via the CData Sync CLI
Replicate multiple LinkedIn Ads accounts to one or many databases.
-
Access Live SageHR Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SageHR data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Scrapfly from a Connection Pool in WebLogic
Use the CData JDBC Driver for Scrapfly to connect to Scrapfly data from Web applications running on WebLogic.
-
Model, Search, and Visualize Live Elasticsearch Data in ThoughtSpot
Use CData Connect AI to connect to live Elasticsearch data for modeling, searching, and visualizing.
-
Connect to Todoist Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Todoist data using standard SQL.
-
Publish FreeAgent-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live FreeAgent data.
-
Build an OLAP Cube in SSAS from QuickBooks Online Data
Establish a connection to QuickBooks Online data data from SQL Server Analysis Services, and use the QuickBooks Online Data Provider to build OLAP cubes for use in analytics and reporting.
-
Freshservice Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Freshservice facts in real time.
-
Natively Connect to Adobe Experience Manager Data in PHP
The CData ODBC driver for Adobe Experience Manager enables you to create PHP applications with connectivity to Adobe Experience Manager data. Leverage the native support for ODBC in PHP.
-
Rapidly Develop Zoho Projects-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 Zoho Projects.
-
Provide OData Services of Microsoft Teams Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft Teams data by developing a WCF Service Application.
-
How to Create Power BI Visual Reports with Real-Time Gong Data
Use CData Power BI Connectors to visualize Gong data in Power BI.
-
Getting Started with the CData JDBC Driver for Avro
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Avro.
-
Integrating LlamaIndex with Kafka Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Kafka data in real time.
-
Integrate with Highrise Data in JReport Designer
Create charts and reports based on Highrise data in JReport Designer.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Aircall
Provide connectivity to Aircall data through an SAP BusinessObjects universe.
-
Automate Shopify Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Shopify data from PowerShell? This article demonstrates how to utilize the Shopify Cmdlets for tasks like connecting to Shopify data, automating operations, downloading data, and more.
-
Integrate with FreshBooks Data in SnapLogic
Use CData Connect AI to connect to and integrate with live FreshBooks data in SnapLogic.
-
Use the CData Software JDBC Driver for Google Forms in MicroStrategy
Connect to Google Forms data in MicroStrategy Developer using the CData Software JDBC Driver for Google Forms.
-
Integrate Real-Time Access to SAS Data Sets in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAS Data Sets data in real time.
-
Work with Tickspot Data in FoxPro
Load Tickspot data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Live SAP Ariba Source Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP Ariba Source from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Ariba Source data.
-
Use the CData Software ODBC Driver for Discord in MicroStrategy
Connect to Discord data in MicroStrategy Developer using the CData Software ODBC Driver for Discord.
-
Use JayDeBeApi to access SAP Business Warehouse Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP Business Warehouse data.
-
Integrating OpenCode with BigCommerce 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.
-
JotForm Reporting in OBIEE with the JotForm JDBC Driver
Deploy the JotForm JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Bridge Missive Connectivity with Apache NiFi
Access and process Missive data in Apache NiFi using the CData JDBC Driver.
-
Import Wistia Data Using Azure Data Factory
Use CData Connect AI to connect to Wistia Data from Azure Data Factory and import live Wistia data.
-
Import Real-Time SAP Hybris C4C Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP Hybris C4C data in ColdFusion.
-
Query, Visualize, and Share live LinkedIn Data in Redash
Use CData Connect AI to connect to live LinkedIn data in Redash for querying, visualizing, and sharing.
-
Object-Relational Mapping (ORM) with Paddle 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 Paddle data into a Java-based ORM framework, Hibernate.
-
Connect to Real-Time Parquet Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Parquet and Dataflow to import and use Parquet data in Power Apps.
-
Automated Continuous Sentry Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Sentry replication to AlloyDB.
-
Access Live SAP HANA XS Advanced Data in AWS Lambda
Connect to live SAP HANA XS Advanced data in AWS Lambda using the CData JDBC Driver.
-
Seamlessly Bring xBase Data into Retool Using CData Connect AI
Integrate xBase data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate Google's Antigravity Agent with Live BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live BigCommerce data using the Model Context Protocol.
-
Create Informatica Mappings From/To an ODBC Data Source for Azure Analysis Services
Create an ODBC connection to Azure Analysis Services in Informatica and browse and transfer Azure Analysis Services data.
-
Create Avalara AvaTax-Connected Business Apps in AppSheet
Connect to Avalara AvaTax Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Avalara AvaTax data.
-
Connect to and Visualize Live Aircall Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Aircall data.
-
Build Data Flows from SQL Server to OneNote through SSIS
Easily push SQL Server data to OneNote using the CData SSIS Tasks for OneNote.
-
Build Apps with Live eBay Analytics data in Adalo using CData Connect AI
Use CData Connect AI to integrate live eBay Analytics data into the Adalo platform and build custom mobile and web applications with real-time eBay Analytics data.
-
Integrating Kiro with LightSpeedRetail 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.
-
Process & Analyze Workday Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Workday Data.
-
Use the CData Software JDBC Driver for Couchbase in MicroStrategy Desktop
Connect to Couchbase data in MicroStrategy Desktop using the CData Software JDBC Driver for Couchbase.
-
How to connect SharePoint with Sage Cloud Accounting Data through external lists
Provide Sage Cloud Accounting data to SharePoint users as an external list.
-
Natively Connect to Dynamics CRM Data in PHP
The CData ODBC driver for Dynamics CRM enables you to create PHP applications with connectivity to Dynamics CRM data. Leverage the native support for ODBC in PHP.
-
Publish Reports with Attio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Attio data.
-
Integrating Codex with HelloSign 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.
-
Automated Continuous Jodoo Replication to Databricks
Use CData Sync for automated, continuous, customizable Jodoo replication to Databricks.
-
Integrate Teradata Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Teradata data and integrate live Teradata data into your Power Automate tasks.
-
Build Pipelines with Live Amazon Athena Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Amazon Athena from Google Cloud Data Fusion, enabling the integration of live Amazon Athena data into the building and management of effective data pipelines.
-
Connect to Salesforce from a Connection Pool in WebLogic
Use the CData JDBC Driver for Salesforce to connect to Salesforce data from Web applications running on WebLogic.
-
Access Printify Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Printify data from your Oracle system.
-
Connect to SAP HANA XS Advanced Data in Ruby
Connect to SAP HANA XS Advanced data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Reports from Cloudant Data in Looker Studio
Use CData Connect AI to gain access to live Cloudant data and create custom reports in Looker Studio.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Discord
Provide connectivity to Discord data through an SAP BusinessObjects universe.
-
How to Seamlessly Import iContact Data into IBM SPSS Modeler
Integrate iContact data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Jira Assets Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Jira Assets data and integrate live Jira Assets data into your Power Automate tasks.
-
Connect to Strava Data in Aqua Data Studio
Access Strava data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Keap Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Keap replication to Azure SQL Database.
-
Build Azure Data Catalog-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Azure Data Catalog data and build web apps with connectivity to live Azure Data Catalog data.
-
Work with Dropbox Data in FoxPro
Load Dropbox data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Impala Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Impala data and build visualizations in Tableau.
-
How to Connect the Power BI Service to Wrike: Complete Guide
Connect to the CData Software Power BI Connector for Wrike from PowerBI.com to provide real-time Wrike data across the organization.
-
Integrate Devin with Live Microsoft Teams Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Microsoft Teams data.
-
Automated Continuous Gong Replication to Oracle
Use CData Sync for automated, continuous, customizable Gong replication to Oracle.