CData Software - Knowledge Base
Recent Articles
-
Automate Drift Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Drift and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Visualize Shopify in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Shopify into TIBCO Spotfire.
-
Consume SharePoint Excel Services OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SharePoint Excel Services feeds that reflect any changes in SAP Lumira.
-
Back Up Unbounce to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Unbounce. In this article, we will employ an SSIS workflow to populate a database with Unbounce data.
-
Create Spark-Connected Business Apps in AppSheet
Connect to Spark via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Apache Spark SQL.
-
How to Query Live Box in Perplexity MacOS Desktop
Connect to and query live Box in Perplexity Desktop using CData Code Assist MCP.
-
Visualize Oracle Eloqua in TIBCO Spotfire through OData
Integrate Oracle Eloqua into dashboards in TIBCO Spotfire.
-
Connect to Microsoft Project from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Microsoft Project to connect to Microsoft Project and execute queries in PowerBuilder.
-
Access Live Greenplum in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Pivotal GreenPlum from your Google Sheets.
-
Natively Connect to Azure Synapse in PHP
The CData ODBC driver for Azure Synapse enables you to create PHP applications with connectivity to Azure Synapse. Leverage the native support for ODBC in PHP.
-
Use Biml to Build SSIS Tasks to Replicate Google Directory to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Directory to SQL Server.
-
Connect to Asana from a Connection Pool in JBoss
Integrate Asana into Java servlets: Use the Management Console in JBoss to install the Asana JDBC Driver.
-
Integrate IBM Cloud Object Storage in Pentaho Data Integration
Build ETL pipelines based on IBM Cloud Object Storage in the Pentaho Data Integration tool.
-
Connecting Moonlit Workflow with Twitter via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Twitter in real time.
-
How to Design Impala Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Create Reports with Redshift in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Amazon Redshift.
-
Connect to Cvent from PowerBuilder via ADO.NET
This article demonstrates how to access Cvent from Appeon PowerBuilder using the CData ADO.NET Provider for Cvent.
-
Analyze SharePoint in Looker
Use CData Connect AI to connect to SharePoint from Looker and build custom apps using live Microsoft SharePoint.
-
Create Informatica Mappings From/To an ODBC Data Source for Twitter
Create an ODBC connection to Twitter in Informatica and browse and transfer Twitter.
-
Connect to Impala in Google Apps Script via Connect AI
Use CData Connect AI to access Apache Impala in Google Apps Script.
-
How to Query Live Okta in Perplexity MacOS Desktop
Connect to and query live Okta in Perplexity Desktop using CData Code Assist MCP.
-
Connect to ShipStation as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live ShipStation.
-
Import and Visualize PayPal in Power View
Create data visualizations based on PayPal in Excel.
-
Connect to SAP SuccessFactors in Google Apps Script via Connect AI
Use CData Connect AI to access SAP SuccessFactors in Google Apps Script.
-
Visualize Live Wave Financial in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Wave Financial.
-
Connect to CSV in Jaspersoft Studio
Execute SQL to remote CSV/TSV Files in Jaspersoft Studio.
-
Build TaxJar-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live TaxJar.
-
Create Informatica Mappings From/To an ODBC Data Source for Adobe Experience Manager
Create an ODBC connection to Adobe Experience Manager in Informatica and browse and transfer Adobe Experience Manager.
-
Provide OData Services of FTP from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for FTP Servers by developing a WCF Service Application.
-
Connect to Paylocity from a Connection Pool in WebLogic
Use the CData JDBC Driver for Paylocity to connect to Paylocity from Web applications running on WebLogic.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Zoom
Provide connectivity to Zoom through an SAP BusinessObjects universe.
-
How to Build an ETL App for YouTube Analytics in Python with CData
Create ETL applications and real-time data pipelines for YouTube Analytics in Python with petl.
-
Migrating data from Avalara AvaTax to Databricks using CData SSIS Components.
Easily push Avalara AvaTax to Databricks using the CData SSIS Tasks for Avalara AvaTax and Databricks.
-
Use the CData ODBC Driver for Act-On in Microsoft Power Query
You can use the CData Act-On ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Act-On into Microsoft Power Query.
-
Build Semantic Layer Views for Oracle in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Oracle Database.
-
Replicate Printful to Multiple Databases
Replicate Printful to disparate databases with a point-and-click configuration.
-
Create Apps from Presto in Qlik Sense Cloud
Use CData Connect AI to connect to Presto and build apps from live Presto in Qlik Sense Cloud.
-
Connect to Oracle Eloqua in JRuby
Create a simple JRuby app with access to live Oracle Eloqua.
-
Automated Continuous CockroachDB Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable CockroachDB replication to Google Cloud SQL.
-
Automated Continuous Act-On Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Act-On replication to AlloyDB.
-
Use Dash to Build to Web Apps on ActiveCampaign
Create Python applications that use pandas and Dash to build ActiveCampaign-connected web apps.
-
Extract, Transform, and Load DB2 in Informatica PowerCenter
Create a simple Workflow for IBM DB2 in Informatica PowerCenter.
-
A PostgreSQL Interface for Jira Service Management (MySQL Remoting via JDBC)
Use the Remoting features of the Jira Service Management JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to SAS Data Sets from Spring Boot
Connect to SAS Data Sets in a Spring Boot Application using CData JDBC SAS Data Sets Driver
-
How to connect PolyBase to Google Search
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Search.
-
Build Gmail-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Gmail and create custom apps in Bubble.
-
Connect to AlloyDB from a Connection Pool in Jetty
The AlloyDB JDBC Driver supports connection pooling: This article shows how to connect faster to Google AlloyDB from Web apps in Jetty.
-
Replicate Act CRM from PowerShell
Write a quick PowerShell script to query Act CRM. Use connectivity to the live data to replicate Act CRM to SQL Server.
-
Natively Connect to OData Services in PHP
The CData ODBC driver for OData enables you to create PHP applications with connectivity to OData. Leverage the native support for ODBC in PHP.
-
Use Dash to Build to Web Apps on Sage Cloud Accounting
Create Python applications that use pandas and Dash to build Sage Cloud Accounting-connected web apps.
-
Integrate Live Paylocity into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Paylocity and integrate live Paylocity into apps built in Microsoft Power Apps.
-
Build Amazon Marketplace-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Amazon Marketplace and create custom apps in Mendix.
-
Connect to Access in NetBeans
Connect to Microsoft Access in NetBeans with the data source configuration wizard.
-
Build SAP Concur-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP Concur.
-
Query, Visualize, and Share live GraphQL in Redash
Use CData Connect AI to connect to live GraphQL in Redash for querying, visualizing, and sharing.
-
Connect to SurveyMonkey in CloverDX (formerly CloverETL)
Transfer SurveyMonkey using the visual workflow in the CloverDX data integration tool.
-
Automate OneNote Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft OneNote replication to Azure Data Lake.
-
Integrate with Oracle Financials Cloud using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Oracle Financials Cloud to a JSON file on disk.
-
Build AI Agents with Amazon DynamoDB Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Connect to Xero as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Xero Accounting.
-
Replicate Invoiced from PowerShell
Write a quick PowerShell script to query Invoiced. Use connectivity to the live data to replicate Invoiced to SQL Server.
-
Add HCL Domino to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for HCL Domino with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Zoom Replication to Oracle
Use CData Sync for automated, continuous, customizable Zoom replication to Oracle.
-
Automated Continuous Twitter Ads Replication to SQLite
Use CData Sync for automated, continuous, customizable Twitter Ads replication to SQLite.
-
SAP Netweaver Gateway Reporting in OBIEE with the SAP Netweaver Gateway JDBC Driver
Deploy the SAP Netweaver Gateway JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Getting Started with the CData Tableau Connector for LinkedIn
-