CData Software - Knowledge Base

Recent Articles

• «
• 207
• 208
• 209
• 210
• 211
• 212
• 213
• 214
• 215
• 216
• »

• Automate Oracle Sales Replication to Azure Synapse

  Use CData Sync to customize and automate Oracle Sales replication to Azure Synapse.

• Visualize Live JSON Services in Tableau

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

• Access Live Todoist in TIBCO Data Virtualization

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

• How to Work with Coinbase in AWS Glue Jobs Using JDBC

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

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

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

• How to publish and share DocuSign dashboards with Tableau Server

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

• How to create ConstantContact federated tables in MySQL

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

• Connect to CockroachDB from AWS Glue

  Use CData Connect Cloud to gain access to live CockroachDB from your AWS Glue jobs.

• Create Azure Synapse-Connected Visualizations in Klipfolio

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

• Back Up XML Files to SQL Server through SSIS

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

• Access Live Dynamics 365 Business Central in Coginiti Pro

  Connect to and query live Dynamics 365 Business Central from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Integrate Pinterest into Automated Tasks with Power Automate

  Use CData Software Connect Server to create a virtual SQL Server database for Pinterest and integrate live Pinterest into your Power Automate (Microsoft Flow) tasks.

• Import Real-Time GitHub in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use GitHub in ColdFusion.

• Connect to SharePoint in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for SharePoint and connect to Microsoft SharePoint in Akorbi Digital RunMyProcess.

• ETL Adobe Commerce in Oracle Data Integrator

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

• LINQ to Zoho CRM

  LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Zoho CRM Data Provider.

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

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

• Integrate with Office 365 in JReport Designer

  Create charts and reports based on Microsoft Office 365 in JReport Designer.

• How to Access Coinbase Using Entity Framework

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

• Build an OLAP Cube in SSAS from Aha

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

• Connect to Outreach.io in RazorSQL

  Connect to Outreach.io from wizards and query Outreach.io from the GUI in the RazorSQL database management tool.

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

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

• Access Live Quickbase in Excel (Desktop)

  Use CData Connect Cloud to gain access to live Quickbase from your Excel spreadsheets.

• Import and Visualize Oracle Financials Cloud in Power View

  Create data visualizations based on Oracle Financials Cloud in Excel.

• How to Query Live Oracle HCM Cloud Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Oracle HCM Cloud data in natural language using Python.

• Use the CData ODBC Driver for Google Directory from SharePoint Excel Services

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

• Connect to Azure DevOps from AWS Glue

  Use CData Connect Cloud to gain access to live Azure DevOps from your AWS Glue jobs.

• Create Data Visualizations in Cognos BI with Twitter

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

• Enable the WordPress JDBC Driver in KNIME

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

• Connect to Presto from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Presto from Filemaker Pro on Mac.

• Integrate Live Neo4J into Custom Business Apps Built in Power Apps

  Use CData Software Connect Server to create a virtual SQL Server Database for Neo4J and integrate live Neo4J into apps built in Microsoft Power Apps.

• Use the CData Software ODBC Driver for Xero in MicroStrategy Web

  Connect to Xero Accounting in MicroStrategy Web using the CData Software ODBC Driver for Xero.

• Use the CData Software ODBC Driver for Google Directory in MicroStrategy Web

  Connect to Google Directory in MicroStrategy Web using the CData Software ODBC Driver for Google Directory.

• ETL OData in Oracle Data Integrator

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

• Analyze Cloudant in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of IBM Cloudant and visualize live IBM Cloudant in Infragistics Reveal.

• Automate SQL Server Replication to Azure Data Lake

  Use CData Sync to customize and automate Microsoft SQL Server replication to Azure Data Lake.

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

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Google Sheets.

• Excel Spreadsheet Automation with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Add Amazon S3 to Informatica Enterprise Data Catalog

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

• Automate Smartsheet Replication to Azure Data Lake

  Use CData Sync to customize and automate Smartsheet replication to Azure Data Lake.

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

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

• Connect to Microsoft Project in JRuby

  Create a simple JRuby app with access to live Microsoft Project.

• Build Visualizations of GitHub in Birst

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

• Automated Continuous Google Spanner Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Google Spanner replication to MongoDB.

• How to connect and process Drip from Azure Databricks

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

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

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

• How to Import Redis into SQL Server using SSIS

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

• Connect to Azure Data Lake Storage in Google Apps Script

  Use the ODBC Driver for Azure Data Lake Storage and the SQL Gateway to access Azure Data Lake Storage from Google Apps Script.

• How to import Google Contacts into Apache Solr

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

• Connect to Power BI XMLA in SpagoBI

  Create reports featuring live Power BI XMLA in SpagoBI Studio. Host Power BI XMLA reports on SpagoBI Server.

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

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

• Connect to Oracle Service Cloud from a Connection Pool in Jetty

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

• Build Splunk Visualizations in Tableau Cloud

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

• Automated Continuous SAP Fieldglass Replication to MySQL

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

• Replicate Amazon Athena to Multiple Databases

  Replicate Amazon Athena to disparate databases with a single configuration.

• Integrate Google Analytics in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Analytics from Informatica Cloud.

• Publish Veeva-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Veeva Vault.

• Connect to Facebook Ads from a Connection Pool in Jetty

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

• Integrate Todoist with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Todoist with External Services.

• Connect to JotForm from a Connection Pool in Jetty

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

• Creating SAS xpt-Connected Applications in Unqork

  You can use CData Connect to feed SAS XPORT to Unqork and build custom business apps.

• Automate SuiteCRM Replication to Azure Data Lake

  Use CData Sync to customize and automate SuiteCRM replication to Azure Data Lake.

• Query Twilio as a SQL Server Database in Node.js

  Execute SQL Server queries against Twilio from Node.js.

• Connect to Office 365 in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Office 365 and connect to Microsoft Office 365 in Akorbi Digital RunMyProcess.

• Create HDFS Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for Apache HDFS to build custom dashboards in Bold BI.

• Build an OLAP Cube in SSAS from Phoenix

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

• Connect to Harvest in Aqua Data Studio

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

• Connect to HCL Domino through External Services in Salesforce

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

• DataBind Charts to Google Campaign Manager 360

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Campaign Manager 360 from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Connect to SAP SuccessFactors from Crystal Reports

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

• Create Reports with SharePoint Excel Services in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SharePoint Excel Services.

• How to Connect to & Open Xero in Microsoft Excel

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

• Enable the Teradata JDBC Driver in KNIME

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

• How to integrate IBM Cloud Object Storage with Apache Airflow

  Access and process IBM Cloud Object Storage in Apache Airflow using the CData JDBC Driver.

• Publish Email-Connected Dashboards in Tableau Server

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

• Publish Jira Service Management-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Atlassian Jira Service Management.

• Access Printful from MySQL in HeidiSQL

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

• Build BigCommerce-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live BigCommerce.

• Connect to Twitter from PowerBuilder

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

• Create Oracle Financials Cloud Dataflows on PowerBI.com

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

• Build Charts with Pinterest in Clear Analytics

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

• Connect to Live Twilio in MicroStrategy through CData Connect Cloud

  Create a live connection to Twilio in CData Connect Cloud and connect to your Twilio from MicroStrategy.

• Dynamics 365 Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Dynamics 365 through CData Connect Cloud using different applications and tools.

• Use JayDeBeApi to access SAP SuccessFactors in Python

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

• Integrate with GraphQL in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live GraphQL in SnapLogic.

• Using AngularJS to Build Dynamic Web Pages with GitHub

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

• Automated Continuous Bing Search Replication to Google Cloud SQL

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

• Integrate Adobe Analytics with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Adobe Analytics with External Services.

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

• Connect to Live Google Analytics in MicroStrategy through CData Connect Cloud

  Create a live connection to Google Analytics in CData Connect Cloud and connect to your Google Analytics from MicroStrategy.

• Connect to Reckon Accounts Hosted in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Build Automated Workflows with Live SharePoint in Workato

  Use CData Connect Cloud to connect to live Microsoft SharePoint and build automated workflows in Workato.

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

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

• Design BIRT Reports on TigerGraph

  Provide current TigerGraph to your embedded analytics.

• How to connect PolyBase to Elasticsearch

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

• Connect to Clio from a Connection Pool in Jetty

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

• Analyze Tableau CRM Analytics in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of Tableau CRM Analytics and visualize live Tableau CRM Analytics in Infragistics Reveal.

• Natively Connect to SAP SuccessFactors in PHP

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

• Author and Share Power BI Reports on Real-Time SAP Netweaver Gateway

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

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

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

• «
• 207
• 208
• 209
• 210
• 211
• 212
• 213
• 214
• 215
• 216
• »