CData Software - Knowledge Base

Recent Articles

• «
• 474
• 475
• 476
• 477
• 478
• 479
• 480
• 481
• 482
• 483
• »

• Enable the Bullhorn CRM JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Bullhorn CRM.

• Create Bullhorn CRM-Connected Applications in Appsmith

  Connect to Bullhorn CRM via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Bullhorn CRM.

• Use the CData Software ODBC Driver for Greenplum in MicroStrategy Desktop

  Connect to Pivotal GreenPlum in MicroStrategy Desktop using the CData Software ODBC Driver for Greenplum.

• Power BI Connector Getting Started Guide

  A basic guide to connecting Power BI to data from anywhere using the CData Power BI Connector.

• Connect to MySQL in Jaspersoft Studio

  Execute SQL to remote MySQL in Jaspersoft Studio.

• Connect to Parquet in NetBeans

  Connect to Apache Parquet in NetBeans with the data source configuration wizard.

• Create SSAS Tabular Models from Databricks

  How to build a SQL Server Analysis Service Tabular Model from Databricks using CData drivers.

• Integrate with eBay using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy eBay to a JSON file on disk.

• Migrating data from BigCommerce to Databricks using CData SSIS Components.

  Easily push BigCommerce to Databricks using the CData SSIS Tasks for BigCommerce and Databricks.

• Connect to SQL Server from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for SQL Server to connect to Microsoft SQL Server and execute queries in PowerBuilder.

• Access Acumatica in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Acumatica ERP.

• Connect to Google Ads in NetBeans

  Connect to Google Ads in NetBeans with the data source configuration wizard.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed Atlassian Jira Service Management to Power BI dashboards. Simply drag and drop Atlassian Jira Service Management into data visuals on the Power BI canvas.

• Create Printify Reports on JasperReports Server

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

• Connect to Zendesk in CloverDX (formerly CloverETL)

  Transfer Zendesk using the visual workflow in the CloverDX data integration tool.

• Query SAP BusinessObjects BI in DataGrip

  Create a Data Source for SAP BusinessObjects BI in DataGrip and use SQL to query live SAP BusinessObjects BI.

• Access Live QuickBooks Time in AWS Lambda (with IntelliJ IDEA)

  Connect to live QuickBooks Time in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Build Data Flows from ADP to SQL Server using SSIS

  Easily back up ADP to SQL Server using the SSIS components for ADP.

• 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.

• Connect to HBase in Ruby

  Connect to Apache HBase in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Connect to SharePoint Excel Services in Jaspersoft Studio

  Execute SQL to remote SharePoint Excel Services in Jaspersoft Studio.

• Process & Analyze Amazon DynamoDB in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Amazon DynamoDB .

• Replicate Sybase IQ in Heroku for Use in Salesforce Connect

  Replicate Sybase IQ to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Use the CData ODBC Driver for Google Data Catalog from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Google Data Catalog to connect to Google Data Catalog from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Data Catalog in Excel.

• Create SSAS Tabular Models from HCL Domino

  How to build a SQL Server Analysis Service Tabular Model from HCL Domino using CData drivers.

• Connect to Square through External Services in Salesforce

  Use CData Connect Cloud to securely connect Salesforce External Services with Square using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Access Authorize.Net as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Authorize.Net from your Oracle system.

• Connect to SAP Ariba Source in SpagoBI

  Create reports featuring live SAP Ariba Source in SpagoBI Studio. Host SAP Ariba Source reports on SpagoBI Server.

• Automated Continuous Authorize.Net Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Authorize.Net replication to AlloyDB.

• How to Query Live PostgreSQL in Claude Desktop

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

• Migrating data from HarperDB to Snowflake using CData SSIS Components.

  Easily push HarperDB to Snowflake using the CData SSIS Tasks for HarperDB and Snowflake.

• Connect to PayPal from a Connection Pool in JBoss

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

• How to use SQLAlchemy ORM to access SAP HANA XS Advanced in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP HANA XS Advanced.

• Use Dash to Build to Web Apps on Jira

  Create Python applications that use pandas and Dash to build Jira-connected web apps.

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

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

• Query SAP Concur through ODBC in Node.js

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

• Build Automated Salesforce Pardot-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Salesforce Pardot and build automated workflows in Zapier.

• How to Connect the Power BI Service to Office 365: Complete Guide

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

• Replicate Highrise from PowerShell

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

• Back Up SurveyMonkey to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SurveyMonkey. In this article, we will employ an SSIS workflow to populate a database with SurveyMonkey data.

• Automated Continuous Oracle SCM Replication to SQL Server

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

• Connect to SAP BusinessObjects BI in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access SAP BusinessObjects BI in Google Apps Script.

• Use the CData API Server to Access Microsoft Exchange in Microsoft PowerPivot

  Use the CData API Server to connect to live Microsoft Exchange in the Power Pivot business intelligence tool.

• Add SAS Data Sets to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for SAS Data Sets with the Informatica Enterprise Data Catalog to classify and organize data.

• Extract, Transform, and Load WooCommerce in Informatica PowerCenter

  Create a simple Workflow for WooCommerce in Informatica PowerCenter.

• REST Reporting and Star Schemas in OBIEE

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

• DataBind Controls to Greenplum in C++Builder

  DataBind to Pivotal GreenPlum in C++Builder with standard components and controls.

• Bridge Active Directory Connectivity with Apache NiFi

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

• Build Bitbucket-Connected ETL Processes in Google Data Fusion

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

• Use Dash to Build to Web Apps on Dynamics CRM

  Create Python applications that use pandas and Dash to build Dynamics CRM-connected web apps.

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

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

• Work with Certinia in FoxPro

  Load Certinia into a FoxPro database. This article includes full code and a walk-through of the process.

• Connect to Tableau CRM Analytics in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Tableau CRM Analytics in the Denodo Virtual DataPort Administrator.

• Access Live QuickBooks Online in Excel (Desktop) via Connect Cloud

  Use CData Connect Cloud to gain access to live QuickBooks Online from your Excel spreadsheets.

• How to connect to Spark from IntelliJ

  Integrate connectivity to Apache Spark SQL with wizards in IntelliJ.

• Connect to Amazon DynamoDB in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Amazon DynamoDB and connect to Amazon DynamoDB in Akorbi Digital RunMyProcess.

• Analyze Office 365 in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Microsoft Office 365 and visualize Microsoft Office 365 in SAP Analytics Cloud.

• How to Query Live Zoho Creator Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Zoho Creator data in natural language using Python.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed Azure Cosmos DB to Power BI dashboards. Simply drag and drop Azure Cosmos DB into data visuals on the Power BI canvas.

• Visualize Phoenix in Tableau

  The CData ODBC driver for Phoenix enables you integrate Apache Phoenix into Tableau dashboards.

• Bidirectional Access to Amazon Marketplace from FileMaker Pro

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

• A PostgreSQL Interface for PingOne (MySQL Remoting via JDBC)

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

• Connect to Zendesk from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Zendesk to connect to Zendesk from Web applications running on WebLogic.

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

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

• Create Reports with Sybase IQ in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Sybase IQ.

• Connect to Excel in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Replicate Multiple Hive Accounts via the CData Sync CLI

  Replicate multiple Hive accounts to one or many databases.

• Access Live Excel Online in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for Excel Online to create a Microsoft Excel Online source in TIBCO Data Virtualization Studio and gain access to live Microsoft Excel Online from your TDV Server.

• Visualize HDFS in TIBCO Spotfire through ODBC

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

• How to import Reckon into Apache Solr

  Use the CData Software JDBC Driver for Reckon in Data Import Handler and create an automated import of Reckon to Apache Solr Enterprise Search platform.

• Integrate MarkLogic in the Pentaho Report Designer

  Publish reports based on MarkLogic in the Pentaho BI tool.

• Use the CData Software JDBC Driver for Asana in MicroStrategy Desktop

  Connect to Asana in MicroStrategy Desktop using the CData Software JDBC Driver for Asana.

• Analyze Live Google Directory in SAS Viya

  Use CData Connect Cloud to connect to Google Directory from SAS Viya and deploy self-service analytics using live Google Directory.

• Building Dynamic Web Pages with Salesforce Marketing Using AngularJS

  Create single-page applications with live connectivity to Salesforce Marketing using the CData API Server.

• Build Charts with Excel Online in Clear Analytics

  Create dynamic charts and perform analytics based on Microsoft Excel Online in Clear Analytics.

• Bidirectional Access to Shippo from FileMaker Pro

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

• A PostgreSQL Interface for Spark using the CData ODBC Driver

  Use the SQL Gateway and Spark ODBC Driver to create a PostgreSQL entry-point for data access.

• Build a Simple VCL Application for SAP Concur

  How to build a simple VCL Application to view SAP Concur in RAD Studio using the CData ODBC Driver for SAP Concur.

• A PostgreSQL Interface for HubDB using the CData ODBC Driver

  Use the SQL Gateway and HubDB ODBC Driver to create a PostgreSQL entry-point for data access.

• Manage Oracle Service Cloud in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Oracle Service Cloud.

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

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

• View Reports on Real-Time SAP HANA in Power BI Report Server

  Use the CData ODBC Driver for SAP HANA to visualize SAP HANA in Power BI Desktop and then publish them to Power BI Report Server.

• Connect Dynamics 365 to AI Assistants With the CData Python MCP Server

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

• Connect to SAP HANA through External Services in Salesforce

  Use CData Connect Cloud to securely connect Salesforce External Services with SAP HANA using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• How to create Zoom federated tables in MySQL

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

• Build MVC Applications with Connectivity to RSS Feeds

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access RSS from an ASP.NET MVC application.

• Import and Visualize Google Calendar in Power View

  Create data visualizations based on Google Calendar in Excel.

• DataBind Controls to Tableau CRM Analytics in Delphi

  DataBind to Tableau CRM Analytics in Delphi with standard data access components and controls.

• Publish Reports with ShipStation in SAP Crystal Reports

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

• Connect to Teradata in HULFT Integrate

  Connect to Teradata as a JDBC data source in HULFT Integrate

• Configure the CData JDBC Driver for Kafka in a Connection Pool in Tomcat

  Connect to Apache Kafka from a connection pool in Tomcat.

• Publish QuickBooks-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live QuickBooks Desktop.

• How to Access SAP Ariba Source Using Entity Framework

  This article shows how to access SAP Ariba Source using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Automate Microsoft Exchange Replication to Azure Data Lake

  Use CData Sync to customize and automate Microsoft Exchange replication to Azure Data Lake.

• Building Dynamic Web Pages with Zendesk Using AngularJS

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

• Connect to Active Directory from a Connection Pool in Jetty

  The Active Directory JDBC Driver supports connection pooling: This article shows how to connect faster to Active Directory from Web apps in Jetty.

• Provide OData Services of CSV from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for CSV/TSV Files by developing a WCF Service Application.

• How to connect to EventBrite from Spring Boot

  Connect to EventBrite in a Spring Boot Application using CData JDBC EventBrite Driver

• Connect to Avalara AvaTax from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Avalara AvaTax from Crystal Reports.

• Integrate Adobe Commerce into Power Automate Desktop using CData Connect

  CData Connect for Adobe Commerce enables you to integrate Adobe Commerce into workflows built using Microsoft Power Automate Desktop.

• «
• 474
• 475
• 476
• 477
• 478
• 479
• 480
• 481
• 482
• 483
• »