CData Software - Knowledge Base
Recent Articles
-
Integrate FHIR with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate FHIR with External Services.
-
Validate WordPress with QuerySurge
Access and validate WordPress in QuerySurge using the CData JDBC Driver.
-
Connect to YouTube Analytics in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for YouTube Analytics and connect to YouTube Analytics in Akorbi Digital RunMyProcess.
-
Analyze Google Spanner in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google Spanner and visualize live Google Spanner in Infragistics Reveal.
-
Rapidly Develop SharePoint-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Analyze Okta in R via JDBC
Use standard R functions and the development environment of your choice to analyze Okta with the CData JDBC Driver for Okta.
-
How to connect SharePoint with MySQL through external lists
Provide MySQL to SharePoint users as an external list.
-
Connect and Visualize Live Salesforce Marketing Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Salesforce Marketing Cloud into the Databricks platform and create visualization dashboards with real-time Salesforce Marketing Cloud.
-
Use Biml to Build SSIS Tasks to Replicate SAP SuccessFactors to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP SuccessFactors to SQL Server.
-
Using the CData Software ODBC Driver for Twitter in PyCharm
Connect to Twitter as an ODBC data source in PyCharm using the CData Software ODBC Driver for Twitter.
-
Automated Continuous TaxJar Replication to Oracle
Use CData Sync for automated, continuous, customizable TaxJar replication to Oracle.
-
Replicate Data from Multiple Local Files Using CData Sync
Use CData Sync to replicate multiple local files to a data warehouse
-
Automate Facebook Ads Replication to SAP HANA
Use CData Sync to customize and automate Facebook Ads replication to SAP HANA.
-
Automated SAP BusinessObjects BI Replication to Teradata
Use CData Sync to Customize and automate SAP BusinessObjects BI replication to Teradata.
-
LINQ to Adobe Commerce
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Adobe Commerce Data Provider.
-
Use the CData API Server to Access CouchDB in Microsoft PowerPivot
Use the CData API Server to connect to live Apache CouchDB in the Power Pivot business intelligence tool.
-
Build Semantic Layer Views for NetSuite in APOS Live Data Gateway
Use the CData Connector for NetSuite in APOS Live Data Gateway to build Semantic Layer Views for NetSuite CRM & ERP.
-
Replicate Multiple RSS Accounts via the CData Sync CLI
Replicate multiple RSS accounts to one or many databases.
-
Feed Impala into FineReport
How to set Apache Impala as a JDBC data source in FineReport.
-
Natively Connect to SAP BusinessObjects BI in PHP
The CData ODBC driver for SAP BusinessObjects BI enables you to create PHP applications with connectivity to SAP BusinessObjects BI. Leverage the native support for ODBC in PHP.
-
Use Azure AI Foundry to Talk to Your Oracle via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Oracle Database for you.
-
Choosing the Best Method to Connect SAP Netweaver Gateway to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP Netweaver Gateway from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create a Data Access Object for Paylocity using JDBI
A brief overview of creating a SQL Object API for Paylocity in JDBI.
-
Integrate with ShipStation in SnapLogic
Use CData Connect AI to connect to and integrate with live ShipStation in SnapLogic.
-
Prepare, Blend, and Analyze Excel Online in Alteryx Designer (Connect AI)
Build workflows to access live Microsoft Excel Online for self-service data analytics.
-
Automated Continuous IBM Informix Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable IBM Informix replication to Azure SQL Database.
-
Automated Continuous Salesforce Pardot Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Apache Cassandra.
-
How to Visualize EnterpriseDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live EnterpriseDB in Python.
-
Connect to Facebook in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Facebook and connect to Facebook in Akorbi Digital RunMyProcess.
-
Add Salesforce Pardot to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Salesforce Pardot with the Informatica Enterprise Data Catalog to classify and organize data.
-
A PostgreSQL Interface for SQL Analysis Services using the CData ODBC Driver
Use the SQL Gateway and SQL Analysis Services ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to & Open SharePoint in Microsoft Excel
This article uses the CData ODBC driver for SharePoint to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connecting Mastra with Jira via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across 300+ enterprise sources no replication required.
-
Using the CData Software ODBC Driver for Amazon Athena in PyCharm
Connect to Amazon Athena as an ODBC data source in PyCharm using the CData Software ODBC Driver for Amazon Athena.
-
Automate Airtable Replication to Couchbase
Use CData Sync to Customize and automate Airtable replication to Couchbase.
-
LINQ to SAS Data Sets
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the SAS Data Sets Data Provider.
-
How to Visualize Shopify Data in Python with pandas
Use pandas and other modules to analyze and visualize live Shopify in Python.
-
How to Connect DBeaver to Reckon via a JDBC Driver
Manage Reckon with visual tools in DBeaver like the query browser.
-
Bridge MailChimp Connectivity with Apache NiFi
Access and process MailChimp in Apache NiFi using the CData JDBC Driver.
-
Bind Live SAP BusinessObjects BI Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP BusinessObjects BI data
-
Automate QuickBooks Replication to Azure Synapse
Use CData Sync to customize and automate QuickBooks Desktop replication to Azure Synapse.
-
Visualize Live Dynamics CRM in the Power BI Service
Use CData Connect AI to connect to live Microsoft Dynamics CRM and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create HubDB Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Consume Zoom OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Zoom feeds that reflect any changes in SAP Lumira.
-
Object-Relational Mapping (ORM) with OneNote 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 Microsoft OneNote into a Java-based ORM framework, Hibernate.
-
Integrate TigerGraph in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live TigerGraph from Informatica Cloud.
-
Query EventBrite through ODBC in Node.js
Use node-odbc to execute SQL queries against Eventbrite from Node.js.
-
Creating CockroachDB-Connected Applications in Unqork
You can use CData Connect AI to feed CockroachDB to Unqork and build custom business apps.
-
Building Dynamic Web Pages with Zoho CRM Using AngularJS
Create single-page applications with live connectivity to Zoho CRM using the CData API Server.
-
Build Data Flows from Epicor Kinetic to SQL Server using SSIS
Easily back up Epicor Kinetic to SQL Server using the SSIS components for Epicor Kinetic.
-
Stream Trello into Apache Kafka Topics
Access and stream Trello in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Avalara AvaTax Replication to SQLite
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to SQLite.
-
Validate Salesforce Data Cloud with QuerySurge
Access and validate Salesforce Data Cloud in QuerySurge using the CData JDBC Driver.
-
Automate CouchDB Replication to Azure Data Lake
Use CData Sync to customize and automate Apache CouchDB replication to Azure Data Lake.
-
Create Data Visualizations in Cognos BI with Google Directory
Access Google Directory as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Semantic Layer Views for Google Calendar in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Calendar.
-
Bidirectional Access to Dynamics 365 from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Dynamics 365 in Filemaker Pro for Mac or Windows.
-
How to pipe ConstantContact to CSV in PowerShell
Use standard PowerShell cmdlets to access ConstantContact tables.
-
Visualize FTP from Tableau
Use the Tableau Desktop business intelligence tool to connect to FTP Servers.
-
DataBind Controls to SAP in C++Builder
DataBind to SAP ERP/NetWeaver in C++Builder with standard components and controls.
-
How to update Zendesk from Excel
This article explains how to transfer data from Excel to Zendesk using the Excel Add-In for Zendesk.
-
Bidirectional Access to LDAP Objects from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate LDAP in Filemaker Pro for Mac or Windows.
-
Connect to Oracle Service Cloud in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Oracle Service Cloud in Airbyte.
-
Build Dashboards with Jira in DBxtra
Create dynamic dashboards and perform analytics based on Atlassian Jira in DBxtra.
-
Integrate TaxJar in the Pentaho Report Designer
Publish reports based on TaxJar in the Pentaho BI tool.
-
Build a Simple VCL Application for JSON Services
How to build a simple VCL Application to view JSON in RAD Studio using the CData ODBC Driver for JSON.
-
Add Square to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Square with the Informatica Enterprise Data Catalog to classify and organize data.
-
Load BigQuery to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google BigQuery to a database.
-
Add Oracle Sales to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle Sales with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Google Directory-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Directory and create custom apps in Mendix.
-
How to Connect to & Open SAP BusinessObjects BI in Microsoft Excel
This article uses the CData ODBC driver for SAP BusinessObjects BI to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Getting Started with the CData SSIS Components for Azure Active Directory
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Azure Active Directory.
-
Act CRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Act CRM facts in real time.
-
Create Reports from Oracle Service Cloud in Looker Studio
Use CData Connect AI to gain access to live Oracle Service Cloud and create custom reports in Looker Studio.
-
Getting Started with the CData PowerShell Cmdlets for MySQL
-