CData Software - Knowledge Base
Recent Articles
-
Access SingleStore as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SingleStore from your Oracle system.
-
Publish Reports with Excel in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Excel.
-
Use the CData API Server to Access Monday.com in Microsoft PowerPivot
Use the CData API Server to connect to live Monday.com in the Power Pivot business intelligence tool.
-
Replicate QuickBooks Online to Multiple Databases
Replicate QuickBooks Online to disparate databases with a point-and-click configuration.
-
Automated Continuous Dynamics CRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Snowflake.
-
Connect to Acumatica through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Acumatica using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automated Continuous SurveyMonkey Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to OneLake in Microsoft Fabric.
-
Access IBM Cloud Object Storage 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 IBM Cloud Object Storage.
-
Use the CData Software JDBC Driver for Amazon S3 in MicroStrategy
Connect to Amazon S3 in MicroStrategy Developer using the CData Software JDBC Driver for Amazon S3.
-
Connect to Drift in Google Apps Script via SQL Gateway
Use the ODBC Driver for Drift and the SQL Gateway to access Drift from Google Apps Script.
-
Connect to Microsoft OneDrive in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft OneDrive in the Denodo Virtual DataPort Administrator.
-
Connect to FHIR in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for FHIR in Airbyte.
-
Connect to Oracle Service Cloud in Aqua Data Studio
Access Oracle Service Cloud from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to MySQL from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live MySQL from Filemaker Pro on Mac.
-
Build a Singer.io Tap for Oracle Eloqua Reporting With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Oracle Eloqua Reporting data using
-
Migrating data from Greenhouse to Databricks using CData SSIS Components.
Easily push Greenhouse to Databricks using the CData SSIS Tasks for Greenhouse and Databricks.
-
Connect to Zoho Books in DBArtisan
Use wizards in DBArtisan to configure Zoho Books as a data source.
-
Connect to EventBrite in CloverDX (formerly CloverETL)
Transfer Eventbrite using the visual workflow in the CloverDX data integration tool.
-
How to integrate Bitbucket with Apache Airflow
Access and process Bitbucket in Apache Airflow using the CData JDBC Driver.
-
Analyze Sage 300 in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Sage 300 and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Build MVC Applications with Connectivity to SAP Netweaver Gateway
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP Netweaver Gateway from an ASP.NET MVC application.
-
Design BIRT Reports on SAP SuccessFactors
Provide current SAP SuccessFactors to your embedded analytics.
-
Use the CData SSIS Components to Insert New or Update Existing Xero Records from SQL Server
Easily push SQL Server data to Xero using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Xero or update existing records with data from a SQL Server database.
-
Connect Freshdesk to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Freshdesk using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Excel Spreadsheet Automation on Zendesk with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Create Tally Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
DataBind Controls to Authorize.Net in Delphi
DataBind to Authorize.Net in Delphi with standard data access components and controls.
-
Connect to LinkedIn Ads in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build QuickBooks Online-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for QuickBooks Online and create custom apps in Bubble.
-
Bind Live Azure Data Catalog Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Azure Data Catalog data
-
Build Pipelines with Live Odoo in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Odoo from Google Cloud Data Fusion, enabling the integration of live Odoo ERP into the building and management of effective data pipelines.
-
Create Twitter Ads-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Twitter Ads from Klipfolio and build custom visualizations using live Twitter Ads.
-
Create SAS Data Sets Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Bidirectional Access to Azure Active Directory from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Azure Active Directory in Filemaker Pro for Mac or Windows.
-
Automated Continuous SAP SuccessFactors Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to delimited files (CSV/TSV).
-
Integrate Oracle Eloqua Reporting in the Pentaho Report Designer
Publish reports based on Oracle Eloqua Reporting in the Pentaho BI tool.
-
Create Amazon DynamoDB Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Salesloft Replication to SQL Server
Use CData Sync for automated, continuous, customizable Salesloft replication to SQL Server.
-
Publish Adobe Analytics-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Adobe Analytics.
-
How to use SQLAlchemy ORM to access Sage 300 in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sage 300.
-
Automated Continuous Asana Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Asana replication to IBM DB2.
-
Import and Visualize DB2 in Power View
Create data visualizations based on IBM DB2 in Excel.
-
Publish SAP HANA XS Advanced-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP HANA XS Advanced.
-
Connect Epicor Kinetic to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Epicor Kinetic using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automate PayPal Integration Tasks from PowerShell
Are you in search of a quick and easy way to access PayPal from PowerShell? This article demonstrates how to utilize the PayPal Cmdlets for tasks like connecting to PayPal, automating operations, downloading data, and more.
-
Connect to REST in NetBeans
Connect to REST in NetBeans with the data source configuration wizard.
-
How to Connect Flowise AI Agents to Live BigCommerce via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
Use the CData Software JDBC Driver for SAP Netweaver Gateway in MicroStrategy Web
Connect to SAP Netweaver Gateway in MicroStrategy Web using the CData Software JDBC Driver for SAP Netweaver Gateway.
-
Automate Asana Replication to SAP HANA
Use CData Sync to customize and automate Asana replication to SAP HANA.
-
Create a Data Access Object for Microsoft Exchange using JDBI
A brief overview of creating a SQL Object API for Microsoft Exchange in JDBI.
-
How to Easily Query Exact Online in OpenOffice Base
-