CData Software - Knowledge Base

Recent Articles

• «
• 280
• 281
• 282
• 283
• 284
• 285
• 286
• 287
• 288
• 289
• »

• Access Live Google Calendar in Google Sheets

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

• Create Act CRM Dashboards in Bold BI

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

• Use the CData ODBC Driver for Power BI XMLA from SharePoint Excel Services

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

• How to Access Zoho Projects Using Entity Framework

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

• Integrate with MailChimp using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy MailChimp to a JSON file on disk.

• How to connect and process Spark from Azure Databricks

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

• How to integrate FHIR with Apache Airflow

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

• Access Reckon Accounts Hosted from MySQL in Amazon QuickSight

  Connect to Reckon Accounts Hosted and build visualizations of Reckon Accounts Hosted using a MySQL Connection in Amazon QuickSight.

• Connect to Oracle Service Cloud in Ruby

  Connect to Oracle Service Cloud in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• How to Work with Act CRM in AWS Glue Jobs Using JDBC

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

• Perform Batch Operations with Email in Apache NiFi

  Connect to Email and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Create PayPal-Connected Business Apps in AppSheet

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

• Query Monday.com as a MySQL Database in Node.js

  Execute MySQL queries against Monday.com from Node.js.

• Provide OData Services of SuiteCRM from a WCF Application

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

• Access Live Kintone in TIBCO Data Virtualization

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

• Automate Zoho Creator Replication to Azure Data Lake

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

• Replicate Harvest to Multiple Databases

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

• How to Build Dynamic React Apps with Microsoft Exchange

  Use the CData Connect and React to Build Dynamic Web Apps with Live Microsoft Exchange .

• Access SharePoint Excel Services from MySQL in Amazon QuickSight

  Connect to SharePoint Excel Services and build visualizations of SharePoint Excel Services using a MySQL Connection in Amazon QuickSight.

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

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

• Sage Cloud Accounting Reporting in OBIEE with the Sage Cloud Accounting JDBC Driver

  Deploy the Sage Cloud Accounting JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• A PostgreSQL Interface for Epicor Kinetic

  Use the SQL Gateway and Epicor Kinetic ODBC Driver to create a PostgreSQL entry-point for data access.

• DataBind Google Ad Manager to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Google Ad Manager with the DevExpress Windows Forms and Web controls to provide Google Ad Manager to a chart.

• Use the CData Software JDBC Driver for Pipedrive in MicroStrategy Web

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

• Prepare, Blend, and Analyze Facebook in Alteryx Designer

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

• Replicate Multiple WordPress Accounts

  Replicate multiple WordPress accounts to one or many databases.

• Connect to Redis in CloverDX (formerly CloverETL)

  Transfer Redis using the visual workflow in the CloverDX data integration tool.

• Integrate Box in Your Informatica Cloud Instance

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

• Explore Geographical Relationships in ShipStation with Power Map

  Create data visualizations with ShipStation in Power Map.

• How to connect and process Dropbox from Azure Databricks

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

• Connect to API from AWS Glue

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

• Automated Continuous JSON Replication to Amazon Redshift

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

• Access Live MYOB AccountRight in Google Sheets

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

• Use the CData Software JDBC Driver for ServiceNow in MicroStrategy

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

• Connect to SAP ByDesign as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live SAP Business ByDesign.

• Process & Analyze Confluence in Databricks (AWS)

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

• Build Automated Zuora-Connected Workflows in Zapier

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

• Build Typeform-Connected Dashboards in Redash

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

• Automate LDAP Objects Replication to SAP HANA

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

• Load MYOB AccountRight to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load MYOB AccountRight to a database.

• Connect to Live Spark in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Spark in CData Connect Cloud and connect to your Apache Spark SQL from PostgreSQL.

• Visualize FHIR in TIBCO Spotfire through OData

  Integrate FHIR into dashboards in TIBCO Spotfire.

• Create Office 365 Dataflows on PowerBI.com

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

• Replicate Adobe Commerce from PowerShell

  Write a quick PowerShell script to query Adobe Commerce. Use connectivity to the live data to replicate Adobe Commerce to SQL Server.

• Create Apps from Airtable in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Airtable and build apps from live Airtable in Qlik Sense Cloud.

• How to Access Azure Synapse Using Entity Framework

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

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

  Provide connectivity to Drift through an SAP BusinessObjects universe.

• Import Power BI XMLA into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Power BI XMLA and provide access to live Power BI XMLA for custom reports in the Power BI Service.

• Query WordPress in MySQL Workbench

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

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

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

• Automated HDFS Replication to Teradata

  Use CData Sync to Customize and automate Apache HDFS replication to Teradata.

• Access SharePoint Excel Services as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SharePoint Excel Services from your Oracle system.

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

  Use the CData Connector for SAP in APOS Live Data Gateway to build Semantic Layer Views for SAP ERP/NetWeaver.

• Connect to and Query Dynamics GP in QlikView over ODBC

  Create data visualizations with Microsoft Dynamics GP in QlikView.

• Analyze Oracle Service Cloud in R

  Create data visualizations and use high-performance statistical functions to analyze Oracle Service Cloud in Microsoft R Open.

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

  Connect to CSV/TSV Files in MicroStrategy Desktop using the CData Software JDBC Driver for CSV.

• Build Twitter-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for Twitter and create custom apps in Mendix.

• Bridge Amazon S3 Connectivity with Apache NiFi

  Access and process Amazon S3 in Apache NiFi using the CData JDBC Driver.

• Query TigerGraph as a MySQL Database in Node.js

  Execute MySQL queries against TigerGraph from Node.js.

• Automate Oracle Financials Cloud Replication to Azure Data Lake

  Use CData Sync to customize and automate Oracle Financials Cloud replication to Azure Data Lake.

• DataBind Greenplum to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Greenplum with the DevExpress Windows Forms and Web controls to provide Pivotal GreenPlum to a chart.

• Build Dashboards with CouchDB in DBxtra

  Create dynamic dashboards and perform analytics based on Apache CouchDB in DBxtra.

• Integrate with Avro in JReport Designer

  Create charts and reports based on Apache Avro in JReport Designer.

• Query, Visualize, and Share live Twilio in Redash

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

• How to Use CData Connect to Access Live Zenefits in Power Automate

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

• Use the CData ODBC Driver for Gmail in SAS JMP

  You can use the CData ODBC Driver to integrate Gmail into the statistical analysis tools available in SAS JMP. This article shows how to use Gmail in the Graph Builder and Query Builder.

• Use the CData Software JDBC Driver for JDBC-ODBC Bridge in MicroStrategy

  Connect to JDBC-ODBC Bridge in MicroStrategy Developer using the CData Software JDBC Driver for JDBC-ODBC Bridge.

• Connect to Zoho Inventory as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Zoho Inventory.

• Stream XML into Apache Kafka Topics

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

• Connect to Google Spanner as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Spanner.

• Connect to Zendesk in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Visualize ClickUp in TIBCO Spotfire through ADO.NET

  Integrate ClickUp into dashboards in TIBCO Spotfire.

• Connect to LDAP Objects in DBArtisan

  Use wizards in DBArtisan to configure LDAP as a data source.

• Excel Spreadsheet Automation with the QUERY Formula

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

• How to connect to Sage 50 UK from IntelliJ

  Integrate connectivity to Sage 50 UK with wizards in IntelliJ.

• Automated Continuous Facebook Ads Replication to Databricks

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

• Connect to Real-Time Jira Service Management Data in Power Apps Using Dataflows to Build Custom Applications

• «
• 280
• 281
• 282
• 283
• 284
• 285
• 286
• 287
• 288
• 289
• »