CData Software - Knowledge Base
Recent Articles
-
Enable the Typeform JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Typeform.
-
Import Raisers Edge NXT into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Raisers Edge NXT. In this article, you will use the OData format to import Raisers Edge NXT into Microsoft Power Query.
-
Build Dashboards with SAP Ariba Source in DBxtra
Create dynamic dashboards and perform analytics based on SAP Ariba Source in DBxtra.
-
Natively Connect to Reckon Accounts Hosted in PHP
The CData ODBC driver for Reckon Accounts Hosted enables you to create PHP applications with connectivity to Reckon Accounts Hosted. Leverage the native support for ODBC in PHP.
-
Edit and Search Sage 300 External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Sage 300 to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Sage 300 objects that you can access from apps and the dashboard.
-
Seamlessly Bring Google Calendar into Retool Using CData Connect AI
Integrate Google Calendar data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Add eBay to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for eBay with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Query Google Ad Manager in MySQL Workbench
Execute MySQL queries against live Google Ad Manager from MySQL Workbench.
-
Automated Continuous Amazon S3 Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Amazon S3 replication to PostgreSQL.
-
Use JayDeBeApi to access MariaDB in Python
Use standard Python scripting and the development environment of your choice to access live MariaDB.
-
Design BIRT Reports on Outreach.io
Provide current Outreach.io to your embedded analytics.
-
Analyze Greenplum in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Pivotal GreenPlum and visualize live Pivotal GreenPlum in Infragistics Reveal.
-
Consume ShipStation OData Feeds in SAP Lumira
Use the API Server to create data visualizations on ShipStation feeds that reflect any changes in SAP Lumira.
-
Consume Dynamics 365 Business Central OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Dynamics 365 Business Central feeds that reflect any changes in SAP Lumira.
-
Build Automated Workflows with Live BigQuery in Workato
Use CData Connect AI to connect to live Google BigQuery and build automated workflows in Workato.
-
Automated Continuous Smartsheet Replication to Vertica
Use CData Sync for automated, continuous, customizable Smartsheet replication to Vertica.
-
Automated Continuous Lakebase Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Lakebase replication to PostgreSQL.
-
Connect to Exact Online in HULFT Integrate
Connect to Exact Online as a JDBC data source in HULFT Integrate
-
Connect and Visualize Live Avalara AvaTax Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Avalara AvaTax into the Databricks platform and create visualization dashboards with real-time Avalara AvaTax.
-
Use ChatGPT to Talk to Your Oracle Service Cloud via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Oracle Service Cloud for you.
-
Access Splunk 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 Splunk.
-
Integrate Gmail in Pentaho Data Integration
Build ETL pipelines based on Gmail in the Pentaho Data Integration tool.
-
Publish GitHub-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live GitHub.
-
Query BigCommerce from Node.js
Use the OData endpoint of the CData API Server to connect to your BigCommerce and perform CRUD operations on BigCommerce from Node.js.
-
Bidirectional Access to Sage 200 from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Sage 200 in Filemaker Pro for Mac or Windows.
-
Automated Continuous Google Spanner Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Spanner replication to SingleStore.
-
Use the CData API Server to Access Azure Data Catalog in Microsoft PowerPivot
Use the CData API Server to connect to live Azure Data Catalog in the Power Pivot business intelligence tool.
-
How to Work with Pinterest in ETL Validator JDBC
Connect to Pinterest from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Presto Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Presto replication to Microsoft Access.
-
How to import Google Spanner into Apache Solr
Use the CData Software JDBC Driver for Google Spanner in Data Import Handler and create an automated import of Google Spanner to Apache Solr Enterprise Search platform.
-
Access Live Adobe Commerce in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Adobe Commerce into the statistical analysis tools available in SAS JMP. This article shows how to use Adobe Commerce in the Graph Builder and Query Builder.
-
Connect to Amazon S3 in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Amazon S3 in Airbyte.
-
Query Google Data Catalog in DataGrip
Create a Data Source for Google Data Catalog in DataGrip and use SQL to query live Google Data Catalog.
-
How to create an RPA flow for MYOB AccountRight in UiPath Studio
Use the MYOB AccountRight ODBC Driver to create workflows that access real-time MYOB AccountRight without any coding.
-
Connect to Salesforce Data Cloud in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to connect SharePoint with Phoenix through external lists
Provide Apache Phoenix to SharePoint users as an external list.
-
Automated Continuous Cloudant Replication to MySQL
Use CData Sync for automated, continuous, customizable Cloudant replication to MySQL.
-
How to Query Live Dynamics NAV in Perplexity MacOS Desktop
Connect to and query live Dynamics NAV in Perplexity Desktop using the CData MCP Server.
-
Build a PostgreSQL Interface for Highrise using the CData JDBC Driver
Use the Remoting features of the Highrise JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access Live Bing Ads in Visual Studio Code via Cline
Run the CData MCP Server for Bing Ads on Windows Subsytem for Linux (WSL) and connect to live Bing Ads from the Cline extension in Visual Studio Code.
-
Use Dash to Build to Web Apps on SAP ByDesign
Create Python applications that use pandas and Dash to build SAP ByDesign-connected web apps.
-
How to import Google Sheets into Apache Solr
Use the CData Software JDBC Driver for Google Sheets in Data Import Handler and create an automated import of Google Sheets to Apache Solr Enterprise Search platform.
-
Enable the Power BI XMLA JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Power BI XMLA.
-
Connect to Pipedrive in Ruby
Connect to Pipedrive in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Import SAP Concur Using Azure Data Factory
Use CData Connect AI to connect to SAP Concur from Azure Data Factory and import live SAP Concur.
-
Import Azure Table Using Azure Data Factory
Use CData Connect AI to connect to Azure Table from Azure Data Factory and import live Azure Table Storage.
-
How to Connect to Live Active Directory 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 Active Directory through natural language.
-
Integrate with API in SnapLogic
Use CData Connect AI to connect to and integrate with live API in SnapLogic.
-
Use the CData SSIS Components to Insert New or Update Existing Google Sheets Records from SQL Server
Easily push SQL Server data to Google Sheets using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Sheets or update existing records with data from a SQL Server database.
-
Build a Simple VCL Application for TaxJar
How to build a simple VCL Application to view TaxJar in RAD Studio using the CData ODBC Driver for TaxJar.
-
Getting Started with the CData JDBC Driver for SAP Hybris C4C
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP Hybris C4C.
-
Feed Slack into FineReport
How to set Slack as a JDBC data source in FineReport.
-
Integrate with Live Quickbase in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Quickbase from the MuleSoft Anypoint Platform to integrate live Quickbase into custom reports and dashboards.
-
Connect to Zoho CRM as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Zoho CRM.
-
Connect to LinkedIn as an External Source in Dremio
Use the CData JDBC Driver to connect to LinkedIn as an External Source in Dremio.
-
Automated Continuous RSS Replication to Snowflake
Use CData Sync for automated, continuous, customizable RSS replication to Snowflake.
-
Integrate Shippo in Pentaho Data Integration
Build ETL pipelines based on Shippo in the Pentaho Data Integration tool.
-
Access Live Redshift in AWS Lambda (with IntelliJ IDEA)
Connect to live Amazon Redshift in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automate MarkLogic Replication to Azure Synapse
Use CData Sync to customize and automate MarkLogic replication to Azure Synapse.
-
Connecting Mastra with CockroachDB 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.
-
Automated Continuous Google Spanner Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Spanner replication to MongoDB.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP SuccessFactors
Create SAP SuccessFactors data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Google Ads in Aqua Data Studio
Access Google Ads from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Live SAP Concur into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP Concur from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Concur.
-
Connect to Neo4J in Aqua Data Studio
Access Neo4J from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Back Up Bullhorn CRM to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Bullhorn CRM. In this article, we will employ an SSIS workflow to populate a database with Bullhorn CRM data.
-
Getting Started with the CData Python Connector for Cloudant
Learn to install and license the CData Python Connector
-
3 Ways to Integrate External Data Sources with FileMaker via CData ODBC Drivers
-
Analyze Microsoft Exchange in Looker
Use CData Connect AI to connect to Microsoft Exchange from Looker and build custom apps using live Microsoft Exchange.
-
Connect to Highrise in DBArtisan
Use wizards in DBArtisan to configure Highrise CRM as a data source.
-
Create OneNote-Connected Applications in Appsmith
Connect to OneNote via CData Connect AI in Appsmith and create custom business applications with real-time access to Microsoft OneNote.
-
Replicate Multiple Dynamics CRM Accounts
Replicate multiple Dynamics CRM accounts to one or many databases.
-
Integrating MariaDB in Talend Cloud Data Management Platform
-