CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Highrise 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 Highrise CRM for you.
-
Model Paylocity Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Paylocity, enabling the direct import of real-time Paylocity.
-
Integrate Live Quickbase Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Quickbase from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Quickbase.
-
Build ADP-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to ADP Data from Zoho Analytics and import live ADP.
-
Access Live Zuora Data in AWS Lambda
Connect to live Zuora in AWS Lambda using the CData JDBC Driver.
-
Publish Reports with Workday Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Workday.
-
Create Informatica Mappings From/To an ODBC Data Source for Monday.com
Create an ODBC connection to Monday.com in Informatica and browse and transfer Monday.com.
-
Getting Started with the CData ODBC Driver for Omnisend
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Omnisend.
-
Build a PostgreSQL Interface for Invoiced Data using the CData JDBC Driver
Use the Remoting features of the Invoiced JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Freshteam Data Replication to Couchbase
Use CData Sync to Customize and automate Freshteam replication to Couchbase.
-
Connect to Redis Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Redis Data and connect to Redis in Akorbi Digital RunMyProcess.
-
Automated Continuous Ontraport Replication to SQLite
Use CData Sync for automated, continuous, customizable Ontraport replication to SQLite.
-
Integrating Antigravity CLI with Auth0 via CData CLI
Connect Auth0 to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to GitLab Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for GitLab Data and connect to GitLab in Akorbi Digital RunMyProcess.
-
Build AI Agents with Phoenix Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Apache Phoenix through CData Connect AI.
-
Natively Connect to SendInBlue Data in PHP
The CData ODBC driver for SendInBlue enables you to create PHP applications with connectivity to SendInBlue. Leverage the native support for ODBC in PHP.
-
Bridge SAP Hybris C4C Connectivity with Apache NiFi
Access and process SAP Hybris C4C in Apache NiFi using the CData JDBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate Landbot Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Landbot to SQL Server.
-
Query Amplitude Data in ColdFusion
Write standard ColdFusion data access code to connect to Amplitude.
-
Visualize Live CampaignMonitor Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live CampaignMonitor using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate OnePageCrm Data in Heroku for Use in Salesforce Connect
Replicate OnePageCrm to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to integrate HBase with Apache Airflow
Access and process Apache HBase in Apache Airflow using the CData JDBC Driver.
-
Access Supabase Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Supabase.
-
Visualize Flowlu Data in TIBCO Spotfire through ADO.NET
Integrate Flowlu into dashboards in TIBCO Spotfire.
-
How to Build an ETL App for Splunk Data in Python with CData
Create ETL applications and real-time data pipelines for Splunk in Python with petl.
-
Create Data Visualizations in Cognos BI with Dropbox Data
Access Dropbox as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Data Visualizations in Cognos BI with Confluence Data
Access Atlassian Confluence as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Data Visualizations in Cognos BI with Salesforce CRM Analytics Data
Access Salesforce CRM Analytics as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Publish Guru-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Guru.
-
How to create Google Forms federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Forms in MySQL .
-
LINQ to Oracle Sales 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 Oracle Sales Data Provider.
-
Connect to Google Calendar Data in NetBeans
Connect to Google Calendar in NetBeans with the data source configuration wizard.
-
Analyze FHIR Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze FHIR in Microsoft R Open.
-
Create Reports from Google Campaign Manager 360 Data in Looker Studio
Use CData Connect AI to gain access to live Google Campaign Manager 360 and create custom reports in Looker Studio.
-
Connect to Dynamics NAV Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Dynamics NAV and the Script function in FileMaker Pro to connect to Dynamics NAV and work with Microsoft Dynamics NAV in your FileMaker application.
-
Integrate with Live Twilio Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Twilio from the MuleSoft Anypoint Platform to integrate live Twilio into custom reports and dashboards.
-
Use JayDeBeApi to access Superchat Data in Python
Use standard Python scripting and the development environment of your choice to access live Superchat.
-
Access Live Power BI XMLA Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Power BI XMLA from your Excel spreadsheets.
-
Create Informatica Mappings From/To an ODBC Data Source for ZarMoney
Create an ODBC connection to ZarMoney in Informatica and browse and transfer ZarMoney.
-
Automate Marketo Data Replication to Azure Data Lake
Use CData Sync to customize and automate Marketo replication to Azure Data Lake.
-
Analyze Google Spanner Data in Looker
Use CData Connect AI to connect to Google Spanner Data from Looker and build custom apps using live Google Spanner.
-
How to Connect to & Open SendGrid Data in Microsoft Excel
This article uses the CData ODBC driver for SendGrid to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize xBase Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to xBase.
-
Connect to Teamgate from a Connection Pool in WebLogic
Use the CData JDBC Driver for Teamgate to connect to Teamgate from Web applications running on WebLogic.
-
Build EnterpriseDB-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for EnterpriseDB to explore live EnterpriseDB Data in GitHub Copilot to assist with building EnterpriseDB-powered applications.
-
Connect to Paymo Data in Aqua Data Studio
Access Paymo from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to import Tickspot Data into Apache Solr
Use the CData Software JDBC Driver for Tickspot in Data Import Handler and create an automated import of Tickspot to Apache Solr Enterprise Search platform.
-
Visualize Vault CRM Data in Tableau
The CData ODBC driver for Vault CRM enables you integrate Veeva Vault & Vault CRM into Tableau dashboards.
-
Build Dashboards with Codat Data in Dundas BI
Create dynamic dashboards and perform analytics based on Codat in Dundas BI.
-
How to create Facebook Ads federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Facebook Ads in MySQL .
-
Use Dash to Build to Web Apps on Teamwork Data
Create Python applications that use pandas and Dash to build Teamwork-connected web apps.
-
Analyze Snapchat Ads Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Snapchat Ads and visualize live Snapchat Ads in Infragistics Reveal.
-
How to work with Asana Data in Apache Spark using SQL
Access and process Asana Data in Apache Spark using the CData Software JDBC Driver.
-
Provide OData Services of ConvertAPI Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ConvertAPI by developing a WCF Service Application.
-
How to Visualize ConvertKit Data in Python with pandas
Use pandas and other modules to analyze and visualize live ConvertKit in Python.
-
Build MVC Applications with Connectivity to Zuora Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zuora from an ASP.NET MVC application.
-
Connect to Live Sage Intacct Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Sage Intacct in CData Connect AI and connect to your Sage Intacct from PostgreSQL.
-
Automated Continuous SAP ByDesign Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Oracle.
-
Connect to Azure Synapse Data in Aqua Data Studio
Access Azure Synapse from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Analyze Greenhouse Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Greenhouse and visualize live Greenhouse in Infragistics Reveal.
-
How to Create Power BI Visual Reports with Real-Time SAP HANA XS Advanced Data
Use CData Power BI Connectors to visualize SAP HANA XS Advanced in Power BI.
-
Establish a Live Connection with Accelo Data using Tableau Bridge
The CData ODBC Driver for Accelo enables you to integrate live Accelo into Tableau Cloud dashboards using the Tableau Bridge.
-
Moving Data from Authorize.Net to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Authorize.Net data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Eventbrite Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Eventbrite from your Oracle system.
-
Create Shopify Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Shopify from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automate Redis Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Redis from PowerShell? This article demonstrates how to utilize the Redis Cmdlets for tasks like connecting to Redis, automating operations, downloading data, and more.
-
Import Real-Time OpenWeatherMap Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use OpenWeatherMap in ColdFusion.
-
DataBind Charts to CapsuleCRM Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to CapsuleCRM 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.
-
Automated Continuous CapsuleCRM Replication to Databricks
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Databricks.
-
Connect to Outlook Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Outlook in the Denodo Virtual DataPort Administrator.
-
Analyze eBay Analytics Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for eBay Analytics from Power Pivot. You will use the Table Import Wizard to load eBay Analytics. You can visually build the import query or use any SQL supported by the driver.
-
Build Apps with Live Twilio in Adalo using CData Connect AI
Use CData Connect AI to integrate live Twilio into the Adalo platform and build custom mobile and web applications with real-time Twilio.
-
Visualize Vault CRM Data in TIBCO Spotfire through OData
Integrate Veeva Vault & Vault CRM into dashboards in TIBCO Spotfire.
-
Build Charts with Workable Data in Clear Analytics
Create dynamic charts and perform analytics based on Workable in Clear Analytics.
-
How to Access Keap Data Using Entity Framework
This article shows how to access Keap using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData ADO.NET Provider for Bitbucket
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Bitbucket.
-
Build MailChimp Visualizations in Tableau Desktop
Use CData Connect AI to connect to live MailChimp and build visualizations in Tableau.
-
How to Work with FHIR Data in ETL Validator JDBC
Connect to FHIR from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect to Live Avro Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Apache Avro securely in real time.
-
Query WooCommerce Data from Node.js
Use the OData endpoint of the CData API Server to connect to your WooCommerce and perform CRUD operations on WooCommerce from Node.js.
-
Build AI/ML Models with Live Attio Data using Dataiku
Connect Attio Data with Dataiku using the CData API Driver for JDBC.
-
Integrating LangGraph with Raisers Edge NXT Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Raisers Edge NXT within automated workflows.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Pushbullet
Provide connectivity to Pushbullet through an SAP BusinessObjects universe.
-
How to Query CockroachDB Data in MySQL Workbench
Execute MySQL queries against live CockroachDB from MySQL Workbench.
-
How to Query YouTube Analytics Data in MySQL Workbench
Execute MySQL queries against live YouTube Analytics from MySQL Workbench.
-
How to work with Act-On Data in Apache Spark using SQL
Access and process Act-On Data in Apache Spark using the CData Software JDBC Driver.
-
Choosing the Best Method to Connect SAP Hybris C4C to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP Hybris C4C from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
ETL Odoo in Oracle Data Integrator
This article shows how to transfer Odoo ERP into a data warehouse using Oracle Data Integrator.
-
Object-Relational Mapping (ORM) with Salesforce CRM Analytics 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 Salesforce CRM Analytics into a Java-based ORM framework, Hibernate.
-
Access Live Microsoft Planner Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Planner data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Building Dynamic Web Pages with Microsoft Dataverse Data Using AngularJS
Create single-page applications with live connectivity to Microsoft Dataverse using the CData API Server.
-
Add Wistia Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Wistia with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live Zoho Inventory Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoho Inventory from your Google Sheets.
-
Automated Continuous Databricks Replication to Snowflake
Use CData Sync for automated, continuous, customizable Databricks replication to Snowflake.
-
How to create ADP federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ADP in MySQL .
-
How to Create Power BI Visual Reports with Real-Time Sage 200 Data
Use CData Power BI Connectors to visualize Sage 200 in Power BI.
-
Enable the PabblySubscriptions JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with PabblySubscriptions.
-
Use the CData Software ODBC Driver for SAP Ariba Procurement in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP Ariba Procurement in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP Ariba Procurement.
-
Connect to JobNimbus 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 JobNimbus and work with JobNimbus in your FileMaker application.
-
Elasticsearch Reporting in OBIEE with the Elasticsearch JDBC Driver
Deploy the Elasticsearch JDBC driver on OBIEE to provide real-time reporting across the enterprise.