CData Software - Knowledge Base
Recent Articles
-
How to Work with Hugging Face Data in AWS Glue Jobs Using JDBC
Connect to Hugging Face from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Reports with LDAP Objects in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date LDAP.
-
Import Kintone Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Kintone. In this article, you will use the OData format to import Kintone into Microsoft Power Query.
-
Automate CouchDB Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Apache CouchDB and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Important Update: NetSuite SuiteQL Schema Changes
Action Required: Recent NetSuite update affects customers using NetSuite SuiteQL schema. SuiteTalk schema users are not impacted.
-
How to create Visio diagrams from Active Directory Data
Automatically update Active Directory with the changes you make to Visio master shapes.
-
Automated Continuous Invoiced Replication to SQLite
Use CData Sync for automated, continuous, customizable Invoiced replication to SQLite.
-
How to Connect to Live Amazon DynamoDB Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Amazon DynamoDB securely in real time.
-
Build Dashboards with Discourse Data in DBxtra
Create dynamic dashboards and perform analytics based on Discourse in DBxtra.
-
Import Real-Time SAP HANA XS Advanced Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP HANA XS Advanced in ColdFusion.
-
How to Access Live SAP Ariba Procurement Data in Visual Studio Code via Cline
Run CData MCP Server for SAP Ariba Procurement on Windows Subsytem for Linux (WSL) and connect to live SAP Ariba Procurement from the Cline extension in Visual Studio Code.
-
Replicate ZohoSubscriptions Data to Multiple Databases
Replicate ZohoSubscriptions to disparate databases with a point-and-click configuration.
-
How to Work with HubSpot Data in AWS Glue Jobs Using JDBC
Connect to HubSpot from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Viewing SAP SuccessFactors Data in RAD Studio Data Explorer
How to view SAP SuccessFactors in RAD Studio Data Explorer using the CData ODBC Driver for SAP SuccessFactors.
-
Integrating Dataiku with Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Reckon Accounts Hosted.
-
Automated Continuous iContact Replication to MongoDB
Use CData Sync for automated, continuous, customizable iContact replication to MongoDB.
-
Connect to MySQL Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for MySQL to connect to MySQL and execute queries in PowerBuilder.
-
Import PostgreSQL Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to PostgreSQL Data and provide access to live PostgreSQL for custom reports in the Power BI Service.
-
Migrating data from MessageBird to Snowflake using CData SSIS Components.
Easily push MessageBird to Snowflake using the CData SSIS Tasks for MessageBird and Snowflake.
-
A PostgreSQL Interface for ScrapingBee Data using the CData ODBC Driver
Use the SQL Gateway and ScrapingBee ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Seamlessly Import Chargebee Data into IBM SPSS Modeler
Integrate Chargebee data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Sugar CRM Data in RapidMiner
Integrate Sugar CRM with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate GraphQL Data into Power Automate Desktop using CData Connect
CData Connect for GraphQL Data enables you to integrate GraphQL into workflows built using Microsoft Power Automate Desktop.
-
Using the CData Software ODBC Driver for Zoho Creator in PyCharm
Connect to Zoho Creator as an ODBC data source in PyCharm using the CData Software ODBC Driver for Zoho Creator.
-
Getting Started with the CData Excel Add-In for DocuSign
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for DocuSign.
-
Integrating Dataiku with Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Epicor Kinetic.
-
Publish Crystal Reports on JSON Services
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date JSON.
-
Create Paylocity-Connected Dashboards in Grafana
Connect to Paylocity Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Paylocity.
-
Working with Paddle Data in LINQPad
Execute LINQ queries to Paddle in LINQPad.
-
Analyze Testmonitor Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Testmonitor in Microsoft R Open.
-
Automated Continuous MailerLite Replication to MySQL
Use CData Sync for automated, continuous, customizable MailerLite replication to MySQL.
-
Connect to Authorize.Net Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Authorize.Net in the Denodo Virtual DataPort Administrator.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Gumroad
Provide connectivity to Gumroad through an SAP BusinessObjects universe.
-
Integrate Live Egnyte Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Egnyte to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Outlook Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Outlook facts in real time.
-
Automated Continuous ADP Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ADP replication to PostgreSQL.
-
Integrate Zoom with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Zoom with External Services.
-
Integrate Live SAP ByDesign Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP Business ByDesign and integrate live SAP Business ByDesign into apps built in Microsoft Power Apps.
-
View Reports on Real-Time Highrise Data in Power BI Report Server
Use the CData ODBC Driver for Highrise to visualize Highrise CRM in Power BI Desktop and then publish them to Power BI Report Server.
-
Rapidly Develop Auth0-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Auth0.
-
Use the CData Software JDBC Driver for Exact Online in MicroStrategy Desktop
Connect to Exact Online in MicroStrategy Desktop using the CData Software JDBC Driver for Exact Online.
-
Automated Continuous Office 365 Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Office 365 replication to Amazon Redshift.
-
Create SSAS Tabular Models from Harvest Data
How to build a SQL Server Analysis Service Tabular Model from Harvest using CData drivers.
-
Edit and Search Parquet External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Apache Parquet to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Parquet objects that you can access from apps and the dashboard.
-
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.
-
Connect to and Visualize Live Dynamics 365 Business Central Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Dynamics 365 Business Central.
-
Creating NetSuite-Connected Applications in Unqork
You can use CData Connect AI to feed NetSuite CRM & ERP to Unqork and build custom business apps.
-
Using the CData Software ODBC Driver for Moosend in PyCharm
Connect to Moosend as an ODBC data source in PyCharm using the CData Software ODBC Driver for Moosend.
-
Connect to Superchat Data in RazorSQL
Connect to Superchat from wizards and query Superchat from the GUI in the RazorSQL database management tool.
-
Automated Continuous Quickbase Replication to Oracle
Use CData Sync for automated, continuous, customizable Quickbase replication to Oracle.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Recurly
Provide connectivity to Recurly through an SAP BusinessObjects universe.
-
Use the CData ODBC Driver for GraphQL from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for GraphQL to connect to GraphQL from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring GraphQL in Excel.
-
Connect to eBay Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for eBay and the SQL Gateway to access eBay from Google Apps Script.
-
Connect to Neo4J Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Neo4J Data and connect to Neo4J in Akorbi Digital RunMyProcess.
-
Publish Crystal Reports on Jira Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Atlassian Jira.
-
Connect to Accelo Data in DBArtisan
Use wizards in DBArtisan to configure Accelo as a data source.
-
How to publish and share Power BI XMLA Data dashboards with Tableau Server
The CData ODBC driver for Power BI XMLA enables you integrate Power BI XMLA into Tableau dashboards.
-
Connect to Sage Intacct Data in Jaspersoft Studio
Execute SQL to remote Sage Intacct in Jaspersoft Studio.
-
Enable the Timely JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Timely.
-
Connect to SAS xpt Data in RapidMiner
Integrate SAS XPORT with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Reports with PagerDuty Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PagerDuty.
-
How to connect to SAP ByDesign Data from Spring Boot
Connect to SAP ByDesign in a Spring Boot Application using the CData JDBC Driver for SAP ByDesign
-
How to Work with Azure Analysis Services Data in AWS Glue Jobs Using JDBC
Connect to Azure Analysis Services from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Live Aweber Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Aweber to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Establish a Live Connection with Delighted Data using Tableau Bridge
The CData ODBC Driver for Delighted enables you to integrate live Delighted into Tableau Cloud dashboards using the Tableau Bridge.
-
Publish ZohoMarketingHub-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ZohoMarketingHub.
-
Back Up SAS Data Sets to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAS Data Sets. In this article, we will employ an SSIS workflow to populate a database with SAS Data Sets data.
-
Create Dynamics 365 Business Central Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Dynamics 365 Business Central from PowerBI.com to create Power BI Dataflows with real-time data.
-
Publish Reports with Clio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Clio.
-
A PostgreSQL Interface for Drift Data using the CData ODBC Driver
Use the SQL Gateway and Drift ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Factorial Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Factorial into the statistical analysis tools available in SAS JMP. This article shows how to use Factorial in the Graph Builder and Query Builder.
-
Build Azure Synapse-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Azure Synapse to explore live Azure Synapse Data in GitHub Copilot to assist with building Azure Synapse-powered applications.
-
Automated Continuous Act CRM Replication to MySQL
Use CData Sync for automated, continuous, customizable Act CRM replication to MySQL.
-
Import Procore Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Procore Data and provide access to live Procore for custom reports in the Power BI Service.
-
Getting Started with the CData ADO.NET Provider for JobNimbus
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Manage SFTP Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SFTP.
-
Automate JSON Services Replication to Azure Data Lake
Use CData Sync to customize and automate JSON replication to Azure Data Lake.
-
Use the CData Software ODBC Driver for GraphQL in MicroStrategy Desktop
Connect to GraphQL in MicroStrategy Desktop using the CData Software ODBC Driver for GraphQL.
-
Replicate Elasticsearch Data in Heroku for Use in Salesforce Connect
Replicate Elasticsearch to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Model, Search, and Visualize Live Active Directory Data in ThoughtSpot
Use CData Connect AI to connect to live Active Directory for modeling, searching, and visualizing.
-
Integrate Azure Data Catalog with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Azure Data Catalog with External Services.
-
Create SAP SuccessFactors LMS-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SAP SuccessFactors LMS Data from Klipfolio and build custom visualizations using live SAP SuccessFactors LMS.
-
Natively Connect to Office 365 Data in PHP
The CData ODBC driver for Office 365 enables you to create PHP applications with connectivity to Microsoft Office 365. Leverage the native support for ODBC in PHP.
-
How to Work with Mailgun Data in AWS Glue Jobs Using JDBC
Connect to Mailgun from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MailChimp
Provide connectivity to MailChimp through an SAP BusinessObjects universe.
-
Integrating Sentry Data in Talend Cloud Data Management Platform
Connect Sentry Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate Wistia with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Wistia with External Services.
-
Configure the CData JDBC Driver for Testmonitor in a Connection Pool in Tomcat
Connect to Testmonitor from a connection pool in Tomcat.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SAS Data Sets to Power BI dashboards. Simply drag and drop SAS Data Sets into data visuals on the Power BI canvas.
-
Build Google Ad Manager-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Ad Manager.
-
Create DB2-Connected Business Apps in AppSheet
Connect to DB2 Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to IBM DB2.
-
Replicate Kafka Data to Multiple Databases via the CData Sync CLI
Replicate Apache Kafka to disparate databases with a single configuration.
-
How to Access AdRoll Data Using Entity Framework
This article shows how to access AdRoll using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Visualize Blackbaud FE NXT Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Blackbaud FE NXT into TIBCO Spotfire.
-
DataBind Charts to Reply.io Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Reply.io from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Getting Started with the CData Excel Add-In for Basecamp
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Basecamp.
-
Publish Office 365-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Office 365.
-
Connect to Pushbullet Data in CloverDX (formerly CloverETL)
Transfer Pushbullet using the visual workflow in the CloverDX data integration tool.
-
Integrate Cline with Live Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Apache Avro from within your IDE.
-
Build Semantic Layer Views for WordPress Data in APOS Live Data Gateway
Use the CData Connector for WordPress in APOS Live Data Gateway to build Semantic Layer Views for WordPress.