CData Software - Knowledge Base

Recent Articles

• «
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• »

• Query BigCommerce in MySQL Workbench

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

• How to connect to SAP from Google Apps Script

  Use CData Software Connect Server to access SAP ERP/NetWeaver in Google Apps Script.

• Create SSAS Tabular Models from HBase

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

• Automated Continuous HCL Domino Replication to SQLite

  Use CData Sync for automated, continuous, customizable HCL Domino replication to SQLite.

• Use JayDeBeApi to access Asana in Python

  Use standard Python scripting and the development environment of your choice to access live Asana.

• Build Zoho Projects-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live Zoho Projects and build Zoho Projects-connected web apps with Axios.

• Natively Connect to Jira in PHP

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

• Automated Continuous Google Sheets Replication to Apache Cassandra

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

• Publish Dynamics NAV-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Microsoft Dynamics NAV.

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

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

• Automated Continuous Aha Replication to Google Cloud SQL

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

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

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

• Build Interactive Dashboards from Harvest in Amazon QuickSight

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

• Build Pipedrive-Connected Dashboards in Redash

  Use CData Software Connect Server to create a virtual SQL Server Database for Pipedrive and build visualizations and dashbaords from Pipedrive in Redash.

• Replicate Multiple Zendesk Accounts

  Replicate multiple Zendesk accounts to one or many databases.

• Publish Crystal Reports on Impala

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apache Impala.

• Automated Continuous Hive Replication to OneLake in Microsoft Fabric

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

• Connect to Marketo in NetBeans

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

• Automated Continuous SAP Ariba Source Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Azure SQL.

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

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

• How to work with Dynamics NAV in Apache Spark using SQL

  Access and process Dynamics NAV in Apache Spark using the CData Software JDBC Driver.

• Automate SingleStore Replication to Azure Synapse

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

• A PostgreSQL Interface for OneNote (MySQL Remoting via JDBC)

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

• Access Live Square in AWS Lambda

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

• Google Search Reporting and Star Schemas in OBIEE

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

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

  Provide connectivity to Oracle SCM through an SAP BusinessObjects universe.

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

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

• Use Dash to Build to Web Apps on JSON Services

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

• Write a Simple Go Application to work with Microsoft Exchange on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Exchange.

• Build an OLAP Cube in SSAS from MarkLogic

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

• How to Use a Microsoft Access Database to Update Dynamics 365 Business Central in Real Time

  Update Dynamics 365 Business Central data by creating a linked table in Microsoft Access with the CData Dynamics 365 Business Central ODBC Driver.

• Integrate with Twitter in JReport Designer

  Create charts and reports based on Twitter in JReport Designer.

• Access Live SAP BusinessObjects BI in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live SAP BusinessObjects BI from your Excel spreadsheets.

• Visualize Sybase IQ in TIBCO Spotfire through ODBC

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

• Automated Continuous Sage 50 UK Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Sage 50 UK replication to Apache Kafka.

• Add ConstantContact to Informatica Enterprise Data Catalog

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

• Access Google Ads from MySQL in HeidiSQL

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

• Connect to SAP Ariba Procurement in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access SAP Ariba Procurement in Google Apps Script.

• Connect to ADP in RapidMiner

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

• Access Salesloft from MySQL in Amazon QuickSight

  Connect to Salesloft and build visualizations of Salesloft using a MySQL Connection in Amazon QuickSight.

• Integrate with live SAP Business One in Jitterbit

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

• Provide OData Services of Highrise from a WCF Application

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

• Feed Workday into FineReport

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

• Connect to HCL Domino as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live HCL Domino.

• Connect to Snapchat Ads from Asprova with CData Software ODBC Driver for Snapchat Ads

  This article shows how to connect faster to Snapchat Ads data from Asprova.

• Connect to Jira as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Atlassian Jira.

• Analyze Act-On in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Act-On with the CData JDBC Driver for Act-On.

• Replicate MongoDB for Use in Salesforce Connect

  Replicate MongoDB to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Build Data Flows from eBay Analytics to SQL Server using SSIS

  Easily back up eBay Analytics to SQL Server using the SSIS components for eBay Analytics.

• Visualize FTP in TIBCO Spotfire through ODBC

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

• Import Sage 300 into Microsoft Power Query

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

• How to connect PolyBase to Facebook Ads

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Facebook Ads.

• Publish Asana-Connected Dashboards in Tableau Server

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

• Connect to PayPal from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from PayPal, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Connect to Instagram in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Instagram in Airbyte.

• Connect to Act CRM in SpagoBI

  Create reports featuring live Act CRM in SpagoBI Studio. Host Act CRM reports on SpagoBI Server.

• Build Zendesk-Connected Dashboards Using Zoho Analytics

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

• How to Seamlessly Import Drip Data into IBM SPSS Modeler

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

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

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

• Build Semantic Layer Views for RSS Feeds in APOS Live Data Gateway

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

• Use the CData ODBC Driver for Facebook in Microsoft Power Query

  You can use the CData Facebook ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Facebook into Microsoft Power Query.

• Integrate Real-Time Access to AlloyDB in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google AlloyDB in real time.

• Connect to Coinbase in DBeaver

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

• Create SSAS Tabular Models from Azure Analysis Services

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

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

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

• Access Live Google Drive in Google Sheets via Connect Cloud

  Use CData Connect Cloud to gain access to live Google Drive from your Google Sheets.

• Query, Visualize, and Share live Paylocity in Redash

  Use CData Connect Cloud to connect to live Paylocity in Redash for querying, visualizing, and sharing.

• Access Live Azure Analysis Services in Excel 365 Online (Excel for the web)

  Connect to Azure Analysis Services from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• ETL Jira Service Management in Oracle Data Integrator

  This article shows how to transfer Atlassian Jira Service Management into a data warehouse using Oracle Data Integrator.

• Use the CData Software JDBC Driver for Act CRM in MicroStrategy Desktop

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

• Use the CData Software ODBC Driver for Zoho Books in MicroStrategy Web

  Connect to Zoho Books in MicroStrategy Web using the CData Software ODBC Driver for Zoho Books.

• How to Work with Veeva Vault in AWS Glue Jobs Using JDBC

  Connect to Veeva Vault from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• How to Query ServiceNow in MySQL Workbench

  Execute MySQL queries against live ServiceNow from MySQL Workbench.

• Access Live DocuSign in Google Sheets through Connect Spreadsheets

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

• Build Visualizations of Oracle Financials Cloud in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle Financials Cloud in Birst.

• Access Live Calendly in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for Calendly to create a Calendly source in TIBCO Data Virtualization Studio and gain access to live Calendly from your TDV Server.

• Use the CData Software JDBC Driver for SAP ByDesign in MicroStrategy

  Connect to SAP Business ByDesign in MicroStrategy Developer using the CData Software JDBC Driver for SAP ByDesign.

• Edit and Search External SAP Hybris C4C Objects in Salesforce Connect

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

• How to work with CSV in Apache Spark using SQL

  Access and process CSV in Apache Spark using the CData Software JDBC Driver.

• Access BigQuery from MySQL in Amazon QuickSight

  Connect to BigQuery and build visualizations of Google BigQuery using a MySQL Connection in Amazon QuickSight.

• Create Facebook Ads-Connected Applications in Appsmith

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

• Access MYOB AccountRight as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MYOB AccountRight from your Oracle system.

• Model Smartsheet Using Azure Analysis Services

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

• Build an OLAP Cube in SSAS from Power BI XMLA

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

• Work with Live Jira Service Management in Power Query

  Use CData Connect Cloud to connect to Atlassian Jira Service Management and work with live Atlassian Jira Service Management in Microsoft Power Query.

• Automated Continuous Sage 50 UK Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Sage 50 UK replication to MongoDB.

• Connect to REST in DBeaver

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

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

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

• Query Freshdesk in ColdFusion

  Write standard ColdFusion data access code to connect to Freshdesk.

• How to Easily Query Tableau CRM Analytics in OpenOffice Base

• «
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• »