CData Software - Knowledge Base
Recent Articles
-
How to Seamlessly Import MailerLite Data into IBM SPSS Modeler
Integrate MailerLite data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Dynamics CRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Dynamics CRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft Dynamics CRM.
-
Build Amazon S3-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Amazon S3 to explore live Amazon S3 Data in Claude Code to assist with building Amazon S3-powered applications.
-
Automated Continuous Cassandra Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Cassandra replication to Amazon S3.
-
Build Pipelines with Live Oracle Eloqua Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Oracle Eloqua from Google Cloud Data Fusion, enabling the integration of live Oracle Eloqua into the building and management of effective data pipelines.
-
Automate Sage Intacct Data Replication to Couchbase
Use CData Sync to Customize and automate Sage Intacct replication to Couchbase.
-
Getting Started with the CData Excel Add-In for Trello
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Trello.
-
Analyze EmailOctopus Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of EmailOctopus and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to connect and process PostgreSQL from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live PostgreSQL.
-
Automated Continuous Avalara AvaTax Replication to SQLite
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to SQLite.
-
Integrating LangGraph with Authorize.Net Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Authorize.Net within automated workflows.
-
Prepare, Blend, and Analyze Eventbrite Data in Alteryx Designer (ODBC)
Build workflows to access live Eventbrite for self-service data analytics.
-
DataBind Charts to Freshteam Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Freshteam 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.
-
Automated Continuous Attio Replication to SQLite
Use CData Sync for automated, continuous, customizable Attio replication to SQLite.
-
Integrate Rebilly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Rebilly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Rebilly.
-
Use the CData Software JDBC Driver for Toggl in MicroStrategy
Connect to Toggl in MicroStrategy Developer using the CData Software JDBC Driver for Toggl.
-
Access Live Acumatica Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Acumatica ERP into the statistical analysis tools available in SAS JMP. This article shows how to use Acumatica ERP in the Graph Builder and Query Builder.
-
Configure the CData JDBC Driver for Insightly in a Connection Pool in Tomcat
Connect to Insightly from a connection pool in Tomcat.
-
Create Datasets from Zoho Inventory in Domo Workbench and Build Visualizations of Zoho Inventory Data in Domo
Use the CData Software ODBC Driver for Zoho Inventory to create datasets from Zoho Inventory in Domo Workbench and then build visualizations in the Domo service.
-
Create a Data Access Object for MongoDB Data using JDBI
A brief overview of creating a SQL Object API for MongoDB in JDBI.
-
Connect to Google Directory Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Directory as an External Source in Dremio.
-
Build Automated Facebook-Connected Workflows in Zapier
Use CData Connect AI to connect to live Facebook and build automated workflows in Zapier.
-
Access Live Adobe Experience Manager Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Adobe Experience Manager into the statistical analysis tools available in SAS JMP. This article shows how to use Adobe Experience Manager in the Graph Builder and Query Builder.
-
Query SingleStore Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SingleStore and perform CRUD operations on SingleStore from Node.js.
-
Design BIRT Reports on Insightly Data
Provide current Insightly to your embedded analytics.
-
How to connect to SAP SuccessFactors Data from Spring Boot
Connect to SAP SuccessFactors in a Spring Boot Application using the CData JDBC Driver for SAP SuccessFactors
-
How to Seamlessly Import Microsoft Teams Data into IBM SPSS Modeler
Integrate Microsoft Teams data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Greenplum Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Greenplum replication to Amazon Redshift.
-
Integrate Instagram Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Instagram and integrate live Instagram into your Power Automate tasks.
-
Access Live Tally Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Tally ERP from your Google Sheets.
-
How to Visualize SAP Ariba Procurement Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP Ariba Procurement in Python.
-
Use the CData ODBC Driver for Jira Assets from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Jira Assets to connect to Jira Assets from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Jira Assets in Excel.
-
View Reports on Real-Time Datadog Data in Power BI Report Server
Use the CData ODBC Driver for Datadog to visualize Datadog in Power BI Desktop and then publish them to Power BI Report Server.
-
Analyze WooCommerce Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze WooCommerce in Microsoft R Open.
-
Extend Google Sheets with Rebilly Data
Make calls to Rebilly from Google Apps Script via the API Server.
-
Prepare, Blend, and Analyze Jira Assets Data in Alteryx Designer (Connect AI)
Build workflows to access live Jira Assets for self-service data analytics.
-
Integrating Dataiku with Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Zendesk.
-
Edit and Search External Microsoft Planner Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft Planner to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Microsoft Planner Data objects that you can access from apps and the dashboard.
-
Use the CData Software ODBC Driver for Zoho Creator in MicroStrategy
Connect to Zoho Creator in MicroStrategy Developer using the CData Software ODBC Driver for Zoho Creator.
-
How to work with AfterShip Data in Apache Spark using SQL
Access and process AfterShip Data in Apache Spark using the CData Software JDBC Driver.
-
How to Easily Query Stripe Data in OpenOffice Base
Connect to Stripe data in OpenOffice Base using the CData ODBC Driver for Stripe and generate reports with live data insights.
-
Analyze Exact Online Data in Cognos Analytics
Use CData Connect AI to connect to Exact Online Data from Cognos Analytics and analyze live Exact Online.
-
Connect to Anaplan Data in HULFT Integrate
Connect to Anaplan as a JDBC data source in HULFT Integrate
-
Explore Geographical Relationships in xBase Data with Power Map
Create data visualizations with xBase in Power Map.
-
Connect Yelp to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Yelp with IBM WebSphere for seamless data integration and connectivity.
-
A PostgreSQL Interface for Copper Data using the CData ODBC Driver
Use the SQL Gateway and Copper ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to BigCommerce Data in CloverDX (formerly CloverETL)
Transfer BigCommerce using the visual workflow in the CloverDX data integration tool.
-
Create SSAS Tabular Models from ClickTime Data
How to build a SQL Server Analysis Service Tabular Model from ClickTime using CData drivers.
-
How to create PhantomBuster federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for PhantomBuster in MySQL .
-
Use the CData Software ODBC Driver for SAP Business One in MicroStrategy
Connect to SAP Business One in MicroStrategy Developer using the CData Software ODBC Driver for SAP Business One.
-
How to load WordPress data into Elasticsearch via Logstash
Introducing a simple method to load WordPress data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to work with xBase Data in Apache Spark using SQL
Access and process xBase Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Office 365 Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Office 365 replication to Google BigQuery.
-
Extract, Transform, and Load Raisers Edge NXT Data in Informatica PowerCenter
Create a simple Workflow for Raisers Edge NXT in Informatica PowerCenter.
-
How to Query Live CouchDB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Apache CouchDB data in natural language using Python.
-
Rapidly Develop Salesforce Data 360-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 Salesforce Data 360.
-
Visualize SAP SuccessFactors Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP SuccessFactors.
-
Automated Continuous MongoDB Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable MongoDB replication to Apache Kafka.
-
Connect to SAP BusinessObjects BI Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP BusinessObjects BI.
-
Building Dynamic Web Pages with Square Data Using AngularJS
Create single-page applications with live connectivity to Square using the CData API Server.
-
How to Connect to Float Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Float. Leverage the pyodbc module for ODBC in Python.
-
How to Build an ETL App for Apify Data in Python with CData
Create ETL applications and real-time data pipelines for Apify in Python with petl.
-
Connect to Coda Data in DBArtisan
Use wizards in DBArtisan to configure Coda as a data source.
-
Automated Continuous FHIR Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable FHIR replication to delimited files (CSV/TSV).
-
How to connect to Azure Data Catalog Data in DBVisualizer
Integrate Azure Data Catalog with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Dynamic Amazon S3 Grids Using the Infragistics XamDataGrid
Learn how you can connect Amazon S3 to Infragistics XamDataGrid to build dynamic grids.
-
Automate MongoDB Integration Tasks from PowerShell
Are you in search of a quick and easy way to access MongoDB from PowerShell? This article demonstrates how to utilize the MongoDB Cmdlets for tasks like connecting to MongoDB, automating operations, downloading data, and more.
-
Visualize Google Drive 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 Google Drive into TIBCO Spotfire.
-
How to Seamlessly Import MYOB AccountRight Data into IBM SPSS Modeler
Integrate MYOB AccountRight data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create Timely Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Timely from PowerBI.com to create Power BI Dataflows with real-time data.
-
Provide OData Services of Suadeo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Suadeo by developing a WCF Service Application.
-
Connect to ClickUp Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating Gumloop with Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Oracle Financials Cloud within automated workflows.
-
Use the CData Software JDBC Driver for VWO in MicroStrategy
Connect to VWO in MicroStrategy Developer using the CData Software JDBC Driver for VWO.
-
How to Easily Query SharePoint Data in OpenOffice Base
Connect to SharePoint data in OpenOffice Base using the CData ODBC Driver for SharePoint and generate reports with live data insights.
-
Creating Google Ad Manager-Connected Applications in Unqork
You can use CData Connect AI to feed Google Ad Manager to Unqork and build custom business apps.
-
Configure the CData JDBC Driver for Demio in a Connection Pool in Tomcat
Connect to Demio from a connection pool in Tomcat.
-
Establish a Live Connection with Stripe Data using Tableau Bridge
The CData ODBC Driver for Stripe enables you to integrate live Stripe into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Dashboards with Oracle Data in Dundas BI
Create dynamic dashboards and perform analytics based on Oracle Database in Dundas BI.
-
How to import Shortcut Data into Apache Solr
Use the CData Software JDBC Driver for Shortcut in Data Import Handler and create an automated import of Shortcut to Apache Solr Enterprise Search platform.
-
Create Reports with Jira Assets Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Jira Assets.
-
Analyze SAP HANA Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP HANA and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
GitHub Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to GitHub through CData Connect AI using different applications and tools.
-
Prepare, Blend, and Analyze Snapchat Ads Data in Alteryx Designer (Connect AI)
Build workflows to access live Snapchat Ads for self-service data analytics.
-
Automated Continuous Google Spanner Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Spanner replication to Amazon Redshift.
-
Create ServiceDesk Plus Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ServiceDesk Plus data access from reports, embedded analytics, and more.
-
Replicate Kafka Data in Heroku for Use in Salesforce Connect
Replicate Apache Kafka to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access ZendeskSell Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ZendeskSell from HeidiSQL.
-
Create Apps from HBase Data in Qlik Sense Cloud
Use CData Connect AI to connect to HBase Data and build apps from live Apache HBase in Qlik Sense Cloud.
-
Use CData Connect AI to Access Oracle SCM Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle SCM in the Power Pivot business intelligence tool.
-
Create Informatica Mappings From/To an ODBC Data Source for Presto
Create an ODBC connection to Presto in Informatica and browse and transfer Presto.
-
Build MessageBird-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live MessageBird.
-
How to Connect to Live Oracle Sales 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 Oracle Sales for you.
-
Create a Data Access Object for Figshare Data using JDBI
A brief overview of creating a SQL Object API for Figshare in JDBI.
-
Query RSS Feeds in DataGrip
Create a Data Source for RSS in DataGrip and use SQL to query live RSS Feeds.
-
Validate Clari Data with QuerySurge
Access and validate Clari in QuerySurge using the CData JDBC Driver.
-
Migrating data from Oracle Eloqua to Databricks using CData SSIS Components.
Easily push Oracle Eloqua to Databricks using the CData SSIS Tasks for Oracle Eloqua and Databricks.
-
Connect to Real-Time Exact Online Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Exact Online and Dataflow to import and use Exact Online in Power Apps.
-
Getting Started with the CData JDBC Driver for PivotalTracker
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for PivotalTracker.
-
Access PivotalTracker Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access PivotalTracker from your Oracle system.