CData Software - Knowledge Base
Recent Articles
-
Consume Phoenix OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Phoenix feeds that reflect any changes in SAP Lumira.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Vault CRM
Provide connectivity to Veeva Vault & Vault CRM through an SAP BusinessObjects universe.
-
Replicate Instagram from PowerShell
Write a quick PowerShell script to query Instagram. Use connectivity to the live data to replicate Instagram to SQL Server.
-
How to pipe Sage 200 to CSV in PowerShell
Use standard PowerShell cmdlets to access Sage 200 tables.
-
How to pipe Dynamics CRM to CSV in PowerShell
Use standard PowerShell cmdlets to access Dynamics CRM tables.
-
Model Monday.com Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Monday.com, enabling the direct import of real-time Monday.com.
-
Build Data Flows from SQL Server to Microsoft Exchange through SSIS
Easily push SQL Server data to Microsoft Exchange using the CData SSIS Tasks for Microsoft Exchange.
-
Explore Geographical Relationships in Redis with Power Map
Create data visualizations with Redis in Power Map.
-
Enable the HarperDB JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with HarperDB.
-
Analyze Authorize.Net in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Authorize.Net and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
DataBind Controls to Square in Delphi
DataBind to Square in Delphi with standard data access components and controls.
-
Import Real-Time Parquet via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Apache Parquet in ColdFusion.
-
Connect to and Visualize Live SFTP in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SFTP.
-
Getting Started with the CData JDBC Driver for Drift
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Drift.
-
Access Live Oracle SCM in AWS Lambda (with IntelliJ IDEA)
Connect to live Oracle SCM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connecting Agentforce with Blackbaud FE NXT 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 Blackbaud FE NXT for you.
-
Prepare, Blend, and Analyze OData Services in Alteryx Designer (ODBC)
Build workflows to access live OData for self-service data analytics.
-
Automated CockroachDB Replication to Teradata
Use CData Sync to Customize and automate CockroachDB replication to Teradata.
-
Replicate Reckon Accounts Hosted in Heroku for Use in Salesforce Connect
Replicate Reckon Accounts Hosted to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Clio in DBArtisan
Use wizards in DBArtisan to configure Clio as a data source.
-
Import and Visualize Cosmos DB in Power View
Create data visualizations based on Azure Cosmos DB in Excel.
-
How to connect to Azure Data Lake Storage from Spring Boot
Connect to Azure Data Lake Storage in a Spring Boot Application using CData JDBC Azure Data Lake Storage Driver
-
Publish Reports with LinkedIn in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date LinkedIn.
-
Publish Printify-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Printify.
-
How to update Microsoft Planner from Excel
This article explains how to transfer data from Excel to Microsoft Planner using the Excel Add-In for Microsoft Planner.
-
Import and Visualize Coinbase in Power View
Create data visualizations based on Coinbase in Excel.
-
Access WooCommerce from MySQL in Amazon QuickSight
Connect to WooCommerce and build visualizations of WooCommerce using a MySQL Connection in Amazon QuickSight.
-
DataBind Charts to Klaviyo
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Klaviyo 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.
-
View Reports on Real-Time Sage 200 in Power BI Report Server
Use the CData ODBC Driver for Sage 200 to visualize Sage 200 in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Data Flows from JotForm to SQL Server using SSIS
Easily back up JotForm to SQL Server using the SSIS components for JotForm.
-
Visualize Monday.com in TIBCO Spotfire through OData
Integrate Monday.com into dashboards in TIBCO Spotfire.
-
Use JayDeBeApi to access SingleStore in Python
Use standard Python scripting and the development environment of your choice to access live SingleStore.
-
Manage Monday.com in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Monday.com.
-
Analyze Google Spanner with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Spanner from Power Pivot. You will use the Table Import Wizard to load Google Spanner. You can visually build the import query or use any SQL supported by the driver.
-
Create Dashboards and Visualize Live Cloudant in Geckoboard
Use CData Connect AI to connect to live IBM Cloudant and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Connect to Live Databricks in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Databricks without replication.
-
Process & Analyze Monday.com in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Monday.com .
-
Process & Analyze Salesforce Data Cloud in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Salesforce Data Cloud .
-
Integrating Boomi Agentstudio with Airtable via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Airtable, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build a PostgreSQL Interface for Sage 200 using the CData JDBC Driver
Use the Remoting features of the Sage 200 JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to create Visio diagrams from Pipedrive
Automatically update Pipedrive with the changes you make to Visio master shapes.
-
How to Access Live Calendly in Power Automate Desktop via ODBC
The CData ODBC Driver for Calendly enables you to integrate Calendly into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Vertica
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Vertica.
-
Prepare, Blend, and Analyze Shopify in Alteryx Designer (Connect AI)
Build workflows to access live Shopify for self-service data analytics.
-
How to Connect to Live QuickBooks Time Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live QuickBooks Time securely in real time.
-
Import Cloudant into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access IBM Cloudant. In this article, you will use the OData format to import IBM Cloudant into Microsoft Power Query.
-
Connect to JDBC-ODBC Bridge in HULFT Integrate
Connect to JDBC-ODBC Bridge as a JDBC data source in HULFT Integrate
-
Create JSON Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Oracle Service Cloud in TIBCO Spotfire through OData
Integrate Oracle Service Cloud into dashboards in TIBCO Spotfire.
-
Access Greenhouse 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 Greenhouse.
-
Connect to Sugar CRM as an External Source in Dremio
Use the CData JDBC Driver to connect to Sugar CRM as an External Source in Dremio.
-
Automated Continuous REST Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable REST replication to Amazon Redshift.
-
Create a Data Access Object for RSS Feeds using JDBI
A brief overview of creating a SQL Object API for RSS Feeds in JDBI.
-
Design BIRT Reports on Xero
Provide current Xero Accounting to your embedded analytics.
-
Getting Started with the CData ADO.NET Provider for Acumatica
-