CData Software - Knowledge Base

Recent Articles

• «
• 67
• 68
• 69
• 70
• 71
• 72
• 73
• 74
• 75
• 76
• »

• Import and Visualize Harvest in Power View

  Create data visualizations based on Harvest in Excel.

• Create Datasets from IBM Cloud Data Engine in Domo Workbench and Build Visualizations of IBM Cloud Data Engine in Domo

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

• Query Trello in ColdFusion

  Write standard ColdFusion data access code to connect to Trello.

• How to connect to RSS Feeds in DBVisualizer

  Integrate RSS Feeds with visual data analysis tools and data connection wizards in DBVisualizer

• Integrate Real-Time Access to Google Search in SAPUI5 MVC Apps

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

• Connect to MarkLogic in as an External Source in Dremio

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

• Visualize Live Zoho Books in the Power BI Service

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

• Connect to Invoiced from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for Invoiced to connect to Invoiced and execute queries in PowerBuilder.

• Replicate Multiple Cassandra Accounts

  Replicate multiple Cassandra accounts to one or many databases.

• Explore Geographical Relationships in Oracle Eloqua with Power Map

  Create data visualizations with Oracle Eloqua in Power Map.

• Author and Share Power BI Reports on Real-Time Sage Cloud Accounting

  Use the CData ODBC Driver for Sage Cloud Accounting to visualize Sage Business Cloud Accounting in Power BI Desktop and then upload to the Power BI service.

• Analyze LinkedIn with Power Pivot

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

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

• Build Dashboards with Dynamics 365 Business Central in Dundas BI

  Create dynamic dashboards and perform analytics based on Dynamics 365 Business Central in Dundas BI.

• Visualize Spark in Sisense

  Create an ElastiCube in Sisense app with access to Apache Spark SQL.

• Automated Continuous Procore Replication to Apache Kafka

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

• Connect to Raisers Edge NXT from a Connection Pool in JBoss

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

• Create Klaviyo-Connected Nintex Workflows

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

• Access QuickBooks Time from MySQL in PHP

  Connect to QuickBooks Time through the standard MySQL libraries in PHP.

• Automated Continuous Dynamics CRM Replication to Apache Kafka

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

• Visualize Live Sugar CRM in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live Sugar CRM into custom reports in Power BI.

• Connect to Zenefits in Google Apps Script

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

• Use Biml to Build SSIS Tasks to Replicate Dynamics CRM to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Dynamics CRM to SQL Server.

• Connect to MongoDB in JRuby

  Create a simple JRuby app with access to live MongoDB.

• Working with SingleStore in LINQPad

  Execute LINQ queries to SingleStore in LINQPad.

• Build Visualizations of Google Calendar in Birst

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

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

  Connect to Google AlloyDB 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.

• Access Paylocity from MySQL in Amazon QuickSight

  Connect to Paylocity and build visualizations of Paylocity using a MySQL Connection in Amazon QuickSight.

• Integrate Reckon with External Services using SnapLogic

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

• Visualize MYOB AccountRight in Tableau

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

• Create Reports with Coinbase in SAP Crystal Reports

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

• How to update Access from Excel

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

• Use the CData ODBC Driver for Klipfolio from SharePoint Excel Services

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

• Use the CData Software ODBC Driver for HubSpot in SAS for Real-Time Reporting and Analytics

  Connect to real-time HubSpot in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for HubSpot.

• Build Apps with Live Outreach.io in Adalo using CData Connect Cloud

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

• LINQ to Google Cloud Storage

  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 Google Cloud Storage Data Provider.

• Integrate with MarkLogic using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy MarkLogic to a JSON file on disk.

• Access RSS Feeds as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access RSS Feeds from your Oracle system.

• Enable the Zoom JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Zoom.

• Automated Continuous LinkedIn Ads Replication to Amazon Redshift

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

• How to pipe SAP Ariba Source to CSV in PowerShell

  Use standard PowerShell cmdlets to access SAP Ariba Source tables.

• How to create an RPA flow for Twitter Ads in UiPath Studio

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

• Automate EventBrite Replication to Couchbase

  Use CData Sync to Customize and automate Eventbrite replication to Couchbase.

• Manage Jira Assets in DBArtisan as a JDBC Source

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

• How to connect to Spark from IntelliJ

  Integrate connectivity to Apache Spark SQL with wizards in IntelliJ.

• How to integrate Google Cloud Storage with Apache Airflow

  Access and process Google Cloud Storage in Apache Airflow using the CData JDBC Driver.

• Import Real-Time Google Search Results in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Google Search in ColdFusion.

• Create Active Directory-Connected Enterprise Applications in OutSystems

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

• Perform Batch Operations with Zoho Creator in Apache NiFi

  Connect to Zoho Creator and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Bridge Splunk Connectivity with Apache NiFi

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

• How to Work with Splunk in AWS Glue Jobs Using JDBC

  Connect to Splunk from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Import Microsoft Exchange into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Microsoft Exchange and provide access to live Microsoft Exchange for custom reports in the Power BI Service.

• How to Connect the Power BI Service to DB2: Complete Guide

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

• Build Apps with Live Twitter in Adalo using CData Connect Cloud

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

• Connect to and Query Azure Synapse in QlikView over ODBC

  Create data visualizations with Azure Synapse in QlikView.

• Connect to Live IBM Informix in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to IBM Informix in CData Connect Cloud and connect to your IBM Informix from PostgreSQL.

• Access Live Google Search Results in TIBCO Data Virtualization

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

• Import SAP Netweaver Gateway into Microsoft Power Query

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

• Query Confluence in ColdFusion

  Write standard ColdFusion data access code to connect to Atlassian Confluence.

• How to use SQLAlchemy ORM to access Zoho CRM in Python

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

• Build Teradata-Connected Dashboards in Redash

  Use CData Software Connect Server to create a virtual SQL Server Database for Teradata and build visualizations and dashbaords from Teradata in Redash.

• Export Data from SQL Server to Tableau CRM Analytics through SSIS

  Easily push SQL Server data to Tableau CRM Analytics using the CData SSIS Tasks for Tableau CRM Analytics.

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

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

• Connect to Sage Cloud Accounting in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Visualize Live MYOB AccountRight in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live MYOB AccountRight.

• Connect to WordPress as a SQL Server Linked Server

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

• Automated Continuous SAP HANA Replication to Google Cloud SQL

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

• Connect to Azure Synapse in Aqua Data Studio

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

• Replicate Multiple Coinbase Accounts

  Replicate multiple Coinbase accounts to one or many databases.

• How to update MySQL from Excel

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

• How to connect to Dynamics GP from Spring Boot

  Connect to Dynamics GP in a Spring Boot Application using CData JDBC Dynamics GP Driver

• Access Live API in Google Sheets

  Use CData Connect Cloud to gain access to live API from your Google Sheets.

• Connect to ConstantContact from a Connection Pool in Jetty

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

• Access Live Procore in TIBCO Data Virtualization

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

• Connect to TaxJar as a Linked Server

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

• DataBind Controls to LDAP Objects in Delphi

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

• Analyze Live Salesforce Pardot in SAS Viya

  Use CData Connect Cloud to connect to Salesforce Pardot from SAS Viya and deploy self-service analytics using live Salesforce Pardot.

• Connect to and Query SAP Fieldglass in QlikView over ODBC

  Create data visualizations with SAP Fieldglass in QlikView.

• Create Sage 200-Connected Business Apps in AppSheet

  Connect to Sage 200 via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Sage 200.

• Write a Simple Go Application to work with Presto on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Presto.

• Analyze ServiceNow in R

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

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

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

• Automate Google Directory Replication to Azure Synapse

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

• Automated Continuous SurveyMonkey Replication to SingleStore

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

• How to create Printful federated tables in MySQL

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

• Replicate Cosmos DB to Multiple Databases

  Replicate Azure Cosmos DB to disparate databases with a point-and-click configuration.

• How to Connect to & Open Google Sheets in Microsoft Excel

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

• How to connect to xBase from Spring Boot

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

• Creating HCL Domino-Connected Applications in Unqork

  You can use CData Connect Cloud to feed HCL Domino to Unqork and build custom business apps.

• Connect to Dynamics 365 Business Central in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Dynamics 365 Business Central and connect to Dynamics 365 Business Central in Akorbi Digital RunMyProcess.

• Connect to EnterpriseDB in Aqua Data Studio

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

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

  Provide connectivity to Okta through an SAP BusinessObjects universe.

• Analyze eBay in Looker

  Use CData Connect Cloud to connect to eBay from Looker and build custom apps using live eBay.

• Import REST into FileMaker Pro

  Create reports that integrate REST in Filemaker Pro.

• Build JotForm Visualizations in Tableau Cloud

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

• A PostgreSQL Interface for ConstantContact

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

• Connect to SAP Concur in DBeaver

  Use the CData ODBC Driver to connect to SAP Concur in DBeaver.

• Replicate Multiple Microsoft Project Accounts

  Replicate multiple Microsoft Project accounts to one or many databases.

• Automated Continuous Act CRM Replication to Apache Kafka

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

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

  Connect to Google Drive from a connection pool in Tomcat.

• «
• 67
• 68
• 69
• 70
• 71
• 72
• 73
• 74
• 75
• 76
• »