CData Software - Knowledge Base
Recent Articles
-
Automated Continuous SuiteCRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Amazon Redshift.
-
Access Live Google Directory in Excel 365 Online (Excel for the web)
Connect to Google Directory from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Azure Table-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Azure Table Storage.
-
DataBind Controls to Eventbrite in C++Builder
DataBind to Eventbrite in C++Builder with standard components and controls.
-
Migrating data from Dynamics CRM to Databricks using CData SSIS Components.
Easily push Microsoft Dynamics CRM to Databricks using the CData SSIS Tasks for Dynamics CRM and Databricks.
-
Use ChatGPT to Talk to Your Google Sheets via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Google Sheets for you.
-
ETL Azure Table in Oracle Data Integrator
This article shows how to transfer Azure Table Storage into a data warehouse using Oracle Data Integrator.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Act CRM
Provide connectivity to Act CRM through an SAP BusinessObjects universe.
-
Connect to Avalara AvaTax in JRuby
Create a simple JRuby app with access to live Avalara AvaTax.
-
Analyze GitHub in Infragistics Reveal
Use CData Connect AI to create on OData API on top of GitHub and visualize live GitHub in Infragistics Reveal.
-
Automate Smartsheet Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Smartsheet from PowerShell? This article demonstrates how to utilize the Smartsheet Cmdlets for tasks like connecting to Smartsheet, automating operations, downloading data, and more.
-
Create a Data Access Object for Oracle Service Cloud using JDBI
A brief overview of creating a SQL Object API for Oracle Service Cloud in JDBI.
-
Query Shopify as a SQL Server Database in Node.js
Execute SQL Server queries against Shopify from Node.js.
-
Connect to Microsoft Exchange through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Microsoft Exchange using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Zendesk using the Model Context Protocol.
-
Create Data Visualizations Based On Zoho Creator in Mode
Use CData Connect AI to connect to Zoho Creator from Mode and build visualizations using live
-
Integrate with MarkLogic in JReport Designer
Create charts and reports based on MarkLogic in JReport Designer.
-
Use the CData Software ODBC Driver for Greenplum in SAS for Real-Time Reporting and Analytics
Connect to real-time Pivotal GreenPlum in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Greenplum.
-
Create Informatica Mappings From/To a JDBC Data Source for Kafka
Create Kafka data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
LINQ to SAP Hybris C4C
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 SAP Hybris C4C Data Provider.
-
How to connect to Clio in DBVisualizer
Integrate Clio with visual data analysis tools and data connection wizards in DBVisualizer
-
Prepare, Blend, and Analyze Procore in Alteryx Designer (ODBC)
Build workflows to access live Procore for self-service data analytics.
-
Microsoft Project Reporting in OBIEE with the Microsoft Project JDBC Driver
Deploy the Microsoft Project JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData ODBC Driver for Salesloft in Microsoft Power Query
You can use the CData Salesloft ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Salesloft into Microsoft Power Query.
-
Replicate Lakebase to Multiple Databases
Replicate Lakebase to disparate databases with a point-and-click configuration.
-
Connect to Gmail as an External Source in Dremio
Use the CData JDBC Driver to connect to Gmail as an External Source in Dremio.
-
Access Live Drift Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Drift data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Bidirectional Access to Act-On from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Act-On in Filemaker Pro for Mac or Windows.
-
Getting Started with the CData Python Connector for Sage Cloud Accounting
Learn to install and license the CData Python Connector
-
Automate Google Search Results Replication to Azure Data Lake
Use CData Sync to customize and automate Google Search replication to Azure Data Lake.
-
Migrating data from SAP Hybris C4C to Snowflake using CData SSIS Components.
Easily push SAP Hybris C4C to Snowflake using the CData SSIS Tasks for SAP Hybris C4C and Snowflake.
-
Connect to AlloyDB in HULFT Integrate
Connect to AlloyDB as a JDBC data source in HULFT Integrate
-
Access Live Acumatica in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Acumatica ERP from your Google Sheets.
-
Visualize SurveyMonkey from Tableau
Use the Tableau Desktop business intelligence tool to connect to SurveyMonkey.
-
Automated Continuous Presto Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Presto replication to Amazon S3.
-
How to Access Live XML in Power Automate Desktop via ODBC
The CData ODBC Driver for XML enables you to integrate XML Files into workflows built using Microsoft Power Automate Desktop.
-
Visualize Live Jira in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Atlassian Jira into custom reports in Power BI.
-
Building Dynamic Web Pages with TaxJar Using AngularJS
Create single-page applications with live connectivity to TaxJar using the CData API Server.
-
Edit and Search External Salesforce Marketing Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Salesforce Marketing Cloud to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Salesforce Marketing objects that you can access from apps and the dashboard.
-
Query RSS Feeds as a MySQL Database in Node.js
Execute MySQL queries against RSS Feeds from Node.js.
-
Analyze SingleStore in Infragistics Reveal
Use the CData API Server to create an OData API on top of SingleStore and visualize live SingleStore in Infragistics Reveal.
-
Replicate REST from PowerShell
Write a quick PowerShell script to query REST. Use connectivity to the live data to replicate REST to SQL Server.
-
Build a PostgreSQL Interface for Facebook Ads using the CData JDBC Driver
Use the Remoting features of the Facebook Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Azure Synapse from AWS Glue
Use CData Connect AI to gain access to live Azure Synapse from your AWS Glue jobs.
-
How to integrate Dropbox with Apache Airflow
Access and process Dropbox in Apache Airflow using the CData JDBC Driver.
-
Connect to MySQL in RapidMiner
Integrate MySQL with standard components and data source configuration wizards in RapidMiner Studio.
-
Build a Simple VCL Application for HubSpot
How to build a simple VCL Application to view HubSpot in RAD Studio using the CData ODBC Driver for HubSpot.
-
Connect to Kafka in RazorSQL
Connect to Kafka from wizards and query Apache Kafka from the GUI in the RazorSQL database management tool.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live LinkedIn within intelligent workflows.
-
Connect Dropbox to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Dropbox using the CData Python MCP Server.
-
Design BIRT Reports on Dynamics 365 Business Central
Provide current Dynamics 365 Business Central to your embedded analytics.
-
Integrate Google Campaign Manager 360 in the Pentaho Report Designer
Publish reports based on Google Campaign Manager 360 in the Pentaho BI tool.
-
Automated Continuous SharePoint Replication to SQL Server
Use CData Sync for automated, continuous, customizable SharePoint replication to SQL Server.
-
Stream eBay into Apache Kafka Topics
Access and stream eBay in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to integrate Google Directory with Apache Airflow
Access and process Google Directory in Apache Airflow using the CData JDBC Driver.
-
How to Connect to Live Reckon Accounts Hosted 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 Reckon Accounts Hosted for you.
-
Analyze Zuora in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Zuora and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Zendesk in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Zendesk and connect to Zendesk in Akorbi Digital RunMyProcess.
-
Query LinkedIn Ads in DataGrip
Create a Data Source for LinkedIn Ads in DataGrip and use SQL to query live LinkedIn Ads.
-
Build LDAP-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live LDAP.
-
Import SurveyMonkey Using Azure Data Factory
Use CData Connect AI to connect to SurveyMonkey from Azure Data Factory and import live SurveyMonkey.
-
A PostgreSQL Interface for Microsoft OneDrive using the CData ODBC Driver
Use the SQL Gateway and Microsoft OneDrive ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Phoenix-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache Phoenix.
-
Use the CData Software ODBC Driver for Kintone in MicroStrategy
Connect to Kintone in MicroStrategy Developer using the CData Software ODBC Driver for Kintone.
-
Automated Continuous Klipfolio Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Klipfolio replication to Azure SQL Database.
-
Connect to SQL Analysis Services from PowerBuilder via JDBC
This article demonstrates how to access SQL Analysis Services from PowerBuilder using the SQL Analysis Services JDBC Driver.
-
Build MVC Applications with Connectivity to Oracle
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Oracle from an ASP.NET MVC application.
-
Connect Azure Data Lake Storage to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Azure Data Lake Storage using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData Software JDBC Driver for Email in MicroStrategy Desktop
Connect to Email in MicroStrategy Desktop using the CData Software JDBC Driver for Email.
-
Rapidly Develop Google Contacts-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.
-
Replicate Dynamics CRM in Heroku for Use in Salesforce Connect
Replicate Microsoft Dynamics CRM to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Analyze Airtable in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Airtable and visualize live Airtable in Infragistics Reveal.
-
Query Oracle HCM Cloud through ODBC in Node.js
Use node-odbc to execute SQL queries against Oracle HCM Cloud from Node.js.
-
Connect to OneNote from PowerBuilder via JDBC
This article demonstrates how to access Microsoft OneNote from PowerBuilder using the OneNote JDBC Driver.
-
Use the CData ODBC Driver for FTP in Microsoft Power Query
You can use the CData FTP ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import FTP Servers into Microsoft Power Query.
-
Publish Reports with ADP in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ADP.
-
Import Real-Time Hive via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Apache Hive in ColdFusion.
-
Use the CData ODBC Driver for Google Ad Manager in Microsoft Power Query
You can use the CData Google Ad Manager ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Ad Manager into Microsoft Power Query.
-
Automated Continuous Printify Replication to Oracle
Use CData Sync for automated, continuous, customizable Printify replication to Oracle.
-
Explore Geographical Relationships in Azure DevOps with Power Map
Create data visualizations with Azure DevOps in Power Map.
-
A PostgreSQL Interface for SAP Fieldglass (MySQL Remoting via JDBC)
Use the Remoting features of the SAP Fieldglass JDBC Driver to create a PostgreSQL entry-point for data access.
-
Load SFTP to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SFTP to a database.
-
Integrate with DB2 in JReport Designer
Create charts and reports based on IBM DB2 in JReport Designer.
-
Use the CData API Server to Access Certinia in Microsoft PowerPivot
Use the CData API Server to connect to live Certinia in the Power Pivot business intelligence tool.
-
How to connect to Cosmos DB in DBVisualizer
Integrate Azure Cosmos DB with visual data analysis tools and data connection wizards in DBVisualizer
-
Connecting Pipedream with SAP BusinessObjects BI 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 SAP BusinessObjects BI data in real time.
-
Connect and Query Live OData Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live OData into Databricks
-
Connect to Microsoft Planner as an External Source in Dremio
Use the CData JDBC Driver to connect to Microsoft Planner as an External Source in Dremio.
-
Build Dashboards with Greenplum in Dundas BI
Create dynamic dashboards and perform analytics based on Pivotal GreenPlum in Dundas BI.
-
Connect to Microsoft Dataverse through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Microsoft Dataverse using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to connect to Google Search Results with Squirrel SQL client
Connect to Google Search and execute queries in the Squirrel SQL Client.
-
How to create Visio diagrams from SendGrid
Automatically update SendGrid with the changes you make to Visio master shapes.
-
Connect to MYOB AccountRight in NetBeans
Connect to MYOB AccountRight in NetBeans with the data source configuration wizard.
-
Access WordPress from MySQL in Amazon QuickSight
Connect to WordPress and build visualizations of WordPress using a MySQL Connection in Amazon QuickSight.
-
How to integrate Aha! with Apache Airflow
Access and process Aha! in Apache Airflow using the CData JDBC Driver.
-
Visualize OneNote in TIBCO Spotfire through OData
Integrate Microsoft OneNote into dashboards in TIBCO Spotfire.
-
Add Jira Service Management to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Jira Service Management with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Shippo in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build Google Spanner-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Spanner.
-
Build Impala Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Apache Impala and build visualizations in Tableau.