CData Software - Knowledge Base

Recent Articles

• «
• 261
• 262
• 263
• 264
• 265
• 266
• 267
• 268
• 269
• 270
• »

• How to use SQLAlchemy ORM to access SFTP in Python

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

• How to Seamlessly Import Certinia Data into IBM SPSS Modeler

  Integrate Certinia data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Model, Search, and Visualize Live Google Analytics in ThoughtSpot

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

• How to Build Dynamic React Apps with SAP ByDesign

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

• Access Live Shopify in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Shopify from your Excel spreadsheets.

• Use the CData Software ODBC Driver for Zoho Books in MicroStrategy Desktop

  Connect to Zoho Books in MicroStrategy Desktop using the CData Software ODBC Driver for Zoho Books.

• Connect to Azure Table 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 Azure Table Storage.

• Extract, Transform, and Load Dynamics 365 Business Central in Informatica PowerCenter

  Create a simple Workflow for Dynamics 365 Business Central in Informatica PowerCenter.

• How to integrate SAP Concur with Apache Airflow

  Access and process SAP Concur in Apache Airflow using the CData JDBC Driver.

• Create a Data Access Object for Sybase using JDBI

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

• Access Smartsheet from MySQL in PHP

  Connect to Smartsheet through the standard MySQL libraries in PHP.

• Connect to Bullhorn CRM in RapidMiner

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

• Connect to and Visualize Live Exact Online in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Exact Online.

• A PostgreSQL Interface for Oracle Service Cloud (MySQL Remoting via JDBC)

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

• Access Live SAP Hybris C4C in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live SAP Hybris C4C from your Excel spreadsheets.

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

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

• Automated Continuous Paylocity Replication to AlloyDB

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

• Build Visualizations of Salesforce Data Cloud in Birst

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

• Connect to Pinterest from a Connection Pool in Jetty

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

• Automate Google Spanner Replication to Azure Synapse

  Use CData Sync to customize and automate Google Spanner replication to Azure Synapse.

• Integrate Live Twilio into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Twilio from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Twilio.

• Create Azure DevOps-Connected Applications in Appsmith

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

• Author and Share Power BI Reports on Real-Time Unbounce

  Use the CData ODBC Driver for Unbounce to visualize Unbounce in Power BI Desktop and then upload to the Power BI service.

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

  Connect to Pinterest from a connection pool in Tomcat.

• Connect to AlloyDB in the Denodo Platform

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

• How to connect to Gmail from Spring Boot

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

• Seamlessly Bring Spark into Retool Using CData Connect Cloud

  Integrate Spark data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.

• Integrate with live Amazon DynamoDB in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Amazon DynamoDB in Jitterbit.

• How to connect to Google Contacts from IntelliJ

  Integrate connectivity to Google Contacts with wizards in IntelliJ.

• Viewing Salesforce in RAD Studio Data Explorer

  How to view Salesforce & Force.com in RAD Studio Data Explorer using the CData ODBC Driver for Salesforce.

• Create Highrise-Connected Visualizations in Klipfolio

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

• Automated Continuous Bing Ads Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Bing Ads replication to Azure SQL.

• Integrate WordPress in the Pentaho Report Designer

  Publish reports based on WordPress in the Pentaho BI tool.

• A PostgreSQL Interface for Veeva Vault (MySQL Remoting via JDBC)

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

• Establish a Live Connection with SharePoint Excel Services using Tableau Bridge

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

• Connect to Avalara AvaTax through External Services in Salesforce

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

• How to create SAP Netweaver Gateway federated tables in MySQL

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

• Integrate with SAP BusinessObjects BI in JReport Designer

  Create charts and reports based on SAP BusinessObjects BI in JReport Designer.

• Analyze DocuSign in SAP Analytics Cloud

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

• Create Confluence-Connected Dashboards in Grafana

  Connect to Confluence via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Atlassian Confluence.

• Access Live Coinbase in AWS Lambda (with IntelliJ IDEA)

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

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

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

• Connect to and Query Salesforce Data Cloud in QlikView over ODBC

  Create data visualizations with Salesforce Data Cloud in QlikView.

• Establish a Live Connection with Sugar CRM using Tableau Bridge

  The CData ODBC Driver for Sugar CRM enables you to integrate live Sugar CRM into Tableau Cloud dashboards using the Tableau Bridge.

• Use the CData SSIS Components to Insert New or Update Existing Google Calendar Records from SQL Server

  Easily push SQL Server data to Google Calendar using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Calendar or update existing records with data from a SQL Server database.

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

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

• Import and Visualize SAP BusinessObjects BI in Power View

  Create data visualizations based on SAP BusinessObjects BI in Excel.

• How to connect to Oracle Eloqua from MS Excel on Mac OS X

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

• Import Real-Time SQL Server via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Microsoft SQL Server in ColdFusion.

• Automated Continuous Azure Active Directory Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Azure Active Directory replication to Google Cloud SQL.

• Automated Continuous Zoho Projects Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Zoho Projects replication to Apache Cassandra.

• Build Sage 50 UK Visualizations in Tableau Cloud

  Use CData Software Connect Server to create a virtual SQL Server Database for Sage 50 UK and build visualizations in Tableau Cloud.

• Seamlessly Bring LinkedIn into Retool Using CData Connect Cloud

  Integrate LinkedIn data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.

• Build Azure Analysis Services-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Azure Analysis Services.

• How to load Quickbase data into Elasticsearch via Logstash

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

• Edit and Search External Microsoft Planner Objects in Salesforce Connect

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

• Build TaxJar Visualizations in Tableau Cloud

  Use CData Software Connect Server to create a virtual SQL Server Database for TaxJar and build visualizations in Tableau Cloud.

• Back Up SAP Business ByDesign to SQL Server through SSIS

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

• Natively Connect to Drift in PHP via ODBC (Linux)

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

• Visualize CockroachDB from Tableau

  Use the Tableau Desktop business intelligence tool to connect to CockroachDB.

• How to create an RPA flow for Sage 50 UK in UiPath Studio

  Use the Sage 50 UK ODBC Driver to create workflows that access real-time Sage 50 UK without any coding.

• Connect to eBay in Aqua Data Studio

  Access eBay from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Edit and Search External CouchDB Objects in Salesforce Connect

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

• Creating Microsoft OneDrive-Connected Applications in Unqork

  You can use CData Connect to feed Microsoft OneDrive to Unqork and build custom business apps.

• Create SSAS Tabular Models from Zenefits

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

• Automated Continuous Outreach.io Replication to Vertica

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

• Visualize Live Azure Active Directory in the Power BI Service

  Use CData Connect Cloud to connect to live Azure Active Directory and create custom reports in the Power BI Service through the On-Premises Gateway.

• Use the CData Software JDBC Driver for Blackbaud FE NXT in MicroStrategy

  Connect to Blackbaud FE NXT in MicroStrategy Developer using the CData Software JDBC Driver for Blackbaud FE NXT.

• Automated Continuous Facebook Replication to PostgreSQL

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

• Automated Continuous DB2 Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable DB2 replication to Amazon S3.

• How to integrate Certinia with Apache Airflow

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

• How to Access Databricks Using Entity Framework

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

• DataBind Controls to Dynamics CRM in Delphi

  DataBind to Microsoft Dynamics CRM in Delphi with standard data access components and controls.

• Connect to LDAP from a Connection Pool in WebLogic

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

• Visualize Live SharePoint Excel Services of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live SharePoint Excel Services using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Publish Hive-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Apache Hive.

• Use the CData ODBC Driver for Google Data Catalog in Microsoft Power Query

  You can use the CData Google Data Catalog ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Data Catalog into Microsoft Power Query.

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

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

• Import Drip into Microsoft Power Query

  The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access Drip. In this article, you will use the OData format to import Drip into Microsoft Power Query.

• Automated Continuous Sugar CRM Replication to Google Cloud SQL

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

• How to connect to Zendesk in DBVisualizer

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

• Access Live Pipedrive in AWS Lambda (with IntelliJ IDEA)

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

• How to create Visio diagrams from Smartsheet

  Automatically update Smartsheet with the changes you make to Visio master shapes.

• Connect to LDAP Objects in the Denodo Platform

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

• Automate Salesloft Replication to Azure Synapse

  Use CData Sync to customize and automate Salesloft replication to Azure Synapse.

• Connect to Jira from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Atlassian Jira, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Integrate TaxJar with External Services using SnapLogic

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

• How to create an RPA flow for HubSpot in UiPath Studio

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

• Working with DocuSign in LINQPad

  Execute LINQ queries to DocuSign in LINQPad.

• Automated Continuous Sugar CRM Replication to Databricks

  Use CData Sync for automated, continuous, customizable Sugar CRM replication to Databricks.

• Connect to Square from HeidiSQL

  Use CData Connect Cloud to connect to and query live Square from HeidiSQL.

• Automated Continuous Zoho Creator Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Zoho Creator replication to MongoDB.

• Create Zoho Projects-Connected Nintex Workflows

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

• How to Query Google Search Results in MySQL Workbench

  Execute MySQL queries against live Google Search from MySQL Workbench.

• Connect to Dynamics 365 Business Central from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Dynamics 365 Business Central to connect to Dynamics 365 Business Central from Web applications running on WebLogic.

• Build SAP Hybris C4C-Connected Web Apps with Axios and CData Connect Cloud

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

• Connect to Zuora as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Zuora.

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

• Integrate with QuickBooks Online in JReport Designer

  Create charts and reports based on QuickBooks Online in JReport Designer.

• Import Tally into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for Tally and create custom reports in the Power BI Service.

• «
• 261
• 262
• 263
• 264
• 265
• 266
• 267
• 268
• 269
• 270
• »