CData Software - Knowledge Base
Recent Articles
-
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 objects 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 data. 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 data.
-
Create Data Visualizations Based On BenchmarkEmail Data in Mode
Use CData Connect AI to connect to BenchmarkEmail Data from Mode and build visualizations using live BenchmarkEmail data.
-
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 data 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 data. 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 data.
-
Integrating Kiro 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 data into Tableau dashboards.
-
Replicate Salesforce Marketing Data from PowerShell
Write a quick PowerShell script to query Salesforce Marketing data. Use connectivity to the live data to replicate Salesforce Marketing data to SQL Server.
-
Build Charts with Twilio Data in Clear Analytics
Create dynamic charts and perform analytics based on Twilio data in Clear Analytics.
-
Create Data Visualizations in Cognos BI with Productboard Data
Access Productboard data 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 data 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 Vault CRM data.
-
Integrating Codex with HDFS 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.
-
Integrating LangGraph with Omnisend Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Omnisend data within automated workflows.
-
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 data across the organization.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Printify
Provide connectivity to Printify data 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 data 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 data with the CData JDBC Driver for Keap.
-
Integrate Microsoft Dataverse Data in the Pentaho Report Designer
Publish reports based on Microsoft Dataverse data 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 data. Leverage the native support for ODBC in PHP.
-
Integrate Highrise Data in the Pentaho Report Designer
Publish reports based on Highrise data 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 data.
-
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 data.
-
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 data into Microsoft Power Query.
-
Stream Dropbox Data into Apache Kafka Topics
Access and stream Dropbox data 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 data 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 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 data in real time.
-
Use the CData Software JDBC Driver for Clari in MicroStrategy
Connect to Clari data 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 data.
-
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 data.
-
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 data.
-
Integrating OpenCode 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 Missive Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Missive replication to Azure SQL Database.
-
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 SharePoint data 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 data 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 data.
-
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 data in LINQPad.
-
Import and Visualize Beeminder Data in Power View
Create data visualizations based on Beeminder data 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 data in the Denodo Virtual DataPort Administrator.
-
Connect to SQL Analysis Services Data in DBArtisan
Use wizards in DBArtisan to configure SQL Analysis Services data 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 data in JDBI.
-
Connect to Salesforce Data 360 in SpagoBI
Create reports featuring live Salesforce Data 360 data 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 data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to connect to Billsby Data from IntelliJ
Integrate connectivity to Billsby data 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 data 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 data.
-
Integrate QuickBooks Online Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live QuickBooks Online data 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 data 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 data 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 data to a chart.
-
Connect and Query Live Basecamp Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Basecamp data into Databricks and enable direct, live querying and analysis without replication.
-
Configure the CData JDBC Driver for ZeroBounce in a Connection Pool in Tomcat
Connect to ZeroBounce data 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.
-
Connect to Microsoft Entra ID Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Entra ID data using standard SQL.
-
Import and Visualize FreeAgent Data in Power View
Create data visualizations based on FreeAgent data in Excel.
-
Connect to SAP Netweaver Gateway Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP Netweaver Gateway data 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 data for you.
-
Back Up Google Drive data 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 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 data within automated workflows.
-
Integrate with Google Drive Data in JReport Designer
Create charts and reports based on Google Drive data 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 data 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 data 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 data 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 data 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 data 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 data 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 data 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 data into a data warehouse using Oracle Data Integrator.
-
Automate Teamwork Data Replication to Azure Data Lake
Use CData Sync to customize and automate Teamwork data 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 data 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 data without any coding.
-
Connect to Sage Intacct Data in RazorSQL
Connect to Sage Intacct from wizards and query Sage Intacct data 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 Avro data.
-
Create Avro Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Avro from PowerBI.com to create Power BI Dataflows with real-time data.
-
Import Real-Time GraphQL Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use GraphQL data in ColdFusion.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Search
Create Google Search data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to DocuSign Data in RazorSQL
Connect to DocuSign from wizards and query DocuSign data from the GUI in the RazorSQL database management tool.