CData Software - Knowledge Base

Recent Articles

• «
• 308
• 309
• 310
• 311
• 312
• 313
• 314
• 315
• 316
• 317
• »

• Export Data from SQL Server to SAS Data Sets through SSIS

  Easily push SQL Server data to SAS Data Sets using the CData SSIS Tasks for SAS Data Sets.

• Visualize Live Paylocity of Power BI Report Builder in Power BI Service

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

• Visualize CockroachDB in Sisense

  Create an ElastiCube in Sisense app with access to CockroachDB.

• Automate Oracle Integration Tasks from PowerShell

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

• Query Azure Table in DataGrip

  Create a Data Source for Azure Table in DataGrip and use SQL to query live Azure Table Storage.

• Connect to ShipStation in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for ShipStation in Airbyte.

• Explore Geographical Relationships in Jira with Power Map

  Create data visualizations with Atlassian Jira in Power Map.

• Automated Continuous OneNote Replication to SQLite

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

• DataBind Controls to Blackbaud FE NXT in Delphi

  DataBind to Blackbaud FE NXT in Delphi with standard data access components and controls.

• How to Connect DBeaver to Azure Synapse via a JDBC Driver

  Manage Azure Synapse with visual tools in DBeaver like the query browser.

• Connect to Exact Online in DBArtisan

  Use wizards in DBArtisan to configure Exact Online as a data source.

• Connect to Drip in DBArtisan

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

• Use the CData ODBC Driver for Wave Financial from SharePoint Excel Services

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

• Visualize Live Drift of Power BI Report Builder in Power BI Service

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

• Automated Continuous Google Contacts Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Google Contacts replication to Azure SQL.

• Create Datasets from Snapchat Ads in Domo Workbench and Build Visualizations of Snapchat Ads in Domo

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Contacts

  Provide connectivity to Google Contacts through an SAP BusinessObjects universe.

• How to Build Dynamic React Apps with Todoist

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

• Viewing Microsoft Teams in RAD Studio Data Explorer

  How to view Microsoft Teams in RAD Studio Data Explorer using the CData ODBC Driver for Microsoft Teams.

• Create SSAS Tabular Models from SAP BusinessObjects BI

  How to build a SQL Server Analysis Service Tabular Model from SAP BusinessObjects BI using CData drivers.

• Create TigerGraph Dataflows on PowerBI.com

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

• Build Charts with Adobe Commerce in Clear Analytics

  Create dynamic charts and perform analytics based on Adobe Commerce in Clear Analytics.

• How to connect to Confluence from IntelliJ

  Integrate connectivity to Atlassian Confluence with wizards in IntelliJ.

• Automated Continuous SingleStore Replication to Apache Kafka

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

• Connect to Zoho Creator in RazorSQL

  Connect to Zoho Creator from wizards and query Zoho Creator from the GUI in the RazorSQL database management tool.

• Publish ConstantContact-Connected Dashboards in Tableau Server

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

• Build Apps with Live Monday.com in Adalo using CData Connect Cloud

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

• Create a Data Access Object for FTP using JDBI

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

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

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

• Automated Continuous Adobe Analytics Replication to MySQL

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

• Create Apps from ShipStation in Qlik Sense Cloud

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

• Use CData Connect Cloud to Access API in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live API in the Power Pivot business intelligence tool.

• Query SharePoint in ColdFusion

  Write standard ColdFusion data access code to connect to Microsoft SharePoint.

• Connect to Freshdesk from Asprova with CData Software ODBC Driver for Freshdesk

  This article shows how to connect faster to Freshdesk data from Asprova.

• How to Visualize AlloyDB Data in Python with pandas

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

• Connect to Microsoft Exchange as a Linked Server

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

• Bridge Authorize.Net Connectivity with Apache NiFi

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

• LINQ to HBase

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

• How to connect PolyBase to Aha

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

• Visualize RSS Feeds in Sisense

  Create an ElastiCube in Sisense app with access to RSS Feeds.

• Visualize IBM Cloud Data Engine in Sisense

  Create an ElastiCube in Sisense app with access to IBM Cloud Data Engine.

• Replicate Zoho Creator to Multiple Databases

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

• Connect to Slack in RazorSQL

  Connect to Slack from wizards and query Slack from the GUI in the RazorSQL database management tool.

• Use the CData ODBC Driver for Oracle HCM Cloud in Microsoft Power Query

  You can use the CData Oracle HCM Cloud ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Oracle HCM Cloud into Microsoft Power Query.

• How to Query Oracle in MySQL Workbench

  Execute MySQL queries against live Oracle Database from MySQL Workbench.

• Connect to Sage Intacct in JRuby

  Create a simple JRuby app with access to live Sage Intacct.

• Access Live HubDB in Coginiti Pro

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

• How to publish and share Freshdesk dashboards with Tableau Server

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

• Query Jira Service Management as a SQL Server Database in Node.js

  Execute SQL Server queries against Atlassian Jira Service Management from Node.js.

• Automated Continuous Microsoft Planner Replication to PostgreSQL

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

• Connect to Sage 50 UK in RapidMiner

  Integrate Sage 50 UK with standard components and data source configuration wizards in RapidMiner Studio.

• How to Connect to Exact Online in Using Python: 6 Steps

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

• Connect to and Query Snowflake in QlikView over ODBC

  Create data visualizations with Snowflake in QlikView.

• Create SharePoint Excel Services-Connected Visualizations in Klipfolio

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

• How to Query Shippo in MySQL Workbench

  Execute MySQL queries against live Shippo from MySQL Workbench.

• Build Semantic Layer Views for IBM Informix in APOS Live Data Gateway

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

• Build Automated Workflows with Live MongoDB in Workato

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

• How to publish and share Certinia dashboards with Tableau Server

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

• LINQ to Dropbox

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

• Create QuickBooks-Connected Nintex Workflows

  Use CData Software Connect Server to connect to QuickBooks from Nintex Workflow Cloud and build custom workflows using live QuickBooks Desktop.

• Create Authorize.Net-Connected Business Apps in AppSheet

  Use CData Software Connect Server to connect to Authorize.Net from AppSheet and build custom business apps using live Authorize.Net.

• A PostgreSQL Interface for Active Directory

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

• Connect to SurveyMonkey in Google Apps Script

  Use CData Connect Cloud to access SurveyMonkey in Google Apps Script.

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

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

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

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

• DataBind Wijmo Grid to Kintone

  Provide real-time Kintone to interactive controls.

• Connect to Live eBay in MicroStrategy through CData Connect Cloud

  Create a live connection to eBay in CData Connect Cloud and connect to your eBay from MicroStrategy.

• Load xBase to a Database Using Embulk

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

• How to Build Dynamic React Apps with Klipfolio

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

• How to use SQLAlchemy ORM to access Azure Table in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure Table Storage.

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

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

• Connect to Google Drive in HULFT Integrate

  Connect to Google Drive as a JDBC data source in HULFT Integrate

• How to connect to Klaviyo from Spring Boot

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

• Feed CSV into FineReport

  How to set CSV/TSV Files as a JDBC data source in FineReport.

• Connect to Kintone from a Connection Pool in WebLogic

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

• Create a Data Access Object for Databricks using JDBI

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

• A PostgreSQL Interface for Coinbase

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

• Author and Share Power BI Reports on Real-Time Google Campaign Manager 360

  Use the CData ODBC Driver for Google Campaign Manager 360 to visualize Google Campaign Manager 360 in Power BI Desktop and then upload to the Power BI service.

• How to Visualize MariaDB Data in Python with pandas

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

• Build Microsoft Exchange-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live Microsoft Exchange and build Microsoft Exchange-connected web apps with Axios.

• Connect to Google Drive in SpagoBI

  Create reports featuring live Google Drive in SpagoBI Studio. Host Google Drive reports on SpagoBI Server.

• Use the CData ODBC Driver for Drift in Microsoft Power Query

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

• Connect to Instagram in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Natively Connect to SAP Ariba Procurement in PHP

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

• Integrate with Google Analytics in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Google Analytics in SnapLogic.

• How to Connect the Power BI Service to Dynamics 365 Business Central: Complete Guide

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

• Bridge CockroachDB Connectivity with Apache NiFi

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

• Build MVC Applications with Connectivity to QuickBooks Time

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

• A PostgreSQL Interface for Stripe

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

• Connect to Dynamics CRM in Jaspersoft Studio

  Execute SQL to remote Microsoft Dynamics CRM in Jaspersoft Studio.

• DataBind MongoDB to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for MongoDB with the DevExpress Windows Forms and Web controls to provide MongoDB to a chart.

• Create Monday.com-Connected Nintex Workflows

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

• Use the CData ODBC Driver for TaxJar in SAS JMP

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

• Connect to SAP Hybris C4C as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live SAP Hybris C4C.

• Use the CData Software JDBC Driver for IBM Cloud Data Engine in MicroStrategy

  Connect to IBM Cloud Data Engine in MicroStrategy Developer using the CData Software JDBC Driver for IBM Cloud Data Engine.

• How to integrate BigCommerce with Apache Airflow

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

• Work with Google Contacts in FoxPro

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

• Create Square-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Square from OutSystems and build custom enterprise apps using live Square.

• Analyze Azure DevOps in SAP Analytics Cloud

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

• How to integrate Metabase with Bing Ads

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

• «
• 308
• 309
• 310
• 311
• 312
• 313
• 314
• 315
• 316
• 317
• »