CData Software - Knowledge Base

Recent Articles

• «
• 275
• 276
• 277
• 278
• 279
• 280
• 281
• 282
• 283
• 284
• »

• Connect to Trello in the Denodo Platform

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

• Visualize Shippo from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Shippo.

• Use the CData ODBC Driver for NetSuite in MicroStrategy

  Connect to NetSuite data in MicroStrategy Developer using the CData ODBC Driver for NetSuite.

• How to Connect the Power BI Service to Azure Data Lake Storage: Complete Guide

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

• Integrate Microsoft OneDrive in Pentaho Data Integration

  Build ETL pipelines based on Microsoft OneDrive in the Pentaho Data Integration tool.

• Extract, Transform, and Load Salesforce Data Cloud in Informatica PowerCenter

  Create a simple Workflow for Salesforce Data Cloud in Informatica PowerCenter.

• Access Live Facebook Ads in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Facebook Ads from your Excel spreadsheets.

• Create Google Data Catalog Dataflows on PowerBI.com

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

• Integrate with CockroachDB in SnapLogic

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

• Build an OLAP Cube in SSAS from Exact Online

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

• Automated Continuous Twitter Ads Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Twitter Ads replication to Google Cloud SQL.

• Work with Live Couchbase in Power Query

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

• How to use SQLAlchemy ORM to access ActiveCampaign in Python

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

• Analyze Live Microsoft Teams in SAS Viya

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

• Build PayPal-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for PayPal and create custom apps in Mendix.

• Analyze NetSuite with Power Pivot

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

• Connect to Oracle SCM through External Services in Salesforce

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

• Build Automated Workflows with Live CockroachDB in Workato

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

• Automated Continuous Dynamics GP Replication to Apache Kafka

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

• Feed Shippo into FineReport

  How to set Shippo as a JDBC data source in FineReport.

• A PostgreSQL Interface for HarperDB using the CData ODBC Driver

  Use the SQL Gateway and HarperDB ODBC Driver to create a PostgreSQL entry-point for data access.

• How to Query Live Snapchat Ads Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Snapchat Ads data in natural language using Python.

• How to Connect to & Open Typeform in Microsoft Excel

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

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

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

• Integrate SendGrid in the Pentaho Report Designer

  Publish reports based on SendGrid in the Pentaho BI tool.

• Bidirectional Access to SendGrid from FileMaker Pro

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

• Use the CData Software JDBC Driver for Amazon Athena in MicroStrategy Desktop

  Connect to Amazon Athena in MicroStrategy Desktop using the CData Software JDBC Driver for Amazon Athena.

• Integrate with Amazon Marketplace using Apache Camel2

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

• Connect to Hive in JRuby

  Create a simple JRuby app with access to live Apache Hive.

• How to Work with SAP Fieldglass in ETL Validator JDBC

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

• Author and Share Power BI Reports on Real-Time Salesforce Marketing

  Use the CData ODBC Driver for Salesforce Marketing to visualize Salesforce Marketing Cloud in Power BI Desktop and then upload to the Power BI service.

• Build Active Directory Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Active Directory and build visualizations in Tableau Cloud.

• Analyze Azure Analysis Services in Looker

  Use CData Connect Cloud to connect to Azure Analysis Services from Looker and build custom apps using live Azure Analysis Services.

• Integrate with LDAP Objects using Apache Camel2

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

• Connect to Live ADP in PostGresSQL Interface through CData Connect Cloud

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

• Process & Analyze SAP ByDesign in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live SAP ByDesign .

• Automate Confluence Replication to Azure Data Lake

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

• Manage JSON Services in DBArtisan as a JDBC Source

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

• Import Zoho Projects into the Power BI Service for Visualizations

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

• Query Presto in ColdFusion

  Write standard ColdFusion data access code to connect to Presto.

• Visualize Live EventBrite in Tableau

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

• Add QuickBooks Online to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for QuickBooks Online with the Informatica Enterprise Data Catalog to classify and organize data.

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

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

• Edit and Search External SAP BusinessObjects BI Objects in Salesforce Connect

  Use CData Connect Cloud to securely provide OData feeds of SAP BusinessObjects BI to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP BusinessObjects BI objects that you can access from apps and the dashboard.

• Connect to SAP BusinessObjects BI in Aqua Data Studio

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

• Connect to Google Analytics from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Google Analytics from Crystal Reports.

• Automated Continuous Azure DevOps Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Azure DevOps replication to Google Cloud SQL.

• Automated Continuous HDFS Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable HDFS replication to Google BigQuery.

• Create IBM Cloud Data Engine-Connected Nintex Workflows

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

• Connect to Cosmos DB as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Azure Cosmos DB.

• Build Dashboards with QuickBooks Online in DBxtra

  Create dynamic dashboards and perform analytics based on QuickBooks Online in DBxtra.

• How to Query Aha in MySQL Workbench

  Execute MySQL queries against live Aha! from MySQL Workbench.

• How to Build Dynamic React Apps with Google Search Results

  Use the CData Connect and React to Build Dynamic Web Apps with Live Google Search Results.

• Connect to Typeform in Jaspersoft Studio

  Execute SQL to remote Typeform in Jaspersoft Studio.

• Query ServiceNow as a MySQL Database in Node.js

  Execute MySQL queries against ServiceNow from Node.js.

• Build Data Flows from Phoenix to SQL Server using SSIS

  Easily back up Apache Phoenix to SQL Server using the SSIS components for Phoenix.

• Automated Continuous Bing Search Replication to Oracle

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

• Build Automated Workflows with Live BigCommerce in Workato

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

• Visualize Presto in TIBCO Spotfire through ADO.NET

  Integrate Presto into dashboards in TIBCO Spotfire.

• Build Asana-Connected Dashboards Using Zoho Analytics

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

• Creating SAP Fieldglass-Connected Applications in Unqork

  You can use CData Connect to feed SAP Fieldglass to Unqork and build custom business apps.

• Automate Zuora Replication to Azure Synapse

  Use CData Sync to customize and automate Zuora replication to Azure Synapse.

• Build Dashboards with ShipStation in DBxtra

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

• Connect to YouTube Analytics as an External Source in Dremio

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

• Connect to PostgreSQL in Jaspersoft Studio

  Execute SQL to remote PostgreSQL in Jaspersoft Studio.

• How to connect to Coinbase with Squirrel SQL client

  Connect to Coinbase and execute queries in the Squirrel SQL Client.

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Directory

  Provide connectivity to Google Directory through an SAP BusinessObjects universe.

• Automate Sybase IQ Integration Tasks from PowerShell

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

• Create Square-Connected Applications in Appsmith

  Connect to Square via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Square.

• Create Informatica Mappings From/To a JDBC Data Source for Jira

  Create Jira data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Automated Continuous Azure Data Catalog Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Microsoft Access.

• How to Access Live SAP Netweaver Gateway in Power Automate Desktop via ODBC

  The CData ODBC Driver for SAP Netweaver Gateway enables you to integrate SAP Netweaver Gateway into workflows built using Microsoft Power Automate Desktop.

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

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

• DataBind Charts to Zoho Creator

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho Creator 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.

• Query Asana in MySQL Workbench

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

• Analyze QuickBooks in Infragistics Reveal

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

• Connect to Acumatica from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Acumatica ERP using standard SQL.

• Connect to Avalara AvaTax from PowerBuilder via ODBC

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

• Import Pinterest into Microsoft Power Query

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

• Import CData Connect Cloud into Microsoft Power Query

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

• How to Connect DBeaver to QuickBooks Time via a JDBC Driver

  Manage QuickBooks Time with visual tools in DBeaver like the query browser.

• Provide OData Services of GraphQL from a WCF Application

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

• Using AngularJS to Build Dynamic Web Pages with Box

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

• Access Live Google Sheets in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Google Sheets from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Build Automated Azure Table-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Azure Table Storage and build automated workflows in Zapier.

• Connect to Zenefits from PowerBuilder via JDBC

  This article demonstrates how to access Zenefits from PowerBuilder using the Zenefits JDBC Driver.

• Connect to Instagram in NetBeans

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

• How to integrate IBM Cloud Object Storage with Apache Airflow

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

• Work with Zoom in FoxPro

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

• Provide OData Services of Azure DevOps from a WCF Application

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

• Publish Azure Active Directory-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Azure Active Directory.

• How to Easily Query Okta in OpenOffice Base

• «
• 275
• 276
• 277
• 278
• 279
• 280
• 281
• 282
• 283
• 284
• »