CData Software - Knowledge Base

Recent Articles

• «
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• »

• Highrise Reporting and Star Schemas in OBIEE

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

• Load Power BI XMLA to a Database Using Embulk

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

• Work with Marketo in FoxPro

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

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

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

• Automated Continuous Twitter Ads Replication to MySQL

  Use CData Sync for automated, continuous, customizable Twitter Ads replication to MySQL.

• Manage Coinbase in DBArtisan as a JDBC Source

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

• Deploy the ADO.NET Provider for Azure Active Directory on an SSRS Report Server

  Connect to Azure Active Directory 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.

• Visualize Gmail in Tableau

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

• Connect to and Visualize Live Azure Active Directory in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Azure Active Directory.

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

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

• Query Reckon in ColdFusion

  Write standard ColdFusion data access code to connect to Reckon.

• Build HDFS-Connected Dashboards in Redash

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

• Work with Live Databricks in Power Query

  Use CData Connect Cloud to connect to Databricks and work with live Databricks in Microsoft Power Query.

• Access Live Google Search Results in Google Sheets through Connect Spreadsheets

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

• Extract, Transform, and Load GraphQL in Informatica PowerCenter

  Create a simple Workflow for GraphQL in Informatica PowerCenter.

• Integrate Power BI XMLA into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Power BI XMLA and integrate live Power BI XMLA into your Power Automate tasks.

• Build Dashboards with Twilio in DBxtra

  Create dynamic dashboards and perform analytics based on Twilio in DBxtra.

• Perform Batch Operations with Redshift in Apache NiFi

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

• Visualize Cvent in TIBCO Spotfire through ADO.NET

  Integrate Cvent into dashboards in TIBCO Spotfire.

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

  Use CData Power BI Connectors to visualize SAP Business ByDesign in Power BI.

• Access Sage Cloud Accounting in PHP through Connect Server

  Connect to Sage Cloud Accounting through the standard SQL Server libraries in PHP.

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

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

• How to connect to Dynamics 365 from MS Excel on Mac OS X

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

• Automate TaxJar Integration Tasks from PowerShell

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

• Query Workday in MySQL Workbench

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

• Access Microsoft Project from MySQL in Amazon QuickSight

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

• Connect and Visualize Live Salesforce Data in Databricks Lakehouse Federation with CData Connect Cloud

  Use CData Connect Cloud to integrate live Salesforce & Force.com into the Databricks platform and create visualization dashboards with real-time Salesforce & Force.com.

• Create Salesforce Pardot Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for Salesforce Pardot to build custom dashboards in Bold BI.

• How to load Excel Online data into Elasticsearch via Logstash

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

• Replicate Multiple Reckon Accounts Hosted Accounts

  Replicate multiple Reckon Accounts Hosted accounts to one or many databases.

• Establish a Live Connection with Microsoft Dataverse using Tableau Bridge

  The CData ODBC Driver for Microsoft Dataverse enables you to integrate live Microsoft Dataverse (CDS) into Tableau Cloud dashboards using the Tableau Bridge.

• Create SSAS Tabular Models from BigQuery

  How to build a SQL Server Analysis Service Tabular Model from Google BigQuery using CData drivers.

• Integrate SAP HANA in Pentaho Data Integration

  Build ETL pipelines based on SAP HANA in the Pentaho Data Integration tool.

• Query Cosmos DB in DataGrip

  Create a Data Source for Cosmos DB in DataGrip and use SQL to query live Azure Cosmos DB.

• Connect to Live Power BI XMLA in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Power BI XMLA in CData Connect Cloud and connect to your Power BI XMLA from PostgreSQL.

• Access SAP Ariba Procurement 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 SAP Ariba Procurement.

• Operational Reporting on Marketo from Spotfire Server

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

• Analyze EnterpriseDB with Power Pivot

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

• Replicate ShipStation to Multiple Databases via the CData Sync CLI

  Replicate ShipStation to disparate databases with a single configuration.

• Model GraphQL Using Azure Analysis Services

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

• Prepare, Blend, and Analyze Bing Ads in Alteryx Designer (ODBC)

  Build workflows to access live Bing Ads for self-service data analytics.

• Create SSAS Tabular Models from HubDB

  How to build a SQL Server Analysis Service Tabular Model from HubDB using CData drivers.

• Establish a Live Connection with Clio using Tableau Bridge

  The CData ODBC Driver for Clio enables you to integrate live Clio into Tableau Cloud dashboards using the Tableau Bridge.

• How to work with SAP Ariba Procurement in Apache Spark using SQL

  Access and process SAP Ariba Procurement in Apache Spark using the CData Software JDBC Driver.

• Visualize Microsoft Dataverse in TIBCO Spotfire through ADO.NET

  Integrate Microsoft Dataverse (CDS) into dashboards in TIBCO Spotfire.

• Automated Continuous Oracle SCM Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Oracle SCM replication to Microsoft Access.

• Connect to Real-Time SharePoint Data in Power Apps Using Dataflows to Build Custom Applications

• «
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• »