CData Software - Knowledge Base
Recent Articles
-
Integrate SuiteCRM in Pentaho Data Integration
Build ETL pipelines based on SuiteCRM in the Pentaho Data Integration tool.
-
How to pipe Dynamics CRM to CSV in PowerShell
Use standard PowerShell cmdlets to access Dynamics CRM tables.
-
How to Access Live Twilio in Power Automate Desktop via ODBC
The CData ODBC Driver for Twilio enables you to integrate Twilio into workflows built using Microsoft Power Automate Desktop.
-
Model, Search, and Visualize Live Cosmos DB in ThoughtSpot
Use CData Connect AI to connect to live Azure Cosmos DB for modeling, searching, and visualizing.
-
Automate Klipfolio Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Klipfolio and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build Dashboards with Teradata in Dundas BI
Create dynamic dashboards and perform analytics based on Teradata in Dundas BI.
-
Automate DocuSign Replication to Couchbase
Use CData Sync to Customize and automate DocuSign replication to Couchbase.
-
Validate Marketo with QuerySurge
Access and validate Marketo in QuerySurge using the CData JDBC Driver.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
Publish SAP Ariba Procurement-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP Ariba Procurement.
-
How to integrate Metabase with Azure Data Lake Storage
Use CData Connect AI to connect to live Azure Data Lake Storage and create an interactive dashboard in Metabase from Azure Data Lake Storage.
-
A PostgreSQL Interface for Redshift (MySQL Remoting via JDBC)
Use the Remoting features of the Redshift JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData ODBC Driver for Amazon DynamoDB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Amazon DynamoDB to connect to Amazon DynamoDB from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Amazon DynamoDB in Excel.
-
Automated Continuous Xero Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Xero replication to Google BigQuery.
-
Build Dashboards with MailChimp in DBxtra
Create dynamic dashboards and perform analytics based on MailChimp in DBxtra.
-
Create Email Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous SAS xpt Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAS xpt replication to Snowflake.
-
Working with OneNote in LINQPad
Execute LINQ queries to Microsoft OneNote in LINQPad.
-
Create Informatica Mappings From/To a JDBC Data Source for PostgreSQL
Create PostgreSQL data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Analyze MongoDB in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of MongoDB and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Acumatica-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Acumatica from Klipfolio and build custom visualizations using live Acumatica ERP.
-
Automated Continuous Sage 200 Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sage 200 replication to Apache Cassandra.
-
Automated Continuous Oracle HCM Cloud Replication to Snowflake
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Snowflake.
-
Connect to Microsoft Dataverse in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft Dataverse (CDS) in the Denodo Virtual DataPort Administrator.
-
Replicate DocuSign from PowerShell
Write a quick PowerShell script to query DocuSign. Use connectivity to the live data to replicate DocuSign to SQL Server.
-
Connect to Microsoft Project from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Project from PowerBuilder using the Microsoft Project JDBC Driver.
-
Automated Continuous AlloyDB Replication to MongoDB
Use CData Sync for automated, continuous, customizable AlloyDB replication to MongoDB.
-
How to Connect to Live Google Calendar from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Google Calendar for you.
-
How to connect Amazon QuickSight to Dynamics CRM
Create a connection to Microsoft Dynamics CRM in CData Connect AI and insert Microsoft Dynamics CRM into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Dashboards with Databricks in DBxtra
Create dynamic dashboards and perform analytics based on Databricks in DBxtra.
-
Connect to Azure Active Directory in ACL Analytics
Connect to Azure Active Directory via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Azure Active Directory.
-
How to Connect to Live Oracle Eloqua from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Oracle Eloqua for you.
-
View Reports on Real-Time Wave Financial in Power BI Report Server
Use the CData ODBC Driver for Wave Financial to visualize Wave Financial in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize Live Kintone in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Kintone.
-
Connect to Confluence in Google Apps Script via SQL Gateway
Use the ODBC Driver for Confluence and the SQL Gateway to access Atlassian Confluence from Google Apps Script.
-
Build Charts with Google Sheets in Clear Analytics
Create dynamic charts and perform analytics based on Google Sheets in Clear Analytics.
-
Build a Simple VCL Application for Google Directory
How to build a simple VCL Application to view Google Directory in RAD Studio using the CData ODBC Driver for Google Directory.
-
Integrate Cursor with Live Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Apache Impala from within the editor.
-
Connect to Act-On from PowerBuilder via JDBC
This article demonstrates how to access Act-On from PowerBuilder using the Act-On JDBC Driver.
-
Feed Exact Online into FineReport
How to set Exact Online as a JDBC data source in FineReport.
-
Import and Visualize Salesloft in Power View
Create data visualizations based on Salesloft in Excel.
-
Working with LDAP Objects in LINQPad
Execute LINQ queries to LDAP in LINQPad.
-
DataBind Couchbase to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Couchbase with the DevExpress Windows Forms and Web controls to provide Couchbase to a chart.
-
Import Salesforce Pardot into the Power BI Service for Visualizations
Use CData Connect AI to connect to Salesforce Pardot and provide access to live Salesforce Pardot for custom reports in the Power BI Service.
-
Query ShipStation in DataGrip
Create a Data Source for ShipStation in DataGrip and use SQL to query live ShipStation.
-
Connect to Twitter Ads in HULFT Integrate
Connect to Twitter Ads as a JDBC data source in HULFT Integrate
-
Build an OLAP Cube in SSAS from Acumatica
Establish a connection to Acumatica ERP data from SQL Server Analysis Services, and use the Acumatica Data Provider to build OLAP cubes for use in analytics and reporting.
-
OLAP Reporting Directly from QuickBooks using ComponentOne OLAP for WinForms
Rich Dudley from ComponentOne explores using the CData QuickBooks Data Provider and ComponentOne OLAP to build a powerful QuickBooks reporting application, all without writing a single line of code.
-
Visualize Dynamics 365 in Sisense
Create an ElastiCube in Sisense app with access to Microsoft Dynamics 365.
-
Integrate Real-Time Access to HubSpot in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to HubSpot in real time.
-
How to Query Live Azure Data Catalog in Perplexity MacOS Desktop
Connect to and query live Azure Data Catalog in Perplexity Desktop using CData Code Assist MCP.
-
Manage Greenplum in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Greenplum.
-
Connect to Klipfolio in DBeaver
Use the CData ODBC Driver to connect to Klipfolio in DBeaver.
-
Migrating data from Invoiced to Google BigQuery using CData SSIS Components.
Easily push Invoiced to Google BigQuery using the CData SSIS Tasks for Invoiced and Google BigQuery.
-
Use the CData ODBC Driver for PostgreSQL in Microsoft Power Query
You can use the CData PostgreSQL ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import PostgreSQL into Microsoft Power Query.
-
Getting Started with the CData Tableau Connector for Microsoft Planner
-