CData Software - Knowledge Base
Recent Articles
-
Connect to Azure Analysis Services in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Getting Started with the CData SSIS Components for Okta
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Okta.
-
Create Informatica Mappings From/To an ODBC Data Source for LinkedIn Ads
Create an ODBC connection to LinkedIn Ads in Informatica and browse and transfer LinkedIn Ads.
-
Query Greenplum from Node.js
Use the OData endpoint of the CData API Server to connect to your Pivotal GreenPlum and perform CRUD operations on Greenplum from Node.js.
-
Visualize Trello in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Trello into TIBCO Spotfire.
-
How to connect and process Snowflake from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Snowflake.
-
Integrate Google Directory with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Directory with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Directory.
-
Integrating Dataiku with Azure Table via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Azure Table Storage.
-
Automate SAP Ariba Procurement Replication to Azure Data Lake
Use CData Sync to customize and automate SAP Ariba Procurement replication to Azure Data Lake.
-
Build Gmail-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Gmail and create custom apps in Mendix.
-
How to create Visio diagrams from Act CRM
Automatically update Act CRM with the changes you make to Visio master shapes.
-
Use the CData Software ODBC Driver for Parquet in MicroStrategy
Connect to Apache Parquet in MicroStrategy Developer using the CData Software ODBC Driver for Parquet.
-
Analyze Blackbaud FE NXT in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Blackbaud FE NXT in Microsoft R Open.
-
Use Dash to Build to Web Apps on Freshdesk
Create Python applications that use pandas and Dash to build Freshdesk-connected web apps.
-
How to Connect to Live Google Sheets from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Google Sheets through natural language.
-
Migrating data from Oracle Sales to Databricks using CData SSIS Components.
Easily push Oracle Sales to Databricks using the CData SSIS Tasks for Oracle Sales and Databricks.
-
Query Stripe from Node.js
Use the OData endpoint of the CData API Server to connect to your Stripe and perform CRUD operations on Stripe from Node.js.
-
Google Spanner Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Spanner facts in real time.
-
Automated Continuous Kintone Replication to MySQL
Use CData Sync for automated, continuous, customizable Kintone replication to MySQL.
-
How to create an RPA flow for XML in UiPath Studio
Use the XML ODBC Driver to create workflows that access real-time XML Files without any coding.
-
Connect to HubSpot from a Connection Pool in JBoss
Integrate HubSpot into Java servlets: Use the Management Console in JBoss to install the HubSpot JDBC Driver.
-
Stream Xero into Apache Kafka Topics
Access and stream Xero Accounting in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate with Sybase IQ using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sybase IQ to a JSON file on disk.
-
Automated Continuous Dynamics 365 Replication to Databricks
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Databricks.
-
Integrate Google Sheets in the Pentaho Report Designer
Publish reports based on Google Sheets in the Pentaho BI tool.
-
Create Dashboards and Visualize Live Google Contacts in Geckoboard
Use CData Connect AI to connect to live Google Contacts and create dashboards for real-time monitoring and visualization in Geckoboard.
-
A PostgreSQL Interface for Outreach.io (MySQL Remoting via JDBC)
Use the Remoting features of the Outreach.io JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Informatica Mappings From/To a JDBC Data Source for CouchDB
Create CouchDB data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Validate Asana with QuerySurge
Access and validate Asana in QuerySurge using the CData JDBC Driver.
-
Load XML to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load XML Files to a database.
-
DataBind FTP to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for FTP with the DevExpress Windows Forms and Web controls to provide FTP Servers to a chart.
-
Connect to Azure Synapse in SpagoBI
Create reports featuring live Azure Synapse in SpagoBI Studio. Host Azure Synapse reports on SpagoBI Server.
-
Build Cloudant-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live IBM Cloudant and build Cloudant-connected web apps with Axios.
-
Add Zoom to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Zoom with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build MVC Applications with Connectivity to Avalara AvaTax
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Avalara AvaTax from an ASP.NET MVC application.
-
DataBind Charts to MailChimp
Use the standard ADO.NET procedures for databinding to provide bidirectional access to MailChimp 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.
-
How to Create Power BI Visual Reports with Real-Time NetSuite
Use CData Power BI Connectors to visualize NetSuite CRM & ERP in Power BI.
-
Integrate with Reckon Accounts Hosted in JReport Designer
Create charts and reports based on Reckon Accounts Hosted in JReport Designer.
-
Write a Simple Go Application to work with Vault CRM on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Veeva Vault & Vault CRM.
-
Bridge Parquet Connectivity with Apache NiFi
Access and process Apache Parquet in Apache NiFi using the CData JDBC Driver.
-
Build a Singer.io Tap for eBay With the CData Python Connector
Learn how to easily build a Singer.io Tap for live eBay data using
-
Publish Zoho Creator-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Zoho Creator.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed MailChimp to Power BI dashboards. Simply drag and drop MailChimp into data visuals on the Power BI canvas.
-
Build Charts with Hive in Clear Analytics
Create dynamic charts and perform analytics based on Apache Hive in Clear Analytics.
-
Dropbox Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Dropbox facts in real time.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Odoo ERP within intelligent workflows.
-
Explore Geographical Relationships in IBM Cloud Object Storage with Power Map
Create data visualizations with IBM Cloud Object Storage in Power Map.
-
Connect to Live Google Contacts in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Contacts in CData Connect AI and connect to your Google Contacts from PostgreSQL.
-
Build Bitbucket-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Bitbucket and build web apps with connectivity to live Bitbucket.
-
Build Semantic Layer Views for LDAP Objects in APOS Live Data Gateway
Use the CData Connector for LDAP in APOS Live Data Gateway to build Semantic Layer Views for LDAP.
-
Use JayDeBeApi to access Splunk in Python
Use standard Python scripting and the development environment of your choice to access live Splunk.
-
Integrate with FTP in JReport Designer
Create charts and reports based on FTP Servers in JReport Designer.
-
Migrating data from RSS to Snowflake using CData SSIS Components.
Easily push RSS Feeds to Snowflake using the CData SSIS Tasks for RSS and Snowflake.
-
Access Live Sugar CRM Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Sugar CRM data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Cassandra in ACL Analytics
Connect to Apache Cassandra via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Apache Cassandra.
-
Integrating Dataiku with BigCommerce via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live BigCommerce.
-
Visualize Live Neo4J of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Neo4J using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Dynamics 365 Replication to Vertica
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Vertica.
-
Build Semantic Layer Views for Avalara AvaTax in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Avalara AvaTax.
-
Prepare, Blend, and Analyze Google Spanner in Alteryx Designer (ODBC)
Build workflows to access live Google Spanner for self-service data analytics.
-
DataBind Controls to Jira Assets in Delphi
DataBind to Jira Assets in Delphi with standard data access components and controls.
-
Automated Continuous Oracle Eloqua Replication to Vertica
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Vertica.
-
Automate Unbounce Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Unbounce and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Analyze Microsoft Project in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft Project and visualize live Microsoft Project in Infragistics Reveal.
-
Build Adobe Experience Manager-Powered Applications in Cursor with CData Code Assist MCP
-