CData Software - Knowledge Base
Recent Articles
-
Use Microsoft Copilot Studio to talk to your Reckon via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Reckon for you.
-
Analyze Klipfolio in R via JDBC
Use standard R functions and the development environment of your choice to analyze Klipfolio with the CData JDBC Driver for Klipfolio.
-
How to pipe Sage Cloud Accounting to CSV in PowerShell
Use standard PowerShell cmdlets to access Sage Cloud Accounting tables.
-
Visualize Adobe Commerce in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Adobe Commerce into TIBCO Spotfire.
-
Bidirectional Access to Oracle Financials Cloud from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Oracle Financials Cloud in Filemaker Pro for Mac or Windows.
-
Analyze Cvent in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Cvent in Microsoft R Open.
-
Visualize Unbounce in TIBCO Spotfire through ADO.NET
Integrate Unbounce into dashboards in TIBCO Spotfire.
-
Analyze Snapchat Ads with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Snapchat Ads from Power Pivot. You will use the Table Import Wizard to load Snapchat Ads. You can visually build the import query or use any SQL supported by the driver.
-
How to update Microsoft Exchange from Excel
This article explains how to transfer data from Excel to Microsoft Exchange using the Excel Add-In for Microsoft Exchange.
-
How to integrate Metabase with Marketo
Use CData Connect AI to connect to live Marketo and create an interactive dashboard in Metabase from Marketo.
-
Extract, Transform, and Load SAP Concur in Informatica PowerCenter
Create a simple Workflow for SAP Concur in Informatica PowerCenter.
-
A PostgreSQL Interface for Redis using the CData ODBC Driver
Use the SQL Gateway and Redis ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Shippo Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Shippo replication to Amazon Redshift.
-
Use Biml to Build SSIS Tasks to Replicate Facebook Ads to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Facebook Ads to SQL Server.
-
Getting Started with the CData Excel Add-In for Xero
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Xero.
-
How to Connect to Live Zendesk 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 Zendesk for you.
-
Connect to Cassandra as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Apache Cassandra.
-
How to import eBay Analytics into Apache Solr
Use the CData Software JDBC Driver for eBay Analytics in Data Import Handler and create an automated import of eBay Analytics to Apache Solr Enterprise Search platform.
-
Use the CData Software ODBC Driver for Facebook in MicroStrategy
Connect to Facebook in MicroStrategy Developer using the CData Software ODBC Driver for Facebook.
-
Integrating Dataiku with Sage Intacct via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Sage Intacct.
-
How to connect to SAP Fieldglass in DBVisualizer
Integrate SAP Fieldglass with visual data analysis tools and data connection wizards in DBVisualizer
-
Model, Search, and Visualize Live Active Directory in ThoughtSpot
Use CData Connect AI to connect to live Active Directory for modeling, searching, and visualizing.
-
Publish SAP BusinessObjects BI-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP BusinessObjects BI.
-
Getting Started with the CData Excel Add-In for Snowflake
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Snowflake.
-
Visualize Live Adobe Target of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Adobe Target using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Using the CData Software ODBC Driver for Google Ads in PyCharm
Connect to Google Ads as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Ads.
-
Create Informatica Mappings From/To an ODBC Data Source for PostgreSQL
Create an ODBC connection to PostgreSQL in Informatica and browse and transfer PostgreSQL.
-
Connect to Google Drive in HULFT Integrate
Connect to Google Drive as a JDBC data source in HULFT Integrate
-
View Reports on Real-Time JSON Services in Power BI Report Server
Use the CData ODBC Driver for JSON to visualize JSON in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Pipedrive Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Pipedrive replication to OneLake in Microsoft Fabric.
-
Visualize Instagram in Sisense
Create an ElastiCube in Sisense app with access to Instagram.
-
Connect to Shippo in DBArtisan
Use wizards in DBArtisan to configure Shippo as a data source.
-
How to import Sage 200 into Apache Solr
Use the CData Software JDBC Driver for Sage 200 in Data Import Handler and create an automated import of Sage 200 to Apache Solr Enterprise Search platform.
-
Automated Continuous Cassandra Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apache Cassandra replication to OneLake in Microsoft Fabric.
-
Build Charts with MailChimp in Clear Analytics
Create dynamic charts and perform analytics based on MailChimp in Clear Analytics.
-
Connect to ConstantContact as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ConstantContact.
-
Import and Visualize Parquet in Power View
Create data visualizations based on Apache Parquet in Excel.
-
How to publish and share Amazon Marketplace dashboards with Tableau Server
The CData ODBC driver for Amazon Marketplace enables you integrate Amazon Marketplace into Tableau dashboards.
-
Create a Data Access Object for Azure Synapse using JDBI
A brief overview of creating a SQL Object API for Azure Synapse in JDBI.
-
Connect to Zoho Projects from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Zoho Projects from Filemaker Pro on Mac.
-
Integrate Live IBM Informix into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to IBM Informix and integrate live IBM Informix into apps built in Microsoft Power Apps.
-
Build ActiveCampaign-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live ActiveCampaign.
-
Connect to Elasticsearch through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Elasticsearch 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 SAP Ariba Procurement using the Model Context Protocol.
-
Replicate SendGrid in Heroku for Use in Salesforce Connect
Replicate SendGrid to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Live Amazon Marketplace into Blue Prism for Intelligent Robotic Process Automation (RPA)
-