CData Software - Knowledge Base
Recent Articles
-
Import Real-Time FTP via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use FTP Servers in ColdFusion.
-
How to connect PolyBase to Stripe
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Stripe.
-
Integrate with live Oracle Sales in Jitterbit
Use CData Connect AI to connect to and integrate live Oracle Sales in Jitterbit.
-
How to Connect the Power BI Service to SurveyMonkey: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Publish Reports with SAP Fieldglass in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Fieldglass.
-
Automated Continuous Outreach.io Replication to SQL Server
Use CData Sync for automated, continuous, customizable Outreach.io replication to SQL Server.
-
Integrate with PayPal in JReport Designer
Create charts and reports based on PayPal in JReport Designer.
-
How to Work with xBase in ETL Validator JDBC
Connect to xBase from ETL Validator jobs using the CData Software JDBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate DocuSign to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate DocuSign to SQL Server.
-
Use the CData Software ODBC Driver for SQL Server in MicroStrategy Web
Connect to Microsoft SQL Server in MicroStrategy Web using the CData Software ODBC Driver for SQL Server.
-
Bridge LinkedIn Connectivity with Apache NiFi
Access and process LinkedIn in Apache NiFi using the CData JDBC Driver.
-
How to Connect to Live SAP ByDesign in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SAP Business ByDesign without replication.
-
Automated WordPress Replication to Teradata
Use CData Sync to Customize and automate WordPress replication to Teradata.
-
Viewing SAP Hybris C4C in RAD Studio Data Explorer
How to view SAP Hybris C4C in RAD Studio Data Explorer using the CData ODBC Driver for SAP Hybris C4C.
-
Create GraphQL Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Publish Reports with Dynamics NAV in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Dynamics NAV.
-
Build Dashboards with Dynamics 365 Business Central in Dundas BI
Create dynamic dashboards and perform analytics based on Dynamics 365 Business Central in Dundas BI.
-
Connect to and Visualize Live Facebook in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Facebook.
-
Automated Continuous Parquet Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Parquet replication to Apache Kafka.
-
How to update Snapchat Ads from Excel
This article explains how to transfer data from Excel to Snapchat Ads using the Excel Add-In for Snapchat Ads.
-
Create a Data Access Object for SAP ByDesign using JDBI
A brief overview of creating a SQL Object API for SAP Business ByDesign in JDBI.
-
Integrating Claude Code with Snowflake via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Snowflake within assisted coding and automated development workflows.
-
Query WordPress through ODBC in Node.js
Use node-odbc to execute SQL queries against WordPress from Node.js.
-
Getting Started with the CData SSIS Components for Databricks
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Databricks.
-
Access Live Zoho Creator in Excel 365 Online (Excel for the web)
Connect to Zoho Creator from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Getting Started with the CData ODBC Driver for eBay
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for eBay.
-
Import Real-Time Oracle SCM via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Oracle SCM in ColdFusion.
-
Access Live SAP Netweaver Gateway in Coginiti Pro
Connect to and query live SAP Netweaver Gateway from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software JDBC Driver for Sage Cloud Accounting in MicroStrategy
Connect to Sage Business Cloud Accounting in MicroStrategy Developer using the CData Software JDBC Driver for Sage Cloud Accounting.
-
Consume SurveyMonkey OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SurveyMonkey feeds that reflect any changes in SAP Lumira.
-
Integrate Real-Time Access to EnterpriseDB in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to EnterpriseDB in real time.
-
Replicate Multiple Google Sheets Accounts via the CData Sync CLI
Replicate multiple Google Sheets accounts to one or many databases.
-
Using the CData Software ODBC Driver for Todoist in PyCharm
Connect to Todoist as an ODBC data source in PyCharm using the CData Software ODBC Driver for Todoist.
-
Automated Continuous Vault CRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Vault CRM replication to PostgreSQL.
-
Replicate Phoenix in Heroku for Use in Salesforce Connect
Replicate Apache Phoenix to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Consume Google Analytics OData Feeds in PowerBuilder
This article demonstrates how to consume Google Analytics as OData feeds from PowerBuilder using the API Server.
-
Query PayPal through ODBC in Node.js
Use node-odbc to execute SQL queries against PayPal from Node.js.
-
DataBind Charts to Zoho Creator
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho Creator 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.
-
Access Live Sage Cloud Accounting in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sage Business Cloud Accounting from your Google Sheets.
-
Connect to XML from a Connection Pool in JBoss
Integrate XML Files into Java servlets: Use the Management Console in JBoss to install the XML JDBC Driver.
-
Connect and Visualize Live Workday Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Workday into the Databricks platform and create visualization dashboards with real-time Workday.
-
Use JayDeBeApi to access Paylocity in Python
Use standard Python scripting and the development environment of your choice to access live Paylocity.
-
Analyze Salesloft with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Salesloft from Power Pivot. You will use the Table Import Wizard to load Salesloft. You can visually build the import query or use any SQL supported by the driver.
-
Import Real-Time Presto via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Presto in ColdFusion.
-
Publish Neo4J-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Neo4J.
-
Connect to Azure Active Directory in SpagoBI
Create reports featuring live Azure Active Directory in SpagoBI Studio. Host Azure Active Directory reports on SpagoBI Server.
-
Build Sugar CRM-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Sugar CRM and create custom apps in Mendix.
-
Use the CData Software ODBC Driver for Azure Analysis Services in MicroStrategy
Connect to Azure Analysis Services in MicroStrategy Developer using the CData Software ODBC Driver for Azure Analysis Services.
-
Automated Continuous Pipedrive Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Pipedrive replication to Google BigQuery.
-
How to integrate Metabase with Google Analytics
Use CData Connect AI to connect to live Google Analytics and create an interactive dashboard in Metabase from Google Analytics.
-
Azure DevOps Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Azure DevOps through CData Connect AI using different applications and tools.
-
Access Live SAP Ariba Procurement in AWS Lambda
Connect to live SAP Ariba Procurement in AWS Lambda using the CData JDBC Driver.
-
LINQ to Amazon S3
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Amazon S3 Data Provider.
-
Replicate Multiple Unbounce Accounts
Replicate multiple Unbounce accounts to one or many databases.
-
Provide OData Services of MongoDB from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for MongoDB by developing a WCF Service Application.
-
Connect to OData Services in RapidMiner
Integrate OData with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Reckon to Power BI dashboards. Simply drag and drop Reckon into data visuals on the Power BI canvas.
-
Build a Simple VCL Application for Tally
How to build a simple VCL Application to view Tally ERP in RAD Studio using the CData ODBC Driver for Tally.
-
Object-Relational Mapping (ORM) with Stripe 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 Stripe into a Java-based ORM framework, Hibernate.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Sage 300 to Power BI dashboards. Simply drag and drop Sage 300 into data visuals on the Power BI canvas.
-
Load Greenplum to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Pivotal GreenPlum to a database.
-
How to connect SharePoint with Authorize.Net through external lists
Provide Authorize.Net to SharePoint users as an external list.
-
Connect to Neo4J in RapidMiner
Integrate Neo4J with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Salesforce Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Salesforce replication to Amazon S3.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
How to Connect to Live Paylocity in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Paylocity without replication.
-
Bidirectional Access to Slack from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Slack in Filemaker Pro for Mac or Windows.
-
How to Seamlessly Import ShipStation Data into IBM SPSS Modeler
Integrate ShipStation data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Load ClickUp to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ClickUp to a database.
-
Connect to and Visualize Live LinkedIn Ads in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live LinkedIn Ads.
-
Connect to Real-Time MariaDB Data in Power Apps Using Dataflows to Build Custom Applications
-