CData Software - Knowledge Base
Recent Articles
-
Building Dynamic Web Pages with Google Analytics Using AngularJS
Create single-page applications with live connectivity to Google Analytics using the CData API Server.
-
Create Data Visualizations in Cognos BI with Salesforce Pardot
Access Salesforce Pardot as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connecting Agentforce with Lakebase via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Lakebase for you.
-
Build Google Directory-Connected Apps in Choreo
Use CData Connect AI to connect to Google Directory from Choreo and build custom apps using live Google Directory.
-
Create Informatica Mappings From/To a JDBC Data Source for Amazon Marketplace
Create Amazon Marketplace data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Load XML to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load XML Files to a database.
-
How to connect to Access from IntelliJ
Integrate connectivity to Microsoft Access with wizards in IntelliJ.
-
Automated Continuous Invoiced Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Invoiced replication to Microsoft Access.
-
How to Connect to Jira Assets in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Jira Assets. Leverage the pyodbc module for ODBC in Python.
-
Connect to Elasticsearch in NetBeans
Connect to Elasticsearch in NetBeans with the data source configuration wizard.
-
How to connect PolyBase to Salesloft
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Salesloft.
-
Create Power BI Reports on Real-Time Amazon S3
Use the CData ODBC Driver for Amazon S3 to visualize Amazon S3 in Power BI Desktop.
-
Stream Salesforce Data Cloud into Apache Kafka Topics
Access and stream Salesforce Data Cloud in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Query IBM Informix in DataGrip
Create a Data Source for IBM Informix in DataGrip and use SQL to query live IBM Informix.
-
Use ChatGPT to Talk to Your MariaDB via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your MariaDB for you.
-
Automated Continuous Access Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Access replication to AlloyDB.
-
Connect to Couchbase in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Couchbase and connect to Couchbase in Akorbi Digital RunMyProcess.
-
Access Live Coinbase Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Coinbase data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Analyze Azure Table in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Azure Table Storage and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Greenhouse in the Pentaho Report Designer
Publish reports based on Greenhouse in the Pentaho BI tool.
-
Automated Continuous CSV Replication to Oracle
Use CData Sync for automated, continuous, customizable CSV replication to Oracle.
-
Connect LDAP Objects to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your LDAP using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Shippo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Shippo facts in real time.
-
Build Data Flows from EnterpriseDB to SQL Server using SSIS
Easily back up EnterpriseDB to SQL Server using the SSIS components for EnterpriseDB.
-
Working with Cassandra in LINQPad
Execute LINQ queries to Apache Cassandra in LINQPad.
-
Viewing MarkLogic in RAD Studio Data Explorer
How to view MarkLogic in RAD Studio Data Explorer using the CData ODBC Driver for MarkLogic.
-
Integrate with Live Airtable in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Airtable from the MuleSoft Anypoint Platform to integrate live Airtable into custom reports and dashboards.
-
Replicate DocuSign from PowerShell
Write a quick PowerShell script to query DocuSign. Use connectivity to the live data to replicate DocuSign to SQL Server.
-
Automated Continuous Dynamics CRM Replication to SQL Server
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to SQL Server.
-
Analyze JotForm in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze JotForm in Microsoft R Open.
-
Publish Crystal Reports on Blackbaud FE NXT
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Blackbaud FE NXT.
-
How to Access AlloyDB Using Entity Framework
This article shows how to access Google AlloyDB using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Visualize Live AlloyDB in the Power BI Service
Use CData Connect AI to connect to live Google AlloyDB and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Highrise in JRuby
Create a simple JRuby app with access to live Highrise CRM.
-
Operational Reporting on IBM Cloud Object Storage from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote IBM Cloud Object Storage.
-
Automated Continuous Tally Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Tally ERP replication to OneLake in Microsoft Fabric.
-
Feed Monday.com into FineReport
How to set Monday.com as a JDBC data source in FineReport.
-
Connect to SAP Netweaver Gateway from PowerBuilder via JDBC
This article demonstrates how to access SAP Netweaver Gateway from PowerBuilder using the SAP Netweaver Gateway JDBC Driver.
-
Work with SAP HANA in FoxPro
Load SAP HANA into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to and Visualize Live Workday in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Workday.
-
Work with Box in FoxPro
Load Box into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for LinkedIn Ads
Provide connectivity to LinkedIn Ads through an SAP BusinessObjects universe.
-
How to Connect to & Open Zuora in Microsoft Excel
This article uses the CData ODBC driver for Zuora to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous SAP Business One Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP Business One replication to delimited files (CSV/TSV).
-
Integrating Gumloop with Epicor Kinetic via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Epicor Kinetic within automated workflows.
-
How to connect to SFTP in DBVisualizer
Integrate SFTP with visual data analysis tools and data connection wizards in DBVisualizer
-
Create a Data Access Object for FHIR using JDBI
A brief overview of creating a SQL Object API for FHIR in JDBI.
-
Access Live Lakebase in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Lakebase through MCP integration.
-
Connect to Access in RapidMiner
Integrate Microsoft Access with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Zoho Creator from HeidiSQL
Use CData Connect AI to connect to and query live Zoho Creator from HeidiSQL.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Azure Active Directory
Provide connectivity to Azure Active Directory through an SAP BusinessObjects universe.
-
Migrating data from Drift to Databricks using CData SSIS Components.
Easily push Drift to Databricks using the CData SSIS Tasks for Drift and Databricks.
-
Use Claude to Talk to Your Jira Service Management via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Atlassian Jira Service Management for you.
-
How to use SQLAlchemy ORM to access Dropbox in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Dropbox.
-
Consume EnterpriseDB OData Feeds in SAP Lumira
Use the API Server to create data visualizations on EnterpriseDB feeds that reflect any changes in SAP Lumira.
-
Automated Continuous ShipStation Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ShipStation replication to PostgreSQL.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Drive
Create Google Drive data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Connect Excel Online to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Excel Online data in real time using natural language.
-
How to Connect DBeaver to Shippo via a JDBC Driver
Manage Shippo with visual tools in DBeaver like the query browser.
-
How to create Exact Online federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Exact Online in MySQL .
-
How to Connect to Paylocity in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Paylocity. Leverage the pyodbc module for ODBC in Python.
-
Use the CData ODBC Driver for REST in Microsoft Power Query
You can use the CData REST ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import REST into Microsoft Power Query.
-
Work with WordPress in FoxPro
Load WordPress into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Neo4J Replication to SingleStore
Use CData Sync for automated, continuous, customizable Neo4J replication to SingleStore.
-
Connect to XML as an External Source in Dremio
Use the CData JDBC Driver to connect to XML as an External Source in Dremio.
-
Connect to Live Outreach.io in MicroStrategy through CData Connect AI
Create a live connection to Outreach.io in CData Connect AI and connect to your Outreach.io from MicroStrategy.
-
How to connect Amazon QuickSight to Hive
Create a connection to Apache Hive in CData Connect AI and insert Apache Hive into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Dashboards and Visualize Live Sage Intacct in Geckoboard
Use CData Connect AI to connect to live Sage Intacct and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Act-On in the Denodo Platform
Use CData driver technologies to create a virtual data source for Act-On in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Klaviyo Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Klaviyo replication to Apache Kafka.
-
Connecting Mastra with MYOB AccountRight via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across hundreds of enterprise sources no replication required.
-
How to Work with Oracle Eloqua Reporting in AWS Glue Jobs Using JDBC
Connect to Oracle Eloqua Reporting from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate FHIR into Automated Tasks with Power Automate
Use CData Connect AI to connect to FHIR and integrate live FHIR into your Power Automate tasks.
-
Bulk Import Tasks from Excel to MS Planner: Excel Add-In for MS Planner
Learn how to bulk import and manage Microsoft Planner tasks directly from Excel using the CData Excel Add-In
-
Connect to Microsoft Project from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Project from PowerBuilder using the Microsoft Project JDBC Driver.
-
Integrate with Live Facebook in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Facebook from the MuleSoft Anypoint Platform to integrate live Facebook into custom reports and dashboards.
-
Build Airtable-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Airtable and create custom apps in Mendix.
-
Connect to Microsoft Exchange in Google Apps Script via SQL Gateway
Use the ODBC Driver for Microsoft Exchange and the SQL Gateway to access Microsoft Exchange from Google Apps Script.
-
Connect to Dynamics NAV as an External Source in Dremio
Use the CData JDBC Driver to connect to Dynamics NAV as an External Source in Dremio.
-
LINQ to SendGrid
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 SendGrid Data Provider.
-
Explore Geographical Relationships in Harvest with Power Map
Create data visualizations with Harvest in Power Map.
-
Create Informatica Mappings From/To a JDBC Data Source for Act CRM
Create Act CRM data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Blackbaud FE NXT from PowerBuilder via ADO.NET
This article demonstrates how to access Blackbaud FE NXT from Appeon PowerBuilder using the CData ADO.NET Provider for Blackbaud FE NXT.
-
Use Microsoft Copilot Studio to talk to your Couchbase 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 Couchbase for you.
-
How to create an RPA flow for MarkLogic in UiPath Studio
Use the MarkLogic ODBC Driver to create workflows that access real-time MarkLogic without any coding.
-
How to integrate JDBC-ODBC Bridge with Apache Airflow
Access and process JDBC-ODBC Bridge in Apache Airflow using the CData JDBC Driver.
-
Create Dynamic Act CRM Grids Using the Infragistics XamDataGrid
Learn how you can connect Act CRM to Infragistics XamDataGrid to build dynamic grids.
-
Configure the CData JDBC Driver for Sybase in a Connection Pool in Tomcat
Connect to Sybase from a connection pool in Tomcat.
-
Integrate Real-Time Access to Todoist in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Todoist in real time.
-
Use Dash to Build to Web Apps on Dropbox
Create Python applications that use pandas and Dash to build Dropbox-connected web apps.
-
Access Live Bing Ads in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Bing Ads from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous Epicor Kinetic Replication to Snowflake
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Snowflake.
-
Connect to SharePoint in NetBeans
Connect to Microsoft SharePoint in NetBeans with the data source configuration wizard.
-
Connect and Query Live MYOB AccountRight Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live MYOB AccountRight into Databricks
-
Creating QuickBooks Online-Connected Applications in Unqork
You can use CData Connect AI to feed QuickBooks Online to Unqork and build custom business apps.
-
Build Semantic Layer Views for XML in APOS Live Data Gateway
Use the CData Connector for XML in APOS Live Data Gateway to build Semantic Layer Views for XML Files.
-
Visualize Freshdesk in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Freshdesk into TIBCO Spotfire.
-
Analyze Google Search Results in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Search and visualize Google Search in SAP Analytics Cloud.
-
Access Klipfolio as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Klipfolio from your Oracle system.
-
Create SSAS Tabular Models from Unbounce
How to build a SQL Server Analysis Service Tabular Model from Unbounce using CData drivers.