CData Software - Knowledge Base

Recent Articles

• «
• 373
• 374
• 375
• 376
• 377
• 378
• 379
• 380
• 381
• 382
• »

• How to connect SharePoint with Excel through external lists

  Provide Microsoft Excel to SharePoint users as an external list.

• Connect to LinkedIn Ads in the Denodo Platform

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

• How to Seamlessly Import Tableau CRM Analytics Data into IBM SPSS Modeler

  Integrate Tableau CRM Analytics data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Automate Tasks in Power Automate Using the CData API Server

  Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.

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

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

• Automated Continuous Greenplum Replication to IBM DB2

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

• Automated Continuous Databricks Replication to Amazon Redshift

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

• Automate Jira Service Management Integration Tasks from PowerShell

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

• Provide OData Services of Authorize.Net from a WCF Application

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

• Replicate Exact Online to Multiple Databases

  Replicate Exact Online to disparate databases with a point-and-click configuration.

• Build Pipelines with Live Confluence in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Confluence from Google Cloud Data Fusion, enabling the integration of live Atlassian Confluence into the building and management of effective data pipelines.

• Automated Continuous Azure Data Lake Storage Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Google Cloud SQL.

• How to Access Live SAP Ariba Source in Power Automate Desktop via ODBC

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

• Connect to Oracle SCM from Blazor Apps

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

• Query IBM Cloud Object Storage from Node.js

  Use the OData endpoint of the CData API Server to connect to your IBM Cloud Object Storage and perform CRUD operations on IBM Cloud Object Storage from Node.js.

• How to connect and process Google BigQuery from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Google BigQuery.

• Connect to Yahoo! Japan Data Solution from AWS Glue

  Use CData Connect Cloud to gain access to live Yahoo! Japan Data Solution from your AWS Glue jobs.

• How to Connect DBeaver to Odoo via a JDBC Driver

  Manage Odoo ERP with visual tools in DBeaver like the query browser.

• Enable the YouTube Analytics JDBC Driver in KNIME

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

• Create SSAS Tabular Models from Oracle Sales

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

• Access Live Exact Online Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live Exact Online data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

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

• Connect to Box in JRuby

  Create a simple JRuby app with access to live Box.

• Use Dash to Build to Web Apps on HBase

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

• Create Reports with Azure Data Catalog in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Azure Data Catalog.

• Easily Integrate Dynamics 365 Business Central in Lazarus Pascal IDE

  Learn how to easily integrate live Dynamics 365 Business Central in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Automated HBase Replication to Teradata

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

• Process & Analyze Google Calendar in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Google Calendar .

• Visualize MySQL in Tableau

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

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

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Veeva Vault & Vault CRM to SQL Server.

• Natively Connect to Coinbase in PHP

  The CData ODBC driver for Coinbase enables you to create PHP applications with connectivity to Coinbase. Leverage the native support for ODBC in PHP.

• Create Amazon Athena-Connected Dashboards in Grafana

  Connect to Amazon Athena via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Amazon Athena.

• Connect Salesloft to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Salesloft using the CData Python MCP Server.

• ETL Adobe Target in Oracle Data Integrator

  This article shows how to transfer Adobe Target into a data warehouse using Oracle Data Integrator.

• How to Design SAP Concur Power Apps with Database-Like Connectivity

  This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.

• Connect to and Query WordPress in QlikView over ODBC

  Create data visualizations with WordPress in QlikView.

• Connect to Salesforce as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Salesforce & Force.com.

• Connect to Raisers Edge NXT in Jaspersoft Studio

  Execute SQL to remote Raisers Edge NXT in Jaspersoft Studio.

• Integrate with SAP Business One in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live SAP Business One in SnapLogic.

• How to Query Printify in MySQL Workbench

  Execute MySQL queries against live Printify from MySQL Workbench.

• Connect to Act CRM in Jaspersoft Studio

  Execute SQL to remote Act CRM in Jaspersoft Studio.

• View Reports on Real-Time Redis in Power BI Report Server

  Use the CData ODBC Driver for Redis to visualize Redis in Power BI Desktop and then publish them to Power BI Report Server.

• Connect to Phoenix in Jaspersoft Studio

  Execute SQL to remote Apache Phoenix in Jaspersoft Studio.

• Working with HCL Domino in LINQPad

  Execute LINQ queries to HCL Domino in LINQPad.

• Integrate Sansan into Automated Tasks with Power Automate

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

• Query Acumatica in DataGrip

  Create a Data Source for Acumatica in DataGrip and use SQL to query live Acumatica ERP.

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

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

• DataBind Zoho Creator to the DevExpress Data Grid

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

• Create Impala-Connected Applications in Appsmith

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

• Build Microsoft Planner Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Microsoft Planner and build visualizations in Tableau.

• How to connect SharePoint with Facebook Ads through external lists

  Provide Facebook Ads to SharePoint users as an external list.

• How to Access Invoiced Using Entity Framework

  This article shows how to access Invoiced using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Build Data Flows from Reckon Accounts Hosted to SQL Server using SSIS

  Easily back up Reckon Accounts Hosted to SQL Server using the SSIS components for Reckon Accounts Hosted.

• Build Semantic Layer Views for TaxJar in APOS Live Data Gateway

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

• Create Data Visualizations in Cognos BI with Cloudant

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

• Integrate LinkedIn into Automated Tasks with Power Automate

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

• Visualize Vault CRM in Tableau

  The CData ODBC driver for Vault CRM enables you integrate Veeva Vault & Vault CRM into Tableau dashboards.

• Access Twitter Ads 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 Twitter Ads.

• How to Build an ETL App for eBay in Python with CData

  Create ETL applications and real-time data pipelines for eBay in Python with petl.

• Build Google Search-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Google Search Results from Choreo and build custom apps using live Google Search.

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

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

• Explore Geographical Relationships in Google Analytics with Power Map

  Create data visualizations with Google Analytics in Power Map.

• How to connect and process Twitter from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Twitter.

• How to Use a Microsoft Access Database to Update Microsoft Project in Real Time

  Update Microsoft Project data by creating a linked table in Microsoft Access with the CData Microsoft Project ODBC Driver.

• Integrate with Blackbaud FE NXT in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Blackbaud FE NXT in SnapLogic.

• How to import Confluence into Apache Solr

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

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

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

• Create Amazon Marketplace-Connected Applications in Appsmith

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

• Create Reports with HCL Domino in SAP Crystal Reports

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

• Create Informatica Mappings From/To an ODBC Data Source for Azure Data Catalog

  Create an ODBC connection to Azure Data Catalog in Informatica and browse and transfer Azure Data Catalog.

• Query ADP using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume ADP entities in PHP by modeling them as objects.

• Use the CData ODBC Driver for SAP Business One from SharePoint Excel Services

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

• Google Data Catalog Reporting in OBIEE with the Google Data Catalog JDBC Driver

  Deploy the Google Data Catalog JDBC driver on OBIEE to provide real-time reporting across the enterprise.

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

• ETL Raisers Edge NXT in Oracle Data Integrator

  This article shows how to transfer Raisers Edge NXT into a data warehouse using Oracle Data Integrator.

• Create GMO MakeShop-Connected Dashboards in Grafana

  Connect to GMO MakeShop via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to GMO MakeShop.

• Access Salesforce Marketing from MySQL in PHP

  Connect to Salesforce Marketing through the standard MySQL libraries in PHP.

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

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

• Cloudant Reporting and Star Schemas in OBIEE

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

• Operational Reporting on Amazon Marketplace from Spotfire Server

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

• Automated Continuous SQL Server Replication to Google Cloud SQL

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

• Automated Continuous Excel Replication to Google Cloud SQL

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

• Access Twitter Ads from MySQL in HeidiSQL

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

• Access Live IBM Informix in AWS Lambda

  Connect to live IBM Informix in AWS Lambda using the CData JDBC Driver.

• Automated Continuous JSON Replication to Microsoft Access

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

• Seamlessly Bring Adobe Analytics into Retool Using CData Connect Cloud

  Integrate Adobe Analytics data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.

• Connect to Todoist in SpagoBI

  Create reports featuring live Todoist in SpagoBI Studio. Host Todoist reports on SpagoBI Server.

• Build Semantic Layer Views for Google Search Results in APOS Live Data Gateway

  Use the CData Connector for Google Search in APOS Live Data Gateway to build Semantic Layer Views for Google Search.

• Create Data Visualizations in Cognos BI with Shippo

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

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

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

• How to connect SharePoint with Xero through external lists

  Provide Xero Accounting to SharePoint users as an external list.

• Connect to Snowflake in NetBeans

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

• Create Kintone-Connected Visualizations in Klipfolio

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

• Build an OLAP Cube in SSAS from SAP Concur

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

• Build Salesforce Pardot-Connected Dashboards Using Zoho Analytics

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

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

• Connect to Presto from Blazor Apps

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

• Enable the Office 365 JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Microsoft Office 365.

• Create EventBrite Dataflows on PowerBI.com

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

• ETL Elasticsearch in Oracle Data Integrator

  This article shows how to transfer Elasticsearch into a data warehouse using Oracle Data Integrator.

• «
• 373
• 374
• 375
• 376
• 377
• 378
• 379
• 380
• 381
• 382
• »