CData Software - Knowledge Base

Recent Articles

• «
• 246
• 247
• 248
• 249
• 250
• 251
• 252
• 253
• 254
• 255
• »

• How to Connect DBeaver to REST via a JDBC Driver

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

• Import SQL Analysis Services into FileMaker Pro

  Create reports that integrate SQL Analysis Services in Filemaker Pro.

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

  Connect to Apache Kafka 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 connect to BambooHR from Spring Boot

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

• Write a Simple Go Application to work with Xero on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Xero Accounting.

• Connect to Reckon in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Query IBM Cloud Object Storage as a MySQL Database in Node.js

  Execute MySQL queries against IBM Cloud Object Storage from Node.js.

• Build Charts with SQL Analysis Services in Clear Analytics

  Create dynamic charts and perform analytics based on SQL Analysis Services in Clear Analytics.

• Connect to Microsoft Project in as an External Source in Dremio

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

• Work with IBM Informix in FoxPro

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

• Connect to Azure Synapse in as an External Source in Dremio

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

• Access Live SAS xpt in AWS Lambda

  Connect to live SAS XPORT in AWS Lambda using the CData JDBC Driver.

• How to create an RPA flow for Zoho CRM in UiPath Studio

  Use the Zoho CRM ODBC Driver to create workflows that access real-time Zoho CRM without any coding.

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

  Provide connectivity to SFTP through an SAP BusinessObjects universe.

• Automated Continuous Google Directory Replication to Databricks

  Use CData Sync for automated, continuous, customizable Google Directory replication to Databricks.

• Build Dashboards with MySQL in DBxtra

  Create dynamic dashboards and perform analytics based on MySQL in DBxtra.

• Prepare, Blend, and Analyze Spark in Alteryx Designer

  Build workflows to access live Apache Spark SQL for self-service data analytics.

• Visualize Zoom in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for Zoom in CData Software Connect (or Connect Server) and build visualizations from live Zoom in Tableau Desktop.

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

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

• Automated Continuous Azure Synapse Replication to SQLite

  Use CData Sync for automated, continuous, customizable Azure Synapse replication to SQLite.

• Natively Connect to Redis in PHP

  Create PHP applications on Linux/UNIX machines with connectivity to Redis. Leverage the native support for ODBC in PHP.

• Connect to Amazon Marketplace from a Connection Pool in WebLogic

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

• Connect to Blackbaud FE NXT through External Services in Salesforce

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

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

  Connect to Klipfolio 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.

• Create Datasets from Amazon DynamoDB in Domo Workbench and Build Visualizations of Amazon DynamoDB in Domo

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

• Integrate Live Zuora into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Zuora and integrate live Zuora into apps built in Microsoft Power Apps.

• Choosing the Best Method to Connect Amazon Athena to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Amazon Athena from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Automate Office 365 Integration Tasks from PowerShell

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

• DataBind Controls to Amazon S3 in Delphi

  DataBind to Amazon S3 in Delphi with standard data access components and controls.

• Analyze Live Azure Data Lake Storage in SAS Viya

  Use CData Connect Cloud to connect to Azure Data Lake Storage from SAS Viya and deploy self-service analytics using live Azure Data Lake Storage.

• Integrate Zoho Projects with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Zoho Projects with External Services.

• Extract, Transform, and Load GitHub in Informatica PowerCenter

  Create a simple Workflow for GitHub in Informatica PowerCenter.

• Automated Continuous FHIR Replication to Vertica

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

• Replicate Multiple Wave Financial Accounts

  Replicate multiple Wave Financial accounts to one or many databases.

• Analyze Google Cloud Storage in SAP Analytics Cloud

  Use the CData Connect Server to create an OData API on top of Google Cloud Storage and visualize Google Cloud Storage in SAP Analytics Cloud.

• Publish Crystal Reports on Google Cloud Storage

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

• How to load Klipfolio data into Elasticsearch via Logstash

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

• Connect to Live Azure Data Lake Storage in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Azure Data Lake Storage in CData Connect Cloud and connect to your Azure Data Lake Storage from PostgreSQL.

• How to Query Jira in MySQL Workbench

  Execute MySQL queries against live Atlassian Jira from MySQL Workbench.

• Connect to and Query Access in QlikView over ODBC

  Create data visualizations with Microsoft Access in QlikView.

• How to Build Dynamic React Apps with Phoenix

  Use the CData Connect and React to Build Dynamic Web Apps with Live Phoenix .

• Integrate Pinterest with External Services using SnapLogic

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

• Integrate NetSuite into Power Automate Desktop using CData Connect

  CData Connect for NetSuite enables you to integrate NetSuite CRM & ERP into workflows built using Microsoft Power Automate Desktop.

• Create Apps from Adobe Commerce in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Adobe Commerce and build apps from live Adobe Commerce in Qlik Sense Cloud.

• Connect to Printful from PowerBuilder

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

• Build Semantic Layer Views for Square in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Square.

• Access OneNote in PHP through Connect Server

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

• Automated Continuous ConstantContact Replication to AlloyDB

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

• Access MongoDB from MySQL in PHP

  Connect to MongoDB through the standard MySQL libraries in PHP.

• Automate SAS xpt Replication to Azure Data Lake

  Use CData Sync to customize and automate SAS XPORT replication to Azure Data Lake.

• Query Azure DevOps in ColdFusion

  Write standard ColdFusion data access code to connect to Azure DevOps.

• Build Excel-Connected ETL Processes in Google Data Fusion

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

• Automated Continuous SAP HANA XS Advanced Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to delimited files (CSV/TSV).

• Automated Continuous MYOB AccountRight Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Microsoft Access.

• Integrate Real-Time Access to EventBrite in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Eventbrite in real time.

• Connect to and Visualize Live Dynamics NAV in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Dynamics NAV.

• Connect to JotForm in Ruby

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

• Design BIRT Reports on Gmail

  Provide current Gmail to your embedded analytics.

• DataBind Controls to Jira Assets in C++Builder

  DataBind to Jira Assets in C++Builder with standard components and controls.

• Use the CData Software JDBC Driver for Shopify in MicroStrategy Web

  Connect to Shopify in MicroStrategy Web using the CData Software JDBC Driver for Shopify.

• Access Hive from MySQL in HeidiSQL

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

• Connect to and Query Hive in QlikView over ODBC

  Create data visualizations with Apache Hive in QlikView.

• Connect to Google Spanner in Ruby

  Connect to Google Spanner in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Automated Continuous Excel Replication to Amazon Redshift

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

• Connect to Zoho Inventory as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Zoho Inventory.

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

• Build MVC Applications with Connectivity to GitHub

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

• Stream GitHub into Apache Kafka Topics

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

• How to connect to Hive in DBVisualizer

  Integrate Apache Hive with visual data analysis tools and data connection wizards in DBVisualizer

• Accessing Website Data Using ADO.NET

  An article from iProgrammer explores accessing Web data through the CData Data Providers: Interacting with websites via the wide range of APIs that are on offer is attractive because it provides new possibilities but is slightly depressing because you have to find out how to do the job all over again for each API. Now there is a better way...

• Publish Crystal Reports on Zoom

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

• Automated Continuous Act-On Replication to Databricks

  Use CData Sync for automated, continuous, customizable Act-On replication to Databricks.

• Access Live SurveyMonkey in Excel (Desktop)

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

• Replicate QuickBooks Online for Use in Salesforce Connect

  Replicate QuickBooks Online to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• How to use SQLAlchemy ORM to access Invoiced in Python

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

• Automated Continuous BigCommerce Replication to AlloyDB

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

• View Reports on Real-Time Google Campaign Manager 360 in Power BI Report Server

  Use the CData ODBC Driver for Google Campaign Manager 360 to visualize Google Campaign Manager 360 in Power BI Desktop and then publish them to Power BI Report Server.

• Build Dashboards with Azure Synapse in DBxtra

  Create dynamic dashboards and perform analytics based on Azure Synapse in DBxtra.

• Connect to Confluence in HULFT Integrate

  Connect to Confluence as a JDBC data source in HULFT Integrate

• Build Hive-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Apache Hive.

• Analyze SharePoint in Looker

  Use CData Connect Cloud to connect to SharePoint from Looker and build custom apps using live Microsoft SharePoint.

• Connect to Real-Time Salesforce Marketing Data in Power Apps Using Dataflows to Build Custom Applications

• «
• 246
• 247
• 248
• 249
• 250
• 251
• 252
• 253
• 254
• 255
• »