CData Software - Knowledge Base

Recent Articles

• «
• 464
• 465
• 466
• 467
• 468
• 469
• 470
• 471
• 472
• 473
• »

• Import and Visualize CockroachDB in Power View

  Create data visualizations based on CockroachDB in Excel.

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

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

• Process & Analyze Excel in Databricks (AWS)

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

• Connect to Hive from Excel & GoogleSheets!

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

• Automated Continuous HCL Domino Replication to Amazon Redshift

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

• A Comparison of Database Drivers for MySQL

  A performance comparison of the CData JDBC & ODBC Drivers for MySQL and the native MySQL Connector/J & Connector/ODBC (updated May 2020)

• Consume SFTP OData Feeds in PowerBuilder

  This article demonstrates how to consume SFTP as OData feeds from PowerBuilder using the API Server.

• Trigger SAP SuccessFactors IFTTT Flows in Azure App Service

  This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.

• Access Live Oracle SCM in AWS Lambda (with IntelliJ IDEA)

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

• Migrating data from LDAP to Google BigQuery using CData SSIS Components.

  Easily push LDAP to Google BigQuery using the CData SSIS Tasks for LDAP and Google BigQuery.

• Connect to Salesloft in Ruby

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

• Replicate Asana to Multiple Databases via the CData Sync CLI

  Replicate Asana to disparate databases with a single configuration.

• Automated Continuous SendGrid Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable SendGrid replication to Google BigQuery.

• Access Tally as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Tally ERP from your Oracle system.

• Build Salesforce Marketing-Connected ETL Processes in Google Data Fusion

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

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

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

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

  Connect to Apache Hive 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.

• Automated Continuous Adobe Analytics Replication to Google Cloud SQL

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

• Create SSAS Tabular Models from Google Sheets

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

• Use the CData Software ODBC Driver for HDFS in MicroStrategy Web

  Connect to Apache HDFS in MicroStrategy Web using the CData Software ODBC Driver for HDFS.

• How to load SFTP data into Elasticsearch via Logstash

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

• View Reports on Real-Time IBM Cloud Object Storage in Power BI Report Server

  Use the CData ODBC Driver for IBM Cloud Object Storage to visualize IBM Cloud Object Storage in Power BI Desktop and then publish them to Power BI Report Server.

• LINQ to Paylocity

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

• Connect to Couchbase from Excel & GoogleSheets!

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

• Use the CData Software ODBC Driver for Amazon DynamoDB in MicroStrategy Web

  Connect to Amazon DynamoDB in MicroStrategy Web using the CData Software ODBC Driver for Amazon DynamoDB.

• Access Typeform from MySQL in HeidiSQL

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

• Create Data Visualizations Based On Stripe in Mode

  Use CData Connect Cloud to connect to Stripe from Mode and build visualizations using live

• Analyze Yahoo! Japan Data Solution in Cognos Analytics

  Use CData Connect Cloud to connect to Yahoo! Japan Data Solution from Cognos Analytics and analyze live Yahoo! Japan Data Solution.

• Build Oracle Eloqua-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Oracle Eloqua and build web apps with connectivity to live Oracle Eloqua.

• Replicate Multiple Act CRM Accounts

  Replicate multiple Act CRM accounts to one or many databases.

• Perform Batch Operations with IBM Cloud Data Engine in Apache NiFi

  Connect to IBM Cloud Data Engine and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Use the CData Software ODBC Driver for TigerGraph in MicroStrategy Web

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

• Create Reports from Freshdesk in Looker Studio

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

• Connect to Trello in the Denodo Platform

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

• How to Visualize Twitter Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Twitter in Python.

• Create Reports from Zoho Projects in Looker Studio

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

• Connect to Kintone as a SQL Server Linked Server

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

• Access Live TaxJar in TIBCO Data Virtualization

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

• Rapidly Develop Twitter Ads-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.

• Connect to Sugar CRM 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 Sugar CRM.

• Connect to Google Drive from Blazor Apps

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

• Cassandra Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Apache Cassandra through CData Connect Cloud using different applications and tools.

• Connect to Okta in the Denodo Platform

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

• Build Shopify Visualizations in Tableau Cloud

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

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

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

• Connect and Visualize Live Sage Intacct Data in Databricks Lakehouse Federation with CData Connect Cloud

  Use CData Connect Cloud to integrate live Sage Intacct into the Databricks platform and create visualization dashboards with real-time Sage Intacct.

• Create SAP Concur Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• Use the CData ODBC Driver for Azure Analysis Services from SharePoint Excel Services

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

• Replicate Basecamp to Multiple Databases via the CData Sync CLI

  Replicate Basecamp to disparate databases with a single configuration.

• DataBind Controls to Stripe in C++Builder

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

• Query Bing Search Results through ODBC in Node.js

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

• Connect to LinkedIn Ads from a Connection Pool in WebLogic

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

• Replicate Zoho CRM to Multiple Databases

  Replicate Zoho CRM to disparate databases with a point-and-click configuration.

• Automated Continuous Drip Replication to Vertica

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

• Automated Continuous Twitter Ads Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Twitter Ads replication to Microsoft Access.

• Access Live Avalara AvaTax in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Avalara AvaTax from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Validate LinkedIn with QuerySurge

  Access and validate LinkedIn in QuerySurge using the CData JDBC Driver.

• Visualize Live Sage Intacct in the Power BI Service

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

• Klipfolio Reporting and Star Schemas in OBIEE

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

• Connect to Google Ads from Excel & GoogleSheets!

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

• Build Data Flows from LinkedIn Ads to SQL Server using SSIS

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

• Connect to Jira Assets in Jaspersoft Studio

  Execute SQL to remote Jira Assets in Jaspersoft Studio.

• Create Dashboards and Visualize Live GMO MakeShop in Geckoboard

  Use CData Connect Cloud to connect to live GMO MakeShop and create dashboards for real-time monitoring and visualization in Geckoboard.

• Reckon Accounts Hosted Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Reckon Accounts Hosted facts in real time.

• Automated Continuous Azure Data Lake Storage Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Apache Kafka.

• Access Microsoft Teams from MySQL in PHP

  Connect to Microsoft Teams through the standard MySQL libraries in PHP.

• ETL SingleStore in Oracle Data Integrator

  This article shows how to transfer SingleStore into a data warehouse using Oracle Data Integrator.

• Working with QuickBooks Online in LINQPad

  Execute LINQ queries to QuickBooks Online in LINQPad.

• Query Redshift through ODBC in Node.js

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

• Automated Microsoft Teams Replication to Teradata

  Use CData Sync to Customize and automate Microsoft Teams replication to Teradata.

• Visualize Power BI XMLA in TIBCO Spotfire through ODBC

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

• Publish Zendesk-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Zendesk.

• Connect to Zenefits as an External Source in Dremio

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

• Query Avro in ColdFusion

  Write standard ColdFusion data access code to connect to Apache Avro.

• How to use SQLAlchemy ORM to access Microsoft Teams in Python

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

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

  Use the CData Connector for REST in APOS Live Data Gateway to build Semantic Layer Views for REST.

• Connect to Shopify from a Connection Pool in Jetty

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

• How to Connect to HubSpot in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to HubSpot. Leverage the pyodbc module for ODBC in Python.

• Edit and Search External Dynamics 365 Objects in Salesforce Connect

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

• Build Automated Workflows with Live SAP Concur in Workato

  Use CData Connect Cloud to connect to live SAP Concur and build automated workflows in Workato.

• Automated Continuous Sugar CRM Replication to Apache Kafka

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

• Connect to SurveyMonkey Using the Script Function in Claris FileMaker Pro

• «
• 464
• 465
• 466
• 467
• 468
• 469
• 470
• 471
• 472
• 473
• »