CData Software - Knowledge Base
Recent Articles
-
Build Visualizations of DocuSign in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of DocuSign in Birst.
-
How to Visualize Microsoft Teams Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Teams in Python.
-
Integrate SAP SuccessFactors in the Pentaho Report Designer
Publish reports based on SAP SuccessFactors in the Pentaho BI tool.
-
Use the CData Software ODBC Driver for Oracle Financials Cloud in MicroStrategy Web
Connect to Oracle Financials Cloud in MicroStrategy Web using the CData Software ODBC Driver for Oracle Financials Cloud.
-
Access Live Kafka in AWS Lambda
Connect to live Apache Kafka in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for SAS xpt in MicroStrategy Desktop
Connect to SAS XPORT in MicroStrategy Desktop using the CData Software ODBC Driver for SAS xpt.
-
Automated Continuous CSV Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable CSV replication to Amazon Redshift.
-
Connect to Todoist from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Todoist using standard SQL.
-
Establish a Live Connection with Google Ads using Tableau Bridge
The CData ODBC Driver for Google Ads enables you to integrate live Google Ads into Tableau Cloud dashboards using the Tableau Bridge.
-
Establish a Live Connection with Couchbase using Tableau Bridge
The CData ODBC Driver for Couchbase enables you to integrate live Couchbase into Tableau Cloud dashboards using the Tableau Bridge.
-
How to update Redis from Excel
This article explains how to transfer data from Excel to Redis using the Excel Add-In for Redis.
-
Visualize Live HarperDB in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live HarperDB.
-
Use the CData Software JDBC Driver for Microsoft Exchange in MicroStrategy Desktop
Connect to Microsoft Exchange in MicroStrategy Desktop using the CData Software JDBC Driver for Microsoft Exchange.
-
Use the CData API Server to Access MySQL in Microsoft PowerPivot
Use the CData API Server to connect to live MySQL in the Power Pivot business intelligence tool.
-
Integrate PayPal in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live PayPal from Informatica Cloud.
-
Visualize Live Cloudant in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live IBM Cloudant.
-
Integrating Gumloop with Exact Online via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Exact Online within automated workflows.
-
Access Greenplum 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 Pivotal GreenPlum.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Drive
Create an ODBC connection to Google Drive in Informatica and browse and transfer Google Drive.
-
Connect to Jira in the Denodo Platform
Use CData driver technologies to create a virtual data source for Atlassian Jira in the Denodo Virtual DataPort Administrator.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Reckon within intelligent workflows.
-
Connect to Zoho Books in ACL Analytics
Connect to Zoho Books via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Zoho Books.
-
Extract, Transform, and Load JotForm in Informatica PowerCenter
Create a simple Workflow for JotForm in Informatica PowerCenter.
-
Using the CData Software ODBC Driver for Salesforce in PyCharm
Connect to Salesforce as an ODBC data source in PyCharm using the CData Software ODBC Driver for Salesforce.
-
Use the CData Software JDBC Driver for Tally in MicroStrategy
Connect to Tally ERP in MicroStrategy Developer using the CData Software JDBC Driver for Tally.
-
How to Connect to Live Redis in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Redis without replication.
-
Deploy the ADO.NET Provider for Twilio on an SSRS Report Server
Connect to Twilio 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.
-
Connect to MailChimp in NetBeans
Connect to MailChimp in NetBeans with the data source configuration wizard.
-
Integrate with SAP SuccessFactors using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP SuccessFactors to a JSON file on disk.
-
How to Work with Microsoft Dataverse in ETL Validator JDBC
Connect to Microsoft Dataverse from ETL Validator jobs using the CData Software JDBC Driver.
-
Work with SuiteCRM in FoxPro
Load SuiteCRM into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Confluence-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Atlassian Confluence.
-
Operational Reporting on SAP ByDesign from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP Business ByDesign.
-
Connect to Sage 200 from PowerBuilder via ADO.NET
This article demonstrates how to access Sage 200 from Appeon PowerBuilder using the CData ADO.NET Provider for Sage 200.
-
Access Live Google Directory Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Google Directory data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Access Live Zoho Creator in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Zoho Creator into the statistical analysis tools available in SAS JMP. This article shows how to use Zoho Creator in the Graph Builder and Query Builder.
-
Automated Continuous HCL Domino Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable HCL Domino replication to Azure SQL Database.
-
Connect to Cosmos DB through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Cosmos DB using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Rapidly Develop DB2-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Getting Started with the CData Python Connector for Teradata
Learn to install and license the CData Python Connector
-
Automated Continuous Stripe Replication to Vertica
Use CData Sync for automated, continuous, customizable Stripe replication to Vertica.
-
Automated Continuous QuickBooks Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable QuickBooks replication to delimited files (CSV/TSV).
-
Connect to Microsoft Exchange in CloverDX (formerly CloverETL)
Transfer Microsoft Exchange using the visual workflow in the CloverDX data integration tool.
-
Integrating LangChain with Oracle Financials Cloud via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Oracle Financials Cloud within automated workflows.
-
How to Connect DBeaver to Google Calendar via a JDBC Driver
Manage Google Calendar with visual tools in DBeaver like the query browser.
-
Build Data Flows from ShipStation to SQL Server using SSIS
Easily back up ShipStation to SQL Server using the SSIS components for ShipStation.
-
DataBind Controls to Sage Intacct in Delphi
DataBind to Sage Intacct in Delphi with standard data access components and controls.
-
How to Seamlessly Import Pinterest Data into IBM SPSS Modeler
Integrate Pinterest data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Outreach.io in AWS Lambda
Connect to live Outreach.io in AWS Lambda using the CData JDBC Driver.
-
Model Spark Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Spark, enabling the direct import of real-time Apache Spark SQL.
-
Integrate Real-Time Access to Kintone in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Kintone in real time.
-
Automated Continuous Box Replication to Snowflake
Use CData Sync for automated, continuous, customizable Box replication to Snowflake.
-
DataBind Controls to Reckon in C++Builder
DataBind to Reckon in C++Builder with standard components and controls.
-
Replicate QuickBooks to Multiple Databases
Replicate QuickBooks Desktop to disparate databases with a point-and-click configuration.
-
Connect to SAP ByDesign as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP ByDesign as an External Source in Dremio.
-
Integrate with Amazon DynamoDB in SnapLogic
Use CData Connect AI to connect to and integrate with live Amazon DynamoDB in SnapLogic.
-
Use the CData SSIS Components to Insert New or Update Existing Google Directory Records from SQL Server
Easily push SQL Server data to Google Directory using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Directory or update existing records with data from a SQL Server database.
-
Load Google Data Catalog to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Data Catalog to a database.
-
Easily Integrate GitHub in Lazarus Pascal IDE
Learn how to easily integrate live GitHub in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect to Live Microsoft Project Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Microsoft Project securely in real time.
-
How to create Visio diagrams from IBM Informix
Automatically update IBM Informix with the changes you make to Visio master shapes.
-
Query PostgreSQL in DataGrip
Create a Data Source for PostgreSQL in DataGrip and use SQL to query live PostgreSQL.
-
Create SSAS Tabular Models from ConstantContact
How to build a SQL Server Analysis Service Tabular Model from ConstantContact using CData drivers.
-
Automated Continuous SAP Ariba Source Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Vertica.
-
Getting Started with the CData ODBC Driver for Lakebase
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Lakebase.
-
Automated Continuous SuiteCRM Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Azure SQL Database.
-
Create Power BI Reports on Real-Time Aha
Use the CData ODBC Driver for Aha to visualize Aha! in Power BI Desktop.
-
Access Live Amazon DynamoDB in Coginiti Pro
Connect to and query live Amazon DynamoDB from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Typeform
Provide connectivity to Typeform through an SAP BusinessObjects universe.
-
ETL Excel Online in Oracle Data Integrator
This article shows how to transfer Microsoft Excel Online into a data warehouse using Oracle Data Integrator.
-
Automated Continuous BambooHR Replication to IBM DB2
Use CData Sync for automated, continuous, customizable BambooHR replication to IBM DB2.
-
Visualize Live Amazon Athena in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Amazon Athena.
-
Create a Data Access Object for Todoist using JDBI
A brief overview of creating a SQL Object API for Todoist in JDBI.
-
Bridge Zoom Connectivity with Apache NiFi
Access and process Zoom in Apache NiFi using the CData JDBC Driver.
-
Use the CData ODBC Driver for Sage 300 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Sage 300 to connect to Sage 300 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Sage 300 in Excel.
-
Automated Continuous Azure Data Catalog Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Microsoft Access.
-
Use the CData ODBC Driver for Azure DevOps from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Azure DevOps to connect to Azure DevOps from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Azure DevOps in Excel.
-
Integrate QuickBooks Time with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate QuickBooks Time with External Services.
-
Back Up Klipfolio to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Klipfolio. In this article, we will employ an SSIS workflow to populate a database with Klipfolio data.
-
Build SAP ByDesign-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAP ByDesign from Zoho Analytics and import live SAP Business ByDesign.
-
Automated Continuous Dynamics 365 Business Central Replication to Oracle
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Oracle.
-
Build Semantic Layer Views for Act CRM in APOS Live Data Gateway
Use the CData Connector for Act CRM in APOS Live Data Gateway to build Semantic Layer Views for Act CRM.
-
Connect to Reckon Accounts Hosted from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Reckon Accounts Hosted using standard SQL.
-
Connect to Real-Time Dynamics 365 Data in Power Apps Using Dataflows to Build Custom Applications
-