CData Software - Knowledge Base
Recent Articles
-
Visualize Google Ad Manager in Sisense
Create an ElastiCube in Sisense app with access to Google Ad Manager.
-
Build Data Flows from SQL Server to Certinia through SSIS
Easily push SQL Server data to Certinia using the CData SSIS Tasks for Certinia.
-
Integrate with live MYOB AccountRight in Jitterbit
Use CData Connect AI to connect to and integrate live MYOB AccountRight in Jitterbit.
-
Working with BigCommerce in LINQPad
Execute LINQ queries to BigCommerce in LINQPad.
-
Automated Continuous Sugar CRM Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Sugar CRM replication to OneLake in Microsoft Fabric.
-
Build Visualizations of IBM Informix in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of IBM Informix in Birst.
-
Connect to Zoho Creator in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Zoho Creator in Airbyte.
-
Connect to Greenplum in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Greenplum and connect to Pivotal GreenPlum in Akorbi Digital RunMyProcess.
-
Analyze Eventbrite in R via JDBC
Use standard R functions and the development environment of your choice to analyze Eventbrite with the CData JDBC Driver for Eventbrite.
-
Manage EnterpriseDB in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for EnterpriseDB.
-
Migrating data from Shippo to Databricks using CData SSIS Components.
Easily push Shippo to Databricks using the CData SSIS Tasks for Shippo and Databricks.
-
DataBind Trello to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Trello with the DevExpress Windows Forms and Web controls to provide Trello to a chart.
-
Provide OData Services of LinkedIn Ads from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for LinkedIn Ads by developing a WCF Service Application.
-
How to Query Gmail in MySQL Workbench
Execute MySQL queries against live Gmail from MySQL Workbench.
-
Create Dashboards and Visualize Live NetSuite in Geckoboard
Use CData Connect AI to connect to live NetSuite CRM & ERP and create dashboards for real-time monitoring and visualization in Geckoboard.
-
DataBind Controls to Microsoft Teams in C++Builder
DataBind to Microsoft Teams in C++Builder with standard components and controls.
-
Connect to Azure Active Directory as an External Source in Dremio
Use the CData JDBC Driver to connect to Azure Active Directory as an External Source in Dremio.
-
Configure the CData JDBC Driver for SAP BusinessObjects BI in a Connection Pool in Tomcat
Connect to SAP BusinessObjects BI from a connection pool in Tomcat.
-
How to connect Amazon QuickSight to SAP BusinessObjects BI
Create a connection to SAP BusinessObjects BI in CData Connect AI and insert SAP BusinessObjects BI into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Design QuickBooks Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Connect to Sage Cloud Accounting from PowerBuilder via ADO.NET
This article demonstrates how to access Sage Business Cloud Accounting from Appeon PowerBuilder using the CData ADO.NET Provider for Sage Cloud Accounting.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Azure Analysis Services within intelligent workflows.
-
Create Data Visualizations in Cognos BI with Azure Data Lake Storage
Access Azure Data Lake Storage as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Analyze Live Adobe Analytics in SAS Viya
Use CData Connect AI to connect to Adobe Analytics from SAS Viya and deploy self-service analytics using live Adobe Analytics.
-
Use the CData ODBC Driver for Amazon DynamoDB in Microsoft Power Query
You can use the CData Amazon DynamoDB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Amazon DynamoDB into Microsoft Power Query.
-
Connect to and Query LinkedIn in QlikView over ODBC
Create data visualizations with LinkedIn in QlikView.
-
Automated Continuous Klipfolio Replication to MySQL
Use CData Sync for automated, continuous, customizable Klipfolio replication to MySQL.
-
Process & Analyze Databricks in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Databricks .
-
How to Query Live HubDB in Perplexity MacOS Desktop
Connect to and query live HubDB in Perplexity Desktop using CData Code Assist MCP.
-
Create Reports from Zoho Inventory in Looker Studio
Use CData Connect AI to gain access to live Zoho Inventory and create custom reports in Looker Studio.
-
Build AI Agents with Oracle Financials Cloud Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Integrate with Zoho Books in SnapLogic
Use CData Connect AI to connect to and integrate with live Zoho Books in SnapLogic.
-
Load PayPal to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load PayPal to a database.
-
Access Live Tableau CRM Analytics in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Tableau CRM Analytics from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to ConstantContact from Asprova with CData Software ODBC Driver for ConstantContact
This article shows how to connect faster to ConstantContact data from Asprova.
-
Create Reports with MySQL in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MySQL.
-
Replicate Multiple Sugar CRM Accounts
Replicate multiple Sugar CRM accounts to one or many databases.
-
Use the CData Software JDBC Driver for ConstantContact in MicroStrategy
Connect to ConstantContact in MicroStrategy Developer using the CData Software JDBC Driver for ConstantContact.
-
How to create ServiceNow federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ServiceNow in MySQL .
-
Visualize Box in TIBCO Spotfire through ADO.NET
Integrate Box into dashboards in TIBCO Spotfire.
-
Connect to Smartsheet in HULFT Integrate
Connect to Smartsheet as a JDBC data source in HULFT Integrate
-
Use JayDeBeApi to access Couchbase in Python
Use standard Python scripting and the development environment of your choice to access live Couchbase.
-
Build Automated SQL Server-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft SQL Server and build automated workflows in Zapier.
-
Integrate SAP Business One into Power Automate Desktop using CData Connect
CData Connect for SAP Business One enables you to integrate SAP Business One into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software JDBC Driver for Adobe Commerce in MicroStrategy
Connect to Adobe Commerce in MicroStrategy Developer using the CData Software JDBC Driver for Adobe Commerce.
-
How to create Sage 200 federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Sage 200 in MySQL .
-
Integrate Live Reckon Accounts Hosted into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Reckon Accounts Hosted and integrate live Reckon Accounts Hosted into apps built in Microsoft Power Apps.
-
Use the CData Software JDBC Driver for Greenplum in MicroStrategy
Connect to Pivotal GreenPlum in MicroStrategy Developer using the CData Software JDBC Driver for Greenplum.
-
How to connect PolyBase to XML
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live XML Files.
-
Use the CData ODBC Driver for EnterpriseDB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for EnterpriseDB to connect to EnterpriseDB from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring EnterpriseDB in Excel.
-
Manage RSS Feeds in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for RSS.
-
Use the CData Software JDBC Driver for Google Sheets in MicroStrategy Desktop
Connect to Google Sheets in MicroStrategy Desktop using the CData Software JDBC Driver for Google Sheets.
-
Connect to SAP ByDesign from a Connection Pool in JBoss
Integrate SAP Business ByDesign into Java servlets: Use the Management Console in JBoss to install the SAP ByDesign JDBC Driver.
-
How to Work with Kintone in AWS Glue Jobs Using JDBC
Connect to Kintone from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Lakebase Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Lakebase replication to PostgreSQL.
-
Visualize Microsoft Exchange in Tableau
The CData ODBC driver for Microsoft Exchange enables you integrate Microsoft Exchange into Tableau dashboards.
-
Connect to JDBC-ODBC Bridge from a Connection Pool in Jetty
The JDBC-ODBC Bridge JDBC Driver supports connection pooling: This article shows how to connect faster to JDBC-ODBC Bridge from Web apps in Jetty.
-
Back Up Slack to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Slack. In this article, we will employ an SSIS workflow to populate a database with Slack data.
-
DataBind Charts to Salesforce
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Salesforce & Force.com 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.
-
Use the CData Software JDBC Driver for PingOne in MicroStrategy Web
Connect to PingOne in MicroStrategy Web using the CData Software JDBC Driver for PingOne.
-
How to Connect to Live SharePoint from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Microsoft SharePoint for you.
-
Replicate Airtable from PowerShell
Write a quick PowerShell script to query Airtable. Use connectivity to the live data to replicate Airtable to SQL Server.
-
Integrate with Act-On in SnapLogic
Use CData Connect AI to connect to and integrate with live Act-On in SnapLogic.
-
How to Connect to Live MariaDB 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 MariaDB for you.
-
Viewing Salesforce Data Cloud in RAD Studio Data Explorer
How to view Salesforce Data Cloud in RAD Studio Data Explorer using the CData ODBC Driver for Salesforce Data Cloud.
-
How to create an RPA flow for Sage Intacct in UiPath Studio
Use the Sage Intacct ODBC Driver to create workflows that access real-time Sage Intacct without any coding.
-
Object-Relational Mapping (ORM) with DocuSign 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 DocuSign into a Java-based ORM framework, Hibernate.
-
Visualize Stripe in TIBCO Spotfire through OData
Integrate Stripe into dashboards in TIBCO Spotfire.
-
Integrate Azure DevOps with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Azure DevOps with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Azure DevOps.
-
Back Up Redis to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Redis. In this article, we will employ an SSIS workflow to populate a database with Redis data.
-
Publish Crystal Reports on Excel
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Excel.
-
Access WooCommerce 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 WooCommerce.
-
Connect to Sybase IQ in CloverDX (formerly CloverETL)
Transfer Sybase IQ using the visual workflow in the CloverDX data integration tool.
-
Visualize ClickUp in TIBCO Spotfire through ADO.NET
Integrate ClickUp into dashboards in TIBCO Spotfire.
-
Access Live Adobe Target in Coginiti Pro
Connect to and query live Adobe Target from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Model Trello Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Trello, enabling the direct import of real-time Trello.
-
Connecting Pipedream with IBM Informix via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on IBM Informix data in real time.
-
Create Twitter Ads-Connected Nintex Workflows
Use CData Connect AI to connect to Twitter Ads from Nintex Workflow Cloud and build custom workflows using live Twitter Ads.
-
Connect to OneNote in Google Apps Script via Connect AI
Use CData Connect AI to access Microsoft OneNote in Google Apps Script.
-
Access Live Zendesk in Excel 365 Online (Excel for the web)
Connect to Zendesk from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Visualize Vault CRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live Veeva Vault & Vault CRM in Python.
-
Dynamics 365 Business Central Reporting in OBIEE with the Dynamics 365 Business Central JDBC Driver
Deploy the Dynamics 365 Business Central JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Automated Workflows with Live PayPal in Workato
Use CData Connect AI to connect to live PayPal and build automated workflows in Workato.
-
View Reports on Real-Time HBase in Power BI Report Server
Use the CData ODBC Driver for HBase to visualize Apache HBase in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Grok to Talk to Your Google Spanner 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 Spanner for you.
-
Configure the CData JDBC Driver for QuickBooks in a Connection Pool in Tomcat
Connect to QuickBooks Desktop from a connection pool in Tomcat.
-
Integrate Live Salesforce Marketing into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Salesforce Marketing Cloud and integrate live Salesforce Marketing Cloud into apps built in Microsoft Power Apps.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live LinkedIn using the Model Context Protocol.
-
How to create Couchbase federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Couchbase in MySQL .
-
How to Connect to SAP BusinessObjects BI in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP BusinessObjects BI. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Active Directory Replication to MySQL
Use CData Sync for automated, continuous, customizable Active Directory replication to MySQL.
-
Build a Singer.io Tap for SAP Fieldglass With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP Fieldglass data using
-
Connect to SingleStore in DBeaver
Use the CData ODBC Driver to connect to SingleStore in DBeaver.
-
Automated Continuous Splunk Replication to SingleStore
Use CData Sync for automated, continuous, customizable Splunk replication to SingleStore.
-
Edit and Search Microsoft Dataverse External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Microsoft Dataverse (CDS) to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Microsoft Dataverse objects that you can access from apps and the dashboard.
-
Connect to CouchDB as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Apache CouchDB.
-
Connect to SAP Concur from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAP Concur from Filemaker Pro on Mac.
-
Build AI/ML Models with Live LinkedIn Ads Data using Dataiku
-