CData Software - Knowledge Base

Recent Articles

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• »

• Query LinkedIn Ads in MySQL Workbench

  Create a virtual MySQL database for LinkedIn Ads in CData Software Connect (or Connect Server) and work with live LinkedIn Ads in MySQL Workbench.

• How to Query Zoho Inventory in MySQL Workbench

  Execute MySQL queries against live Zoho Inventory from MySQL Workbench.

• Connect to Todoist in as an External Source in Dremio

  Use the CData JDBC Driver to connect to Todoist as an External Source in Dremio.

• Using AngularJS to Build Dynamic Web Pages with BigCommerce

  Use the CData Connect Server to create BigCommerce OData feeds and build single-page applications with live BigCommerce.

• Build Sage 200 Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Sage 200 and build visualizations in Tableau Cloud.

• Connect to Zoho Creator in Ruby

  Connect to Zoho Creator in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Connect to Azure DevOps in DBArtisan

  Use wizards in DBArtisan to configure Azure DevOps as a data source.

• Export Data from SQL Server to Spark through SSIS

  Easily push SQL Server data to Spark using the CData SSIS Tasks for Spark.

• Stream SAP HANA into Apache Kafka Topics

  Access and stream SAP HANA in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Connect to MYOB AccountRight in RapidMiner

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

• Query xBase as a SQL Server in Node.js

  Execute SQL Server queries against xBase from Node.js.

• Integrate Adobe Commerce with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Adobe Commerce with External Services.

• Access Live Zuora in Excel 365 Online (Excel for the web)

  Connect to Zuora from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Create Dynamic Jira Grids Using the Infragistics XamDataGrid

  Learn how you can connect Jira to Infragistics XamDataGrid to build dynamic grids.

• Analyze HBase in Infragistics Reveal

  Use the CData Connect Server to create an OData API on top of Apache HBase and visualize live Apache HBase in Ingragistics Reveal.

• Integrate Office 365 in the Pentaho Report Designer

  Publish reports based on Microsoft Office 365 in the Pentaho BI tool.

• Access Instagram in PHP through Connect Server

  Connect to Instagram through the standard SQL Server libraries in PHP.

• How to connect PolyBase to Kintone

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Kintone.

• Connect to Facebook Ads as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Facebook Ads.

• Analyze Oracle Service Cloud in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of Oracle Service Cloud and visualize live Oracle Service Cloud in Infragistics Reveal.

• How to create TigerGraph federated tables in MySQL

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

• Access IBM Informix from MySQL in HeidiSQL

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

• Import Microsoft Dataverse into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Microsoft Dataverse and provide access to live Microsoft Dataverse (CDS) for custom reports in the Power BI Service.

• Model IBM Informix Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and IBM Informix, enabling the direct import of real-time IBM Informix.

• Connect to Marketo in DBArtisan

  Use wizards in DBArtisan to configure Marketo as a data source.

• Automated Continuous Kintone Replication to AlloyDB

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

• How to create an RPA flow for SAP HANA XS Advanced in UiPath Studio

  Use the SAP HANA XS Advanced ODBC Driver to create workflows that access real-time SAP HANA XS Advanced without any coding.

• Write a Simple Go Application to work with SAP Business One on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Business One.

• Replicate SAP Concur to Multiple Databases

  Replicate SAP Concur to disparate databases with a single configuration.

• Use the CData Software JDBC Driver for SharePoint Excel Services in MicroStrategy

  Connect to SharePoint Excel Services in MicroStrategy Developer using the CData Software JDBC Driver for SharePoint Excel Services.

• Build Pipelines with Live ADP in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to ADP from Google Cloud Data Fusion, enabling the integration of live ADP into the building and management of effective data pipelines.

• Publish Crystal Reports on Calendly

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Calendly.

• Automated Continuous Microsoft Exchange Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to SingleStore.

• Use the CData ODBC Driver for DB2 in SAS JMP

  You can use the CData ODBC Driver to integrate IBM DB2 into the statistical analysis tools available in SAS JMP. This article shows how to use IBM DB2 in the Graph Builder and Query Builder.

• Publish Jira Assets-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Jira Assets.

• Replicate Sybase from PowerShell

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

• Visualize Live Printful in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Printful.

• Use the CData Software JDBC Driver for CockroachDB in MicroStrategy

  Connect to CockroachDB in MicroStrategy Developer using the CData Software JDBC Driver for CockroachDB.

• Query Cvent as a MySQL Database in Node.js

  Execute MySQL queries against Cvent from Node.js.

• How to connect to WooCommerce in DBVisualizer

  Integrate WooCommerce with visual data analysis tools and data connection wizards in DBVisualizer

• Create a Data Access Object for SAP Fieldglass using JDBI

  A brief overview of creating a SQL Object API for SAP Fieldglass in JDBI.

• Connect to Dynamics NAV in Jaspersoft Studio

  Execute SQL to remote Microsoft Dynamics NAV in Jaspersoft Studio.

• Connect to Oracle Financials Cloud in SpagoBI

  Create reports featuring live Oracle Financials Cloud in SpagoBI Studio. Host Oracle Financials Cloud reports on SpagoBI Server.

• Validate Google Search Results with QuerySurge

  Access and validate Google Search in QuerySurge using the CData JDBC Driver.

• Automated Continuous Oracle Service Cloud Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to SingleStore.

• Build Visualizations of Tableau CRM Analytics in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Tableau CRM Analytics in Birst.

• Import Active Directory into FileMaker Pro

  Create reports that integrate Active Directory in Filemaker Pro.

• Automated Continuous Freshdesk Replication to MySQL

  Use CData Sync for automated, continuous, customizable Freshdesk replication to MySQL.

• Manage Jira in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Jira.

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

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

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

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

• Connect to Oracle Financials Cloud in RapidMiner

  Integrate Oracle Financials Cloud with standard components and data source configuration wizards in RapidMiner Studio.

• Build an OLAP Cube in SSAS from MongoDB

  Establish a connection to MongoDB data from SQL Server Analysis Services, and use the MongoDB Data Provider to build OLAP cubes for use in analytics and reporting.

• Query LinkedIn Ads through ODBC in Node.js

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

• How to create Oracle Eloqua federated tables in MySQL

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

• Access Live Sybase in Coginiti Pro

  Connect to and query live Sybase from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Build Dashboards with Paylocity in Dundas BI

  Create dynamic dashboards and perform analytics based on Paylocity in Dundas BI.

• DataBind Wijmo Grid to Drift

  Provide real-time Drift to interactive controls.

• Automated Continuous Pinterest Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Pinterest replication to Amazon Redshift.

• How to Connect DBeaver to MongoDB via a JDBC Driver

  Manage MongoDB with visual tools in DBeaver like the query browser.

• Create Procore-Connected Visualizations in Klipfolio

  Use CData Software Connect Server to connect to Procore from Klipfolio and build custom visualizations using live Procore.

• How to connect PolyBase to Google Calendar

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Calendar.

• Connect to Bing Ads from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for Bing Ads to connect to Bing Ads and execute queries in PowerBuilder.

• Bridge Gmail Connectivity with Apache NiFi

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

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

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

• Create Sugar CRM Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for Sugar CRM to build custom dashboards in Bold BI.

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

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

• Connect to SharePoint in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to SingleStore through External Services in Salesforce

  Use CData Connect Cloud to securely provide OData feeds of SingleStore to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SingleStore objects that you can access from apps and the dashboard.

• Automated Continuous Access Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Access replication to Google Cloud SQL.

• Load SQL Server to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft SQL Server to a database.

• Connect to Pipedrive from a Connection Pool in JBoss

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

• How to connect to Marketo from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Marketo and work with Marketo in Microsoft Excel on Mac OS X.

• DataBind Controls to Exact Online in Delphi

  DataBind to Exact Online in Delphi with standard data access components and controls.

• Use Biml to Build SSIS Tasks to Replicate Google Analytics to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Analytics to SQL Server.

• Connect to and Visualize Live Salesforce in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Salesforce & Force.com.

• Create SSAS Tabular Models from GitHub

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

• How to Create Power BI Visual Reports with Real-Time Quickbase

  Use CData Power BI Connectors to visualize Quickbase in Power BI.

• How to publish and share Microsoft Project dashboards with Tableau Server

  The CData ODBC driver for Microsoft Project enables you integrate Microsoft Project into Tableau dashboards.

• Automated Continuous SuiteCRM Replication to Oracle

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

• Connect to Google Drive in Google Apps Script

  Use the ODBC Driver for Google Drive and the SQL Gateway to access Google Drive from Google Apps Script.

• Use JayDeBeApi to access Zuora in Python

  Use standard Python scripting and the development environment of your choice to access live Zuora.

• Explore Geographical Relationships in Presto with Power Map

  Create data visualizations with Presto in Power Map.

• Connect to Microsoft OneDrive in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Use the CData Software ODBC Driver for SAP HANA in MicroStrategy Web

  Connect to SAP HANA in MicroStrategy Web using the CData Software ODBC Driver for SAP HANA.

• Explore Geographical Relationships in Power BI XMLA with Power Map

  Create data visualizations with Power BI XMLA in Power Map.

• Access Live Redis in TIBCO Data Virtualization

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

• Create Adobe Analytics Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for Adobe Analytics to build custom dashboards in Bold BI.

• Automated Continuous Tally Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Tally replication to Apache Kafka.

• How to Connect the Power BI Service to SharePoint Excel Services: Complete Guide

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

• Salesforce Reporting in OBIEE with the Salesforce JDBC Driver

  Deploy the Salesforce JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Build Visualizations of Elasticsearch in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Elasticsearch in Birst.

• Build Apps with Live Adobe Analytics in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live Adobe Analytics into the Adalo platform and build custom mobile and web applications with real-time Adobe Analytics.

• Connect to JDBC-ODBC Bridge in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Use the CData Software JDBC Driver for Zoho Projects in MicroStrategy

  Connect to Zoho Projects in MicroStrategy Developer using the CData Software JDBC Driver for Zoho Projects.

• Creating Couchbase-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Couchbase to Unqork and build custom business apps.

• A PostgreSQL Interface for Zenefits

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

• Build Presto-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Presto from Zoho Analytics and import live Presto.

• Connect to Google Analytics in RapidMiner

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

• Connect to Oracle Sales from PowerBuilder

  This article demonstrates how to access Oracle Sales from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle Sales.

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• »