CData Software - Knowledge Base
Recent Articles
-
Access Live SparkPost Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SparkPost into the statistical analysis tools available in SAS JMP. This article shows how to use SparkPost in the Graph Builder and Query Builder.
-
Connect to MariaDB Data in RazorSQL
Connect to MariaDB from wizards and query MariaDB from the GUI in the RazorSQL database management tool.
-
Connect to Live ADP Data in PostGresSQL Interface through CData Connect AI
Create a live connection to ADP in CData Connect AI and connect to your ADP from PostgreSQL.
-
Working with Neo4J Data in LINQPad
Execute LINQ queries to Neo4J in LINQPad.
-
DataBind Charts to Everhour Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Everhour 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.
-
Work with Demio Data in FoxPro
Load Demio into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Access Active Directory Data Using Entity Framework
This article shows how to access Active Directory using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connecting Pipedream with IBM Informix 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 IBM Informix data in real time.
-
Connect to Vercel Data from PowerBuilder via JDBC
This article demonstrates how to access Vercel from PowerBuilder using the Vercel JDBC Driver.
-
Automate Sage Intacct Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sage Intacct from PowerShell? This article demonstrates how to utilize the Sage Intacct Cmdlets for tasks like connecting to Sage Intacct, automating operations, downloading data, and more.
-
Import Real-Time Beeminder Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Beeminder in ColdFusion.
-
Excel Spreadsheet Automation on Snowflake Data with the QUERY Formula
Pull data from Snowflake, automate spreadsheets, and more with the QUERY formula.
-
How to connect PolyBase to QuickBooks
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live QuickBooks Desktop.
-
Explore Geographical Relationships in Monday.com Data with Power Map
Create data visualizations with Monday.com in Power Map.
-
Create Data Visualizations in Cognos BI with Clari Data
Access Clari as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to import Retently Data into Apache Solr
Use the CData Software JDBC Driver for Retently in Data Import Handler and create an automated import of Retently to Apache Solr Enterprise Search platform.
-
Integrating Dataiku with Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Azure Synapse.
-
Create iContact Dataflows on PowerBI.com
Connect to the CData Power BI Connector for iContact from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Avalara AvaTax Data from PowerBuilder via JDBC
This article demonstrates how to access Avalara AvaTax from PowerBuilder using the Avalara AvaTax JDBC Driver.
-
DataBind Controls to XML Data in C++Builder
DataBind to XML Files in C++Builder with standard components and controls.
-
Prepare, Blend, and Analyze Avalara AvaTax Data in Alteryx Designer (Connect AI)
Build workflows to access live Avalara AvaTax for self-service data analytics.
-
Object-Relational Mapping (ORM) with YouTube Analytics 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 YouTube Analytics into a Java-based ORM framework, Hibernate.
-
Automated Continuous FHIR Replication to Snowflake
Use CData Sync for automated, continuous, customizable FHIR replication to Snowflake.
-
Create Power BI Reports on Real-Time Customer.io Data
Use the CData ODBC Driver for Customer.io to visualize Customer.io in Power BI Desktop.
-
Connect to Google Sheets Data in DBArtisan
Use wizards in DBArtisan to configure Google Sheets as a data source.
-
Visualize Live CapsuleCRM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live CapsuleCRM using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Live SAP Business One Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP Business One in CData Connect AI and connect to your SAP Business One from PostgreSQL.
-
How to Connect to Live Snapchat Ads 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 Snapchat Ads for you.
-
Use the CData Software JDBC Driver for CapsuleCRM in MicroStrategy
Connect to CapsuleCRM in MicroStrategy Developer using the CData Software JDBC Driver for CapsuleCRM.
-
DataBind Controls to Invoiced Data in C++Builder
DataBind to Invoiced in C++Builder with standard components and controls.
-
FHIR Reporting in OBIEE with the FHIR JDBC Driver
Deploy the FHIR JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to create Visio diagrams from SAP Hybris C4C Data
Automatically update SAP Hybris C4C with the changes you make to Visio master shapes.
-
Connect Reckon Accounts Hosted Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Reckon Accounts Hosted using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automate Oracle Eloqua Reporting Data Replication to Azure Data Lake
Use CData Sync to customize and automate Oracle Eloqua Reporting replication to Azure Data Lake.
-
Visualize Live Google Contacts Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Contacts.
-
Use the CData Software ODBC Driver for Vimeo in MicroStrategy Desktop
Connect to Vimeo in MicroStrategy Desktop using the CData Software ODBC Driver for Vimeo.
-
Automate Tasks in Power Automate Using the CData API Server
Automate GitHub actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Integrate with LinkedIn Ads Data in JReport Designer
Create charts and reports based on LinkedIn Ads in JReport Designer.
-
Model, Search, and Visualize Live Salesforce CRM Analytics Data in ThoughtSpot
Use CData Connect AI to connect to live Salesforce CRM Analytics for modeling, searching, and visualizing.
-
Build Rootly-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Rootly Data in GitHub Copilot to assist with building Rootly-powered applications.
-
How to Easily Query Yelp Data in OpenOffice Base
Connect to Yelp data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Creating PostgreSQL-Connected Applications in Unqork
You can use CData Connect AI to feed PostgreSQL to Unqork and build custom business apps.
-
How to import Grafana Data into Apache Solr
Use the CData Software JDBC Driver for Grafana in Data Import Handler and create an automated import of Grafana to Apache Solr Enterprise Search platform.
-
How to Create Power BI Visual Reports with Real-Time SAP Hybris C4C Data
Use CData Power BI Connectors to visualize SAP Hybris C4C in Power BI.
-
Connect to Hubstaff Data in RapidMiner
Integrate Hubstaff with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Biml to Build SSIS Tasks to Replicate Oracle Eloqua Reporting Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle Eloqua Reporting to SQL Server.
-
Visualize Perplexity Data in Sisense
Create an ElastiCube in Sisense app with access to Perplexity.
-
Connect to Amazon S3 Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Amazon S3 and the SQL Gateway to access Amazon S3 from Google Apps Script.
-
Use the CData Software ODBC Driver for Hacker News in MicroStrategy
Connect to Hacker News in MicroStrategy Developer using the CData Software ODBC Driver for Hacker News.
-
Visualize Brex Data in TIBCO Spotfire through OData
Integrate Brex into dashboards in TIBCO Spotfire.
-
Connect to Browserless Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Browserless in the Denodo Virtual DataPort Administrator.
-
Analyze Freshservice Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Freshservice in Microsoft R Open.
-
Automate OnePageCrm Data Replication to Couchbase
Use CData Sync to Customize and automate OnePageCrm replication to Couchbase.
-
Natively Connect to Active Directory Data in PHP
The CData ODBC driver for Active Directory enables you to create PHP applications with connectivity to Active Directory. Leverage the native support for ODBC in PHP.
-
Create Dynamic SAP Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP to Infragistics XamDataGrid to build dynamic grids.
-
Getting Started with the CData ODBC Driver for CSV
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for CSV.
-
Connecting Mastra with Kintone Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Kintone, no replication required.
-
Automated Continuous Kintone Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Kintone replication to Apache Cassandra.
-
Import Real-Time Adobe Experience Manager Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Adobe Experience Manager in ColdFusion.
-
Connect to and Visualize Live EnterpriseDB Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live EnterpriseDB.
-
Build Voice Agents in ElevenLabs with access to Live ServiceNow Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live ServiceNow.
-
Integrate Real-Time Access to Tickspot in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Tickspot in real time.
-
Query SAP BusinessObjects BI Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP BusinessObjects BI and perform CRUD operations on SAP BusinessObjects BI from Node.js.
-
How to integrate SendPulse with Apache Airflow
Access and process SendPulse in Apache Airflow using the CData JDBC Driver.
-
How to create Dynamics CRM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Dynamics CRM in MySQL .
-
Create Power BI Reports on Real-Time LeadDesk Data
Use the CData ODBC Driver for LeadDesk to visualize LeadDesk in Power BI Desktop.
-
Import Dynamics CRM Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Dynamics CRM. In this article, you will use the OData format to import Microsoft Dynamics CRM into Microsoft Power Query.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Calendly
Provide connectivity to Calendly through an SAP BusinessObjects universe.
-
Visualize Sage Cloud Accounting Data in Tableau
The CData ODBC driver for Sage Cloud Accounting enables you integrate Sage Business Cloud Accounting into Tableau dashboards.
-
Connect to ServiceNow Data in Aqua Data Studio
Access ServiceNow from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Pipeliner CRM-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Pipeliner CRM Data in GitHub Copilot to assist with building Pipeliner CRM-powered applications.
-
How to Connect SAP Hybris C4C 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 SAP Hybris C4C data in real time using natural language.
-
Integrate Redis with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Redis with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Redis.
-
Building Dynamic Web Pages with Google Calendar Data Using AngularJS
Create single-page applications with live connectivity to Google Calendar using the CData API Server.
-
Build Semantic Layer Views for Recurly Data in APOS Live Data Gateway
Use the CData Connector for Recurly in APOS Live Data Gateway to build Semantic Layer Views for Recurly.
-
Connect to Zendesk Data from PowerBuilder via ADO.NET
This article demonstrates how to access Zendesk from Appeon PowerBuilder using the CData ADO.NET Provider for Zendesk.
-
Model SingleStore Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SingleStore, enabling the direct import of real-time SingleStore.
-
Connect to Reply.io Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to PostgreSQL Data in Jaspersoft Studio
Execute SQL to remote PostgreSQL in Jaspersoft Studio.
-
Integrate with Browserless Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Browserless to a JSON file on disk.
-
Back Up FTP Servers to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for FTP. In this article, we will employ an SSIS workflow to populate a database with FTP Servers data.
-
Connecting Mastra with Vault CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Veeva Vault & Vault CRM, no replication required.
-
Connect to Instagram Data in Jaspersoft Studio
Execute SQL to remote Instagram in Jaspersoft Studio.
-
Integrating Kiro CLI with Dynamics CRM 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.
-
Create Informatica Mappings From/To a JDBC Data Source for Rootly
Create Rootly data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating Kiro CLI with Aweber 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 Apps with Live Impala Data Using the Low-Code Development Platform of Mendix
Connect Apache Impala with Mendix to build apps using the CData JDBC Driver for Impala.
-
Integrating LangGraph with Zoom Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Zoom within automated workflows.
-
How to publish and share eBay Analytics Data dashboards with Tableau Server
The CData ODBC driver for eBay Analytics enables you integrate eBay Analytics into Tableau dashboards.
-
Build Apps with Live SAP SuccessFactors LMS in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP SuccessFactors LMS into the Adalo platform and build custom mobile and web applications with real-time SAP SuccessFactors LMS.
-
Getting Started with the CData SSIS Components for Notion
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Notion.
-
Use Biml to Build SSIS Tasks to Replicate ZohoDesk Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ZohoDesk to SQL Server.
-
Connect to Wrike Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Wrike using standard SQL.
-
Use Biml to Build SSIS Tasks to Replicate SAS Data Sets Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAS Data Sets to SQL Server.
-
Establish a Live Connection with Salesforce Pardot Data using Tableau Bridge
The CData ODBC Driver for Salesforce Pardot enables you to integrate live Salesforce Pardot into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Kintone Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Kintone replication to Google BigQuery.
-
Automate Stripe Data Replication to SAP HANA
Use CData Sync to customize and automate Stripe replication to SAP HANA.
-
How to Design YouTube Analytics Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to YouTube Analytics from mobile and tablet Power Apps.
-
How to Easily Query Oracle Sales Data in OpenOffice Base
Connect to Oracle Sales data in OpenOffice Base using the CData ODBC Driver for Oracle Sales and generate reports with live data insights.
-
Establish a Live Connection with Confluence Data using Tableau Bridge
The CData ODBC Driver for Confluence enables you to integrate live Atlassian Confluence into Tableau Cloud dashboards using the Tableau Bridge.