CData Software - Knowledge Base

Recent Articles

• «
• 59
• 60
• 61
• 62
• 63
• 64
• 65
• 66
• 67
• 68
• »

• Provide OData Services of QuickBooks from a WCF Application

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

• Object-Relational Mapping (ORM) with Exact Online 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 Exact Online into a Java-based ORM framework, Hibernate.

• Connect to SAP Concur as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP Concur.

• Connect to Act CRM from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Act CRM to connect to Act CRM from Web applications running on WebLogic.

• How to integrate Metabase with Monday.com

  Use CData Connect Cloud to connect to live Monday.com and create an interactive dashboard in Metabase from Monday.com.

• Analyze HarperDB in SAP Analytics Cloud

  Use the CData Connect Server to create an OData API on top of HarperDB and visualize HarperDB in SAP Analytics Cloud.

• Automated Google Directory Replication to Teradata

  Use CData Sync to Customize and automate Google Directory replication to Teradata.

• Analyze Microsoft Dataverse with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Microsoft Dataverse from Power Pivot. You will use the Table Import Wizard to load Microsoft Dataverse (CDS). You can visually build the import query or use any SQL supported by the driver.

• Replicate SAP Ariba Source to Multiple Databases

  Replicate SAP Ariba Source to disparate databases with a single configuration.

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

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

• How to use SQLAlchemy ORM to access Basecamp in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Basecamp.

• Automated Continuous SAP Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable SAP replication to Amazon S3.

• Connect to Sage 200 in CloverDX (formerly CloverETL)

  Transfer Sage 200 using the visual workflow in the CloverDX data integration tool.

• Bidirectional Access to Box from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Box in Filemaker Pro for Mac or Windows.

• Establish a Live Connection with Twilio using Tableau Bridge

  The CData ODBC Driver for Twilio enables you to integrate live Twilio into Tableau Cloud dashboards using the Tableau Bridge.

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

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

• Connect to HBase in DBeaver

  Use the CData ODBC Driver to connect to Apache HBase in DBeaver.

• Validate Excel with QuerySurge

  Access and validate Microsoft Excel in QuerySurge using the CData JDBC Driver.

• Prepare, Blend, and Analyze Couchbase in Alteryx Designer

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

• Integrate Real-Time Access to Azure Data Catalog in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Azure Data Catalog in real time.

• Build Epicor Kinetic-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Epicor Kinetic from Choreo and build custom apps using live Epicor Kinetic.

• Connect to Office 365 from a Connection Pool in Jetty

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

• Natively Connect to Oracle in PHP

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

• Replicate RSS Feeds from PowerShell

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

• Automated Continuous Snapchat Ads Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Azure SQL.

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

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

• Replicate Google Sheets to Multiple Databases

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

• Analyze Procore with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Procore from Power Pivot. You will use the Table Import Wizard to load Procore. You can visually build the import query or use any SQL supported by the driver.

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

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

• Working with Hive in LINQPad

  Execute LINQ queries to Apache Hive in LINQPad.

• Access IBM Cloud Data Engine 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 IBM Cloud Data Engine.

• Visualize Excel Online in Tableau

  The CData ODBC driver for Excel Online enables you integrate Microsoft Excel Online into Tableau dashboards.

• Create SSAS Tabular Models from SAP Fieldglass

  How to build a SQL Server Analysis Service Tabular Model from SAP Fieldglass using CData drivers.

• Build Charts with Presto in Clear Analytics

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

• Process & Analyze Acumatica in Databricks (AWS)

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

• Model, Search, and Visualize Live Oracle HCM Cloud in ThoughtSpot

  Use CData Connect Cloud to connect to live Oracle HCM Cloud for modeling, searching, and visualizing.

• Automated Continuous Google Calendar Replication to Amazon Redshift

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

• Query Cassandra in DataGrip

  Create a Data Source for Cassandra in DataGrip and use SQL to query live Apache Cassandra.

• Automated Continuous Oracle HCM Cloud Replication to MySQL

  Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to MySQL.

• Create Datasets from Databricks in Domo Workbench and Build Visualizations of Databricks in Domo

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

• A PostgreSQL Interface for Slack

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

• How to Build an ETL App for Stripe in Python with CData

  Create ETL applications and real-time data pipelines for Stripe in Python with petl.

• Create Microsoft OneDrive-Connected Nintex Workflows

  Use CData Software Connect Server to connect to Microsoft OneDrive from Nintex Workflow Cloud and build custom workflows using live Microsoft OneDrive.

• Connect to TaxJar in SpagoBI

  Create reports featuring live TaxJar in SpagoBI Studio. Host TaxJar reports on SpagoBI Server.

• Integrate Live Cloudant into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Cloudant from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live IBM Cloudant.

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

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

• Visualize CSV from Tableau

  Use the Tableau Desktop business intelligence tool to connect to CSV/TSV Files.

• How to Import OneNote into SQL Server using SSIS

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

• DataBind Charts to Marketo

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Marketo 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.

• Create DocuSign Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time DocuSign data access from reports, embedded analytics, and more.

• Replicate ClickUp to Multiple Databases

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

• Validate Sage Cloud Accounting with QuerySurge

  Access and validate Sage Business Cloud Accounting in QuerySurge using the CData JDBC Driver.

• Connect to Unbounce in SpagoBI

  Create reports featuring live Unbounce in SpagoBI Studio. Host Unbounce reports on SpagoBI Server.

• View Reports on Real-Time Airtable in Power BI Report Server

  Use the CData ODBC Driver for Airtable to visualize Airtable in Power BI Desktop and then publish them to Power BI Report Server.

• Build ShipStation-Connected Apps in Mendix

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

• Build Salesloft-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Salesloft and build web apps with connectivity to live Salesloft.

• How to connect to Zoho Inventory from MS Excel on Mac OS X

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

• Integrate Live Marketo into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Marketo from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Marketo.

• Integrate with Zoho Inventory in SnapLogic

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

• Azure Active Directory Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Azure Active Directory through CData Connect Cloud using different applications and tools.

• Create Data Visualizations Based On Amazon S3 in Mode

  Use CData Connect Cloud to connect to Amazon S3 from Mode and build visualizations using live

• Establish a Live Connection with Tally using Tableau Bridge

  The CData ODBC Driver for Tally enables you to integrate live Tally ERP into Tableau Cloud dashboards using the Tableau Bridge.

• Access Live Jira Service Management in Excel (Desktop)

  Use CData Connect Cloud to gain access to live Atlassian Jira Service Management from your Excel spreadsheets.

• DataBind Controls to MYOB AccountRight in C++Builder

  DataBind to MYOB AccountRight in C++Builder with standard components and controls.

• Create SSAS Tabular Models from Tableau CRM Analytics

  How to build a SQL Server Analysis Service Tabular Model from Tableau CRM Analytics using CData drivers.

• A PostgreSQL Interface for Azure DevOps

  Use the Remoting features of the Azure DevOps ODBC Driver to create a PostgreSQL entry-point for data access.

• Build Dashboards with Jira Service Management in DBxtra

  Create dynamic dashboards and perform analytics based on Atlassian Jira Service Management in DBxtra.

• Connect to BigCommerce in RapidMiner

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

• Create SSAS Tabular Models from Greenhouse

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

• Connect to SAP HANA XS Advanced from PowerBuilder

  This article demonstrates how to access SAP HANA XS Advanced from Appeon PowerBuilder using the CData ADO.NET Provider for SAP HANA XS Advanced.

• Automate Hive Replication to Azure Data Lake

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

• Edit and Search External Azure Data Lake Storage Objects in Salesforce Connect

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

• Replicate Multiple PayPal Accounts

  Replicate multiple PayPal accounts to one or many databases.

• Analyze Instagram in Infragistics Reveal

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

• How to publish and share HDFS dashboards with Tableau Server

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

• How to Visualize Salesforce Marketing Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Salesforce Marketing Cloud in Python.

• Build an OLAP Cube in SSAS from Invoiced

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

• How to Import Snowflake into SQL Server using SSIS

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

• Connect to Hive from PowerBuilder

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

• Invoiced Reporting and Star Schemas in OBIEE

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

• Connect to Snowflake in Airbyte ELT Pipelines

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

• DataBind Controls to Paylocity in C++Builder

  DataBind to Paylocity in C++Builder with standard components and controls.

• Access Facebook from MySQL in PHP

  Connect to Facebook through the standard MySQL libraries in PHP.

• Creating Cosmos DB-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Azure Cosmos DB to Unqork and build custom business apps.

• Automated Continuous Act CRM Replication to Oracle

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

• Automated Continuous Azure Active Directory Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Azure Active Directory replication to IBM DB2.

• Build Stripe-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Stripe.

• Design BIRT Reports on MySQL

  Provide current MySQL to your embedded analytics.

• Visualize Redshift in TIBCO Spotfire through ADO.NET

  Integrate Amazon Redshift into dashboards in TIBCO Spotfire.

• Connect to ADP in Google Apps Script

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

• Build Apps with Live GitHub in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live GitHub into the Adalo platform and build custom mobile and web applications with real-time GitHub.

• Analyze Twitter with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Twitter from Power Pivot. You will use the Table Import Wizard to load Twitter. You can visually build the import query or use any SQL supported by the driver.

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

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

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

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

• Analyze Shippo with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Shippo from Power Pivot. You will use the Table Import Wizard to load Shippo. You can visually build the import query or use any SQL supported by the driver.

• Integrate with SingleStore using Apache Camel2

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

• Integrate GitHub in the Pentaho Report Designer

  Publish reports based on GitHub in the Pentaho BI tool.

• Build a Simple VCL Application for Neo4J

  How to build a simple VCL Application to view Neo4J in RAD Studio using the CData ODBC Driver for Neo4J.

• Work with Freshdesk in FoxPro

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

• Build Visualizations of Salesforce Pardot in Birst

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

• «
• 59
• 60
• 61
• 62
• 63
• 64
• 65
• 66
• 67
• 68
• »