CData Software - Knowledge Base
Recent Articles
-
Raisers Edge NXT Reporting in OBIEE with the Raisers Edge NXT JDBC Driver
Deploy the Raisers Edge NXT JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to SAS xpt Data in Ruby
Connect to SAS XPORT in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Design BIRT Reports on Drip Data
Provide current Drip to your embedded analytics.
-
Connect to SAP Business One Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP Business One.
-
Access Live BigQuery Data in AWS Lambda
Connect to live Google BigQuery in AWS Lambda using the CData JDBC Driver.
-
Connect to Aweber in SpagoBI
Create reports featuring live Aweber in SpagoBI Studio. Host Aweber reports on SpagoBI Server.
-
Easily Integrate Raisers Edge NXT Data in Lazarus Pascal IDE
Learn how to easily integrate live Raisers Edge NXT in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to SAP SuccessFactors LMS Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP SuccessFactors LMS in the Denodo Virtual DataPort Administrator.
-
Migrating data from Oracle Service Cloud to Snowflake using CData SSIS Components.
Easily push Oracle Service Cloud to Snowflake using the CData SSIS Tasks for Oracle Service Cloud and Snowflake.
-
Trigger SAP Concur IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SAP Concur with standard wizards in Logic Apps.
-
Integrate Cloudant Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to IBM Cloudant and integrate live IBM Cloudant into your Power Automate tasks.
-
How to Build an ETL App for Vimeo Data in Python with CData
Create ETL applications and real-time data pipelines for Vimeo in Python with petl.
-
Access Live MailerSend Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate MailerSend into the statistical analysis tools available in SAS JMP. This article shows how to use MailerSend in the Graph Builder and Query Builder.
-
Connect to Mocean Data in Ruby
Connect to Mocean in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Maximizing SQL Server Linked Server Efficiency with CData SQL Gateway
With the help of a series of performance tests, this article demonstrates how the newer version of CData SQL Gateway optimizes the efficiency of SQL Server Linked Server, enabling seamless reading and writing of Snowflake data within SQL Server.
-
Integrate Open WebUI with Live Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Marketo from within the chat interface.
-
Analyze Mode Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Mode in Microsoft R Open.
-
DataBind Blackbaud FE NXT Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Blackbaud FE NXT with the DevExpress Windows Forms and Web controls to provide Blackbaud FE NXT to a chart.
-
Validate BigQuery Data with QuerySurge
Access and validate Google BigQuery in QuerySurge using the CData JDBC Driver.
-
Access Live Microsoft Dataverse Data in TIBCO Data Virtualization
Use the Microsoft Dataverse Tibco DV Adapter to create a Microsoft Dataverse (CDS) data source in TIBCO Data Virtualization Studio and gain access to live Microsoft Dataverse (CDS) from your TDV Server.
-
Migrating data from Placid to Google BigQuery using CData SSIS Components.
Easily push Placid to Google BigQuery using the CData SSIS Tasks for Placid and Google BigQuery.
-
Import Real-Time OnePageCrm Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use OnePageCrm in ColdFusion.
-
Validate Microsoft OneDrive Data with QuerySurge
Access and validate Microsoft OneDrive in QuerySurge using the CData JDBC Driver.
-
Analyze Freshdesk Data in Cognos Analytics
Use CData Connect AI to connect to Freshdesk Data from Cognos Analytics and analyze live Freshdesk.
-
Analyze Klaviyo Data in Cognos Analytics
Use CData Connect AI to connect to Klaviyo Data from Cognos Analytics and analyze live Klaviyo.
-
Build Dashboards with Printify Data in Dundas BI
Create dynamic dashboards and perform analytics based on Printify in Dundas BI.
-
How to Visualize SendPulse Data in Python with pandas
Use pandas and other modules to analyze and visualize live SendPulse in Python.
-
Automated Continuous PolarTeamPro Replication to Databricks
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to Databricks.
-
Migrating data from Office 365 to Google BigQuery using CData SSIS Components.
Easily push Microsoft Office 365 to Google BigQuery using the CData SSIS Tasks for Office 365 and Google BigQuery.
-
Connect to Sage 300 Data in JRuby
Create a simple JRuby app with access to live Sage 300.
-
Getting Started with the CData Excel Add-In for Guru
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Guru.
-
Build Pipelines with Live Microsoft Entra ID Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Entra ID from Google Cloud Data Fusion, enabling the integration of live Microsoft Entra ID into the building and management of effective data pipelines.
-
Integrating Antigravity CLI with Trello via CData CLI
Connect Trello to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Google Forms Data in Pentaho Data Integration
Build ETL pipelines based on Google Forms in the Pentaho Data Integration tool.
-
Analyze Microsoft Entra ID Data in Cognos Analytics
Use CData Connect AI to connect to Microsoft Entra ID Data from Cognos Analytics and analyze live Microsoft Entra ID.
-
How to connect to Excel Online Data from IntelliJ
Integrate connectivity to Microsoft Excel Online with wizards in IntelliJ.
-
Connect to Salesloft Data from PowerBuilder via JDBC
This article demonstrates how to access Salesloft from PowerBuilder using the Salesloft JDBC Driver.
-
Getting Started with the CData ADO.NET Provider for Timely
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Pipedrive Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Pipedrive as an External Source in Dremio.
-
Visualize Live Epicor Kinetic Data in the Power BI Service
Use CData Connect AI to connect to live Epicor Kinetic and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Apps with Live Pipeline CRM Data Using the Low-Code Development Platform of Mendix
Connect Pipeline CRM with Mendix to build apps using the CData API Driver for JDBC.
-
Build a Singer.io Tap for ElevenLabs With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ElevenLabs data using
-
Create a Data Access Object for Procore Data using JDBI
A brief overview of creating a SQL Object API for Procore in JDBI.
-
Use Databricks Agent Bricks to Talk to Your Sage Intacct Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Sage Intacct for you.
-
How to Access Campaigner Data Using Entity Framework
This article shows how to access Campaigner using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData Tableau Connector for CircleCI
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Visualize Live Zoho CRM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Zoho CRM using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Establish a Live Connection with Airtable Data using Tableau Bridge
The CData ODBC Driver for Airtable enables you to integrate live Airtable into Tableau Cloud dashboards using the Tableau Bridge.
-
Create SSAS Tabular Models from Toggl Data
How to build a SQL Server Analysis Service Tabular Model from Toggl using CData drivers.
-
Access Live Smartsheet Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Smartsheet from your Google Sheets.
-
Migrating data from Sage 300 to Google BigQuery using CData SSIS Components.
Easily push Sage 300 to Google BigQuery using the CData SSIS Tasks for Sage 300 and Google BigQuery.
-
Connect to BigQuery Data from AWS Glue
Use CData Connect AI to gain access to live Google BigQuery from your AWS Glue jobs.
-
Choosing the Best Method to Connect Wrike to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Wrike from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to load Certinia data into Elasticsearch via Logstash
Introducing a simple method to load Certinia data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Customer.io Data in Talend Cloud Data Management Platform
Connect Customer.io Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use the CData Software ODBC Driver for Foursquare in MicroStrategy
Connect to Foursquare in MicroStrategy Developer using the CData Software ODBC Driver for Foursquare.
-
How to Easily Query ConvertKit Data in OpenOffice Base
Connect to ConvertKit data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Publish Reports with QuickBooks Time Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date QuickBooks Time.
-
Access Microsoft Planner Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Planner from HeidiSQL.
-
Connect to Zendesk Data in CloverDX (formerly CloverETL)
Transfer Zendesk using the visual workflow in the CloverDX data integration tool.
-
Integrate Oracle SCM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Oracle SCM with External Services.
-
Create Dynamic SAP Hybris C4C Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP Hybris C4C to Infragistics XamDataGrid to build dynamic grids.
-
Automate Trello Data Replication to Azure Data Lake
Use CData Sync to customize and automate Trello replication to Azure Data Lake.
-
Connecting Pipedream with ADP Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on ADP data in real time.
-
Consume Gmail OData Feeds in PowerBuilder
This article demonstrates how to consume Gmail as OData feeds from PowerBuilder using the API Server.
-
Use the CData Software ODBC Driver for Cosmos DB in MicroStrategy Desktop
Connect to Azure Cosmos DB in MicroStrategy Desktop using the CData Software ODBC Driver for Cosmos DB.
-
Automated PayPal Data Replication to Teradata
Use CData Sync to Customize and automate PayPal replication to Teradata.
-
Visualize Live Azure DevOps Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Azure DevOps using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Teamgate Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Teamgate from HeidiSQL.
-
How to Access Live Hive Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Hive enables you to integrate Apache Hive into workflows built using Microsoft Power Automate Desktop.
-
How to Connect to Neo4J Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Neo4J. Leverage the pyodbc module for ODBC in Python.
-
Edit and Search External Odoo Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Odoo ERP to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Odoo Data objects that you can access from apps and the dashboard.
-
Automated Continuous SurveyMonkey Replication to MySQL
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to MySQL.
-
Build an OLAP Cube in SSAS from Adobe Target Data
Establish a connection to Adobe Target data from SQL Server Analysis Services, and use the Adobe Target Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query Jodoo Data in DataGrip
Create a Data Source for Jodoo in DataGrip and use SQL to query live Jodoo.
-
Integrate with Stripe Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Stripe to a JSON file on disk.
-
Manage HDFS Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for HDFS.
-
Access Oracle Financials Cloud Data from MySQL in Amazon QuickSight
Connect to Oracle Financials Cloud and build visualizations of Oracle Financials Cloud using a MySQL Connection in Amazon QuickSight.
-
How to Build an ETL App for Nethunt Data in Python with CData
Create ETL applications and real-time data pipelines for Nethunt in Python with petl.
-
Connect to PivotalTracker Data as an External Source in Dremio
Use the CData JDBC Driver to connect to PivotalTracker as an External Source in Dremio.
-
Integrate Avaza with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Avaza with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Avaza.
-
Integrate Live Missive Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Missive to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Visualize GraphQL Data in TIBCO Spotfire through ADO.NET
Integrate GraphQL into dashboards in TIBCO Spotfire.
-
Build Apps with Live Apache HBase in Adalo using CData Connect AI
Use CData Connect AI to integrate live Apache HBase into the Adalo platform and build custom mobile and web applications with real-time Apache HBase.
-
Access Live Cvent Data in Coginiti Pro
Connect to and query live Cvent from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Replicate Google Sheets Data from PowerShell
Write a quick PowerShell script to query Google Sheets. Use connectivity to the live data to replicate Google Sheets to SQL Server.
-
Connect to Tavily Data in HULFT Integrate
Connect to Tavily as a JDBC data source in HULFT Integrate
-
Working with Moosend Data in LINQPad
Execute LINQ queries to Moosend in LINQPad.
-
Build Visualizations of Optimizely Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Optimizely in Birst.
-
LINQ to Nuclia 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 Nuclia Data Provider.
-
Automated Continuous Asana Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Asana replication to Amazon Redshift.
-
Analyze Active Directory Data in Looker
Use CData Connect AI to connect to Active Directory Data from Looker and build custom apps using live Active Directory.
-
How to integrate Blackbaud FE NXT with Apache Airflow
Access and process Blackbaud FE NXT in Apache Airflow using the CData JDBC Driver.
-
Use Dash to Build to Web Apps on Microsoft Teams Data
Create Python applications that use pandas and Dash to build Microsoft Teams-connected web apps.
-
Create Databricks-Connected Dashboards in Grafana
Connect to Databricks Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Databricks.
-
Connect to Productboard Data in DBArtisan
Use wizards in DBArtisan to configure Productboard as a data source.
-
How to integrate Metabase with SurveyMonkey Data
Use CData Connect AI to connect to live SurveyMonkey and create an interactive dashboard in Metabase from SurveyMonkey.
-
Connect to and Visualize Live Apollo Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apollo.
-
Use the CData ODBC Driver for MySQL from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for MySQL to connect to MySQL from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring MySQL in Excel.
-
Stream BambooHR Data into Apache Kafka Topics
Access and stream BambooHR in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.