CData Software - Knowledge Base
Recent Articles
-
Query CockroachDB as a SQL Server Database in Node.js
Execute SQL Server queries against CockroachDB from Node.js.
-
Replicate SAP to Multiple Databases via the CData Sync CLI
Replicate SAP ERP/NetWeaver to disparate databases with a single configuration.
-
How to Connect to & Open Act-On in Microsoft Excel
This article uses the CData ODBC driver for Act-On to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Dynamics 365 in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Dynamics 365 from Informatica Cloud.
-
Work with Live Amazon Athena in Power Query
Use CData Connect AI to connect to Amazon Athena and work with live Amazon Athena in Microsoft Power Query.
-
Create Informatica Mappings From/To an ODBC Data Source for Cvent
Create an ODBC connection to Cvent in Informatica and browse and transfer Cvent.
-
Work with Excel in FoxPro
Load Microsoft Excel into a FoxPro database. This article includes full code and a walk-through of the process.
-
Import Google Drive Using Azure Data Factory
Use CData Connect AI to connect to Google Drive from Azure Data Factory and import live Google Drive.
-
Create Greenplum Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Greenplum data access from reports, embedded analytics, and more.
-
Replicate Vertica to Multiple Databases via the CData Sync CLI
Replicate Vertica to disparate databases with a single configuration.
-
Query Live BigCommerce in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live BigCommerce directly from the development environment.
-
Object-Relational Mapping (ORM) with PingOne 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 PingOne into a Java-based ORM framework, Hibernate.
-
How to Seamlessly Import Salesforce Marketing Data into IBM SPSS Modeler
Integrate Salesforce Marketing data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Getting Started with the CData Excel Add-In for Xero
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Xero.
-
Analyze Salesforce Data Cloud with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Salesforce Data Cloud from Power Pivot. You will use the Table Import Wizard to load Salesforce Data Cloud. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous EnterpriseDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to SingleStore.
-
Analyze SAP SuccessFactors with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP SuccessFactors from Power Pivot. You will use the Table Import Wizard to load SAP SuccessFactors. You can visually build the import query or use any SQL supported by the driver.
-
Automated Paylocity Replication to Teradata
Use CData Sync to Customize and automate Paylocity replication to Teradata.
-
Connect to HCL Domino as an External Source in Dremio
Use the CData JDBC Driver to connect to HCL Domino as an External Source in Dremio.
-
How to load Phoenix data into Elasticsearch via Logstash
Introducing a simple method to load Phoenix data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Live Access into Blue Prism for Intelligent Robotic Process Automation (RPA)
-