CData Software - Knowledge Base
Recent Articles
-
Work with Live Blackbaud FE NXT Data in Power Query
Use CData Connect AI to connect to Blackbaud FE NXT and work with live Blackbaud FE NXT in Microsoft Power Query.
-
Migrating data from Google Drive to Snowflake using CData SSIS Components.
Easily push Google Drive to Snowflake using the CData SSIS Tasks for Google Drive and Snowflake.
-
Import Real-Time PabblySubscriptions Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use PabblySubscriptions in ColdFusion.
-
Migrating data from Wistia to Google BigQuery using CData SSIS Components.
Easily push Wistia to Google BigQuery using the CData SSIS Tasks for Wistia and Google BigQuery.
-
Build Data Flows from NASA to SQL Server using SSIS
Easily back up NASA to SQL Server using the SSIS components for NASA.
-
How to Connect to & Open HelloSign Data in Microsoft Excel
This article uses the CData ODBC driver for HelloSign to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Email-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Email Data from OutSystems and build custom enterprise apps using live Email.
-
Create Informatica Mappings From/To an ODBC Data Source for Paylocity
Create an ODBC connection to Paylocity in Informatica and browse and transfer Paylocity.
-
Create YouTube Analytics-Connected Nintex Workflows
Use CData Connect AI to connect to YouTube Analytics Data from Nintex Workflow Cloud and build custom workflows using live YouTube Analytics.
-
Automated Continuous Codat Replication to Vertica
Use CData Sync for automated, continuous, customizable Codat replication to Vertica.
-
Access PDFMonkey Data from MySQL in PHP
Connect to PDFMonkey through the standard MySQL libraries in PHP.
-
Connect to IBM Informix Data from HeidiSQL
Use CData Connect AI to connect to and query live IBM Informix from HeidiSQL.
-
Create Dynamic Flowlu Grids Using the Infragistics XamDataGrid
Learn how you can connect Flowlu to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Live Zoho Projects Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Zoho Projects to Blue Prism using the CData ODBC Driver for Zoho Projects to create automated workflows for repetitive business tasks.
-
Connect to Campaigner Data in HULFT Integrate
Connect to Campaigner as a JDBC data source in HULFT Integrate
-
Automated Continuous SparkPost Replication to Oracle
Use CData Sync for automated, continuous, customizable SparkPost replication to Oracle.
-
Configure the CData JDBC Driver for Everhour in a Connection Pool in Tomcat
Connect to Everhour from a connection pool in Tomcat.
-
Integrate Cline with Live Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Pivotal GreenPlum from within your IDE.
-
Visualize Pipeline CRM Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pipeline CRM.
-
Object-Relational Mapping (ORM) with Unbounce 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 Unbounce into a Java-based ORM framework, Hibernate.
-
Use Grok to Talk to Your Google Drive 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 Google Drive for you.
-
How to Import Data from Oracle Eloqua into Google Sheets
Import Oracle Eloqua into a Google spreadsheet that is automatically refreshed.
-
Rapidly Develop Wistia-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 Wistia.
-
Choosing the Best Method to Connect Amazon Marketplace to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Amazon Marketplace from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Data Visualizations in Cognos BI with Paylocity Data
Access Paylocity as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Establish a Live Connection with Slack Data using Tableau Bridge
The CData ODBC Driver for Slack enables you to integrate live Slack into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Shopify Data in DBArtisan
Use wizards in DBArtisan to configure Shopify as a data source.
-
Provide OData Services of FHIR Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for FHIR by developing a WCF Service Application.
-
Query Sendwithus Data in DataGrip
Create a Data Source for Sendwithus in DataGrip and use SQL to query live Sendwithus.
-
ETL Reckon in Oracle Data Integrator
This article shows how to transfer Reckon into a data warehouse using Oracle Data Integrator.
-
Build a Singer.io Tap for Acumatica With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Acumatica data using
-
DataBind Controls to Zoho Projects Data in C++Builder
DataBind to Zoho Projects in C++Builder with standard components and controls.
-
Getting Started with the CData SSIS Components for Sendwithus
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Sendwithus.
-
Build Apps with Live Microsoft OneDrive in Adalo using CData Connect AI
Use CData Connect AI to integrate live Microsoft OneDrive into the Adalo platform and build custom mobile and web applications with real-time Microsoft OneDrive.
-
Viewing Miro Data in RAD Studio Data Explorer
How to view Miro in RAD Studio Data Explorer using the CData ODBC Driver for Miro.
-
How to Connect to Insightly Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Insightly. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous iContact Replication to Snowflake
Use CData Sync for automated, continuous, customizable iContact replication to Snowflake.
-
Automated Continuous ServiceNow Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ServiceNow replication to IBM DB2.
-
Getting Started with the CData Excel Add-In for Teamwork
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Teamwork.
-
Access Live ServiceNow 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 ServiceNow through MCP integration.
-
Migrating data from Azure Analysis Services to Databricks using CData SSIS Components.
Easily push Azure Analysis Services to Databricks using the CData SSIS Tasks for Azure Analysis Services and Databricks.
-
Working with Amplitude Data in LINQPad
Execute LINQ queries to Amplitude in LINQPad.
-
How to Visualize Sybase IQ Data in Python with pandas
Use pandas and other modules to analyze and visualize live Sybase IQ in Python.
-
Connect to SFTP in SpagoBI
Create reports featuring live SFTP in SpagoBI Studio. Host SFTP reports on SpagoBI Server.
-
Analyze BigCommerce Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze BigCommerce in Microsoft R Open.
-
Work with OData Services in FoxPro
Load OData into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate with ClickUp Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ClickUp to a JSON file on disk.
-
Automated Continuous Harvest Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Harvest replication to Amazon Redshift.
-
How to create an RPA flow for LaunchDarkly Data in UiPath Studio
Use the LaunchDarkly ODBC Driver to create workflows that access real-time LaunchDarkly without any coding.
-
Integrate with Wistia Data in JReport Designer
Create charts and reports based on Wistia in JReport Designer.
-
Use the CData Software ODBC Driver for Delighted in SAS for Real-Time Reporting and Analytics
Connect to real-time Delighted in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Delighted.
-
Object-Relational Mapping (ORM) with GitHub 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 GitHub into a Java-based ORM framework, Hibernate.
-
Automated Continuous Freshdesk Replication to SQLite
Use CData Sync for automated, continuous, customizable Freshdesk replication to SQLite.
-
Automated Continuous Amazon S3 Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Amazon S3 replication to Apache Cassandra.
-
Create Informatica Mappings From/To a JDBC Data Source for ShipEngine
Create ShipEngine data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData Software JDBC Driver for HubDB in MicroStrategy Desktop
Connect to HubDB in MicroStrategy Desktop using the CData Software JDBC Driver for HubDB.
-
Connect to and Visualize Live Spark Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apache Spark SQL.
-
Deploy the ADO.NET Provider for Elasticsearch on an SSRS Report Server
Connect to Elasticsearch from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Automate ADP Data Replication to Azure Synapse
Use CData Sync to customize and automate ADP replication to Azure Synapse.
-
Use the CData Software ODBC Driver for ADP in MicroStrategy Desktop
Connect to ADP in MicroStrategy Desktop using the CData Software ODBC Driver for ADP.
-
Connect to Google Spanner in SpagoBI
Create reports featuring live Google Spanner in SpagoBI Studio. Host Google Spanner reports on SpagoBI Server.
-
Replicate Square Data to Multiple Databases
Replicate Square to disparate databases with a point-and-click configuration.
-
Connect to Square Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Square and the Script function in FileMaker Pro to connect to Square and work with Square in your FileMaker application.
-
A PostgreSQL Interface for Opsgenie Data (MySQL Remoting via JDBC)
Use the Remoting features of the Opsgenie JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Live Databricks Data in SAS Viya
Use CData Connect AI to connect to Databricks from SAS Viya and deploy self-service analytics using live Databricks.
-
Rapidly Develop Egnyte-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 Egnyte.
-
Use the CData Software ODBC Driver for Adobe Target in MicroStrategy Desktop
Connect to Adobe Target in MicroStrategy Desktop using the CData Software ODBC Driver for Adobe Target.
-
Analyze Shopify Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Shopify in Microsoft R Open.
-
Build an OLAP Cube in SSAS from LinkedIn Data
Establish a connection to LinkedIn data from SQL Server Analysis Services, and use the LinkedIn Data Provider to build OLAP cubes for use in analytics and reporting.
-
Rapidly Develop Azure DevOps-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 Azure DevOps.
-
Excel Spreadsheet Automation on FHIR Data with the QUERY Formula
Pull data from FHIR, automate spreadsheets, and more with the QUERY formula.
-
Connect to Live Trello Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Trello in CData Connect AI and connect to your Trello from PostgreSQL.
-
DataBind MongoDB Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for MongoDB with the DevExpress Windows Forms and Web controls to provide MongoDB to a chart.
-
Access Email 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 Email.
-
Query Asana Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Asana and perform CRUD operations on Asana from Node.js.
-
Create Data Visualizations Based On SAP HANA Data in Mode
Use CData Connect AI to connect to SAP HANA Data from Mode and build visualizations using live
-
Back Up Zendesk to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Zendesk. In this article, we will employ an SSIS workflow to populate a database with Zendesk data.
-
Connect to IBM Informix Data in Aqua Data Studio
Access IBM Informix from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Live SpaceX Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SpaceX into the statistical analysis tools available in SAS JMP. This article shows how to use SpaceX in the Graph Builder and Query Builder.
-
Visualize QuickBooks Online Data in Tableau
The CData ODBC driver for QuickBooks Online enables you integrate QuickBooks Online into Tableau dashboards.
-
Bidirectional Access to SAP Concur Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP Concur in Filemaker Pro for Mac or Windows.
-
Build a Singer.io Tap for Brex With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Brex data using
-
Build a Simple VCL Application for Clockify Data
How to build a simple VCL Application to view Clockify in RAD Studio using the CData ODBC Driver for Clockify.
-
Analyze PostgreSQL Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of PostgreSQL and visualize PostgreSQL in SAP Analytics Cloud.
-
Getting Started with the CData Power BI Connector for Act-On
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Act-On.
-
Use CData Connect AI to Access Amazon Athena Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Amazon Athena in the Power Pivot business intelligence tool.
-
Connect to Zoho Creator Data from AWS Glue
Use CData Connect AI to gain access to live Zoho Creator from your AWS Glue jobs.
-
Visualize Teradata Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Teradata.
-
Use Manus AI to Talk to Your Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Exact Online.
-
Bidirectional Access to Guru Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Guru in Filemaker Pro for Mac or Windows.
-
Process & Analyze Freshsales Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Freshsales Data.
-
Build MVC Applications with Connectivity to Invoiced Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Invoiced from an ASP.NET MVC application.
-
Visualize Live SAP Business Warehouse Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP Business Warehouse using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query LinkedIn Ads Data in DataGrip
Create a Data Source for LinkedIn Ads in DataGrip and use SQL to query live LinkedIn Ads.
-
Validate Demio Data with QuerySurge
Access and validate Demio in QuerySurge using the CData JDBC Driver.
-
Build Apps with Live Odoo ERP in Adalo using CData Connect AI
Use CData Connect AI to integrate live Odoo ERP into the Adalo platform and build custom mobile and web applications with real-time Odoo ERP.
-
Use the CData Software ODBC Driver for Dynamics NAV in MicroStrategy
Connect to Microsoft Dynamics NAV in MicroStrategy Developer using the CData Software ODBC Driver for Dynamics NAV.
-
Integrate with ShipStation Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ShipStation to a JSON file on disk.
-
Connect to Chargebee Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Chargebee to connect to Chargebee and execute queries in PowerBuilder.
-
Build SAP Netweaver Gateway-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP Netweaver Gateway Data and create custom apps in Bubble.