CData Software - Knowledge Base
Recent Articles
-
How to Create Power BI Visual Reports with Real-Time Sybase
Use CData Power BI Connectors to visualize Sybase in Power BI.
-
How to Connect the Power BI Service to ClickUp: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Automated Continuous Jira Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Jira replication to Apache Kafka.
-
Build MVC Applications with Connectivity to Acumatica
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Acumatica from an ASP.NET MVC application.
-
Create Smartsheet-Connected Dashboards in Grafana
Connect to Smartsheet via CData Connect AI in Grafana and create custom business dashboards with real-time access to Smartsheet.
-
How to Connect to & Open Trello in Microsoft Excel
This article uses the CData ODBC driver for Trello to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Zoho Books from AWS Glue
Use CData Connect AI to gain access to live Zoho Books from your AWS Glue jobs.
-
Visualize TigerGraph in Sisense
Create an ElastiCube in Sisense app with access to TigerGraph.
-
Connect to Bitbucket in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData Software ODBC Driver for Salesforce Pardot in MicroStrategy Web
Connect to Salesforce Pardot in MicroStrategy Web using the CData Software ODBC Driver for Salesforce Pardot.
-
Query GitHub as a SQL Server Database in Node.js
Execute SQL Server queries against GitHub from Node.js.
-
Work with xBase in FoxPro
Load xBase into a FoxPro database. This article includes full code and a walk-through of the process.
-
Add Certinia to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Certinia with the Informatica Enterprise Data Catalog to classify and organize data.
-
Choosing the Best Method to Connect Procore to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Procore from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Automated Workflows with Live SAP BusinessObjects BI in Workato
Use CData Connect AI to connect to live SAP BusinessObjects BI and build automated workflows in Workato.
-
Perform Batch Operations with Google Spanner in Apache NiFi
Connect to Google Spanner and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Microsoft Project in Jaspersoft Studio
Execute SQL to remote Microsoft Project in Jaspersoft Studio.
-
Use the CData Software ODBC Driver for Facebook Ads in SAS for Real-Time Reporting and Analytics
Connect to real-time Facebook Ads in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Facebook Ads.
-
Create Informatica Mappings From/To an ODBC Data Source for JSON
Create an ODBC connection to JSON in Informatica and browse and transfer JSON.
-
Connecting Moonlit Workflow with Square 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 Square in real time.
-
Build FHIR-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to FHIR from Zoho Analytics and import live FHIR.
-
Visualize Microsoft OneDrive in Tableau
The CData ODBC driver for Microsoft OneDrive enables you integrate Microsoft OneDrive into Tableau dashboards.
-
Connect to Live Act CRM in PostGresSQL Interface through CData Connect AI
Create a live connection to Act CRM in CData Connect AI and connect to your Act CRM from PostgreSQL.
-
Analyze Oracle Eloqua with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Oracle Eloqua from Power Pivot. You will use the Table Import Wizard to load Oracle Eloqua. You can visually build the import query or use any SQL supported by the driver.
-
How to Access Live QuickBooks in Power Automate Desktop via ODBC
The CData ODBC Driver for QuickBooks enables you to integrate QuickBooks Desktop into workflows built using Microsoft Power Automate Desktop.
-
How to Work with Zoho Creator in AWS Glue Jobs Using JDBC
Connect to Zoho Creator from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Query, Visualize, and Share live Azure DevOps in Redash
Use CData Connect AI to connect to live Azure DevOps in Redash for querying, visualizing, and sharing.
-
Bidirectional Access to HBase from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Apache HBase in Filemaker Pro for Mac or Windows.
-
Edit and Search External SendGrid Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SendGrid to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SendGrid objects that you can access from apps and the dashboard.
-
Query Splunk using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Splunk entities in PHP by modeling them as objects.
-
Connect to Bullhorn CRM from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Bullhorn CRM, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Publish Salesforce-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Salesforce & Force.com.
-
Design BIRT Reports on SAP Business One
Provide current SAP Business One to your embedded analytics.
-
Connect to Klaviyo from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Klaviyo using standard SQL.
-
Connect to SharePoint from a Connection Pool in Jetty
The SharePoint JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft SharePoint from Web apps in Jetty.
-
How to integrate Salesforce Data Cloud with Apache Airflow
Access and process Salesforce Data Cloud in Apache Airflow using the CData JDBC Driver.
-
Create SSAS Tabular Models from Act CRM
How to build a SQL Server Analysis Service Tabular Model from Act CRM using CData drivers.
-
Build Data Flows from EnterpriseDB to SQL Server using SSIS
Easily back up EnterpriseDB to SQL Server using the SSIS components for EnterpriseDB.
-
Build Visualizations of CouchDB in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Apache CouchDB in Birst.
-
Build AI Agents with Spark Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Trigger Act CRM IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Analyze Google Campaign Manager 360 in Looker
Use CData Connect AI to connect to Google Campaign Manager 360 from Looker and build custom apps using live Google Campaign Manager 360.
-
Connect to Amazon Athena from Asprova with CData Software ODBC Driver for Amazon Athena
This article shows how to connect faster to Amazon Athena data from Asprova.
-
How to Access Live Authorize.Net in Power Automate Desktop via ODBC
The CData ODBC Driver for Authorize.Net enables you to integrate Authorize.Net into workflows built using Microsoft Power Automate Desktop.
-
Access Live SendGrid in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SendGrid from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Access Live Jira Assets in Power Automate Desktop via ODBC
The CData ODBC Driver for Jira Assets enables you to integrate Jira Assets into workflows built using Microsoft Power Automate Desktop.
-
Model, Search, and Visualize Live Databricks in ThoughtSpot
Use CData Connect AI to connect to live Databricks for modeling, searching, and visualizing.
-
Integrate Cursor with Live Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Amazon DynamoDB from within the editor.
-
Connect to Confluence as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Atlassian Confluence.
-
Import Google Spanner into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google Spanner. In this article, you will use the OData format to import Google Spanner into Microsoft Power Query.
-
Getting Started with the CData ODBC Driver for Zuora
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Zuora.
-
Connect to Presto in ACL Analytics
Connect to Presto via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Presto.
-
Create Power BI Reports on Real-Time Amazon DynamoDB
Use the CData ODBC Driver for Amazon DynamoDB to visualize Amazon DynamoDB in Power BI Desktop.
-
Getting Started with the CData Excel Add-In for MailChimp
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for MailChimp.
-
How to import Google Data Catalog into Apache Solr
Use the CData Software JDBC Driver for Google Data Catalog in Data Import Handler and create an automated import of Google Data Catalog to Apache Solr Enterprise Search platform.
-
Connect to Blackbaud FE NXT from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Blackbaud FE NXT to connect to Blackbaud FE NXT and execute queries in PowerBuilder.
-
Use the CData API Server to Access Unbounce in Microsoft PowerPivot
Use the CData API Server to connect to live Unbounce in the Power Pivot business intelligence tool.
-
Create Amazon Marketplace-Connected Dashboards in Grafana
Connect to Amazon Marketplace via CData Connect AI in Grafana and create custom business dashboards with real-time access to Amazon Marketplace.
-
Rapidly Develop Snapchat Ads-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Create Informatica Mappings From/To an ODBC Data Source for WordPress
Create an ODBC connection to WordPress in Informatica and browse and transfer WordPress.
-
Access Live Zoho Creator in AWS Lambda
Connect to live Zoho Creator in AWS Lambda using the CData JDBC Driver.
-
Build Data Flows from SQL Server to NetSuite through SSIS
Easily push SQL Server data to NetSuite using the CData SSIS Tasks for NetSuite.
-
Build Apps with Live Oracle SCM in Adalo using CData Connect AI
Use CData Connect AI to integrate live Oracle SCM into the Adalo platform and build custom mobile and web applications with real-time Oracle SCM.
-
Visualize EventBrite in Tableau
The CData ODBC driver for EventBrite enables you integrate Eventbrite into Tableau dashboards.
-
Create Dynamic Tally Grids Using the Infragistics XamDataGrid
Learn how you can connect Tally to Infragistics XamDataGrid to build dynamic grids.
-
Create Reports with Highrise in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Highrise CRM.
-
Build Charts with Avalara AvaTax in Clear Analytics
Create dynamic charts and perform analytics based on Avalara AvaTax in Clear Analytics.
-
Analyze Vault CRM in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Veeva Vault & Vault CRM in Microsoft R Open.
-
Connect to Live Instagram in MicroStrategy through CData Connect AI
Create a live connection to Instagram in CData Connect AI and connect to your Instagram from MicroStrategy.
-
Build Act CRM-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Act CRM and create custom apps in Bubble.
-
Connect to Facebook in DBArtisan
Use wizards in DBArtisan to configure Facebook as a data source.
-
Integrate Oracle Eloqua with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Oracle Eloqua with External Services.
-
Automate Dynamics CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Dynamics CRM from PowerShell? This article demonstrates how to utilize the Dynamics CRM Cmdlets for tasks like connecting to Microsoft Dynamics CRM, automating operations, downloading data, and more.
-
How to connect to Redis in DBVisualizer
Integrate Redis with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Apps with Live Workday Using the Low-Code Development Platform of Mendix
-