CData Software - Knowledge Base
Recent Articles
-
Automated Continuous LinkedIn Ads Replication to IBM DB2
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to IBM DB2.
-
Automated Continuous Jira Service Management Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Jira Service Management replication to AlloyDB.
-
Use the CData Software ODBC Driver for Google Campaign Manager 360 in MicroStrategy Desktop
Connect to Google Campaign Manager 360 in MicroStrategy Desktop using the CData Software ODBC Driver for Google Campaign Manager 360.
-
Visualize JSON Services in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load JSON into TIBCO Spotfire.
-
Getting Started with the CData ODBC Driver for SQL Server
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SQL Server.
-
Automated Continuous Authorize.Net Replication to MySQL
Use CData Sync for automated, continuous, customizable Authorize.Net replication to MySQL.
-
Prepare, Blend, and Analyze SAP Ariba Procurement in Alteryx Designer (ODBC)
Build workflows to access live SAP Ariba Procurement for self-service data analytics.
-
Connect to SendGrid in JRuby
Create a simple JRuby app with access to live SendGrid.
-
Migrating data from Redis to Snowflake using CData SSIS Components.
Easily push Redis to Snowflake using the CData SSIS Tasks for Redis and Snowflake.
-
Connect to Live BigCommerce in PostGresSQL Interface through CData Connect AI
Create a live connection to BigCommerce in CData Connect AI and connect to your BigCommerce from PostgreSQL.
-
Automated Continuous SAP HANA XS Advanced Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to SQLite.
-
Integrate Live PayPal into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to PayPal and integrate live PayPal into apps built in Microsoft Power Apps.
-
Provide OData Services of Oracle from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Oracle Database by developing a WCF Service Application.
-
Build ActiveCampaign-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for ActiveCampaign and create custom apps in Bubble.
-
How to Query Live Access Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Access data in natural language using Python.
-
Working with GitHub in LINQPad
Execute LINQ queries to GitHub in LINQPad.
-
Access Live PayPal in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live PayPal from your Excel spreadsheets.
-
Build Automated Workflows with Live Zoho Creator in Workato
Use CData Connect AI to connect to live Zoho Creator and build automated workflows in Workato.
-
Query ServiceNow using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume ServiceNow entities in PHP by modeling them as objects.
-
Integrate with Azure Analysis Services using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Azure Analysis Services to a JSON file on disk.
-
Design BIRT Reports on LinkedIn
Provide current LinkedIn to your embedded analytics.
-
Integrate Zendesk in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zendesk from Informatica Cloud.
-
Connect to Zoom from a Connection Pool in JBoss
Integrate Zoom into Java servlets: Use the Management Console in JBoss to install the Zoom JDBC Driver.
-
Build Basecamp-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Basecamp.
-
Configure the CData JDBC Driver for Power BI XMLA in a Connection Pool in Tomcat
Connect to Power BI XMLA from a connection pool in Tomcat.
-
Replicate MariaDB in Heroku for Use in Salesforce Connect
Replicate MariaDB to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Data Flows from Twitter to SQL Server using SSIS
Easily back up Twitter to SQL Server using the SSIS components for Twitter.
-
Create Typeform Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Gmail in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Gmail from Informatica Cloud.
-
Connect to and Visualize Live Odoo in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Odoo ERP.
-
Automated Continuous Twitter Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Twitter replication to Google BigQuery.
-
Integrate Azure DevOps into Automated Tasks with Power Automate
Use CData Connect AI to connect to Azure DevOps and integrate live Azure DevOps into your Power Automate tasks.
-
Automated Continuous Google Campaign Manager 360 Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Amazon S3.
-
Use ChatGPT to Talk to Your OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your OData for you.
-
Seamlessly Bring AlloyDB into Retool Using CData Connect AI
Integrate AlloyDB data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
PowerShell Scripting to Replicate SAP BusinessObjects BI to MySQL
Write a simple PowerShell script to replicate SAP BusinessObjects BI to a MySQL database.
-
Connect to Blackbaud FE NXT in CloverDX (formerly CloverETL)
Transfer Blackbaud FE NXT using the visual workflow in the CloverDX data integration tool.
-
Access LinkedIn Ads as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access LinkedIn Ads from your Oracle system.
-
Analyze HCL Domino with Power Pivot
This article walks you through the process of using the CData ODBC Driver for HCL Domino from Power Pivot. You will use the Table Import Wizard to load HCL Domino. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Azure DevOps in Pentaho Data Integration
Build ETL pipelines based on Azure DevOps in the Pentaho Data Integration tool.
-
Integrate Stripe with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Stripe with External Services.
-
Connect to Oracle from a Connection Pool in WebLogic
Use the CData JDBC Driver for Oracle to connect to Oracle Database from Web applications running on WebLogic.
-
Connect to Oracle HCM Cloud from Crystal Reports
Use CData Connect AI to connect to and report on live Oracle HCM Cloud from Crystal Reports.
-
Jetty Security Notice Overview
CData is aware of a potential security issue with the Jetty embedded webserver (versions as high as 10.0.20, 11.0.20, and 12.0.7).
-
Build Charts with Oracle in Clear Analytics
Create dynamic charts and perform analytics based on Oracle Database in Clear Analytics.
-
Write a Simple Go Application to work with ConstantContact on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ConstantContact.
-
Automate HDFS Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Apache HDFS from PowerShell? This article demonstrates how to utilize the HDFS Cmdlets for tasks like connecting to Apache HDFS, automating operations, downloading data, and more.
-
Explore Geographical Relationships in Google Spanner with Power Map
Create data visualizations with Google Spanner in Power Map.
-
Load QuickBooks Online to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load QuickBooks Online to a database.
-
View Reports on Real-Time Drip in Power BI Report Server
Use the CData ODBC Driver for Drip to visualize Drip in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Twitter Ads-Connected Business Apps in AppSheet
Connect to Twitter Ads via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Twitter Ads.
-
DataBind Controls to Google Campaign Manager 360 in C++Builder
DataBind to Google Campaign Manager 360 in C++Builder with standard components and controls.
-
Connect to Oracle in SpagoBI
Create reports featuring live Oracle Database in SpagoBI Studio. Host Oracle reports on SpagoBI Server.
-
Using the CData Software ODBC Driver for Microsoft Dataverse in PyCharm
Connect to Microsoft Dataverse as an ODBC data source in PyCharm using the CData Software ODBC Driver for Microsoft Dataverse.
-
How to Build an ETL App for YouTube Analytics in Python with CData
Create ETL applications and real-time data pipelines for YouTube Analytics in Python with petl.
-
Build Semantic Layer Views for MongoDB in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for MongoDB.
-
How to connect Amazon QuickSight to Microsoft Teams
Create a connection to Microsoft Teams in CData Connect AI and insert Microsoft Teams into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Connect to Live OneNote 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 Microsoft OneNote without replication.
-
Automated Continuous WooCommerce Replication to SQLite
Use CData Sync for automated, continuous, customizable WooCommerce replication to SQLite.
-
Automated Continuous Dynamics 365 Business Central Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Amazon S3.
-
Building Dynamic Web Pages with Sage 200 Using AngularJS
Create single-page applications with live connectivity to Sage 200 using the CData API Server.
-
How to work with NetSuite in Apache Spark using SQL
Access and process NetSuite in Apache Spark using the CData Software JDBC Driver.
-
Connect to and Visualize Live Oracle SCM in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle SCM.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Procore to Power BI dashboards. Simply drag and drop Procore into data visuals on the Power BI canvas.
-
Create Tableau CRM Analytics-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Tableau CRM Analytics from Klipfolio and build custom visualizations using live Tableau CRM Analytics.
-
Visualize Salesforce Pardot from Tableau
Use the Tableau Desktop business intelligence tool to connect to Salesforce Pardot.
-
Use the CData Software ODBC Driver for Avalara AvaTax in MicroStrategy Web
Connect to Avalara AvaTax in MicroStrategy Web using the CData Software ODBC Driver for Avalara AvaTax.
-
Import Real-Time Salesforce via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Salesforce & Force.com in ColdFusion.
-
Visualize Live Bitbucket in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Bitbucket.
-
Create a Data Access Object for Act-On using JDBI
A brief overview of creating a SQL Object API for Act-On in JDBI.
-
Build MVC Applications with Connectivity to Oracle Sales
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Oracle Sales from an ASP.NET MVC application.
-
Integrate Live Greenplum into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Pivotal GreenPlum and integrate live Pivotal GreenPlum into apps built in Microsoft Power Apps.
-
Access Live Twilio Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Twilio data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to connect to HCL Domino from Spring Boot
Connect to HCL Domino in a Spring Boot Application using CData JDBC HCL Domino Driver
-
Manage eBay Analytics in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for eBay Analytics.
-
Integrate Greenplum into Power Automate Desktop using CData Connect
CData Connect for Greenplum enables you to integrate Pivotal GreenPlum into workflows built using Microsoft Power Automate Desktop.
-
Replicate Multiple Elasticsearch Accounts via the CData Sync CLI
Replicate multiple Elasticsearch accounts to one or many databases.
-
Connecting Agentforce with Zendesk 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 Zendesk for you.
-
Connect to Exact Online from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Exact Online to connect to Exact Online and execute queries in PowerBuilder.
-
Build Pipelines with Live Zoho Creator in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Zoho Creator from Google Cloud Data Fusion, enabling the integration of live Zoho Creator into the building and management of effective data pipelines.
-
Create Data Visualizations in Cognos BI with Coinbase
Access Coinbase as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Semantic Layer Views for Access in APOS Live Data Gateway
Use the CData Connector for Access in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Access.
-
DataBind Controls to Act-On in Delphi
DataBind to Act-On in Delphi with standard data access components and controls.
-
Visualize Zendesk in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Zendesk into TIBCO Spotfire.
-
Automated Continuous Square Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Square replication to Microsoft Access.
-
How to Connect the Power BI Service to Zuora: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Visualize Drip from Tableau
Use the Tableau Desktop business intelligence tool to connect to Drip.
-
Build Visualizations of Twitter Ads in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Twitter Ads in Birst.
-
Build Reckon-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Reckon.
-
Build a Simple VCL Application for Sugar CRM
How to build a simple VCL Application to view Sugar CRM in RAD Studio using the CData ODBC Driver for Sugar CRM.
-
Connect to Printful as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Printful.
-
Amazon Redshift: Million Row Challenge
CData Software tests a one million row bulk load of Amazon Redshift data.
-
Integrate with Active Directory using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Active Directory to a JSON file on disk.
-
Integrating LangChain with Epicor Kinetic via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Epicor Kinetic within automated workflows.
-
Connect to Adobe Analytics in RazorSQL
Connect to Adobe Analytics from wizards and query Adobe Analytics from the GUI in the RazorSQL database management tool.
-
Replicate Wave Financial in Heroku for Use in Salesforce Connect
Replicate Wave Financial to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Snowflake from MySQL in Amazon QuickSight
Connect to Snowflake and build visualizations of Snowflake using a MySQL Connection in Amazon QuickSight.
-
Integrating SAP SuccessFactors in Talend Cloud Data Management Platform
-