CData Software - Knowledge Base

Recent Articles

• «
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• »

• Automated Continuous Splunk Replication to Snowflake

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

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

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

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

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

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

  Provide connectivity to OData through an SAP BusinessObjects universe.

• Create Datasets from Google Campaign Manager 360 in Domo Workbench and Build Visualizations of Google Campaign Manager 360 in Domo

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

• Access Kintone in PHP through Connect Server

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

• How to create ShipStation federated tables in MySQL

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

• Connect to Live Avro in MicroStrategy through CData Software Connect Server

  Create a virtual database for Avro in CData Software Connect Server and connect to it from MicroStrategy.

• How to update Cloudant from Excel

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

• Create Sugar CRM-Connected Business Apps in AppSheet

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

• Visualize Avro in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for Apache Avro in CData Software Connect (or Connect Server) and build visualizations from live Apache Avro in Tableau Desktop.

• How to connect and process Avro from Azure Databricks

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

• Connect to Tableau CRM Analytics from HeidiSQL

  Use CData Connect Cloud to connect to and query live Tableau CRM Analytics from HeidiSQL.

• Automated Continuous Monday.com Replication to Apache Cassandra

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

• How to Import Microsoft Dataverse into SQL Server using SSIS

  Easily back up Microsoft Dataverse (CDS) to SQL Server using the SSIS components for Microsoft Dataverse.

• Automate Zoom Replication to SAP HANA

  Use CData Sync to customize and automate Zoom replication to SAP HANA.

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

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

• Visualize Live Oracle HCM Cloud in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Oracle HCM Cloud.

• Model Azure Synapse Using Azure Analysis Services

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

• Integrate SAP SuccessFactors in the Pentaho Report Designer

  Publish reports based on SAP SuccessFactors in the Pentaho BI tool.

• Manage xBase in DBArtisan as a JDBC Source

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

• Query Azure DevOps in DataGrip

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

• Automated Continuous Oracle Sales Replication to Google Cloud SQL

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

• Build Interactive Dashboards from FTP in Amazon QuickSight

  Create a virtual SQL Server database for FTP Servers in CData Software Connect Server and import FTP Servers into Amazon QuickSight SPICE to build interactive dashboards.

• Replicate IBM Cloud Object Storage for Use in Salesforce Connect

  Replicate IBM Cloud Object Storage to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Deploy the ADO.NET Provider for Bitbucket on an SSRS Report Server

  Connect to Bitbucket 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.

• Prepare, Blend, and Analyze Snapchat Ads in Alteryx Designer

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Act-On

  Provide connectivity to Act-On through an SAP BusinessObjects universe.

• Connect to Oracle HCM Cloud in SpagoBI

  Create reports featuring live Oracle HCM Cloud in SpagoBI Studio. Host Oracle HCM Cloud reports on SpagoBI Server.

• Connect to Outreach.io in JRuby

  Create a simple JRuby app with access to live Outreach.io.

• Analyze Live ADP in SAS Viya

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

• Visualize Live IBM Informix in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live IBM Informix.

• Back Up Bitbucket to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Bitbucket. In this article, we will employ an SSIS workflow to populate a database with Bitbucket data.

• Analyze Oracle SCM in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Oracle SCM and visualize Oracle SCM in SAP Analytics Cloud.

• How to connect and process Zoho Inventory from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Zoho Inventory

• Import and Visualize Sage 50 UK in Power View

  Create data visualizations based on Sage 50 UK in Excel.

• Automated Continuous Box Replication to Oracle

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

• Visualize Live Jira of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Atlassian Jira using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Use the CData Software JDBC Driver for Typeform in MicroStrategy Desktop

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

• Automated Continuous Zoho CRM Replication to Microsoft Access

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

• How to connect to SAS xpt from MS Excel on Mac OS X

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

• Use the CData Software ODBC Driver for Sage Intacct in MicroStrategy Web

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

• Use the CData Software ODBC Driver for Redis in SAS for Real-Time Reporting and Analytics

  Connect to real-time Redis in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Redis.

• Use the CData ODBC Driver for Zoho Books from SharePoint Excel Services

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

• Stream ActiveCampaign into Apache Kafka Topics

  Access and stream ActiveCampaign in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Create SFTP-Connected Business Apps in AppSheet

  Use CData Software Connect Server to connect to SFTP from AppSheet and build custom business apps using live SFTP.

• Deploy the ADO.NET Provider for Zenefits on an SSRS Report Server

  Connect to Zenefits 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.

• Connect to HCL Domino in Ruby

  Connect to HCL Domino in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Replicate Multiple Neo4J Accounts

  Replicate multiple Neo4J accounts to one or many databases.

• How to Connect to & Open HCL Domino in Microsoft Excel

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

• How to pipe Acumatica to CSV in PowerShell

  Use standard PowerShell cmdlets to access Acumatica tables.

• Visualize Live MarkLogic of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live MarkLogic using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Process & Analyze Couchbase in Databricks (AWS)

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

• Natively Connect to Excel Online in PHP

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

• Build Apps with Live Power BI XMLA Using the Low-Code Development Platform of Mendix

• «
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• »