CData Software - Knowledge Base

Recent Articles

• «
• 223
• 224
• 225
• 226
• 227
• 228
• 229
• 230
• 231
• 232
• »

• Operational Reporting on HCL Domino from Spotfire Server

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

• Replicate Instagram from PowerShell

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

• Use JayDeBeApi to access Microsoft Dataverse in Python

  Use standard Python scripting and the development environment of your choice to access live Microsoft Dataverse (CDS).

• Create Data Visualizations in Cognos BI with Azure Synapse

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

• Enable the MySQL JDBC Driver in KNIME

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

• Zendesk Cloud Connectivity

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

• Analyze ConstantContact in Infragistics Reveal

  Use the CData Connect Server to create an OData API on top of ConstantContact and visualize live ConstantContact in Ingragistics Reveal.

• Shippo Reporting in OBIEE with the Shippo JDBC Driver

  Deploy the Shippo JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Exact Online Cloud Connectivity

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

• Connect to Twitter as a Linked Server

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

• Create a Data Access Object for IBM Cloud Object Storage using JDBI

  A brief overview of creating a SQL Object API for IBM Cloud Object Storage in JDBI.

• Analyze OneNote with Power Pivot

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

• How to create Visio diagrams from Excel Online

  Automatically update Microsoft Excel Online with the changes you make to Visio master shapes.

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

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

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

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

• Visualize AlloyDB in TIBCO Spotfire through ADO.NET

  Integrate Google AlloyDB into dashboards in TIBCO Spotfire.

• Automate Salesforce Marketing Replication to Azure Data Lake

  Use CData Sync to customize and automate Salesforce Marketing Cloud replication to Azure Data Lake.

• Create SAP Hybris C4C-Connected Business Apps in AppSheet

  Connect to SAP Hybris C4C via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to SAP Hybris C4C.

• Analyze Twitter Ads in Cognos Analytics

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

• Automate JSON Services Replication to Azure Data Lake

  Use CData Sync to customize and automate JSON replication to Azure Data Lake.

• Connect to Sage 200 from HeidiSQL

  Use CData Connect Cloud to connect to and query live Sage 200 from HeidiSQL.

• Integrate with QuickBooks Time in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live QuickBooks Time in SnapLogic.

• Integrate Box in the Pentaho Report Designer

  Publish reports based on Box in the Pentaho BI tool.

• How to connect to Twitter Ads with Squirrel SQL client

  Connect to Twitter Ads and execute queries in the Squirrel SQL Client.

• Connect to Drift in the Denodo Platform

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

• Access SharePoint in PHP through Connect Server

  Connect to SharePoint through the standard SQL Server libraries in PHP.

• Query HCL Domino as a SQL Server Database in Node.js

  Execute SQL Server queries against HCL Domino from Node.js.

• Automated Continuous Kafka Replication to Vertica

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

• Connect to Zendesk from a Connection Pool in Jetty

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

• Design BIRT Reports on Zoho Books

  Provide current Zoho Books to your embedded analytics.

• Drip Reporting and Star Schemas in OBIEE

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

• A PostgreSQL Interface for Kafka

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

• Back Up HubSpot to SQL Server through SSIS

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

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

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

• Access Live Highrise in TIBCO Data Virtualization

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

• Publish Reports with Oracle SCM in SAP Crystal Reports

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

• Object-Relational Mapping (ORM) with Sugar CRM Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Sugar CRM into a Java-based ORM framework, Hibernate.

• Create Dynamics 365-Connected Enterprise Applications in OutSystems

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

• DataBind Controls to Excel Online in C++Builder

  DataBind to Microsoft Excel Online in C++Builder with standard components and controls.

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

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

• Automate Adobe Analytics Integration Tasks from PowerShell

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

• Connect to Salesforce in RazorSQL

  Connect to Salesforce from wizards and query Salesforce & Force.com from the GUI in the RazorSQL database management tool.

• Using AngularJS to Build Dynamic Web Pages with SharePoint Excel Services

  Use the CData Connect Server to create SharePoint Excel Services OData feeds and build single-page applications with live SharePoint Excel Services.

• Build MVC Applications with Connectivity to Presto

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

• How to connect to EventBrite from Google Apps Script

  Use CData Software Connect Server to access Eventbrite in Google Apps Script.

• Automated Continuous Microsoft Teams Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Microsoft Teams replication to AlloyDB.

• Connect to FTP in RazorSQL

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

• Provide OData Services of HBase from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Apache HBase by developing a WCF Service Application.

• Perform Batch Operations with Active Directory in Apache NiFi

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• Working with Zoho CRM in LINQPad

  Execute LINQ queries to Zoho CRM in LINQPad.

• Automated Continuous Microsoft Teams Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Microsoft Teams replication to IBM DB2.

• Connect to Blackbaud FE NXT in RapidMiner

  Integrate Blackbaud FE NXT with standard components and data source configuration wizards in RapidMiner Studio.

• How to import LDAP Objects into Apache Solr

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

• Connect to NetSuite from AWS Glue

  Use CData Connect Cloud to gain access to live NetSuite CRM & ERP from your AWS Glue jobs.

• How to load Google Spanner data into Elasticsearch via Logstash

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

• Visualize Live Slack in Tableau

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

• Using the CData Software ODBC Driver for Microsoft Dataverse in PyCharm

  Connect to Microsoft Dataverse as an ODBC data source in PyCharm using the CData Software ODBC Driver for Microsoft Dataverse.

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

• Operational Reporting on Bing Search Results from Spotfire Server

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

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

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

• Query EnterpriseDB in MySQL Workbench

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

• How to Access Live Microsoft Dataverse in Power Automate Desktop via ODBC

  The CData ODBC Driver for Microsoft Dataverse enables you to integrate Microsoft Dataverse (CDS) into workflows built using Microsoft Power Automate Desktop.

• Automated Continuous Access Replication to Apache Kafka

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

• Build Visualizations of Zoho Books in Birst

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

• Access Live SendGrid in TIBCO Data Virtualization

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

• Automate HBase Replication to Couchbase

  Use CData Sync to Customize and automate Apache HBase replication to Couchbase.

• How to connect Amazon QuickSight to ADP

  Create a connection to ADP in CData Connect Cloud and insert ADP into Amazon QuickSight SPICE to build interactive dashboards.

• Build Dashboards with SAP Business One in DBxtra

  Create dynamic dashboards and perform analytics based on SAP Business One in DBxtra.

• Connect to SAP HANA XS Advanced in Ruby

  Connect to SAP HANA XS Advanced in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Connect to SAP in DBArtisan

  Use wizards in DBArtisan to configure SAP ERP/NetWeaver as a data source.

• Build Visualizations of Cloudant in Birst

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

• Analyze Gmail in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of Gmail and visualize live Gmail in Infragistics Reveal.

• Create Bing Search-Connected Business Apps in AppSheet

  Connect to Bing Search Results via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Bing Search.

• Use the CData ODBC Driver for LinkedIn Ads from SharePoint Excel Services

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

• Connect to Redshift in Aqua Data Studio

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

• Build Apps with Live SAP HANA in Adalo using CData Connect Cloud

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

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

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

• Publish Crystal Reports on Adobe Analytics

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Adobe Analytics.

• Connect to CouchDB in the Denodo Platform

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

• Work with Sage 300 in FoxPro

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

• Bidirectional Access to Sage 300 from FileMaker Pro

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

• Integrate Live Salesloft into Custom Business Apps Built in Power Apps

  Use CData Software Connect Server to create a virtual SQL Server Database for Salesloft and integrate live Salesloft into apps built in Microsoft Power Apps.

• Create MailChimp-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to MailChimp from Klipfolio and build custom visualizations using live MailChimp.

• Create eBay Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time eBay data access from reports, embedded analytics, and more.

• Operational Reporting on MailChimp from Spotfire Server

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

• Integrate with live Acumatica in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Acumatica ERP in Jitterbit.

• Build an OLAP Cube in SSAS from PostgreSQL

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

• DataBind Reckon to the DevExpress Data Grid

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

• How to connect and process Dynamics GP from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Dynamics GP

• Create MongoDB Dataflows on PowerBI.com

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

• Access HubSpot from MySQL in PHP

  Connect to HubSpot through the standard MySQL libraries in PHP.

• Import Google Cloud Storage into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for Google Cloud Storage and create custom reports in the Power BI Service.

• Export Data from SQL Server to ADP through SSIS

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

• Automated Continuous Coinbase Replication to Databricks

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

• Manage Microsoft Teams in DBArtisan as a JDBC Source

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

• How to connect to Dropbox from IntelliJ

  Integrate connectivity to Dropbox with wizards in IntelliJ.

• Connect to Zoom as a Linked Server

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

• Add Azure Analysis Services to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Azure Analysis Services with the Informatica Enterprise Data Catalog to classify and organize data.

• Query Dynamics GP as a SQL Server in Node.js

  Execute SQL Server queries against Microsoft Dynamics GP from Node.js.

• «
• 223
• 224
• 225
• 226
• 227
• 228
• 229
• 230
• 231
• 232
• »