CData Software - Knowledge Base
Recent Articles
-
Prepare, Blend, and Analyze Avro in Alteryx Designer (ODBC)
Build workflows to access live Apache Avro for self-service data analytics.
-
Automated Continuous MariaDB Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable MariaDB replication to Microsoft Access.
-
Automated Continuous Microsoft Teams Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Google Cloud SQL.
-
Query IBM Informix using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume IBM Informix entities in PHP by modeling them as objects.
-
Migrating data from Exact Online to Google BigQuery using CData SSIS Components.
Easily push Exact Online to Google BigQuery using the CData SSIS Tasks for Exact Online and Google BigQuery.
-
Query Epicor Kinetic as a SQL Server Database in Node.js
Execute SQL Server queries against Epicor Kinetic from Node.js.
-
Building Dynamic Web Pages with Facebook Ads Using AngularJS
Create single-page applications with live connectivity to Facebook Ads using the CData API Server.
-
Create a Data Access Object for Pipedrive using JDBI
A brief overview of creating a SQL Object API for Pipedrive in JDBI.
-
How to Connect to & Open Certinia in Microsoft Excel
This article uses the CData ODBC driver for Certinia to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automate Google Contacts Replication to Azure Synapse
Use CData Sync to customize and automate Google Contacts replication to Azure Synapse.
-
Visualize Exact Online in Tableau
The CData ODBC driver for Exact Online enables you integrate Exact Online into Tableau dashboards.
-
Connect and Visualize Live Act CRM Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Act CRM into the Databricks platform and create visualization dashboards with real-time Act CRM.
-
Access Live Outreach.io in AWS Lambda (with IntelliJ IDEA)
Connect to live Outreach.io in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automate Pinterest Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Pinterest from PowerShell? This article demonstrates how to utilize the Pinterest Cmdlets for tasks like connecting to Pinterest, automating operations, downloading data, and more.
-
How to Create Power BI Visual Reports with Real-Time Sage 300
Use CData Power BI Connectors to visualize Sage 300 in Power BI.
-
How to Import Data from Pipedrive into Google Sheets
Import Pipedrive into a Google spreadsheet that is automatically refreshed.
-
Design BIRT Reports on Unbounce
Provide current Unbounce to your embedded analytics.
-
Create QuickBooks Online-Connected Dashboards in Grafana
Connect to QuickBooks Online via CData Connect AI in Grafana and create custom business dashboards with real-time access to QuickBooks Online.
-
Automated Continuous Reckon Accounts Hosted Replication to MySQL
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to MySQL.
-
Connect to SendGrid in DBeaver
Use the CData ODBC Driver to connect to SendGrid in DBeaver.
-
Create Data Visualizations in Cognos BI with GitHub
Access GitHub as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Presto Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Presto facts in real time.
-
How to Connect the Power BI Service to Zoom: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Use the CData Software JDBC Driver for Adobe Analytics in MicroStrategy
Connect to Adobe Analytics in MicroStrategy Developer using the CData Software JDBC Driver for Adobe Analytics.
-
Import Real-Time Basecamp via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Basecamp in ColdFusion.
-
Integrate Oracle Financials Cloud with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Oracle Financials Cloud with External Services.
-
Access Amazon Marketplace from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Amazon Marketplace from HeidiSQL.
-
Bind Live Quickbase Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Quickbase data
-
Visualize Hive in Tableau
The CData ODBC driver for Hive enables you integrate Apache Hive into Tableau dashboards.
-
Connect to TaxJar in Ruby
Connect to TaxJar in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Redis Replication to MySQL
Use CData Sync for automated, continuous, customizable Redis replication to MySQL.
-
Access Oracle Sales from MySQL in PHP
Connect to Oracle Sales through the standard MySQL libraries in PHP.
-
Process & Analyze Oracle Financials Cloud in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Oracle Financials Cloud .
-
Import SAP HANA Using Azure Data Factory
Use CData Connect AI to connect to SAP HANA from Azure Data Factory and import live SAP HANA.
-
Use the CData API Server to Access Bullhorn CRM in Microsoft PowerPivot
Use the CData API Server to connect to live Bullhorn CRM in the Power Pivot business intelligence tool.
-
Microsoft OneDrive Reporting in OBIEE with the Microsoft OneDrive JDBC Driver
Deploy the Microsoft OneDrive JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Publish Crystal Reports on Jira Assets
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Jira Assets.
-
Connect to ServiceNow in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Create Reports with Neo4J in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Neo4J.
-
Build Semantic Layer Views for Sage Intacct in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Sage Intacct.
-
Create Amazon Marketplace Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Amazon Marketplace data access from reports, embedded analytics, and more.
-
Building Dynamic Web Pages with SAS Data Sets Using AngularJS
Create single-page applications with live connectivity to SAS Data Sets using the CData API Server.
-
Publish ServiceNow-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ServiceNow.
-
Replicate Multiple Quickbase Accounts
Replicate multiple Quickbase accounts to one or many databases.
-
Getting Started with the CData SSIS Components for SAP Netweaver Gateway
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP Netweaver Gateway.
-
Connect to Google Contacts from a Connection Pool in JBoss
Integrate Google Contacts into Java servlets: Use the Management Console in JBoss to install the Google Contacts JDBC Driver.
-
Explore Geographical Relationships in TigerGraph with Power Map
Create data visualizations with TigerGraph in Power Map.
-
Automate Airtable Replication to Azure Data Lake
Use CData Sync to customize and automate Airtable replication to Azure Data Lake.
-
How to connect to EventBrite in DBVisualizer
Integrate Eventbrite with visual data analysis tools and data connection wizards in DBVisualizer
-
PowerShell Scripting to Replicate Bullhorn CRM to MySQL
Write a simple PowerShell script to replicate Bullhorn CRM to a MySQL database.
-
Connect to Live AlloyDB in PostGresSQL Interface through CData Connect AI
Create a live connection to AlloyDB in CData Connect AI and connect to your Google AlloyDB from PostgreSQL.
-
Integrate Live Zoho Books into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Zoho Books and integrate live Zoho Books into apps built in Microsoft Power Apps.
-
Connect Jira Assets to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Jira Assets using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Jira Assets in SpagoBI
Create reports featuring live Jira Assets in SpagoBI Studio. Host Jira Assets reports on SpagoBI Server.
-
Create Dynamic Slack Grids Using the Infragistics XamDataGrid
Learn how you can connect Slack to Infragistics XamDataGrid to build dynamic grids.
-
Use JayDeBeApi to access Zendesk in Python
Use standard Python scripting and the development environment of your choice to access live Zendesk.
-
Viewing QuickBooks Online in RAD Studio Data Explorer
How to view QuickBooks Online in RAD Studio Data Explorer using the CData ODBC Driver for QuickBooks Online.
-
How to Access Live Xero in Power Automate Desktop via ODBC
The CData ODBC Driver for Xero enables you to integrate Xero Accounting into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData Python Connector for MySQL
Learn to install and license the CData Python Connector
-
Visualize Live Klaviyo in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Klaviyo.
-
Integrate Cvent in the Pentaho Report Designer
Publish reports based on Cvent in the Pentaho BI tool.
-
Build Microsoft Dataverse Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Microsoft Dataverse (CDS) and build visualizations in Tableau Cloud.
-
View Reports on Real-Time Zendesk in Power BI Report Server
Use the CData ODBC Driver for Zendesk to visualize Zendesk in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Cursor with Live SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Microsoft SQL Server from within the editor.
-
Connect Zendesk to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zendesk using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Apps with Live Jira Using the Low-Code Development Platform of Mendix
-