CData Software - Knowledge Base
Recent Articles
-
Integrate Lakebase with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Lakebase with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Lakebase.
-
Create Reports with Oracle SCM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle SCM.
-
How to Connect Salesforce Marketing Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Salesforce Marketing data in real time using natural language.
-
How to connect to PingOne Data with Squirrel SQL client
Connect to PingOne and execute queries in the Squirrel SQL Client.
-
Create Okta-Connected Dashboards in Grafana
Connect to Okta Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Okta.
-
Import Sage Intacct Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Sage Intacct Data and provide access to live Sage Intacct for custom reports in the Power BI Service.
-
How to Seamlessly Import SAP Fieldglass Data into IBM SPSS Modeler
Integrate SAP Fieldglass data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Charts with Bullhorn CRM Data in Clear Analytics
Create dynamic charts and perform analytics based on Bullhorn CRM in Clear Analytics.
-
Connect to CircleCI Data in DBeaver
Use the CData ODBC Driver to connect to CircleCI in DBeaver.
-
Integrate Live Marketo Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Marketo to Blue Prism using the CData ODBC Driver for Marketo to create automated workflows for repetitive business tasks.
-
Connect to JobNimbus from a Connection Pool in WebLogic
Use the CData JDBC Driver for JobNimbus to connect to JobNimbus from Web applications running on WebLogic.
-
Connect to Avro Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Apache Avro in Airbyte.
-
Create a Data Access Object for Flowlu Data using JDBI
A brief overview of creating a SQL Object API for Flowlu in JDBI.
-
Create Informatica Mappings From/To an ODBC Data Source for Coda
Create an ODBC connection to Coda in Informatica and browse and transfer Coda.
-
Build Pipedrive-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Pipedrive and build Pipedrive-connected web apps with Axios.
-
Connect to Google Sheets Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Sheets Data and connect to Google Sheets in Akorbi Digital RunMyProcess.
-
Access Live Azure Table Data in Excel 365 Online (Excel for the web)
Connect to Azure Table Storage from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Query Live Exact Online Data in Claude Desktop
Connect to and query live Exact Online Data in Claude Desktop using CData MCP Server.
-
Create Informatica Mappings From/To an ODBC Data Source for Redshift
Create an ODBC connection to Redshift in Informatica and browse and transfer Amazon Redshift.
-
Query Beeminder Data in DataGrip
Create a Data Source for Beeminder in DataGrip and use SQL to query live Beeminder.
-
Connect to Cassandra Data in Claris FileMaker Pro
Use the CData ODBC Driver for Cassandra in FileMaker Pro to connect to Cassandra and work with Apache Cassandra in your FileMaker applications.
-
Integrating Helpscout Data in Talend Cloud Data Management Platform
Connect Helpscout Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to create Visio diagrams from SuiteCRM Data
Automatically update SuiteCRM with the changes you make to Visio master shapes.
-
Visualize Live AfterShip Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live AfterShip using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Bullhorn CRM Replication to MySQL
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to MySQL.
-
Access Parallel Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Parallel from HeidiSQL.
-
Visualize Oracle HCM Cloud Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Oracle HCM Cloud.
-
Automated Continuous Google Sheets Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Sheets replication to Snowflake.
-
Build SAS Data Sets-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAS Data Sets and build web apps with connectivity to live SAS Data Sets.
-
Automated Continuous PabblySubscriptions Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Apache Cassandra.
-
Automated Continuous MailChimp Replication to MySQL
Use CData Sync for automated, continuous, customizable MailChimp replication to MySQL.
-
Query Front Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Front from Node.js.
-
Connect to Shippo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Shippo.
-
Access Google Contacts Data from MySQL in PHP
Connect to Google Contacts through the standard MySQL libraries in PHP.
-
Build Dashboards with Sage Cloud Accounting Data in Dundas BI
Create dynamic dashboards and perform analytics based on Sage Business Cloud Accounting in Dundas BI.
-
Access Live Monday.com Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Monday.com from your Excel spreadsheets.
-
Integrate Google Spanner Data in the Pentaho Report Designer
Publish reports based on Google Spanner in the Pentaho BI tool.
-
How to connect PolyBase to LinkedIn
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live LinkedIn.
-
Easily Integrate Zoho Creator Data in Lazarus Pascal IDE
Learn how to easily integrate live Zoho Creator in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Live Pipedrive Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to LinkedIn Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for LinkedIn and the Script function in FileMaker Pro to connect to LinkedIn and work with LinkedIn in your FileMaker application.
-
Use the CData ODBC Driver for ZohoDesk from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ZohoDesk to connect to ZohoDesk from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ZohoDesk in Excel.
-
How to Connect the Power BI Service to SharePoint Excel Services: Complete Guide
Connect to the CData Software Power BI Connector for SharePoint Excel Services from PowerBI.com to provide real-time SharePoint Excel Services across the organization.
-
Create Informatica Mappings From/To a JDBC Data Source for Flowlu
Create Flowlu data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Provide OData Services of Oracle Eloqua Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Oracle Eloqua by developing a WCF Service Application.
-
How to connect to Cosmos DB Data with Squirrel SQL client
Connect to Azure Cosmos DB and execute queries in the Squirrel SQL Client.
-
Connect to PhantomBuster in SpagoBI
Create reports featuring live PhantomBuster in SpagoBI Studio. Host PhantomBuster reports on SpagoBI Server.
-
How to Connect to Live Sybase Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Sybase for you.
-
Query Google Analytics Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Analytics from Node.js.
-
Integrating Cursor CLI with Google Translate 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.
-
How to Build an ETL App for Oracle HCM Cloud Data in Python with CData Connect AI
Build ETL pipelines that read and write live Oracle HCM Cloud in Python with petl and the CData Connect AI Python SDK.
-
Replicate Multiple Pipeline CRM Accounts
Replicate multiple Pipeline CRM accounts to one or many databases.
-
Build Apps with Live Email in Adalo using CData Connect AI
Use CData Connect AI to integrate live Email into the Adalo platform and build custom mobile and web applications with real-time Email.
-
Build Microsoft OneDrive-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft OneDrive.
-
Connect to DB2 Data in Ruby
Connect to IBM DB2 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to LeadDesk Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time LeadDesk using standard SQL.
-
How to Work with Mixpanel Data in ETL Validator JDBC
Connect to Mixpanel from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData JDBC Driver for FTP
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for FTP.
-
Automate FHIR Data Replication to Couchbase
Use CData Sync to Customize and automate FHIR replication to Couchbase.
-
Replicate Multiple Jira Accounts
Replicate multiple Jira accounts to one or many databases.
-
Use the CData Software ODBC Driver for Vercel in MicroStrategy Web
Connect to Vercel in MicroStrategy Web using the CData Software ODBC Driver for Vercel.
-
Connect to GitLab Data from AWS Glue
Use CData Connect AI to gain access to live GitLab from your AWS Glue jobs.
-
View Reports on Real-Time Procore Data in Power BI Report Server
Use the CData ODBC Driver for Procore to visualize Procore in Power BI Desktop and then publish them to Power BI Report Server.
-
How to import Onfleet Data into Apache Solr
Use the CData Software JDBC Driver for Onfleet in Data Import Handler and create an automated import of Onfleet to Apache Solr Enterprise Search platform.
-
Getting Started with the CData ADO.NET Provider for PhantomBuster
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create Power BI Reports on Real-Time Bitbucket Data
Use the CData ODBC Driver for Bitbucket to visualize Bitbucket in Power BI Desktop.
-
Use the CData Software ODBC Driver for MessageBird in MicroStrategy Desktop
Connect to MessageBird in MicroStrategy Desktop using the CData Software ODBC Driver for MessageBird.
-
Connect to Klipfolio Data in Jaspersoft Studio
Execute SQL to remote Klipfolio in Jaspersoft Studio.
-
Access Live Zoho CRM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Zoho CRM from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Access Google Translate Data Using Entity Framework
This article shows how to access Google Translate using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Marketo Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Marketo Data and connect to Marketo in Akorbi Digital RunMyProcess.
-
Create Data Visualizations in Cognos BI with Adobe Target Data
Access Adobe Target as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live Amazon DynamoDB Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Amazon DynamoDB through MCP integration.
-
Create Reports from Salesforce CRM Analytics Data in Looker Studio
Use CData Connect AI to gain access to live Salesforce CRM Analytics and create custom reports in Looker Studio.
-
How to Work with SAP BusinessObjects BI Data in ETL Validator JDBC
Connect to SAP BusinessObjects BI from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Google Contacts to Power BI dashboards. Simply drag and drop Google Contacts into data visuals on the Power BI canvas.
-
Connect to Optimizely Data in Ruby
Connect to Optimizely in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Visualize Salesforce Data 360 Data in Python with pandas
Use pandas and other modules to analyze and visualize live Salesforce Data 360 in Python.
-
Use Biml to Build SSIS Tasks to Replicate Stack Exchange Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Stack Exchange to SQL Server.
-
Connect to REST Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for REST to connect to REST and execute queries in PowerBuilder.
-
Operational Reporting on SendPulse Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SendPulse.
-
How to connect SharePoint with xBase Data through external lists
Provide xBase to SharePoint users as an external list.
-
Access Google Campaign Manager 360 Data from MySQL in Amazon QuickSight
Connect to Google Campaign Manager 360 and build visualizations of Google Campaign Manager 360 using a MySQL Connection in Amazon QuickSight.
-
Integrating Antigravity CLI with Salesforce & Force.com via CData CLI
Connect Salesforce & Force.com to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Publish Reports with Microsoft Entra ID Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Entra ID.
-
Process & Analyze HBase Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live HBase Data.
-
Build Automated Workflows with Live Amazon Athena Data in Workato
Use CData Connect AI to connect to live Amazon Athena and build automated workflows in Workato.
-
Automated Continuous Jira Replication to Databricks
Use CData Sync for automated, continuous, customizable Jira replication to Databricks.
-
Use the CData API Server to Access Elasticsearch Data in Microsoft PowerPivot
Use the CData API Server to connect to live Elasticsearch in the Power Pivot business intelligence tool.
-
Connecting Moonlit Workflow with Stripe Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Stripe in real time.
-
Publish Reports with Zoho Inventory Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoho Inventory.
-
Query SharePoint Data as a SQL Server Database in Node.js
Execute SQL Server queries against Microsoft SharePoint from Node.js.
-
Connect to and Query Wistia Data in QlikView over ODBC
Create data visualizations with Wistia in QlikView.
-
Integrate Live Parallel Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Parallel to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Access Templated Data Using Entity Framework
This article shows how to access Templated using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Live ActiveCampaign Data in MicroStrategy through CData Connect AI
Create a live connection to ActiveCampaign Data in CData Connect AI and connect to your ActiveCampaign from MicroStrategy.
-
Build Clockify-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Clockify.
-
Connect to Square Data in Jaspersoft Studio
Execute SQL to remote Square in Jaspersoft Studio.
-
Automated Google Spanner Data Replication to Teradata
Use CData Sync to Customize and automate Google Spanner replication to Teradata.
-
Create Sybase IQ-Connected Business Apps in AppSheet
Connect to Sybase IQ Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Sybase IQ.