CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Vault CRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable Vault CRM replication to Snowflake.
-
Bridge CouchDB Connectivity with Apache NiFi
Access and process Apache CouchDB in Apache NiFi using the CData JDBC Driver.
-
How to Design QuickBooks Online Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Write a Simple Go Application to work with Kintone on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Kintone.
-
Migrating data from Bing Ads to Google BigQuery using CData SSIS Components.
Easily push Bing Ads to Google BigQuery using the CData SSIS Tasks for Bing Ads and Google BigQuery.
-
Create Power BI Reports on Real-Time Teradata
Use the CData ODBC Driver for Teradata to visualize Teradata in Power BI Desktop.
-
Integrate Real-Time Access to MySQL in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to MySQL in real time.
-
Automated Continuous Sybase IQ Replication to Vertica
Use CData Sync for automated, continuous, customizable Sybase IQ replication to Vertica.
-
Connect to Monday.com in Google Apps Script via SQL Gateway
Use the ODBC Driver for Monday.com and the SQL Gateway to access Monday.com from Google Apps Script.
-
Query PingOne through ODBC in Node.js
Use node-odbc to execute SQL queries against PingOne from Node.js.
-
Query Act CRM as a MySQL Database in Node.js
Execute MySQL queries against Act CRM from Node.js.
-
Create Informatica Mappings From/To an ODBC Data Source for Phoenix
Create an ODBC connection to Phoenix in Informatica and browse and transfer Apache Phoenix.
-
Connect to SingleStore in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SingleStore in Airbyte.
-
Rapidly Develop Redshift-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.
-
Build Automated Workflows with Live Tableau CRM Analytics in Workato
Use CData Connect AI to connect to live Tableau CRM Analytics and build automated workflows in Workato.
-
Automate QuickBooks Replication to SAP HANA
Use CData Sync to customize and automate QuickBooks Desktop replication to SAP HANA.
-
Prepare, Blend, and Analyze IBM Informix in Alteryx Designer (Connect AI)
Build workflows to access live IBM Informix for self-service data analytics.
-
Design BIRT Reports on Salesforce
Provide current Salesforce & Force.com to your embedded analytics.
-
Connect to Twilio from a Connection Pool in JBoss
Integrate Twilio into Java servlets: Use the Management Console in JBoss to install the Twilio JDBC Driver.
-
Connect to Parquet in RapidMiner
Integrate Apache Parquet with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Paylocity Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Paylocity replication to Apache Cassandra.
-
Publish SQL Server-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft SQL Server.
-
How to pipe Greenplum to CSV in PowerShell
Use standard PowerShell cmdlets to access Greenplum tables.
-
Consume IBM Informix OData Feeds in SAP Lumira
Use the API Server to create data visualizations on IBM Informix feeds that reflect any changes in SAP Lumira.
-
Visualize NetSuite in Sisense
Create an ElastiCube in Sisense app with access to NetSuite CRM & ERP.
-
How to Work with SAS Data Sets in AWS Glue Jobs Using JDBC
Connect to SAS Data Sets from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Import and Visualize Office 365 in Power View
Create data visualizations based on Microsoft Office 365 in Excel.
-
Integrate with Twitter in JReport Designer
Create charts and reports based on Twitter in JReport Designer.
-
Perform Batch Operations with Dynamics NAV in Apache NiFi
Connect to Microsoft Dynamics NAV and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous SAP Fieldglass Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Vertica.
-
Stream Google Analytics into Apache Kafka Topics
Access and stream Google Analytics in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Connect to Live SurveyMonkey 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 SurveyMonkey for you.
-
Query FHIR through ODBC in Node.js
Use node-odbc to execute SQL queries against FHIR from Node.js.
-
How to Seamlessly Import Google Ads Data into IBM SPSS Modeler
Integrate Google Ads data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Charts with SAP Ariba Procurement in Clear Analytics
Create dynamic charts and perform analytics based on SAP Ariba Procurement in Clear Analytics.
-
Extend Google Sheets with Dropbox
Make calls to the API Server from Google Apps Script.
-
Access Twitter Ads from MySQL in PHP
Connect to Twitter Ads through the standard MySQL libraries in PHP.
-
Connect to Zoom in RazorSQL
Connect to Zoom from wizards and query Zoom from the GUI in the RazorSQL database management tool.
-
How to Use a Microsoft Access Database to Update Sugar CRM in Real Time
Update Sugar CRM data by creating a linked table in Microsoft Access with the CData Sugar CRM ODBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate Salesforce Marketing to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Salesforce Marketing Cloud to SQL Server.
-
Visualize Cassandra in Sisense
Create an ElastiCube in Sisense app with access to Apache Cassandra.
-
Connect to MariaDB in JRuby
Create a simple JRuby app with access to live MariaDB.
-
Model GraphQL Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and GraphQL, enabling the direct import of real-time GraphQL.
-
Create Data Visualizations Based On PayPal in Mode
Use CData Connect AI to connect to PayPal from Mode and build visualizations using live
-
Replicate Multiple Phoenix Accounts
Replicate multiple Phoenix accounts to one or many databases.
-
Automated Continuous HBase Replication to SQL Server
Use CData Sync for automated, continuous, customizable HBase replication to SQL Server.
-
Visualize Live Certinia of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Certinia using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live WooCommerce in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live WooCommerce from your Excel spreadsheets.
-
Access Lakebase from MySQL in Amazon QuickSight
Connect to Lakebase and build visualizations of Lakebase using a MySQL Connection in Amazon QuickSight.
-
Connect to Microsoft Project in CloverDX (formerly CloverETL)
Transfer Microsoft Project using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Azure Data Catalog Replication to MySQL
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to MySQL.
-
Connect to PayPal in Google Apps Script via SQL Gateway
Use the ODBC Driver for PayPal and the SQL Gateway to access PayPal from Google Apps Script.
-
Analyze Microsoft Teams in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft Teams and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Gmail from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Gmail using standard SQL.
-
How to Create Power BI Visual Reports with Real-Time Salesloft
Use CData Power BI Connectors to visualize Salesloft in Power BI.
-
Build Dashboards with LDAP Objects in DBxtra
Create dynamic dashboards and perform analytics based on LDAP in DBxtra.
-
Provide OData Services of Outreach.io from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Outreach.io by developing a WCF Service Application.
-
How to connect to Oracle from IntelliJ
Integrate connectivity to Oracle Database with wizards in IntelliJ.
-
Getting Started with the CData PowerShell Cmdlets for Blackbaud FE NXT
-