CData Software - Knowledge Base
Recent Articles
-
Explore Geographical Relationships in Twitter Ads with Power Map
Create data visualizations with Twitter Ads in Power Map.
-
Automated Continuous EventBrite Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable EventBrite replication to Microsoft Access.
-
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.
-
How to connect PolyBase to Azure Synapse
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Azure Synapse.
-
A Performance Comparison of Drivers for Amazon DynamoDB
An article comparing the read performance of various vendors
-
Create SAP Business One-Connected Applications in Appsmith
Connect to SAP Business One via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Business One.
-
Import Real-Time Freshdesk via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Freshdesk in ColdFusion.
-
Model, Search, and Visualize Live Impala in ThoughtSpot
Use CData Connect AI to connect to live Apache Impala for modeling, searching, and visualizing.
-
Viewing LDAP Objects in RAD Studio Data Explorer
How to view LDAP in RAD Studio Data Explorer using the CData ODBC Driver for LDAP.
-
How to integrate Dynamics 365 with Apache Airflow
Access and process Microsoft Dynamics 365 in Apache Airflow using the CData JDBC Driver.
-
Use CData Connect AI to Access SAP Hybris C4C in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP Hybris C4C in the Power Pivot business intelligence tool.
-
Access Live Salesforce in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Salesforce & Force.com into the statistical analysis tools available in SAS JMP. This article shows how to use Salesforce & Force.com in the Graph Builder and Query Builder.
-
Provide OData Services of Act-On from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Act-On by developing a WCF Service Application.
-
How to Access Live Freshdesk in Power Automate Desktop via ODBC
The CData ODBC Driver for Freshdesk enables you to integrate Freshdesk into workflows built using Microsoft Power Automate Desktop.
-
Build Agents in Relevance AI with Access to Live Redshift via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Amazon Redshift within intelligent agent workflows.
-
How to connect to Google Contacts from IntelliJ
Integrate connectivity to Google Contacts with wizards in IntelliJ.
-
How to publish and share Google Data Catalog dashboards with Tableau Server
The CData ODBC driver for Google Data Catalog enables you integrate Google Data Catalog into Tableau dashboards.
-
Edit and Search SendGrid External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SendGrid to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SendGrid objects that you can access from apps and the dashboard.
-
Replicate Multiple Cosmos DB Accounts via the CData Sync CLI
Replicate multiple Cosmos DB accounts to one or many databases.
-
Build Automated Workflows with Live Azure Synapse in Workato
Use CData Connect AI to connect to live Azure Synapse and build automated workflows in Workato.
-
Analyze Oracle Sales in Cognos Analytics
Use CData Connect AI to connect to Oracle Sales from Cognos Analytics and analyze live Oracle Sales.
-
Visualize Live Pinterest in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Pinterest.
-
Automated Continuous Facebook Ads Replication to Oracle
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Oracle.
-
Build Apps with Live Trello in Adalo using CData Connect AI
Use CData Connect AI to integrate live Trello into the Adalo platform and build custom mobile and web applications with real-time Trello.
-
Use CData Connect AI to Access WooCommerce in Microsoft Power Pivot
Use CData Connect AI to connect to live WooCommerce in the Power Pivot business intelligence tool.
-
How to pipe Office 365 to CSV in PowerShell
Use standard PowerShell cmdlets to access Office 365 tables.
-
Integrate Real-Time Access to LinkedIn Ads in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to LinkedIn Ads in real time.
-
DataBind Controls to Reckon in Delphi
DataBind to Reckon in Delphi with standard data access components and controls.
-
Build a Singer.io Tap for Neo4J With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Neo4J data using
-
Build QuickBooks-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live QuickBooks Desktop.
-
Salesforce Marketing Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Salesforce Marketing facts in real time.
-
Bind Live RSS Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live RSS data
-
Import Real-Time FTP via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use FTP Servers in ColdFusion.
-
Integrate with live Excel Online in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft Excel Online in Jitterbit.
-
Enable the Vault CRM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Veeva Vault & Vault CRM.
-
How to connect PolyBase to eBay
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live eBay.
-
Object-Relational Mapping (ORM) with Spark Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Apache Spark SQL into a Java-based ORM framework, Hibernate.
-
Analyze Cosmos DB in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Azure Cosmos DB and visualize live Azure Cosmos DB in Infragistics Reveal.
-
Automate Zoom Replication to Azure Synapse
Use CData Sync to customize and automate Zoom replication to Azure Synapse.
-
Automated Continuous Twitter Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Amazon S3.
-
DataBind Charts to Oracle
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Database 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.
-
Extract, Transform, and Load Sage 200 in Informatica PowerCenter
Create a simple Workflow for Sage 200 in Informatica PowerCenter.
-
Use the CData SSIS Components to Insert New or Update Existing Blackbaud FE NXT Records from SQL Server
Easily push SQL Server data to Blackbaud FE NXT using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Blackbaud FE NXT or update existing records with data from a SQL Server database.
-
Jira Assets Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Jira Assets facts in real time.
-
Build a PostgreSQL Interface for Azure DevOps using the CData JDBC Driver
Use the Remoting features of the Azure DevOps JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Controls to XML in C++Builder
DataBind to XML Files in C++Builder with standard components and controls.
-
Visualize ActiveCampaign in TIBCO Spotfire through OData
Integrate ActiveCampaign into dashboards in TIBCO Spotfire.
-
Analyze Office 365 in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft Office 365 and visualize Microsoft Office 365 in SAP Analytics Cloud.
-
Add Hive to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Hive with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Azure Data Lake Storage from a Connection Pool in WebLogic
Use the CData JDBC Driver for Azure Data Lake Storage to connect to Azure Data Lake Storage from Web applications running on WebLogic.
-
How to use SQLAlchemy ORM to access OneNote in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft OneNote.
-
Integrating Gumloop with Dynamics CRM via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft Dynamics CRM within automated workflows.
-
How to Query Oracle in MySQL Workbench
Execute MySQL queries against live Oracle Database from MySQL Workbench.
-
Integrating LangChain with Azure Table via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Azure Table Storage within automated workflows.
-
How to work with Oracle Service Cloud in Apache Spark using SQL
Access and process Oracle Service Cloud in Apache Spark using the CData Software JDBC Driver.
-
How to Easily Query Reckon in OpenOffice Base
-