CData Software - Knowledge Base

Recent Articles

• «
• 273
• 274
• 275
• 276
• 277
• 278
• 279
• 280
• 281
• 282
• »

• Connect to Spark from PowerBuilder

  This article demonstrates how to access Apache Spark SQL from Appeon PowerBuilder using the CData ADO.NET Provider for Spark.

• Query Sage Cloud Accounting as a SQL Server Database in Node.js

  Execute SQL Server queries against Sage Business Cloud Accounting from Node.js.

• Automated Continuous EventBrite Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable EventBrite replication to delimited files (CSV/TSV).

• Connect to SAP Concur in Aqua Data Studio

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

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

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

• Connect to Live Facebook Ads in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Facebook Ads in CData Connect Cloud and connect to your Facebook Ads from PostgreSQL.

• Explore Geographical Relationships in Basecamp with Power Map

  Create data visualizations with Basecamp in Power Map.

• Excel Spreadsheet Automation with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Connect to Snapchat Ads in Ruby

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

• Author and Share Power BI Reports on Real-Time SharePoint Excel Services

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

• Build Apps with Live QuickBooks Online in Adalo using CData Connect Cloud

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

• Connect to Live Jira Service Management in MicroStrategy through CData Connect Cloud

  Create a live connection to Jira Service Management in CData Connect Cloud and connect to your Atlassian Jira Service Management from MicroStrategy.

• Operational Reporting on LDAP Objects from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote LDAP.

• Automated Continuous Zoho Inventory Replication to Apache Cassandra

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

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

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

• Create Data Visualizations in Cognos BI with BigQuery

  Access Google BigQuery as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• GraphQL Cloud Connectivity

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

• Connect to EnterpriseDB from a Connection Pool in JBoss

  Integrate EnterpriseDB into Java servlets: Use the Management Console in JBoss to install the EnterpriseDB JDBC Driver.

• Publish Reports with Gmail in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Gmail.

• Build Automated Jira Service Management-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Atlassian Jira Service Management and build automated workflows in Zapier.

• Analyze Act CRM with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Act CRM from Power Pivot. You will use the Table Import Wizard to load Act CRM. You can visually build the import query or use any SQL supported by the driver.

• Visualize Live Marketo in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Marketo.

• Bidirectional Access to Act CRM from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Act CRM in Filemaker Pro for Mac or Windows.

• How to Connect DBeaver to HCL Domino via a JDBC Driver

  Manage HCL Domino with visual tools in DBeaver like the query browser.

• How to Connect DBeaver to CSV via a JDBC Driver

  Manage CSV/TSV Files with visual tools in DBeaver like the query browser.

• How to update Kintone from Excel

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

• Build Charts with Excel Online in Clear Analytics

  Create dynamic charts and perform analytics based on Microsoft Excel Online in Clear Analytics.

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

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

• Use Biml to Build SSIS Tasks to Replicate Cassandra to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Apache Cassandra to SQL Server.

• Automated Continuous ActiveCampaign Replication to Apache Kafka

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

• Access Live Epicor Kinetic in Excel (Desktop)

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

• Connect to ServiceNow in Jaspersoft Studio

  Execute SQL to remote ServiceNow in Jaspersoft Studio.

• Analyze Shopify in Cognos Analytics

  Use CData Connect Cloud to connect to Shopify from Cognos Analytics and analyze live Shopify.

• Automated Continuous Epicor Kinetic Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to MongoDB.

• Automate IBM Cloud Data Engine Integration Tasks from PowerShell

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

• Connect to and Query Email in QlikView over ODBC

  Create data visualizations with Email in QlikView.

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

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

• Connect to QuickBooks Online from PowerBuilder

  This article demonstrates how to access QuickBooks Online from Appeon PowerBuilder using the CData ADO.NET Provider for QuickBooks Online.

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

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

• How to Visualize Active Directory Data in Python with pandas

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

• How to import PostgreSQL into Apache Solr

  Use the CData Software JDBC Driver for PostgreSQL in Data Import Handler and create an automated import of PostgreSQL to Apache Solr Enterprise Search platform.

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

• Analyze ActiveCampaign in R

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

• Connect to MySQL in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• How to Work with Neo4J in ETL Validator JDBC

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

• Access SAP BusinessObjects BI in PHP through Connect Server

  Connect to SAP BusinessObjects BI through the standard SQL Server libraries in PHP.

• Automated Continuous SAP Business One Replication to Snowflake

  Use CData Sync for automated, continuous, customizable SAP Business One replication to Snowflake.

• Connect to ActiveCampaign in the Denodo Platform

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

• Query Outreach.io in MySQL Workbench

  Create a virtual MySQL database for Outreach.io in CData Software Connect (or Connect Server) and work with live Outreach.io in MySQL Workbench.

• Analyze Microsoft Dataverse in R

  Use standard R functions and the development environment of your choice to analyze Microsoft Dataverse (CDS) with the CData JDBC Driver for Microsoft Dataverse.

• DataBind Controls to Printify in Delphi

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

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

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

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

  Connect to Printify from a connection pool in Tomcat.

• Analyze Cloudant in R

  Use standard R functions and the development environment of your choice to analyze IBM Cloudant with the CData JDBC Driver for Cloudant.

• Use the CData ODBC Driver for Clio in SAS JMP

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

• Connect to Smartsheet in Google Apps Script

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

• Connect to Azure Active Directory from PowerBuilder

  This article demonstrates how to access Azure Active Directory from PowerBuilder using the Azure Active Directory JDBC Driver.

• Connect to Google Ads in Ruby

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

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

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

• Excel Spreadsheet Automation with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• How to Create Power BI Visual Reports with Real-Time Elasticsearch

  Use CData Power BI Connectors to visualize Elasticsearch in Power BI.

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

• Build Raisers Edge NXT-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Raisers Edge NXT and build web apps with connectivity to live Raisers Edge NXT.

• Integrate with Zoho Creator in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Zoho Creator in SnapLogic.

• ETL Drip in Oracle Data Integrator

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

• DataBind Google Spanner to the DevExpress Data Grid

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

• How to Access Pinterest Using Entity Framework

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

• Integrate Databricks in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Databricks from Informatica Cloud.

• Use the CData Software ODBC Driver for GitHub in MicroStrategy Desktop

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

• Use the CData Software JDBC Driver for eBay Analytics in MicroStrategy Desktop

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

• Publish Zoho CRM-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Zoho CRM.

• Integrate ShipStation in the Pentaho Report Designer

  Publish reports based on ShipStation in the Pentaho BI tool.

• How to connect to SharePoint Excel Services from IntelliJ

  Integrate connectivity to SharePoint Excel Services with wizards in IntelliJ.

• Manage Tally in DBArtisan as a JDBC Source

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

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

• Use the CData Software JDBC Driver for Azure Synapse in MicroStrategy

  Connect to Azure Synapse in MicroStrategy Developer using the CData Software JDBC Driver for Azure Synapse.

• Build Google Spanner-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Google Spanner from Zoho Analytics and import live Google Spanner.

• Connect to Printify in RazorSQL

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

• Connect to MYOB AccountRight from PowerBuilder

  This article demonstrates how to access MYOB AccountRight from Appeon PowerBuilder using the CData ADO.NET Provider for MYOB AccountRight.

• Create Datasets from Clio in Domo Workbench and Build Visualizations of Clio in Domo

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

• Access Live Avalara AvaTax in Coginiti Pro

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

• DataBind Charts to BigQuery

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google BigQuery from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

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

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

• Connect to Coinbase from a Connection Pool in JBoss

  Integrate Coinbase into Java servlets: Use the Management Console in JBoss to install the Coinbase JDBC Driver.

• Build an OLAP Cube in SSAS from MySQL

  Establish a connection to MySQL data from SQL Server Analysis Services, and use the MySQL Data Provider to build OLAP cubes for use in analytics and reporting.

• How to Use CData Connect to Access Live Harvest in Power Automate

  CData Connect for Harvest enables you to integrate Harvest into workflows built using Microsoft Power Automate Desktop.

• Visualize HCL Domino in TIBCO Spotfire through ODBC

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

• Create Dynamics 365-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Dynamics 365 from Klipfolio and build custom visualizations using live Microsoft Dynamics 365.

• How to load Veeva data into Elasticsearch via Logstash

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

• Query Paylocity through ODBC in Node.js

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

• Replicate Freshdesk from PowerShell

  Write a quick PowerShell script to query Freshdesk. Use connectivity to the live data to replicate Freshdesk to SQL Server.

• Create QuickBooks Online-Connected Enterprise Applications in OutSystems

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

• Automated Continuous Vertica Replication to Amazon Redshift

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

• Back Up Microsoft SharePoint to SQL Server through SSIS

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

• How to Work with xBase in ETL Validator JDBC

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

• Automated Continuous Office 365 Replication to Databricks

  Use CData Sync for automated, continuous, customizable Office 365 replication to Databricks.

• Query Shippo in MySQL Workbench

  Create a virtual MySQL database for Shippo in CData Software Connect (or Connect Server) and work with live Shippo in MySQL Workbench.

• DataBind Controls to Phoenix in C++Builder

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

• Import and Visualize Cosmos DB in Power View

  Create data visualizations based on Azure Cosmos DB in Excel.

• Integrate Confluence into Power Automate Desktop using CData Connect

  CData Connect for Confluence enables you to integrate Atlassian Confluence into workflows built using Microsoft Power Automate Desktop.

• «
• 273
• 274
• 275
• 276
• 277
• 278
• 279
• 280
• 281
• 282
• »