CData Software - Knowledge Base
Recent Articles
-
Query Excel Online in ColdFusion
Write standard ColdFusion data access code to connect to Microsoft Excel Online.
-
Automate Vault CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Veeva Vault & Vault CRM from PowerShell? This article demonstrates how to utilize the Vault CRM Cmdlets for tasks like connecting to Veeva Vault & Vault CRM, automating operations, downloading data, and more.
-
Connect to SAP ByDesign from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP ByDesign to connect to SAP Business ByDesign from Web applications running on WebLogic.
-
Building Dynamic Web Pages with HDFS Using AngularJS
Create single-page applications with live connectivity to HDFS using the CData API Server.
-
Write a Simple Go Application to work with Power BI XMLA on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Power BI XMLA.
-
Connect to Redshift as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Amazon Redshift.
-
Automate Box Replication to SAP HANA
Use CData Sync to customize and automate Box replication to SAP HANA.
-
How to pipe Snapchat Ads to CSV in PowerShell
Use standard PowerShell cmdlets to access Snapchat Ads tables.
-
Build Agents in Relevance AI with Access to Live Reckon via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Reckon within intelligent agent workflows.
-
How to create SAP federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP ERP/NetWeaver in MySQL .
-
Operational Reporting on Oracle SCM from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Oracle SCM.
-
Connect to Act CRM in the Denodo Platform
Use CData driver technologies to create a virtual data source for Act CRM in the Denodo Virtual DataPort Administrator.
-
How to Work with DB2 in AWS Glue Jobs Using JDBC
Connect to DB2 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Getting Started with the CData ODBC Driver for Typeform
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Typeform.
-
Build AI Agents with Twitter Ads Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Build Visualizations of Act-On in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Act-On in Birst.
-
Connect and Visualize Live Salesforce Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Salesforce & Force.com into the Databricks platform and create visualization dashboards with real-time Salesforce & Force.com.
-
Bidirectional Access to Airtable from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Airtable in Filemaker Pro for Mac or Windows.
-
Automated Continuous PostgreSQL Replication to Amazon S3
Use CData Sync for automated, continuous, customizable PostgreSQL replication to Amazon S3.
-
Connect to Microsoft Dataverse from Asprova with CData Software ODBC Driver for Microsoft Dataverse
This article shows how to connect faster to Microsoft Dataverse data from Asprova.
-
How to Connect the Power BI Service to Shopify: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Visualize Live CockroachDB in the Power BI Service
Use CData Connect AI to connect to live CockroachDB and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Validate HubSpot with QuerySurge
Access and validate HubSpot in QuerySurge using the CData JDBC Driver.
-
Use CData Connect AI to Access BigCommerce in Microsoft Power Pivot
Use CData Connect AI to connect to live BigCommerce in the Power Pivot business intelligence tool.
-
How to connect PolyBase to Parquet
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apache Parquet.
-
Build Dynamics CRM-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Dynamics CRM.
-
Extend Google Sheets with Sybase
Make calls to the API Server from Google Apps Script.
-
Access Salesloft 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 Salesloft.
-
Automated Continuous SAP Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP replication to Snowflake.
-
Enable the Google Cloud Storage JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Cloud Storage.
-
Use the CData Software JDBC Driver for NetSuite in MicroStrategy Web
Connect to NetSuite CRM & ERP in MicroStrategy Web using the CData Software JDBC Driver for NetSuite.
-
Query Impala in DataGrip
Create a Data Source for Impala in DataGrip and use SQL to query live Apache Impala.
-
Build Dashboards with Salesforce Pardot in Dundas BI
Create dynamic dashboards and perform analytics based on Salesforce Pardot in Dundas BI.
-
Back Up Microsoft Excel Online to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Excel Online. In this article, we will employ an SSIS workflow to populate a database with Microsoft Excel Online data.
-
Integrate Theia IDE with Live Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Getting Started with the CData Excel Add-In for Oracle Service Cloud
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Oracle Service Cloud.
-
Migrating data from Salesforce Pardot to Databricks using CData SSIS Components.
Easily push Salesforce Pardot to Databricks using the CData SSIS Tasks for Salesforce Pardot and Databricks.
-
Prepare, Blend, and Analyze Sage 300 in Alteryx Designer (ODBC)
Build workflows to access live Sage 300 for self-service data analytics.
-
Connect to Printify from PowerBuilder via ADO.NET
This article demonstrates how to access Printify from Appeon PowerBuilder using the CData ADO.NET Provider for Printify.
-
Automated Continuous Lakebase Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Lakebase replication to Apache Kafka.
-
Consume Shopify OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Shopify feeds that reflect any changes in SAP Lumira.
-
Replicate SAP SuccessFactors to Multiple Databases via the CData Sync CLI
Replicate SAP SuccessFactors to disparate databases with a single configuration.
-
Build MongoDB-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live MongoDB.
-
Visualize Live ShipStation in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ShipStation.
-
Build Semantic Layer Views for Oracle Service Cloud in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Oracle Service Cloud.
-
Getting Started with the CData JDBC Driver for WordPress
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for WordPress.
-
Analyze Live Presto in SAS Viya
Use CData Connect AI to connect to Presto from SAS Viya and deploy self-service analytics using live Presto.
-
How to Design ADP Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Work with Azure Data Catalog in FoxPro
Load Azure Data Catalog into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect the Power BI Service to Asana: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
How to connect PolyBase to Oracle HCM Cloud
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle HCM Cloud.
-
Use the CData Software ODBC Driver for eBay Analytics in MicroStrategy
Connect to eBay Analytics in MicroStrategy Developer using the CData Software ODBC Driver for eBay Analytics.
-
Access Live BigCommerce in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate BigCommerce into the statistical analysis tools available in SAS JMP. This article shows how to use BigCommerce in the Graph Builder and Query Builder.
-
Connect to Airtable in JRuby
Create a simple JRuby app with access to live Airtable.
-
Connect to IBM Cloud Object Storage from PowerBuilder via ADO.NET
This article demonstrates how to access IBM Cloud Object Storage from Appeon PowerBuilder using the CData ADO.NET Provider for IBM Cloud Object Storage.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for HCL Domino
Provide connectivity to HCL Domino through an SAP BusinessObjects universe.
-
Connect to QuickBooks Online in ACL Analytics
Connect to QuickBooks Online via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to QuickBooks Online.
-
Replicate Outreach.io to Multiple Databases via the CData Sync CLI
Replicate Outreach.io to disparate databases with a single configuration.
-
Seamlessly Bring Amazon DynamoDB into Retool Using CData Connect AI
Integrate Amazon DynamoDB data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to import Basecamp into Apache Solr
Use the CData Software JDBC Driver for Basecamp in Data Import Handler and create an automated import of Basecamp to Apache Solr Enterprise Search platform.
-
Automated Continuous SAP HANA XS Advanced Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to delimited files (CSV/TSV).
-
Use Dash to Build to Web Apps on SAP Business One
Create Python applications that use pandas and Dash to build SAP Business One-connected web apps.
-
Build AI/ML Models with Live Certinia Data using Dataiku
-