CData Software - Knowledge Base

Recent Articles

• «
• 405
• 406
• 407
• 408
• 409
• 410
• 411
• 412
• 413
• 414
• »

• Import SAP into Microsoft Power Query

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

• How to update Sage 50 UK from Excel

  This article explains how to transfer data from Excel to Sage 50 UK using the Excel Add-In for Sage 50 UK.

• Use the CData SSIS Components to Insert New or Update Existing EnterpriseDB Records from SQL Server

  Easily push SQL Server data to EnterpriseDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into EnterpriseDB or update existing records with data from a SQL Server database.

• Automated Continuous SAP Concur Replication to Vertica

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

• Easily Integrate SAS Data Sets in Lazarus Pascal IDE

  Learn how to easily integrate live SAS Data Sets in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Connect to MongoDB from Blazor Apps

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

• Connect to SAP Hybris C4C as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live SAP Hybris C4C.

• Visualize Live Bing Search Results in the Power BI Service

  Use CData Connect Cloud to connect to live Bing Search and create custom reports in the Power BI Service through the On-Premises Gateway.

• How to integrate Metabase with Oracle Eloqua

  Use CData Connect Cloud to connect to live Oracle Eloqua and create an interactive dashboard in Metabase from Oracle Eloqua.

• How to integrate Monday.com with Apache Airflow

  Access and process Monday.com in Apache Airflow using the CData JDBC Driver.

• Automated Continuous Veeva Vault Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Veeva Vault replication to delimited files (CSV/TSV).

• How to Connect DBeaver to Kintone via a JDBC Driver

  Manage Kintone with visual tools in DBeaver like the query browser.

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

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

• Connect to Oracle Sales in Jaspersoft Studio

  Execute SQL to remote Oracle Sales in Jaspersoft Studio.

• Extract, Transform, and Load Printful in Informatica PowerCenter

  Create a simple Workflow for Printful in Informatica PowerCenter.

• Integrate Live SAP Ariba Source into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to SAP Ariba Source and integrate live SAP Ariba Source into apps built in Microsoft Power Apps.

• How to Connect the Power BI Service to SAP SuccessFactors: Complete Guide

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

• How to Connect DBeaver to Okta via a JDBC Driver

  Manage Okta with visual tools in DBeaver like the query browser.

• Build an OLAP Cube in SSAS from Oracle

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

• Establish a Live Connection with SAP Fieldglass using Tableau Bridge

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

• How to Connect to Salesforce Pardot in Using Python: 6 Steps

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

• How to connect to Sage Intacct from MS Excel on Mac OS X

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

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

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

• ETL Quickbase in Oracle Data Integrator

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

• Connect to DocuSign from Crystal Reports

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

• Import Real-Time Authorize.Net via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Authorize.Net in ColdFusion.

• Connect to SAP Business One as an External Source in Dremio

  Use the CData JDBC Driver to connect to SAP Business One as an External Source in Dremio.

• Automated Continuous EventBrite Replication to Amazon Redshift

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

• Automated Workday Replication to Teradata

  Use CData Sync to Customize and automate Workday replication to Teradata.

• Automated Continuous Pinterest Replication to OneLake in Microsoft Fabric

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

• Import Real-Time SQL Analysis Services via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use SQL Analysis Services in ColdFusion.

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

• Validate Cvent with QuerySurge

  Access and validate Cvent in QuerySurge using the CData JDBC Driver.

• Create SAP Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for SAP ERP/NetWeaver to build custom dashboards in Bold BI.

• Create SurveyMonkey-Connected Visualizations in Klipfolio

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

• Create Datasets from Neo4J in Domo Workbench and Build Visualizations of Neo4J in Domo

  Use the CData Software ODBC Driver for Neo4J to create datasets from Neo4J in Domo Workbench and then build visualizations in the Domo service.

• Visualize Google Ad Manager in TIBCO Spotfire through ODBC

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

• Integrate HubSpot in the Pentaho Report Designer

  Publish reports based on HubSpot in the Pentaho BI tool.

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

  Provide connectivity to Stripe through an SAP BusinessObjects universe.

• Integrate Okta in the Pentaho Report Designer

  Publish reports based on Okta in the Pentaho BI tool.

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

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

• Author and Share Power BI Reports on Real-Time Sage 200

  Use the CData ODBC Driver for Sage 200 to visualize Sage 200 in Power BI Desktop and then upload to the Power BI service.

• Connect to Salesloft in DBeaver

  Use the CData ODBC Driver to connect to Salesloft in DBeaver.

• Operational Reporting on Typeform from Spotfire Server

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

• Add Sage 50 UK to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Sage 50 UK with the Informatica Enterprise Data Catalog to classify and organize data.

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

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

• How to Seamlessly Import IBM Cloud Data Engine Data into IBM SPSS Modeler

  Integrate IBM Cloud Data Engine data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Analyze BambooHR in Infragistics Reveal

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

• Publish Drift-Connected Dashboards in Tableau Server

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

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

  Create an ODBC connection to Salesforce in Informatica and browse and transfer Salesforce & Force.com.

• Connect to Wave Financial in RapidMiner

  Integrate Wave Financial with standard components and data source configuration wizards in RapidMiner Studio.

• How to connect to CouchDB from MS Excel on Mac OS X

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

• Author and Share Power BI Reports on Real-Time Shopify

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

• Integrate with live Hive in Jitterbit

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

• Connect to Highrise in DBeaver

  Use the CData ODBC Driver to connect to Highrise CRM in DBeaver.

• Create SSAS Tabular Models from WordPress

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

• How to create CouchDB federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Apache CouchDB in MySQL .

• Bidirectional Access to Box from FileMaker Pro

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

• Connect to Coinbase from a Connection Pool in Jetty

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

• Working with Amazon S3 in LINQPad

  Execute LINQ queries to Amazon S3 in LINQPad.

• Publish Reports with Spark in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Apache Spark SQL.

• How to create Visio diagrams from LDAP Objects

  Automatically update LDAP with the changes you make to Visio master shapes.

• Connect to Dynamics GP from PowerBuilder via ADO.NET

  This article demonstrates how to access Microsoft Dynamics GP from Appeon PowerBuilder using the CData ADO.NET Provider for Dynamics GP.

• Use the CData SSIS Components to Insert New or Update Existing Google Sheets Records from SQL Server

  Easily push SQL Server data to Google Sheets using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Sheets or update existing records with data from a SQL Server database.

• How to Work with Azure Table in ETL Validator JDBC

  Connect to Azure Table from ETL Validator jobs using the CData Software JDBC Driver.

• Access YouTube Analytics from MySQL in HeidiSQL

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

• Add Zoho Projects to Informatica Enterprise Data Catalog

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

• Use CData Connect Cloud to Access MongoDB in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live MongoDB in the Power Pivot business intelligence tool.

• How to Access Snapchat Ads Using Entity Framework

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

• Create Acumatica-Connected Visualizations in Klipfolio

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

• Connect to Amazon DynamoDB in the Denodo Platform

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

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

  Build workflows to access live Microsoft Access for self-service data analytics.

• Connect to Excel in CloverDX (formerly CloverETL)

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

• Connect to HDFS from PowerBuilder via ODBC

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

• Analyze ConstantContact in SAP Analytics Cloud

  Use the CData Connect Server to create an OData API on top of ConstantContact and visualize ConstantContact in SAP Analytics Cloud.

• How to load SAP Hybris C4C data into Elasticsearch via Logstash

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

• Build Interactive Dashboards from SAP HANA XS Advanced in Amazon QuickSight

  Create a virtual SQL Server database for SAP HANA XS Advanced in CData Software Connect Server and import SAP HANA XS Advanced into Amazon QuickSight SPICE to build interactive dashboards.

• Build Apps with Live Splunk Using the Low-Code Development Platform of Mendix

• «
• 405
• 406
• 407
• 408
• 409
• 410
• 411
• 412
• 413
• 414
• »