CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData SSIS Components for Adobe Commerce
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Adobe Commerce.
-
Publish Databricks-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Databricks.
-
Connect to SAP Netweaver Gateway Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Netweaver Gateway and the Script function in FileMaker Pro to connect to SAP Netweaver Gateway and work with SAP Netweaver Gateway in your FileMaker application.
-
Build SurveyMonkey Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SurveyMonkey and build visualizations in Tableau Cloud.
-
Access Live Dynamics 365 Business Central Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Dynamics 365 Business Central in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Object-Relational Mapping (ORM) with LDAP Objects 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 LDAP into a Java-based ORM framework, Hibernate.
-
How to Connect to JobNimbus Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to JobNimbus. Leverage the pyodbc module for ODBC in Python.
-
How to connect PolyBase to Teradata
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Teradata.
-
DataBind Keap Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Keap to a chart.
-
Connect to ConstantContact Data in HULFT Integrate
Connect to ConstantContact as a JDBC data source in HULFT Integrate
-
Natively Connect to PhantomBuster Data in PHP
The CData ODBC driver for PhantomBuster enables you to create PHP applications with connectivity to PhantomBuster. Leverage the native support for ODBC in PHP.
-
Connect to Salesforce CRM Analytics Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Salesforce CRM Analytics.
-
Integrating Kiro CLI with Bugsnag 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.
-
Build AI/ML Models with Live Egnyte Data using Dataiku
Connect Egnyte Data with Dataiku using the CData API Driver for JDBC.
-
How to publish and share ADP Data dashboards with Tableau Server
The CData ODBC driver for ADP enables you integrate ADP into Tableau dashboards.
-
Replicate Salesforce Marketing Data from PowerShell
Write a quick PowerShell script to query Salesforce Marketing Cloud. Use connectivity to the live data to replicate Salesforce Marketing Cloud to SQL Server.
-
Build Charts with Twilio Data in Clear Analytics
Create dynamic charts and perform analytics based on Twilio in Clear Analytics.
-
Create Data Visualizations in Cognos BI with Productboard Data
Access Productboard as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Extract, Transform, and Load VWO Data in Informatica PowerCenter
Create a simple Workflow for VWO in Informatica PowerCenter.
-
LINQ to Pingdom Data
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 Pingdom Data Provider.
-
Create Vault CRM-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Vault CRM Data from OutSystems and build custom enterprise apps using live Veeva Vault & Vault CRM.
-
Integrating Codex CLI with Apache HDFS 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 Connect the Power BI Service to Gorgias: Complete Guide
Connect to the CData Software Power BI Connector for Gorgias from PowerBI.com to provide real-time Gorgias across the organization.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Printify
Provide connectivity to Printify through an SAP BusinessObjects universe.
-
Integrate Cursor with Live Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Authorize.Net from within the editor.
-
Analyze Keap Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Keap with the CData JDBC Driver for Keap.
-
Integrate Microsoft Dataverse Data in the Pentaho Report Designer
Publish reports based on Microsoft Dataverse (CDS) in the Pentaho BI tool.
-
Natively Connect to Sentry Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Sentry. Leverage the native support for ODBC in PHP.
-
Integrate Highrise Data in the Pentaho Report Designer
Publish reports based on Highrise CRM in the Pentaho BI tool.
-
How to Seamlessly Import Outreach.io Data into IBM SPSS Modeler
Integrate Outreach.io data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize Salesforce Marketing Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Salesforce Marketing Cloud.
-
Create Yelp Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Yelp data access from reports, embedded analytics, and more.
-
Integrate Mailjet with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Mailjet with External Services.
-
Visualize Trello Data in Sisense
Create an ElastiCube in Sisense app with access to Trello.
-
Automated Continuous FreshBooks Replication to Databricks
Use CData Sync for automated, continuous, customizable FreshBooks replication to Databricks.
-
Use the CData ODBC Driver for SpaceX in Microsoft Power Query
You can use the CData SpaceX ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SpaceX into Microsoft Power Query.
-
Stream Dropbox Data into Apache Kafka Topics
Access and stream Dropbox in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Work with DB2 Data in ETL Validator JDBC
Connect to DB2 from ETL Validator jobs using the CData Software JDBC Driver.
-
How to create Visio diagrams from Oracle Sales Data
Automatically update Oracle Sales with the changes you make to Visio master shapes.
-
How to Query Live Toggl Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Toggl data in natural language using Python.
-
Integrate Real-Time Access to IBM Informix in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to IBM Informix in real time.
-
Use the CData Software JDBC Driver for Clari in MicroStrategy
Connect to Clari in MicroStrategy Developer using the CData Software JDBC Driver for Clari.
-
Connect to Redis Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Redis.
-
Getting Started with the CData ADO.NET Provider for Oracle HCM Cloud
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Oracle HCM Cloud.
-
Getting Started with the CData Power BI Connector for Adobe Experience Manager
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Adobe Experience Manager.
-
Access Strava 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 Strava.
-
Integrate Live Gmail Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Gmail from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Gmail.
-
Integrating OpenCode Terminal with Stripe 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 Dynamics 365 Business Central Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Amazon Redshift.
-
Replicate SharePoint Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft SharePoint to disparate databases with a single configuration.
-
Visualize Live FHIR Data in the Power BI Service
Use CData Connect AI to connect to live FHIR and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Splunk with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Splunk with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Splunk.
-
Automated Continuous Paylocity Replication to Oracle
Use CData Sync for automated, continuous, customizable Paylocity replication to Oracle.
-
Working with Telegram Data in LINQPad
Execute LINQ queries to Telegram in LINQPad.
-
Import and Visualize Beeminder Data in Power View
Create data visualizations based on Beeminder in Excel.
-
Process & Analyze Sage 200 Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Sage 200 Data.
-
Connect to DocuSign Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for DocuSign in the Denodo Virtual DataPort Administrator.
-
Connect to SQL Analysis Services Data in DBArtisan
Use wizards in DBArtisan to configure SQL Analysis Services as a data source.
-
Create a Data Access Object for Freshdesk Data using JDBI
A brief overview of creating a SQL Object API for Freshdesk in JDBI.
-
Connect to Salesforce Data 360 in SpagoBI
Create reports featuring live Salesforce Data 360 in SpagoBI Studio. Host Salesforce Data 360 reports on SpagoBI Server.
-
Connect to Stripe Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Stripe as an External Source in Dremio.
-
How to Use a Microsoft Access Database to Update Airtable Data in Real Time
Update Airtable data by creating a linked table in Microsoft Access with the CData Airtable ODBC Driver.
-
Connect to Eventbrite Data in Ruby
Connect to Eventbrite in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to connect to Billsby Data from IntelliJ
Integrate connectivity to Billsby with wizards in IntelliJ.
-
Analyze Sendwithus Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Sendwithus with the CData JDBC Driver for Sendwithus.
-
Create Smartsheet-Connected Business Apps in AppSheet
Connect to Smartsheet Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Smartsheet.
-
Integrate QuickBooks Online Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live QuickBooks Online from Informatica Cloud.
-
Visualize Live Planio Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Planio using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Pinecone from a Connection Pool in WebLogic
Use the CData JDBC Driver for Pinecone to connect to Pinecone from Web applications running on WebLogic.
-
How to Work with Opsgenie Data in ETL Validator JDBC
Connect to Opsgenie from ETL Validator jobs using the CData Software JDBC Driver.
-
DataBind ZohoInvoice Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ZohoInvoice to a chart.
-
Connect and Query Live Basecamp Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Basecamp into Databricks
-
Configure the CData JDBC Driver for ZeroBounce in a Connection Pool in Tomcat
Connect to ZeroBounce from a connection pool in Tomcat.
-
How to Work with Greenplum Data in AWS Glue Jobs Using JDBC
Connect to Greenplum from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Query Live Salesforce CRM Analytics Data in Claude Desktop
Connect to and query live Salesforce CRM Analytics Data in Claude Desktop using CData MCP Server.
-
Connect to Microsoft Entra ID Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Entra ID using standard SQL.
-
How to connect PolyBase to Drift
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Drift.
-
Import and Visualize FreeAgent Data in Power View
Create data visualizations based on FreeAgent in Excel.
-
Connect to SAP Netweaver Gateway Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP Netweaver Gateway in Google Apps Script.
-
Use Grok to Talk to Your Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Google Ad Manager for you.
-
Back Up Google Drive to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Drive. In this article, we will employ an SSIS workflow to populate a database with Google Drive data.
-
Integrating LangGraph with Shopify Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Shopify within automated workflows.
-
Integrate with Google Drive Data in JReport Designer
Create charts and reports based on Google Drive in JReport Designer.
-
Object-Relational Mapping (ORM) with Perplexity Data 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 Perplexity into a Java-based ORM framework, Hibernate.
-
Automated Continuous Everhour Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Everhour replication to delimited files (CSV/TSV).
-
Integrate Live Vercel Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Vercel to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build Zuora-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Zuora Data and create custom apps in Bubble.
-
Connect to Workday in SpagoBI
Create reports featuring live Workday in SpagoBI Studio. Host Workday reports on SpagoBI Server.
-
Edit and Search External Email Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Email to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Email Data objects that you can access from apps and the dashboard.
-
Access Live Dynamics 365 Business Central Data in Coginiti Pro
Connect to and query live Dynamics 365 Business Central from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
IBM Informix Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to IBM Informix through CData Connect AI using different applications and tools.
-
Integrate with Oracle Sales Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Oracle Sales in SnapLogic.
-
Replicate Multiple Chargebee Accounts
Replicate multiple Chargebee accounts to one or many databases.
-
Build a PostgreSQL Interface for Marketo Data using the CData JDBC Driver
Use the Remoting features of the Marketo JDBC Driver to create a PostgreSQL entry-point for data access.
-
ETL Google Spanner in Oracle Data Integrator
This article shows how to transfer Google Spanner into a data warehouse using Oracle Data Integrator.
-
Automate Teamwork Data Replication to Azure Data Lake
Use CData Sync to customize and automate Teamwork replication to Azure Data Lake.
-
Visualize Blackbaud FE NXT Data in Tableau
The CData ODBC driver for Blackbaud FE NXT enables you integrate Blackbaud FE NXT into Tableau dashboards.
-
How to create an RPA flow for ZohoSubscriptions Data in UiPath Studio
Use the ZohoSubscriptions ODBC Driver to create workflows that access real-time ZohoSubscriptions without any coding.
-
Connect to Sage Intacct Data in RazorSQL
Connect to Sage Intacct from wizards and query Sage Intacct from the GUI in the RazorSQL database management tool.
-
Create Avro-Connected Business Apps in AppSheet
Connect to Avro Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Apache Avro.