CData Software - Knowledge Base

Recent Articles

• «
• 156
• 157
• 158
• 159
• 160
• 161
• 162
• 163
• 164
• 165
• »

• Use the CData Software ODBC Driver for EventBrite in MicroStrategy

  Connect to Eventbrite in MicroStrategy Developer using the CData Software ODBC Driver for EventBrite.

• Automate Bullhorn CRM Replication to Azure Synapse

  Use CData Sync to customize and automate Bullhorn CRM replication to Azure Synapse.

• Work with Live OneNote in Power Query

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

• Work with Okta in FoxPro

  Load Okta into a FoxPro database. This article includes full code and a walk-through of the process.

• Visualize Cvent in TIBCO Spotfire through ODBC

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

• Automate Act-On Replication to Azure Synapse

  Use CData Sync to customize and automate Act-On replication to Azure Synapse.

• Model PayPal Using Azure Analysis Services

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

• How to Seamlessly Import MariaDB Data into IBM SPSS Modeler

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

• How to Build Dynamic React Apps with SharePoint Excel Services

  Use the CData Connect and React to Build Dynamic Web Apps with Live SharePoint Excel Services .

• Query Epicor Kinetic in MySQL Workbench

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

• Connect to PCA Sales from AWS Glue

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

• Connect to BigCommerce through External Services in Salesforce

  Use CData Connect Cloud to securely connect Salesforce External Services with BigCommerce using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• How to pipe SharePoint to CSV in PowerShell

  Use standard PowerShell cmdlets to access SharePoint tables.

• Connect to Smartsheet in Airbyte ELT Pipelines

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

• How to connect Amazon QuickSight to Amazon Athena

  Create a connection to Amazon Athena in CData Connect Cloud and insert Amazon Athena into Amazon QuickSight SPICE to build interactive dashboards.

• How to connect Amazon QuickSight to Sugar CRM

  Create a connection to Sugar CRM in CData Connect Cloud and insert Sugar CRM into Amazon QuickSight SPICE to build interactive dashboards.

• Query IBM Cloud Data Engine as a MySQL Database in Node.js

  Execute MySQL queries against IBM Cloud Data Engine from Node.js.

• DataBind Controls to HubDB in Delphi

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

• Create Elasticsearch-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Elasticsearch from OutSystems and build custom enterprise apps using live Elasticsearch.

• Integrate Calendly with External Services using SnapLogic

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

• Add Jira Service Management to Informatica Enterprise Data Catalog

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

• Connect to GraphQL in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

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

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

• Create Odoo Dashboards in Bold BI

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

• Automate GraphQL Replication to SAP HANA

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

• Visualize Live Hive in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Apache Hive.

• Connect to NetSuite from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for NetSuite to connect to NetSuite CRM & ERP and execute queries in PowerBuilder.

• Use the CData ODBC Driver for Email from SharePoint Excel Services

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

• Connect to Zoho Inventory in RunMyProcess through Connect Cloud

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Dynamics NAV

  Provide connectivity to Microsoft Dynamics NAV through an SAP BusinessObjects universe.

• Connect to Reckon Accounts Hosted as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Reckon Accounts Hosted.

• ETL Phoenix in Oracle Data Integrator

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

• Connect to CSV in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for CSV and connect to CSV/TSV Files in Akorbi Digital RunMyProcess.

• Connect to Google Drive as a Linked Server via SQL Gateway

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

• Connect to PostgreSQL in Google Apps Script via SQL Gateway

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

• Connect to Dynamics NAV as an External Source in Dremio

  Use the CData JDBC Driver to connect to Dynamics NAV as an External Source in Dremio.

• How to create Cvent federated tables in MySQL

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

• Access HCL Domino from MySQL in PHP

  Connect to HCL Domino through the standard MySQL libraries in PHP.

• Create Excel Dashboards in Bold BI

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

• Integrate with JotForm in JReport Designer

  Create charts and reports based on JotForm in JReport Designer.

• Natively Connect to Google Campaign Manager 360 in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Google Campaign Manager 360. Leverage the native support for ODBC in PHP.

• Visualize Workday in TIBCO Spotfire through ODBC

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

• How to Visualize Excel Online Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Microsoft Excel Online in Python.

• Access SFTP in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for SFTP.

• Use the CData Software JDBC Driver for EventBrite in MicroStrategy

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

• How to connect to Power BI XMLA from IntelliJ

  Integrate connectivity to Power BI XMLA with wizards in IntelliJ.

• Build Acumatica-Connected Dashboards Using Zoho Analytics

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

• How to connect to Microsoft Teams from MS Excel on Mac OS X

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

• Analyze LinkedIn in Cognos Analytics

  Use CData Connect Cloud to connect to LinkedIn from Cognos Analytics and analyze live LinkedIn.

• Stream Azure Data Catalog into Apache Kafka Topics

  Access and stream Azure Data Catalog in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Object-Relational Mapping (ORM) with Tally Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Tally ERP into a Java-based ORM framework, Hibernate.

• Connect to ClickUp from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for ClickUp to connect to ClickUp and execute queries in PowerBuilder.

• Automated Continuous Sybase Replication to Amazon Redshift

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

• Query Wave Financial in DataGrip

  Create a Data Source for Wave Financial in DataGrip and use SQL to query live Wave Financial.

• Integrate OData Services into Automated Tasks with Power Automate

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

• Connect to Jira in RapidMiner

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

• Connect to Azure Active Directory from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Azure Active Directory from Filemaker Pro on Mac.

• How to work with SAP ByDesign in Apache Spark using SQL

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

• Working with BigCommerce in LINQPad

  Execute LINQ queries to BigCommerce in LINQPad.

• Use Dash to Build to Web Apps on Impala

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

• Import Real-Time Oracle SCM via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Oracle SCM in ColdFusion.

• DataBind Email to the DevExpress Data Grid

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

• How to create an RPA flow for Outreach.io in UiPath Studio

  Use the Outreach.io ODBC Driver to create workflows that access real-time Outreach.io without any coding.

• Access GitHub in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for GitHub.

• Automated Continuous Procore Replication to Oracle

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

• Integrate with ShipStation using Apache Camel2

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

• Build an OLAP Cube in SSAS from Snapchat Ads

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

• Integrate Azure Table into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Azure Table Storage and integrate live Azure Table Storage into your Power Automate tasks.

• Connect to WooCommerce from a Connection Pool in JBoss

  Integrate WooCommerce into Java servlets: Use the Management Console in JBoss to install the WooCommerce JDBC Driver.

• Publish Reports with Adobe Commerce in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Adobe Commerce.

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

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

• Automated Continuous Todoist Replication to Vertica

  Use CData Sync for automated, continuous, customizable Todoist replication to Vertica.

• Publish Reports with SAP SuccessFactors in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SAP SuccessFactors.

• Automate Snapchat Ads Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Snapchat Ads from PowerShell? This article demonstrates how to utilize the Snapchat Ads Cmdlets for tasks like connecting to Snapchat Ads, automating operations, downloading data, and more.

• Connect to Raisers Edge NXT from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Raisers Edge NXT to connect to Raisers Edge NXT from Web applications running on WebLogic.

• Automated Continuous SAP Ariba Procurement Replication to Vertica

  Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Vertica.

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

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

• Coinbase Reporting and Star Schemas in OBIEE

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

• Automated Continuous PostgreSQL Replication to SQLite

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

• Automated Continuous eBay Analytics Replication to MongoDB

  Use CData Sync for automated, continuous, customizable eBay Analytics replication to MongoDB.

• Automate Procore Replication to SAP HANA

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

• Create a Data Access Object for CSV using JDBI

  A brief overview of creating a SQL Object API for CSV/TSV Files in JDBI.

• Connect to Dynamics CRM in SpagoBI

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

• Operational Reporting on Phoenix from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Apache Phoenix.

• Build Azure Data Lake Storage-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live Azure Data Lake Storage and build Azure Data Lake Storage-connected web apps with Axios.

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

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

• Connect to Greenplum in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Greenplum and the SQL Gateway to access Pivotal GreenPlum from Google Apps Script.

• Model Amazon Athena Using Azure Analysis Services

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

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

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

• Integrate XML in the Pentaho Report Designer

  Publish reports based on XML Files in the Pentaho BI tool.

• Connect to Sybase IQ from Asprova with CData Software ODBC Driver for Sybase IQ

  This article shows how to connect faster to Sybase IQ data from Asprova.

• Connect to HCL Domino in DBeaver

  Use the CData ODBC Driver to connect to HCL Domino in DBeaver.

• FHIR Reporting in OBIEE with the FHIR JDBC Driver

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

• Connect to Oracle from PowerBuilder via ADO.NET

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

• Automated Continuous Airtable Replication to MongoDB

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

• Integrate with Couchbase using Apache Camel2

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

• Connect to Zenefits from Asprova with CData Software ODBC Driver for Zenefits

  This article shows how to connect faster to Zenefits data from Asprova.

• How to integrate Jira with Apache Airflow

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

• Connect to Cloudant from Excel & GoogleSheets!

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

• Connect to Calendly from a Connection Pool in JBoss

  Integrate Calendly into Java servlets: Use the Management Console in JBoss to install the Calendly JDBC Driver.

• «
• 156
• 157
• 158
• 159
• 160
• 161
• 162
• 163
• 164
• 165
• »