CData Software - Knowledge Base

Recent Articles

• «
• 347
• 348
• 349
• 350
• 351
• 352
• 353
• 354
• 355
• 356
• »

• Publish BigCommerce-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live BigCommerce.

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

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

• Automate XML Replication to Couchbase

  Use CData Sync to Customize and automate XML Files replication to Couchbase.

• Access Live Dynamics CRM in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Microsoft Dynamics CRM from your Google Sheets.

• Prepare, Blend, and Analyze QuickBooks Online in Alteryx Designer (ODBC)

  Build workflows to access live QuickBooks Online for self-service data analytics.

• Easily Integrate Kintone in Lazarus Pascal IDE

  Learn how to easily integrate live Kintone in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• DataBind Controls to Sybase IQ in C++Builder

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

• Build Visualizations of Quickbase in Birst

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

• Visualize JSON Services from Tableau

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

• Analyze Databricks in SAP Analytics Cloud

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

• Design BIRT Reports on Azure Synapse

  Provide current Azure Synapse to your embedded analytics.

• A PostgreSQL Interface for Kintone using the CData ODBC Driver

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

• Seamlessly Bring CockroachDB into Retool Using CData Connect Cloud

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

• Create Informatica Mappings From/To a JDBC Data Source for SharePoint

  Create SharePoint data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

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

  Provide connectivity to Email through an SAP BusinessObjects universe.

• Query, Visualize, and Share live Facebook in Redash

  Use CData Connect Cloud to connect to live Facebook in Redash for querying, visualizing, and sharing.

• Build Semantic Layer Views for Azure Table in APOS Live Data Gateway

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

• Connect to Pipedrive in DBeaver

  Use the CData ODBC Driver to connect to Pipedrive in DBeaver.

• How to connect to WordPress from Spring Boot

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

• Connect to SendGrid in Google Apps Script via SQL Gateway

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

• Connect to Azure Synapse from Blazor Apps

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

• Connect to Redshift in Jaspersoft Studio

  Execute SQL to remote Amazon Redshift in Jaspersoft Studio.

• Load SFTP to a Database Using Embulk

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

• How to Work with Greenhouse in ETL Validator JDBC

  Connect to Greenhouse from ETL Validator jobs using the CData Software JDBC Driver.

• How to Connect to & Open DocuSign in Microsoft Excel

  This article uses the CData ODBC driver for DocuSign to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Visualize Live Phoenix in the Power BI Service

  Use CData Software Connect Server to create a virtual SQL Server database for Apache Phoenix and create custom reports in the Power BI Service.

• Manage Oracle in DBArtisan as a JDBC Source

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

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

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

• Use the CData ODBC Driver for Microsoft Project from SharePoint Excel Services

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

• Integrate with live Act CRM in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Act CRM in Jitterbit.

• Connect to and Query Authorize.Net in QlikView over ODBC

  Create data visualizations with Authorize.Net in QlikView.

• Visualize Microsoft Dataverse in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft Dataverse (CDS) into TIBCO Spotfire.

• Integrate Azure Analysis Services into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Azure Analysis Services and integrate live Azure Analysis Services into your Power Automate tasks.

• How to update Twitter from Excel

  This article explains how to transfer data from Excel to Twitter using the Excel Add-In for Twitter.

• Build Freshdesk-Connected Web Apps in Servoy

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

• Use the CData Software JDBC Driver for SAP Fieldglass in MicroStrategy

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

• Replicate Oracle Eloqua for Use in Salesforce Connect

  Replicate Oracle Eloqua to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Manage Trello in DBArtisan as a JDBC Source

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

• Automated Continuous OData Replication to Google Cloud SQL

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

• Visualize Live SAP Ariba Procurement in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live SAP Ariba Procurement into custom reports in Power BI.

• How to use SQLAlchemy ORM to access Cosmos DB in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure Cosmos DB.

• DataBind Wijmo Grid to Google Drive

  Provide real-time Google Drive to interactive controls.

• How to Work with SFTP in ETL Validator JDBC

  Connect to SFTP from ETL Validator jobs using the CData Software JDBC Driver.

• Build a Simple VCL Application for Zoho Creator

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

• SQL Analysis Services Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on SQL Analysis Services facts in real time.

• Create Oracle Financials Cloud-Connected Nintex Workflows

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

• Connect to Jira in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Atlassian Jira in Google Apps Script.

• Automate SAP Replication to Azure Data Lake

  Use CData Sync to customize and automate SAP ERP/NetWeaver replication to Azure Data Lake.

• Replicate Harvest for Use in Salesforce Connect

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

• How to Visualize Salesloft Data in Python with pandas

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

• Create a Data Access Object for Amazon Athena using JDBI

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

• Connect to Airtable as a Linked Server via SQL Gateway

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

• Automated Continuous SAP Netweaver Gateway Replication to MySQL

  Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to MySQL.

• Automate Excel Online Integration Tasks from PowerShell

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

• Natively Connect to Drift in PHP

  The CData ODBC driver for Drift enables you to create PHP applications with connectivity to Drift. Leverage the native support for ODBC in PHP.

• How to Visualize Adobe Analytics Data in Python with pandas

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

• Create Salesforce-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Salesforce from OutSystems and build custom enterprise apps using live Salesforce & Force.com.

• LINQ to Bitbucket

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

• Connect to and Query Sage Intacct in QlikView over ODBC

  Create data visualizations with Sage Intacct in QlikView.

• Visualize Paylocity in TIBCO Spotfire through ADO.NET

  Integrate Paylocity into dashboards in TIBCO Spotfire.

• Connect to MariaDB in DBeaver

  Use the CData ODBC Driver to connect to MariaDB in DBeaver.

• Connect to SendGrid in JRuby

  Create a simple JRuby app with access to live SendGrid.

• Integrate SAP BusinessObjects BI in Pentaho Data Integration

  Build ETL pipelines based on SAP BusinessObjects BI in the Pentaho Data Integration tool.

• Create Azure Data Lake Storage-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Azure Data Lake Storage from Klipfolio and build custom visualizations using live Azure Data Lake Storage.

• Visualize Workday from Tableau

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

• Build Data Flows from SQL Server to NetSuite through SSIS

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

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

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

• Automated Continuous Acumatica Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Acumatica ERP replication to OneLake in Microsoft Fabric.

• Access Live Jira in Excel (Desktop) via Connect Cloud

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

• Integrate Amazon Athena with External Services using SnapLogic

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

• Prepare, Blend, and Analyze Facebook in Alteryx Designer (ODBC)

  Build workflows to access live Facebook for self-service data analytics.

• How to integrate Azure Data Lake Storage with Apache Airflow

  Access and process Azure Data Lake Storage in Apache Airflow using the CData JDBC Driver.

• Replicate Salesforce to Multiple Databases via the CData Sync CLI

  Replicate Salesforce & Force.com to disparate databases with a single configuration.

• Automate Dynamics NAV Replication to SAP HANA

  Use CData Sync to customize and automate Microsoft Dynamics NAV replication to SAP HANA.

• Use CData Connect Cloud to Access Dynamics 365 Business Central in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Dynamics 365 Business Central in the Power Pivot business intelligence tool.

• How to connect PolyBase to Dynamics 365

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

• Connect to Harvest from a Connection Pool in WebLogic

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

• Query IBM Informix in DataGrip

  Create a Data Source for IBM Informix in DataGrip and use SQL to query live IBM Informix.

• Build Dashboards with IBM Cloud Data Engine in Dundas BI

  Create dynamic dashboards and perform analytics based on IBM Cloud Data Engine in Dundas BI.

• Build Presto-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for Presto and create custom apps in Mendix.

• Connect to Airtable from Blazor Apps

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

• Bridge Dynamics GP Connectivity with Apache NiFi

  Access and process Microsoft Dynamics GP in Apache NiFi using the CData JDBC Driver.

• ETL Twitter Ads in Oracle Data Integrator

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

• Working with Cvent in LINQPad

  Execute LINQ queries to Cvent in LINQPad.

• How to Work with Excel in ETL Validator JDBC

  Connect to Excel from ETL Validator jobs using the CData Software JDBC Driver.

• How to Work with Zendesk in ETL Validator JDBC

  Connect to Zendesk from ETL Validator jobs using the CData Software JDBC Driver.

• Connect to WooCommerce from a Connection Pool in Jetty

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

• PowerShell Scripting to Replicate EventBrite to MySQL

  Write a simple PowerShell script to replicate Eventbrite to a MySQL database.

• Create Snowflake Dashboards in Bold BI

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

• Use the CData Software JDBC Driver for Twitter Ads in MicroStrategy Web

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

• How to Use a Microsoft Access Database to Update Salesforce in Real Time

  Update Salesforce data by creating a linked table in Microsoft Access with the CData Salesforce ODBC Driver.

• Create Data Visualizations in Cognos BI with SAP

  Access SAP ERP/NetWeaver as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Connect to Sugar CRM from Asprova with CData Software ODBC Driver for Sugar CRM

  This article shows how to connect faster to Sugar CRM data from Asprova.

• How to load Tableau CRM Analytics data into Elasticsearch via Logstash

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

• DataBind Controls to JotForm in Delphi

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

• How to integrate Metabase with MongoDB

  Use CData Connect Cloud to connect to live MongoDB and create an interactive dashboard in Metabase from MongoDB.

• Connect to Salesforce Pardot from PowerBuilder via JDBC

  This article demonstrates how to access Salesforce Pardot from PowerBuilder using the Salesforce Pardot JDBC Driver.

• Visualize SAP Business One in Tableau

  The CData ODBC driver for SAP Business One enables you integrate SAP Business One into Tableau dashboards.

• Analyze Google Sheets in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Google Sheets in Microsoft R Open.

• Integrate Zoho Books in Pentaho Data Integration

  Build ETL pipelines based on Zoho Books in the Pentaho Data Integration tool.

• «
• 347
• 348
• 349
• 350
• 351
• 352
• 353
• 354
• 355
• 356
• »