CData Software - Knowledge Base
Recent Articles
-
Integrate ZohoInvoice with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ZohoInvoice with External Services.
-
Connect to ShipStation Data in DBArtisan
Use wizards in DBArtisan to configure ShipStation as a data source.
-
Build an OLAP Cube in SSAS from Office 365 Data
Establish a connection to Microsoft Office 365 data from SQL Server Analysis Services, and use the Office 365 Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to create Visio diagrams from Square Data
Automatically update Square with the changes you make to Visio master shapes.
-
Analyze Quickbase Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Quickbase and visualize Quickbase in SAP Analytics Cloud.
-
Visualize Live Hive Data in the Power BI Service
Use CData Connect AI to connect to live Apache Hive and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Live RSS Feeds of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live RSS Feeds using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query SAP Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP entities in PHP by modeling them as objects.
-
Back Up Dropbox to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Dropbox. In this article, we will employ an SSIS workflow to populate a database with Dropbox data.
-
How to Connect Flowise AI Agents to Live Dynamics 365 Business Central Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Dynamics 365 Business Central without replication.
-
How to Connect the Power BI Service to Datadog: Complete Guide
Connect to the CData Software Power BI Connector for Datadog from PowerBI.com to provide real-time Datadog across the organization.
-
Build Dashboards with CapsuleCRM Data in Dundas BI
Create dynamic dashboards and perform analytics based on CapsuleCRM in Dundas BI.
-
How to Build an ETL App for Demio Data in Python with CData
Create ETL applications and real-time data pipelines for Demio in Python with petl.
-
Query, Visualize, and Share live Greenhouse Data in Redash
Use CData Connect AI to connect to live Greenhouse in Redash for querying, visualizing, and sharing.
-
Process & Analyze EmailOctopus Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live EmailOctopus Data.
-
Validate SharePoint Data with QuerySurge
Access and validate Microsoft SharePoint in QuerySurge using the CData JDBC Driver.
-
Publish Paylocity-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Paylocity.
-
DataBind Charts to Bitbucket Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Bitbucket 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.
-
Build ZeroBounce-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ZeroBounce.
-
How to Connect to Live Oracle Service Cloud Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Oracle Service Cloud for you.
-
Automate Basecamp Data Replication to Couchbase
Use CData Sync to Customize and automate Basecamp replication to Couchbase.
-
Use Azure AI Foundry to Talk to Your Sage Cloud Accounting Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Sage Business Cloud Accounting for you.
-
Connecting GenSpark with Zoom Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Zoom without any replication or custom integration required.
-
Publish Power BI XMLA-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Power BI XMLA.
-
Automate ServiceNow Data Replication to SAP HANA
Use CData Sync to customize and automate ServiceNow replication to SAP HANA.
-
Create Cloudant-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Cloudant Data from Klipfolio and build custom visualizations using live IBM Cloudant.
-
Integrate Facebook Data into Power Automate Desktop using CData Connect
CData Connect for Facebook Data enables you to integrate Facebook into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous ZohoInvoice Replication to Vertica
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to Vertica.
-
Replicate Multiple Salesforce Marketing Accounts via the CData Sync CLI
Replicate multiple Salesforce Marketing accounts to one or many databases.
-
Use Biml to Build SSIS Tasks to Replicate Dynamics 365 Business Central Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Dynamics 365 Business Central to SQL Server.
-
Integrate LinkedIn Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live LinkedIn from Informatica Cloud.
-
Use Claude to Talk to Your YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your YouTube Analytics for you.
-
Integrate Cline with Live Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Spanner from within your IDE.
-
Use the CData Software JDBC Driver for Amazon Marketplace in MicroStrategy
Connect to Amazon Marketplace in MicroStrategy Developer using the CData Software JDBC Driver for Amazon Marketplace.
-
Connect to RSS Feeds from a Connection Pool in JBoss
Integrate RSS Feeds into Java servlets: Use the Management Console in JBoss to install the RSS JDBC Driver.
-
Connect to Odoo Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build Visualizations of Amazon S3 Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Amazon S3 in Birst.
-
Use the CData Software ODBC Driver for Jira in MicroStrategy Desktop
Connect to Atlassian Jira in MicroStrategy Desktop using the CData Software ODBC Driver for Jira.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Sage 300 to Power BI dashboards. Simply drag and drop Sage 300 into data visuals on the Power BI canvas.
-
Integrate ServiceDesk Plus Data in the Pentaho Report Designer
Publish reports based on ServiceDesk Plus in the Pentaho BI tool.
-
Import Real-Time Outreach.io Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Outreach.io in ColdFusion.
-
Connect to Apify Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Import Real-Time Teradata Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Teradata in ColdFusion.
-
Integrating SendGrid Data in Talend Cloud Data Management Platform
Connect SendGrid Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SendGrid.
-
Deploy the ADO.NET Provider for SAP ByDesign on an SSRS Report Server
Connect to SAP Business ByDesign 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.
-
How to publish and share Snapchat Ads Data dashboards with Tableau Server
The CData ODBC driver for Snapchat Ads enables you integrate Snapchat Ads into Tableau dashboards.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Simplesat
Provide connectivity to Simplesat through an SAP BusinessObjects universe.
-
Automated Continuous Oracle Service Cloud Replication to SQLite
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to SQLite.
-
Connect Redis to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Redis with IBM WebSphere for seamless data integration and connectivity.
-
Feed Email Data into FineReport
How to set Email as a JDBC data source in FineReport.
-
Object-Relational Mapping (ORM) with Outreach.io 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 Outreach.io into a Java-based ORM framework, Hibernate.
-
Getting Started with the CData JDBC Driver for Webflow
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Webflow.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Oracle Database to Power BI dashboards. Simply drag and drop Oracle Database into data visuals on the Power BI canvas.
-
How to connect Amazon QuickSight to Oracle SCM Data
Create a connection to Oracle SCM in CData Connect AI and insert Oracle SCM into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Dashboards and Visualize Live Google Search Results in Geckoboard
Use CData Connect AI to connect to live Google Search and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Getting Started with the CData ODBC Driver for Azure Table
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Azure Table.
-
Create Informatica Mappings From/To a JDBC Data Source for SparkPost
Create SparkPost data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Data Flows from Stripe to SQL Server using SSIS
Easily back up Stripe to SQL Server using the SSIS components for Stripe.
-
Create Dashboards and Visualize Live CSV Data in Geckoboard
Use CData Connect AI to connect to live CSV/TSV Files and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to PostgreSQL Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time PostgreSQL using standard SQL.
-
Getting Started with the CData Python Connector for Avro
Learn to install and license the CData Python Connector
-
Visualize Basecamp Data in TIBCO Spotfire through OData
Integrate Basecamp into dashboards in TIBCO Spotfire.
-
Connect to Mode Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Mode.
-
Analyze Splunk Data in Cognos Analytics
Use CData Connect AI to connect to Splunk Data from Cognos Analytics and analyze live Splunk.
-
Integrate MariaDB Data in Pentaho Data Integration
Build ETL pipelines based on MariaDB in the Pentaho Data Integration tool.
-
Connect to Google Directory Data in Ruby
Connect to Google Directory in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Exa Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Exa replication to Amazon Redshift.
-
Upsert Salesforce Data Using External Id in SSIS
Upsert Salesforce Data Using External Id in SSIS.
-
Consume Act CRM OData Feeds in PowerBuilder
This article demonstrates how to consume Act CRM as OData feeds from PowerBuilder using the API Server.
-
Access ChargeOver Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ChargeOver from your Oracle system.
-
Import Real-Time SharePoint Excel Services Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SharePoint Excel Services in ColdFusion.
-
Automated Continuous SQL Server Replication to SQLite
Use CData Sync for automated, continuous, customizable SQL Server replication to SQLite.
-
Build Freshsales-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Freshsales.
-
Replicate Wistia Data in Heroku for Use in Salesforce Connect
Replicate Wistia to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Databricks Data from a Connection Pool in JBoss
Integrate Databricks into Java servlets: Use the Management Console in JBoss to install the Databricks JDBC Driver.
-
Operational Reporting on Gorgias Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Gorgias.
-
How to Connect DBeaver to Okta via a JDBC Driver
Manage Okta with visual tools in DBeaver like the query browser.
-
Connect to Drip Data from a Connection Pool in Jetty
The Drip JDBC Driver supports connection pooling: This article shows how to connect faster to Drip from Web apps in Jetty.
-
Create Oracle Service Cloud-Connected Nintex Workflows
Use CData Connect AI to connect to Oracle Service Cloud Data from Nintex Workflow Cloud and build custom workflows using live Oracle Service Cloud.
-
How to Connect DBeaver to GetResponse via a JDBC Driver
Manage GetResponse with visual tools in DBeaver like the query browser.
-
Use Dash to Build to Web Apps on Excel Data
Create Python applications that use pandas and Dash to build Excel-connected web apps.
-
Connect to OneNote Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft OneNote in DBeaver.
-
Automated Continuous Google Spanner Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Spanner replication to AlloyDB.
-
Manage Google Contacts Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Contacts.
-
Connect to Webflow Data in RazorSQL
Connect to Webflow from wizards and query Webflow from the GUI in the RazorSQL database management tool.
-
Validate PagerDuty Data with QuerySurge
Access and validate PagerDuty in QuerySurge using the CData JDBC Driver.
-
Connecting Agentforce with OneNote Data 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 Microsoft OneNote for you.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Snowflake to Power BI dashboards. Simply drag and drop Snowflake into data visuals on the Power BI canvas.
-
Create Apps from Salesforce CRM Analytics Data in Qlik Sense Cloud
Use CData Connect AI to connect to Salesforce CRM Analytics Data and build apps from live Salesforce CRM Analytics in Qlik Sense Cloud.
-
Create Data Visualizations in Cognos BI with Odoo Data
Access Odoo ERP as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Bind Live Azure Data Lake Storage Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Azure Data Lake Storage data
-
How to import Square Data into Apache Solr
Use the CData Software JDBC Driver for Square in Data Import Handler and create an automated import of Square to Apache Solr Enterprise Search platform.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Exact Online using the Model Context Protocol.
-
How to Connect to Gumroad Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Gumroad. Leverage the pyodbc module for ODBC in Python.
-
Visualize Gumroad Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Gumroad.
-
Prepare, Blend, and Analyze Basecamp Data in Alteryx Designer (Connect AI)
Build workflows to access live Basecamp for self-service data analytics.
-
Getting Started with the CData Tableau Connector for Landbot
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use the CData Software JDBC Driver for GraphQL in MicroStrategy Web
Connect to GraphQL in MicroStrategy Web using the CData Software JDBC Driver for GraphQL.
-
Stream Reckon Accounts Hosted Data into Apache Kafka Topics
Access and stream Reckon Accounts Hosted in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Trigger Salesloft IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Salesloft with standard wizards in Logic Apps.