CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Presto Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Presto replication to Google BigQuery.
-
Getting Started with the CData Tableau Connector for Epicor Kinetic
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Epicor Kinetic.
-
Automated Continuous Datadog Replication to Snowflake
Use CData Sync for automated, continuous, customizable Datadog replication to Snowflake.
-
Automated Continuous Google Contacts Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Contacts replication to AlloyDB.
-
Visualize Google Translate Data in Sisense
Create an ElastiCube in Sisense app with access to Google Translate.
-
Publish Crystal Reports on PagerDuty Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date PagerDuty.
-
Create Reports with SAP SuccessFactors Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP SuccessFactors.
-
Migrating data from Cohere to Google BigQuery using CData SSIS Components.
Easily push Cohere to Google BigQuery using the CData SSIS Tasks for Cohere and Google BigQuery.
-
Use CData Connect AI to Access Office 365 Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Microsoft Office 365 in the Power Pivot business intelligence tool.
-
Access Live PayPal Data in TIBCO Data Virtualization
Use the PayPal Tibco DV Adapter to create a PayPal data source in TIBCO Data Virtualization Studio and gain access to live PayPal from your TDV Server.
-
Integrating GitHub Copilot CLI with eBay Analytics via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Publish Crystal Reports on EmailOctopus Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date EmailOctopus.
-
Automated Continuous HubDB Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable HubDB replication to delimited files (CSV/TSV).
-
Use CData Connect AI to Access eBay Data in Microsoft Power Pivot
Use CData Connect AI to connect to live eBay in the Power Pivot business intelligence tool.
-
Import Microsoft Entra ID Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Microsoft Entra ID Data and provide access to live Microsoft Entra ID for custom reports in the Power BI Service.
-
Automated Continuous Optimizely Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Optimizely replication to OneLake in Microsoft Fabric.
-
Query Amazon Marketplace Data in ColdFusion
Write standard ColdFusion data access code to connect to Amazon Marketplace.
-
Consume Amazon Marketplace OData Feeds in PowerBuilder
This article demonstrates how to consume Amazon Marketplace as OData feeds from PowerBuilder using the API Server.
-
Publish Reports with Tanda Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Tanda.
-
Automated Continuous SAP Fieldglass Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Apache Kafka.
-
How to Seamlessly Import HubDB Data into IBM SPSS Modeler
Integrate HubDB data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Seamlessly Bring Redshift Data into Retool Using CData Connect AI
Integrate Redshift data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous Office 365 Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Office 365 replication to Apache Cassandra.
-
Automated Asana Data Replication to Teradata
Use CData Sync to Customize and automate Asana replication to Teradata.
-
Connect to Live Power BI XMLA Data in MicroStrategy through CData Connect AI
Create a live connection to Power BI XMLA Data in CData Connect AI and connect to your Power BI XMLA from MicroStrategy.
-
Migrating data from Cloudflare to Snowflake using CData SSIS Components.
Easily push Cloudflare to Snowflake using the CData SSIS Tasks for Cloudflare and Snowflake.
-
Explore Geographical Relationships in Stripe Data with Power Map
Create data visualizations with Stripe in Power Map.
-
Extract, Transform, and Load Oracle Eloqua Data in Informatica PowerCenter
Create a simple Workflow for Oracle Eloqua in Informatica PowerCenter.
-
Create a Data Access Object for SAP Business One Data using JDBI
A brief overview of creating a SQL Object API for SAP Business One in JDBI.
-
Connect to AfterShip Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to AfterShip and work with AfterShip in your FileMaker applications.
-
How to connect to Humanity Data from Spring Boot
Connect to Humanity in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to OData Services in Claris FileMaker Pro
Use the CData ODBC Driver for OData in FileMaker Pro to connect to OData and work with OData in your FileMaker applications.
-
Integrating GitHub Copilot CLI with Blackbaud FE NXT via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
How to Query Live Azure Analysis Services Data in Claude Desktop
Connect to and query live Azure Analysis Services Data in Claude Desktop using CData MCP Server.
-
Publish Crystal Reports on Jodoo Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Jodoo.
-
Use the CData ODBC Driver for Gmail from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Gmail to connect to Gmail from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Gmail in Excel.
-
Visualize Vault CRM Data in Sisense
Create an ElastiCube in Sisense app with access to Veeva Vault & Vault CRM.
-
Create a Data Access Object for Teamwork Data using JDBI
A brief overview of creating a SQL Object API for Teamwork in JDBI.
-
Integrate LibreChat with Live Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Paylocity from within the chat interface.
-
Migrating data from Wrike to Google BigQuery using CData SSIS Components.
Easily push Wrike to Google BigQuery using the CData SSIS Tasks for Wrike and Google BigQuery.
-
Access ZarMoney Data 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 ZarMoney.
-
Connect to SAP ByDesign Data from a Connection Pool in JBoss
Integrate SAP Business ByDesign into Java servlets: Use the Management Console in JBoss to install the SAP ByDesign JDBC Driver.
-
Create Okta-Connected Nintex Workflows
Use CData Connect AI to connect to Okta Data from Nintex Workflow Cloud and build custom workflows using live Okta.
-
DataBind Controls to Twitter Ads Data in C++Builder
DataBind to Twitter Ads in C++Builder with standard components and controls.
-
How to Work with Zoho Recruit Data in ETL Validator JDBC
Connect to Zoho Recruit from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to DB2 Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live IBM DB2.
-
Visualize Live Asana Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Asana.
-
Access Live Cloudant Data in TIBCO Data Virtualization
Use the Cloudant Tibco DV Adapter to create a IBM Cloudant data source in TIBCO Data Virtualization Studio and gain access to live IBM Cloudant from your TDV Server.
-
Connect to Real-Time SAS Data Sets Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SAS Data Sets and Dataflow to import and use SAS Data Sets in Power Apps.
-
Automated Continuous ChargeOver Replication to Snowflake
Use CData Sync for automated, continuous, customizable ChargeOver replication to Snowflake.
-
How to Build an ETL App for Suadeo Data in Python with CData
Create ETL applications and real-time data pipelines for Suadeo in Python with petl.
-
Connect Onfleet to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Onfleet with IBM WebSphere for seamless data integration and connectivity.
-
Migrating data from Microsoft Ads to Google BigQuery using CData SSIS Components.
Easily push Microsoft Ads to Google BigQuery using the CData SSIS Tasks for Microsoft Ads and Google BigQuery.
-
Analyze MongoDB Data in Looker
Use CData Connect AI to connect to MongoDB Data from Looker and build custom apps using live MongoDB.
-
Create Reports from Neo4J Data in Looker Studio
Use CData Connect AI to gain access to live Neo4J and create custom reports in Looker Studio.
-
Publish Crystal Reports on Drip Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Drip.
-
Getting Started with the CData Tableau Connector for HelloSign
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Oracle Sales Replication to Vertica
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Vertica.
-
Query Paymo Data as a MySQL Database in Node.js
Execute MySQL queries against Paymo from Node.js.
-
Integrating Codex CLI with Sybase via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Integrate with live Google Directory Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google Directory in Jitterbit.
-
Using the CData Software ODBC Driver for Shippo in PyCharm
Connect to Shippo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Shippo.
-
Integrating Kiro CLI with Cohere Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Automated Continuous Salesloft Replication to Vertica
Use CData Sync for automated, continuous, customizable Salesloft replication to Vertica.
-
Integrate Nethunt with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Nethunt with External Services.
-
How to Connect the Power BI Service to Yelp: Complete Guide
Connect to the CData Software Power BI Connector for Yelp from PowerBI.com to provide real-time Yelp across the organization.
-
Query Office 365 Data as a SQL Server Database in Node.js
Execute SQL Server queries against Microsoft Office 365 from Node.js.
-
Use the CData Software ODBC Driver for Printify in MicroStrategy Desktop
Connect to Printify in MicroStrategy Desktop using the CData Software ODBC Driver for Printify.
-
How to Connect to Live MYOB AccountRight Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live MYOB AccountRight securely in real time.
-
Highrise Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Highrise facts in real time.
-
Visualize Strava Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Strava.
-
How to Connect to Live SAP Ariba Source Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your SAP Ariba Source for you.
-
Connect to Microsoft Planner Data in Jaspersoft Studio
Execute SQL to remote Microsoft Planner in Jaspersoft Studio.
-
How to Connect to Live Impala Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Apache Impala for you.
-
Automated Continuous REST Replication to SQL Server
Use CData Sync for automated, continuous, customizable REST replication to SQL Server.
-
Automated Continuous Harvest Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Harvest replication to Azure SQL Database.
-
Integrating Kiro CLI with Invoiced Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Publish SAP Business Warehouse-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP Business Warehouse.
-
Connect to Square Data in Aqua Data Studio
Access Square from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Work with Splunk Data in AWS Glue Jobs Using JDBC
Connect to Splunk from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Okta with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Okta with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Okta.
-
Working with ShipStation Data in LINQPad
Execute LINQ queries to ShipStation in LINQPad.
-
Build JSON-Connected Apps in Choreo
Use CData Connect AI to connect to JSON Services from Choreo and build custom apps using live JSON.
-
Automated Continuous Delighted Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Delighted replication to Amazon Redshift.
-
Build Apps with Live Oracle Eloqua Reporting Data Using the Low-Code Development Platform of Mendix
Connect Oracle Eloqua Reporting with Mendix to build apps using the CData JDBC Driver for Oracle Eloqua Reporting.
-
Import Greenplum Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Pivotal GreenPlum. In this article, you will use the OData format to import Pivotal GreenPlum into Microsoft Power Query.
-
Model Facebook Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Facebook, enabling the direct import of real-time Facebook.
-
Automate Sugar CRM Data Replication to Azure Data Lake
Use CData Sync to customize and automate Sugar CRM replication to Azure Data Lake.
-
Automated Continuous Helpscout Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Helpscout replication to Apache Kafka.
-
Connect to and Query Google Translate Data in QlikView over ODBC
Create data visualizations with Google Translate in QlikView.
-
Create Reports with PostgreSQL Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PostgreSQL.
-
Connect to Dynamics NAV with the CData OData Provider
This article uses the CData ADO.NET OData provider to retrieve data from Dynamics NAV. The process described will also work for other CData OData providers (JDBC, ODBC, SSIS, etc.).
-
How to work with Attio Data in Apache Spark using SQL
Access and process Attio Data in Apache Spark using the CData Software JDBC Driver.
-
Replicate Trello Data in Heroku for Use in Salesforce Connect
Replicate Trello to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to YouTube Analytics Data from PowerBuilder via ADO.NET
This article demonstrates how to access YouTube Analytics from Appeon PowerBuilder using the CData ADO.NET Provider for YouTube Analytics.
-
Build Semantic Layer Views for Epicor Kinetic Data in APOS Live Data Gateway
Use the CData Connector for Epicor Kinetic in APOS Live Data Gateway to build Semantic Layer Views for Epicor Kinetic.
-
How to publish and share Pipedrive Data dashboards with Tableau Server
The CData ODBC driver for Pipedrive enables you integrate Pipedrive into Tableau dashboards.
-
How to Query Live Sage Cloud Accounting Data in Perplexity MacOS Desktop
Connect to and query live Sage Cloud Accounting Data in Perplexity Desktop using CData MCP Server.
-
How to import AdRoll Data into Apache Solr
Use the CData Software JDBC Driver for AdRoll in Data Import Handler and create an automated import of AdRoll to Apache Solr Enterprise Search platform.
-
How to connect SharePoint with Neo4J Data through external lists
Provide Neo4J to SharePoint users as an external list.