CData Software - Knowledge Base

Recent Articles

• «
• 211
• 212
• 213
• 214
• 215
• 216
• 217
• 218
• 219
• 220
• »

• Integrate with Live LinkedIn Ads in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to LinkedIn Ads from the MuleSoft Anypoint Platform to integrate live LinkedIn Ads into custom reports and dashboards.

• Access Live GMO MakeShop in Google Sheets via Connect Cloud

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

• Build Charts with Microsoft Teams in Clear Analytics

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

• Model Google Search Results Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Google Search, enabling the direct import of real-time Google Search.

• Analyze Live SAP Concur in SAS Viya

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

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

• Build Automated Workflows with Live Twitter in Workato

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

• Automated Continuous Instagram Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Instagram replication to SQL Server.

• Connect to Parquet in CloverDX (formerly CloverETL)

  Transfer Apache Parquet using the visual workflow in the CloverDX data integration tool.

• Object-Relational Mapping (ORM) with Phoenix 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 Apache Phoenix into a Java-based ORM framework, Hibernate.

• Automated Continuous SAP Business One Replication to Oracle

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

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

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

• Use Dash to Build to Web Apps on Bullhorn CRM

  Create Python applications that use pandas and Dash to build Bullhorn CRM-connected web apps.

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

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

• Create Dynamics 365 Dashboards in Bold BI

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

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

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

• How to Query Google Ads in MySQL Workbench

  Execute MySQL queries against live Google Ads from MySQL Workbench.

• Natively Connect to Clio in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Clio. Leverage the native support for ODBC in PHP.

• Visualize Amazon S3 from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Amazon S3.

• How to Connect to & Open Dynamics CRM in Microsoft Excel

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

• Connect to Hive from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Apache Hive from Crystal Reports.

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

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

• Publish Klipfolio-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Klipfolio.

• Access Live Veeva Vault in Excel (Desktop) via Connect Cloud

  Use CData Connect Cloud to gain access to live Veeva Vault & Vault CRM from your Excel spreadsheets.

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

  Connect to PostgreSQL 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 Couchbase from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Couchbase from HeidiSQL.

• Automated Continuous Microsoft Dataverse Replication to AlloyDB

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

• Build an OLAP Cube in SSAS from ShipStation

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

• Model, Search, and Visualize Live MySQL in ThoughtSpot

  Use CData Connect Cloud to connect to live MySQL for modeling, searching, and visualizing.

• Connect to Stripe in NetBeans

  Connect to Stripe in NetBeans with the data source configuration wizard.

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

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

• How to Build Dynamic React Apps with Smartsheet

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

• Azure Data Lake Storage Reporting in OBIEE with the Azure Data Lake Storage JDBC Driver

  Deploy the Azure Data Lake Storage JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• How to create an RPA flow for Google Contacts in UiPath Studio

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

• Query Google Contacts in MySQL Workbench

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

• Access Live HCL Domino in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live HCL Domino from your Google Sheets.

• Connect to SharePoint in CloverDX (formerly CloverETL)

  Transfer Microsoft SharePoint using the visual workflow in the CloverDX data integration tool.

• Visualize Live Sage Cloud Accounting in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Sage Business Cloud Accounting.

• Automated Continuous Asana Replication to OneLake in Microsoft Fabric

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

• Access RSS Feeds 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 RSS Feeds.

• Use Dash to Build to Web Apps on HCL Domino

  Create Python applications that use pandas and Dash to build HCL Domino-connected web apps.

• Build Sybase-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sybase.

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

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

• Replicate Veeva Vault for Use in Salesforce Connect

  Replicate Veeva Vault & Vault CRM to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• How to connect to NetSuite with Squirrel SQL client

  Connect to NetSuite CRM & ERP and execute queries in the Squirrel SQL Client.

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

• Automated Continuous Cloudant Replication to Oracle

  Use CData Sync for automated, continuous, customizable Cloudant replication to Oracle.

• Import eBay Analytics into the Power BI Service for Visualizations

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

• Build Semantic Layer Views for SAP Ariba Procurement in APOS Live Data Gateway

  Use the CData Connector for SAP Ariba Procurement in APOS Live Data Gateway to build Semantic Layer Views for SAP Ariba Procurement.

• Query LDAP Objects as a SQL Server in Node.js

  Execute SQL Server queries against LDAP from Node.js.

• Access Live Confluence in Coginiti Pro

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

• How to publish and share Databricks dashboards with Tableau Server

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

• How to import Microsoft Teams into Apache Solr

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

• How to connect to REST from Spring Boot

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

• Build a PostgreSQL Interface for Elasticsearch using the CData JDBC Driver

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

• Integrate with Google Campaign Manager 360 in JReport Designer

  Create charts and reports based on Google Campaign Manager 360 in JReport Designer.

• How to Connect to & Open Bitbucket in Microsoft Excel

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

• Visualize Live Act-On in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Act-On.

• How to connect and process Sage Cloud Accounting from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Sage Cloud Accounting

• Analyze Live YouTube Analytics in SAS Viya

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

• Visualize Pinterest in TIBCO Spotfire through ODBC

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

• Integrate with Google Sheets using Apache Camel2

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

• Visualize SFTP in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for SFTP in CData Software Connect (or Connect Server) and build visualizations from live SFTP in Tableau Desktop.

• Replicate Teradata from PowerShell

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

• Object-Relational Mapping (ORM) with JSON Services 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 JSON into a Java-based ORM framework, Hibernate.

• Connect to and Visualize Live Reckon in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Reckon.

• Connect to Elasticsearch as an External Source in Dremio

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

• Create Reports from Salesforce in Looker Studio

  Use CData Connect Cloud to gain access to live Salesforce & Force.com and create custom reports in Looker Studio.

• Connect to and Query HarperDB in QlikView over ODBC

  Create data visualizations with HarperDB in QlikView.

• Bridge Reckon Connectivity with Apache NiFi

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

• How to work with Printful in Apache Spark using SQL

  Access and process Printful in Apache Spark using the CData Software JDBC Driver.

• How to work with Todoist in Apache Spark using SQL

  Access and process Todoist in Apache Spark using the CData Software JDBC Driver.

• Query eBay through ODBC in Node.js

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

• Connect to Odoo through External Services in Salesforce

  Use CData Connect Cloud to securely connect Salesforce External Services with Odoo using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Build Dashboards with Facebook in Dundas BI

  Create dynamic dashboards and perform analytics based on Facebook in Dundas BI.

• Connect to ShipStation in Aqua Data Studio

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

• Integrate Amazon Marketplace in Your Informatica Cloud Instance

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

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

  Provide connectivity to DocuSign through an SAP BusinessObjects universe.

• Build Interactive Dashboards from Access in Amazon QuickSight

  Create a virtual SQL Server database for Microsoft Access in CData Software Connect Server and import Microsoft Access into Amazon QuickSight SPICE to build interactive dashboards.

• Replicate Multiple Zoom Accounts via the CData Sync CLI

  Replicate multiple Zoom accounts to one or many databases.

• Integrate with live Twilio in Jitterbit

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

• Access Live Avro in AWS Lambda (with IntelliJ IDEA)

  Connect to live Apache Avro in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

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

  Connect to Zoho Projects from a connection pool in Tomcat.

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

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

• Explore Geographical Relationships in SQL Analysis Services with Power Map

  Create data visualizations with SQL Analysis Services in Power Map.

• Build Automated Workflows with Live Blackbaud FE NXT in Workato

  Use CData Connect Cloud to connect to live Blackbaud FE NXT and build automated workflows in Workato.

• Automated Continuous Airtable Replication to SingleStore

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

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

  Use CData Power BI Connectors to visualize Apache HDFS in Power BI.

• XML Reporting and Star Schemas in OBIEE

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

• How to pipe Impala to CSV in PowerShell

  Use standard PowerShell cmdlets to access Impala tables.

• Connect to Printify in CloverDX (formerly CloverETL)

  Transfer Printify using the visual workflow in the CloverDX data integration tool.

• Perform Batch Operations with SAP HANA in Apache NiFi

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

• Connect to ActiveCampaign in Aqua Data Studio

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

• Create PostgreSQL-Connected Enterprise Applications in OutSystems

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

• Build Visualizations of Dynamics GP in Birst

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

• Import Backlog Using Azure Data Factory

  Use CData Connect Cloud to connect to Backlog from Azure Data Factory and import live Backlog.

• Integrate Live HubDB into Blue Prism for Intelligent Robotic Process Automation (RPA)

• «
• 211
• 212
• 213
• 214
• 215
• 216
• 217
• 218
• 219
• 220
• »