CData Software - Knowledge Base

Recent Articles

• «
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• »

• Automated Continuous Impala Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Impala replication to IBM DB2.

• Connect QuickBooks to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your QuickBooks Desktop using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Build Gmail-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Gmail.

• Integrate Active Directory with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Active Directory with External Services.

• Create Apps from Vault CRM in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Vault CRM and build apps from live Veeva Vault & Vault CRM in Qlik Sense Cloud.

• Deploy the ADO.NET Provider for Square on an SSRS Report Server

  Connect to Square from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• How to work with Typeform in Apache Spark using SQL

  Access and process Typeform in Apache Spark using the CData Software JDBC Driver.

• Create Microsoft Teams-Connected Nintex Workflows

  Use CData Connect Cloud to connect to Microsoft Teams from Nintex Workflow Cloud and build custom workflows using live Microsoft Teams.

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Bullhorn CRM

  Provide connectivity to Bullhorn CRM through an SAP BusinessObjects universe.

• How to load Xero data into Elasticsearch via Logstash

  Introducing a simple method to load Xero data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Consume GitHub OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on GitHub feeds that reflect any changes in SAP Lumira.

• ETL SAP Hybris C4C in Oracle Data Integrator

  This article shows how to transfer SAP Hybris C4C into a data warehouse using Oracle Data Integrator.

• Replicate Multiple Paylocity Accounts via the CData Sync CLI

  Replicate multiple Paylocity accounts to one or many databases.

• Replicate Multiple Microsoft Dataverse Accounts via the CData Sync CLI

  Replicate multiple Microsoft Dataverse accounts to one or many databases.

• Access Pipedrive from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Pipedrive from HeidiSQL.

• Stream Greenplum into Apache Kafka Topics

  Access and stream Pivotal GreenPlum in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Automated Continuous SAP Ariba Procurement Replication to Oracle

  Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Oracle.

• Use CData Connect Cloud to Access Smaregi in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Smaregi in the Power Pivot business intelligence tool.

• How to work with Freshdesk in Apache Spark using SQL

  Access and process Freshdesk in Apache Spark using the CData Software JDBC Driver.

• Build Zoho Books-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Zoho Books.

• Connect to Microsoft Project from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Microsoft Project from Filemaker Pro on Mac.

• How to work with Printify in Apache Spark using SQL

  Access and process Printify in Apache Spark using the CData Software JDBC Driver.

• Build LinkedIn Ads-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live LinkedIn Ads.

• Integrate with DocuSign in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live DocuSign in SnapLogic.

• Automated Continuous Shopify Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Shopify replication to SQL Server.

• Create GitHub Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time GitHub data access from reports, embedded analytics, and more.

• Visualize Confluence from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Atlassian Confluence.

• How to connect to Google Drive from IntelliJ

  Integrate connectivity to Google Drive with wizards in IntelliJ.

• Connect to and Query SAP in QlikView over ODBC

  Create data visualizations with SAP ERP/NetWeaver in QlikView.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Tally

  Provide connectivity to Tally ERP through an SAP BusinessObjects universe.

• Rapidly Develop Sage 200-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 PostgreSQL-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to PostgreSQL from Klipfolio and build custom visualizations using live PostgreSQL.

• Publish Zoho Projects-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Zoho Projects.

• Bridge Freshdesk Connectivity with Apache NiFi

  Access and process Freshdesk in Apache NiFi using the CData JDBC Driver.

• Connect to Workday from a Connection Pool in JBoss

  Integrate Workday into Java servlets: Use the Management Console in JBoss to install the Workday JDBC Driver.

• How to Access Live Excel in Power Automate Desktop via ODBC

  The CData ODBC Driver for Excel enables you to integrate Microsoft Excel into workflows built using Microsoft Power Automate Desktop.

• Create Apps from Microsoft Project in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Microsoft Project and build apps from live Microsoft Project in Qlik Sense Cloud.

• Connect to Outreach.io in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Outreach.io in the Denodo Virtual DataPort Administrator.

• How to Work with Snowflake in ETL Validator JDBC

  Connect to Snowflake from ETL Validator jobs using the CData Software JDBC Driver.

• Automated Continuous Microsoft Planner Replication to Vertica

  Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Vertica.

• Automated Continuous Dynamics CRM Replication to Oracle

  Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Oracle.

• DataBind Charts to Google Data Catalog

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Data Catalog 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.

• Automated Continuous PayPal Replication to Vertica

  Use CData Sync for automated, continuous, customizable PayPal replication to Vertica.

• Create Power BI Reports on Real-Time ServiceNow

  Use the CData ODBC Driver for ServiceNow to visualize ServiceNow in Power BI Desktop.

• Epicor Kinetic Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Epicor Kinetic facts in real time.

• Automate Google Drive Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Google Drive from PowerShell? This article demonstrates how to utilize the Google Drive Cmdlets for tasks like connecting to Google Drive, automating operations, downloading data, and more.

• Visualize Kafka in Sisense

  Create an ElastiCube in Sisense app with access to Apache Kafka.

• LINQ to Invoiced

  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 Invoiced Data Provider.

• Automated Continuous Quickbase Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Quickbase replication to SQL Server.

• Connect to Live Microsoft Teams in MicroStrategy through CData Connect Cloud

  Create a live connection to Microsoft Teams in CData Connect Cloud and connect to your Microsoft Teams from MicroStrategy.

• Automate Google Data Catalog Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Google Data Catalog from PowerShell? This article demonstrates how to utilize the Google Data Catalog Cmdlets for tasks like connecting to Google Data Catalog, automating operations, downloading data, and more.

• Automate Twitter Ads Replication to SAP HANA

  Use CData Sync to customize and automate Twitter Ads replication to SAP HANA.

• Connect to SAP BusinessObjects BI from a Connection Pool in WebLogic

  Use the CData JDBC Driver for SAP BusinessObjects BI to connect to SAP BusinessObjects BI from Web applications running on WebLogic.

• Publish Reports with Google Campaign Manager 360 in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Google Campaign Manager 360.

• Model, Search, and Visualize Live Reckon in ThoughtSpot

  Use CData Connect Cloud to connect to live Reckon for modeling, searching, and visualizing.

• How to Query Live Zoho Creator in Claude Desktop

  Connect to and query live Zoho Creator in Claude Desktop using the CData MCP Server.

• Automate Tasks in Power Automate Using the CData API Server

  Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.

• How to create Sage 200 federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Sage 200 in MySQL .

• Establish a Live Connection with Excel Online using Tableau Bridge

  The CData ODBC Driver for Excel Online enables you to integrate live Microsoft Excel Online into Tableau Cloud dashboards using the Tableau Bridge.

• Use the CData Software ODBC Driver for Printful in MicroStrategy

  Connect to Printful in MicroStrategy Developer using the CData Software ODBC Driver for Printful.

• A PostgreSQL Interface for Excel Online (MySQL Remoting via JDBC)

  Use the Remoting features of the Excel Online JDBC Driver to create a PostgreSQL entry-point for data access.

• How to Import Data from Zoho Creator into Google Sheets

  Import Zoho Creator into a Google spreadsheet that is automatically refreshed.

• Build DocuSign-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live DocuSign and build DocuSign-connected web apps with Axios.

• Working with Act-On in LINQPad

  Execute LINQ queries to Act-On in LINQPad.

• Using the CData Software ODBC Driver for Blackbaud FE NXT in PyCharm

  Connect to Blackbaud FE NXT as an ODBC data source in PyCharm using the CData Software ODBC Driver for Blackbaud FE NXT.

• How to use SQLAlchemy ORM to access Google Spanner in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Spanner.

• Create Reports with Zoho Creator in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Zoho Creator.

• How to connect and process Aha! from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Aha!.

• Query Shopify through ODBC in Node.js

  Use node-odbc to execute SQL queries against Shopify from Node.js.

• Replicate Parquet from PowerShell

  Write a quick PowerShell script to query Apache Parquet. Use connectivity to the live data to replicate Apache Parquet to SQL Server.

• Query MYOB AccountRight in DataGrip

  Create a Data Source for MYOB AccountRight in DataGrip and use SQL to query live MYOB AccountRight.

• Automated Continuous ADP Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable ADP replication to PostgreSQL.

• How to Work with Adobe Commerce in AWS Glue Jobs Using JDBC

  Connect to Adobe Commerce from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• How to Connect the Power BI Service to CouchDB: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Access Google Spanner as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Spanner from your Oracle system.

• How to connect Amazon QuickSight to Tableau CRM Analytics

  Create a connection to Tableau CRM Analytics in CData Connect Cloud and insert Tableau CRM Analytics into Amazon QuickSight SPICE to build interactive dashboards.

• Create Reports from Couchbase in Looker Studio

  Use CData Connect Cloud to gain access to live Couchbase and create custom reports in Looker Studio.

• Create Datasets from Dropbox in Domo Workbench and Build Visualizations of Dropbox in Domo

  Use the CData Software ODBC Driver for Dropbox to create datasets from Dropbox in Domo Workbench and then build visualizations in the Domo service.

• Connect to and Visualize Live Marketo in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Marketo.

• Build Shopify-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Shopify from Choreo and build custom apps using live Shopify.

• Connect to MailChimp from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time MailChimp using standard SQL.

• How to update WooCommerce from Excel

  This article explains how to transfer data from Excel to WooCommerce using the Excel Add-In for WooCommerce.

• How to work with Twitter Ads in Apache Spark using SQL

  Access and process Twitter Ads in Apache Spark using the CData Software JDBC Driver.

• Connect to Odoo from Asprova with CData Software ODBC Driver for Odoo

  This article shows how to connect faster to Odoo data from Asprova.

• Create Datasets from Google Contacts in Domo Workbench and Build Visualizations of Google Contacts in Domo

  Use the CData Software ODBC Driver for Google Contacts to create datasets from Google Contacts in Domo Workbench and then build visualizations in the Domo service.

• Building Dynamic Web Pages with Sage 200 Using AngularJS

  Create single-page applications with live connectivity to Sage 200 using the CData API Server.

• Visualize Act-On in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Act-On into TIBCO Spotfire.

• Bidirectional Access to Todoist from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Todoist in Filemaker Pro for Mac or Windows.

• Use the CData Software ODBC Driver for Act-On in SAS for Real-Time Reporting and Analytics

  Connect to real-time Act-On in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Act-On.

• A PostgreSQL Interface for Bing Ads (MySQL Remoting via JDBC)

  Use the Remoting features of the Bing Ads JDBC Driver to create a PostgreSQL entry-point for data access.

• Bridge Certinia Connectivity with Apache NiFi

  Access and process Certinia in Apache NiFi using the CData JDBC Driver.

• Host the API Server on Heroku

  Host the CData API Servers in Heroku Cloud Application Platform.

• Analyze Salesforce in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Salesforce & Force.com in Microsoft R Open.

• Integrate Office 365 in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Office 365 from Informatica Cloud.

• Connect to Basecamp in RapidMiner

  Integrate Basecamp with standard components and data source configuration wizards in RapidMiner Studio.

• Query Xero in ColdFusion

  Write standard ColdFusion data access code to connect to Xero Accounting.

• Query Airtable through ODBC in Node.js

  Use node-odbc to execute SQL queries against Airtable from Node.js.

• Visualize Facebook in TIBCO Spotfire through ADO.NET

  Integrate Facebook into dashboards in TIBCO Spotfire.

• Visualize Twilio in TIBCO Spotfire through OData

  Integrate Twilio into dashboards in TIBCO Spotfire.

• Connect Klaviyo to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Klaviyo using the CData Python MCP Server.

• «
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• »