CData Software - Knowledge Base

Recent Articles

• «
• 76
• 77
• 78
• 79
• 80
• 81
• 82
• 83
• 84
• 85
• »

• How to update SAP SuccessFactors from Excel

  This article explains how to transfer data from Excel to SAP SuccessFactors using the Excel Add-In for SAP SuccessFactors.

• Access Live MailChimp in Google Sheets through Connect Spreadsheets

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

• Import Tally into Microsoft Power Query

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

• Author and Share Power BI Reports on Real-Time Amazon Athena

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

• PowerShell Scripting to Replicate QuickBooks Online to MySQL

  Write a simple PowerShell script to replicate QuickBooks Online to a MySQL database.

• Connect to Avalara AvaTax in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Avalara AvaTax and the SQL Gateway to access Avalara AvaTax from Google Apps Script.

• Visualize Live Printify in Tableau

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

• DataBind Controls to Presto in Delphi

  DataBind to Presto in Delphi with standard data access components and controls.

• Work with Live Azure DevOps in Power Query

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

• How to Connect DBeaver to Google Search via a JDBC Driver

  Manage Google Search with visual tools in DBeaver like the query browser.

• Connect to IBM Cloud Object Storage as an External Source in Dremio

  Use the CData JDBC Driver to connect to IBM Cloud Object Storage as an External Source in Dremio.

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

  Provide connectivity to Highrise CRM through an SAP BusinessObjects universe.

• How to connect to Cassandra in DBVisualizer

  Integrate Apache Cassandra with visual data analysis tools and data connection wizards in DBVisualizer

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

  Provide connectivity to Adobe Analytics through an SAP BusinessObjects universe.

• Use the CData Software JDBC Driver for Oracle SCM in MicroStrategy Web

  Connect to Oracle SCM in MicroStrategy Web using the CData Software JDBC Driver for Oracle SCM.

• Create Data Visualizations Based On Google Sheets in Mode

  Use CData Connect Cloud to connect to Google Sheets from Mode and build visualizations using live

• Build an OLAP Cube in SSAS from SAS xpt

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

• Access SAP Concur as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP Concur from your Oracle system.

• Automated Continuous Exact Online Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Exact Online replication to Snowflake.

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

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

• Connect to Cassandra from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Cassandra to connect to Apache Cassandra from Web applications running on WebLogic.

• Import Real-Time IBM Informix via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use IBM Informix in ColdFusion.

• Replicate Multiple IBM Cloud Data Engine Accounts

  Replicate multiple IBM Cloud Data Engine accounts to one or many databases.

• Connect to Jira Assets from Asprova with CData Software ODBC Driver for Jira Assets

  This article shows how to connect faster to Jira Assets data from Asprova.

• Connect to Harvest in HULFT Integrate

  Connect to Harvest as a JDBC data source in HULFT Integrate

• Build Presto-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Presto and build web apps with connectivity to live Presto.

• Automated Continuous MailChimp Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable MailChimp replication to Azure SQL.

• Use the CData Software ODBC Driver for HBase in MicroStrategy Desktop

  Connect to Apache HBase in MicroStrategy Desktop using the CData Software ODBC Driver for HBase.

• Build Charts with Microsoft Exchange in Clear Analytics

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

• Automated Instagram Replication to Teradata

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

• Viewing Google Search Results in RAD Studio Data Explorer

  How to view Google Search in RAD Studio Data Explorer using the CData ODBC Driver for Google Search.

• Easily Integrate Bitbucket in Lazarus Pascal IDE

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

• Integrate Facebook into Automated Tasks with Power Automate

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

• Integrate with Blackbaud FE NXT in JReport Designer

  Create charts and reports based on Blackbaud FE NXT in JReport Designer.

• Connect to Excel in Jaspersoft Studio

  Execute SQL to remote Microsoft Excel in Jaspersoft Studio.

• How to Access SQL Analysis Services Using Entity Framework

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

• Automated Continuous MySQL Replication to Databricks

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

• Automated Continuous Access Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Access replication to Apache Cassandra.

• Query Splunk as a MySQL Database in Node.js

  Execute MySQL queries against Splunk from Node.js.

• How to connect to GraphQL from IntelliJ

  Integrate connectivity to GraphQL with wizards in IntelliJ.

• Connect to CSV in Jaspersoft Studio

  Execute SQL to remote CSV/TSV Files in Jaspersoft Studio.

• How to Seamlessly Import Adobe Commerce Data into IBM SPSS Modeler

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

• Create Oracle SCM Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Oracle SCM data access from reports, embedded analytics, and more.

• Automated Continuous Azure DevOps Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Azure DevOps replication to AlloyDB.

• Access PostgreSQL in PHP through Connect Server

  Connect to PostgreSQL through the standard SQL Server libraries in PHP.

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

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

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

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

• Access IBM Cloud Object Storage from MySQL in PHP

  Connect to IBM Cloud Object Storage through the standard MySQL libraries in PHP.

• Manage Excel Online in DBArtisan as a JDBC Source

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

• Using AngularJS to Build Dynamic Web Pages with Google Calendar

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

• Automated Continuous Confluence Replication to Oracle

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

• Create Salesloft-Connected Nintex Workflows

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

• How to connect PolyBase to SAP Ariba Procurement

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Ariba Procurement.

• Natively Connect to Oracle Service Cloud in PHP via ODBC (Linux)

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

• Automate Dynamics 365 Replication to SAP HANA

  Use CData Sync to customize and automate Microsoft Dynamics 365 replication to SAP HANA.

• Analyze Power BI XMLA in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of Power BI XMLA and visualize live Power BI XMLA in Infragistics Reveal.

• Build Automated PostgreSQL-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live PostgreSQL and build automated workflows in Zapier.

• Connect to Salesforce Marketing in NetBeans

  Connect to Salesforce Marketing Cloud in NetBeans with the data source configuration wizard.

• Explore Geographical Relationships in Elasticsearch with Power Map

  Create data visualizations with Elasticsearch in Power Map.

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

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

• Import Real-Time Trello via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Trello in ColdFusion.

• How to create MYOB AccountRight federated tables in MySQL

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

• Publish Asana-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Asana.

• Create Oracle Dataflows on PowerBI.com

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

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

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

• Create SharePoint-Connected Business Apps in AppSheet

  Connect to SharePoint via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Microsoft SharePoint.

• How to Seamlessly Import Sage 50 UK Data into IBM SPSS Modeler

  Integrate Sage 50 UK data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

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

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

• Automated Continuous Confluence Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Confluence replication to Azure SQL.

• How to connect to Amazon Athena with Squirrel SQL client

  Connect to Amazon Athena and execute queries in the Squirrel SQL Client.

• Automated Continuous JotForm Replication to Amazon Redshift

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

• Create Aha-Connected Nintex Workflows

  Use CData Software Connect Server to connect to Aha from Nintex Workflow Cloud and build custom workflows using live Aha!.

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

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

• Use the CData Software ODBC Driver for Highrise in MicroStrategy

  Connect to Highrise CRM in MicroStrategy Developer using the CData Software ODBC Driver for Highrise.

• How to Connect to Access in Using Python: 6 Steps

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

• Automated Continuous Adobe Commerce Replication to SQL Server

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

• Stream SAP into Apache Kafka Topics

  Access and stream SAP ERP/NetWeaver in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Replicate Trello to Multiple Databases

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

• Import Real-Time Certinia via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Certinia in ColdFusion.

• Connect to Live Dynamics 365 in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Dynamics 365 in CData Connect Cloud and connect to your Microsoft Dynamics 365 from PostgreSQL.

• Prepare, Blend, and Analyze Workday in Alteryx Designer (Connect Cloud)

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

• Connect to Slack from a Connection Pool in Jetty

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

• Connect to Okta in Aqua Data Studio

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

• Build ADP Visualizations in Tableau Cloud

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

• Integrate ActiveCampaign into Power Automate Desktop using CData Connect

  CData Connect for ActiveCampaign enables you to integrate ActiveCampaign into workflows built using Microsoft Power Automate Desktop.

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

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

• Build Dashboards with Zuora in DBxtra

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

• Automated Continuous MarkLogic Replication to Databricks

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

• Automated Continuous Oracle Service Cloud Replication to Microsoft Access

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

• Marketo Reporting in OBIEE with the Marketo JDBC Driver

  Deploy the Marketo JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Connect to Amazon Athena as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Amazon Athena.

• Replicate CData Connect Cloud to Multiple Databases via the CData Sync CLI

  Replicate CData Connect Cloud to disparate databases with a single configuration.

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

  Create an ODBC connection to Salesforce Data Cloud in Informatica and browse and transfer Salesforce Data Cloud.

• Connect to Microsoft OneDrive in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Automated Continuous Sage Intacct Replication to SingleStore

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

• Build a PostgreSQL Interface for Exact Online using the CData JDBC Driver

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

• Oracle HCM Cloud Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Oracle HCM Cloud facts in real time.

• Integrate with Live Zoho Creator in MuleSoft (via CData Connect Cloud)

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

• How to load Oracle Service Cloud data into Elasticsearch via Logstash

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

• Use the CData Software JDBC Driver for Google Drive in MicroStrategy

  Connect to Google Drive in MicroStrategy Developer using the CData Software JDBC Driver for Google Drive.

• «
• 76
• 77
• 78
• 79
• 80
• 81
• 82
• 83
• 84
• 85
• »