CData Software - Knowledge Base
Recent Articles
-
DataBind Charts to Salesforce
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Salesforce & Force.com 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.
-
Create Informatica Mappings From/To a JDBC Data Source for Power BI XMLA
Create Power BI XMLA data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Active Directory in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Active Directory in Airbyte.
-
Connect to Office 365 in RapidMiner
Integrate Microsoft Office 365 with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData ODBC Driver for Cassandra in Microsoft Power Query
You can use the CData Cassandra ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apache Cassandra into Microsoft Power Query.
-
Connect to Microsoft Teams in Jaspersoft Studio
Execute SQL to remote Microsoft Teams in Jaspersoft Studio.
-
Analyze Airtable in Cognos Analytics
Use CData Connect AI to connect to Airtable from Cognos Analytics and analyze live Airtable.
-
Use the CData ODBC Driver for Dynamics 365 Business Central from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Dynamics 365 Business Central to connect to Dynamics 365 Business Central from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Dynamics 365 Business Central in Excel.
-
How to Query Klipfolio in MySQL Workbench
Execute MySQL queries against live Klipfolio from MySQL Workbench.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for BigCommerce
Provide connectivity to BigCommerce through an SAP BusinessObjects universe.
-
Create Dynamic Reckon Grids Using the Infragistics XamDataGrid
Learn how you can connect Reckon to Infragistics XamDataGrid to build dynamic grids.
-
Automate PayPal Replication to Azure Synapse
Use CData Sync to customize and automate PayPal replication to Azure Synapse.
-
Query JotForm in ColdFusion
Write standard ColdFusion data access code to connect to JotForm.
-
How to Connect to Live SendGrid 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 SendGrid for you.
-
Process & Analyze Salesforce in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Salesforce .
-
Bridge Sugar CRM Connectivity with Apache NiFi
Access and process Sugar CRM in Apache NiFi using the CData JDBC Driver.
-
How to create an RPA flow for SAP in UiPath Studio
Use the SAP ODBC Driver to create workflows that access real-time SAP ERP/NetWeaver without any coding.
-
Build Agents in Relevance AI with Access to Live IBM Informix via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on IBM Informix within intelligent agent workflows.
-
How to pipe Azure Active Directory to CSV in PowerShell
Use standard PowerShell cmdlets to access Azure Active Directory tables.
-
Explore Geographical Relationships in Klipfolio with Power Map
Create data visualizations with Klipfolio in Power Map.
-
A PostgreSQL Interface for Gmail (MySQL Remoting via JDBC)
Use the Remoting features of the Gmail JDBC Driver to create a PostgreSQL entry-point for data access.
-
Operational Reporting on Snapchat Ads from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Snapchat Ads.
-
Connect to Microsoft Dataverse in JRuby
Create a simple JRuby app with access to live Microsoft Dataverse (CDS).
-
Create Reports with SAP Ariba Procurement in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Ariba Procurement.
-
Create Data Visualizations Based On HubSpot in Mode
Use CData Connect AI to connect to HubSpot from Mode and build visualizations using live
-
Connect to Bullhorn CRM in Google Apps Script via Connect AI
Use CData Connect AI to access Bullhorn CRM in Google Apps Script.
-
Connect to Highrise from PowerBuilder via ADO.NET
This article demonstrates how to access Highrise CRM from Appeon PowerBuilder using the CData ADO.NET Provider for Highrise.
-
Migrating data from PingOne to Databricks using CData SSIS Components.
Easily push PingOne to Databricks using the CData SSIS Tasks for PingOne and Databricks.
-
Connecting Agentforce with Adobe Commerce 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 Adobe Commerce for you.
-
Working with BambooHR in LINQPad
Execute LINQ queries to BambooHR in LINQPad.
-
Use the CData API Server to Access SendGrid in Microsoft PowerPivot
Use the CData API Server to connect to live SendGrid in the Power Pivot business intelligence tool.
-
Visualize Live SAP Fieldglass of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP Fieldglass using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Oracle Service Cloud in ColdFusion
Write standard ColdFusion data access code to connect to Oracle Service Cloud.
-
Connect to Excel Online as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Excel Online.
-
Publish Redshift-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Amazon Redshift.
-
Getting Started with the CData Python Connector for Act CRM
Learn to install and license the CData Python Connector
-
Connect to SharePoint in Google Apps Script via Connect AI
Use CData Connect AI to access Microsoft SharePoint in Google Apps Script.
-
How to Use a Microsoft Access Database to Update SAP Hybris C4C in Real Time
Update SAP Hybris C4C data by creating a linked table in Microsoft Access with the CData SAP Hybris C4C ODBC Driver.
-
Integrating Boomi Agentstudio with MongoDB via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to MongoDB, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Visualize Live Twitter of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Twitter using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build BigQuery-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for BigQuery and create custom apps in Mendix.
-
How to connect to EnterpriseDB in DBVisualizer
Integrate EnterpriseDB with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Exact Online from MySQL in Amazon QuickSight
Connect to Exact Online and build visualizations of Exact Online using a MySQL Connection in Amazon QuickSight.
-
How to connect to ADP with Squirrel SQL client
Connect to ADP and execute queries in the Squirrel SQL Client.
-
How to import EventBrite into Apache Solr
Use the CData Software JDBC Driver for EventBrite in Data Import Handler and create an automated import of Eventbrite to Apache Solr Enterprise Search platform.
-
Integrate Gmail into Power Automate Desktop using CData Connect
CData Connect for Gmail enables you to integrate Gmail into workflows built using Microsoft Power Automate Desktop.
-
Enable the SAP BusinessObjects BI JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP BusinessObjects BI.
-
DataBind Controls to ADP in C++Builder
DataBind to ADP in C++Builder with standard components and controls.
-
Connect to Twitter in NetBeans
Connect to Twitter in NetBeans with the data source configuration wizard.
-
Edit and Search External Confluence Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Atlassian Confluence to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Confluence objects that you can access from apps and the dashboard.
-
Use CData Connect AI to Access Google Analytics in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Analytics in the Power Pivot business intelligence tool.
-
Analyze Zuora in Looker
Use CData Connect AI to connect to Zuora from Looker and build custom apps using live Zuora.
-
How to Query Live Oracle SCM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Oracle SCM data in natural language using Python.
-
Connect to Spark in Claris FileMaker Pro
-