CData Software - Knowledge Base

Recent Articles

• «
• 306
• 307
• 308
• 309
• 310
• 311
• 312
• 313
• 314
• 315
• »

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

• Build Zoho Inventory-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Zoho Inventory from Choreo and build custom apps using live Zoho Inventory.

• Deploy the ADO.NET Provider for Databricks on an SSRS Report Server

  Connect to Databricks from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Connect to Facebook from a Connection Pool in JBoss

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

• How to pipe Slack to CSV in PowerShell

  Use standard PowerShell cmdlets to access Slack tables.

• A PostgreSQL Interface for Okta

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

• Feed SAP Hybris C4C into FineReport

  How to set SAP Hybris C4C as a JDBC data source in FineReport.

• Query Pipedrive in ColdFusion

  Write standard ColdFusion data access code to connect to Pipedrive.

• Create Reports with Calendly in SAP Crystal Reports

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

• How to create an RPA flow for Salesforce Pardot in UiPath Studio

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

• How to create Okta federated tables in MySQL

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

• Create Apps from NetSuite in Qlik Sense Cloud

  Use CData Connect Cloud to connect to NetSuite and build apps from live NetSuite CRM & ERP in Qlik Sense Cloud.

• Work with Live Smartsheet in Power Query

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

• Automated Continuous Instagram Replication to Amazon S3

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

• A PostgreSQL Interface for SAP BusinessObjects BI

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

• Analyze Clio in R

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

• Visualize Live SAP Business One in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Business One.

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

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

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

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

• DataBind Controls to Pinterest in Delphi

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

• PowerShell Scripting to Replicate Calendly to MySQL

  Write a simple PowerShell script to replicate Calendly to a MySQL database.

• How to pipe Invoiced to CSV in PowerShell

  Use standard PowerShell cmdlets to access Invoiced tables.

• Build Interactive Dashboards from Printful in Amazon QuickSight

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

• Create Informatica Mappings From/To a JDBC Data Source for Salesforce Pardot

  Create Salesforce Pardot data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Connect to Sage 200 in HULFT Integrate

  Connect to Sage 200 as a JDBC data source in HULFT Integrate

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

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

• Visualize WordPress in Sisense

  Create an ElastiCube in Sisense app with access to WordPress.

• Rapidly Develop Klaviyo-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Create Informatica Mappings From/To an ODBC Data Source for ActiveCampaign

  Create an ODBC connection to ActiveCampaign in Informatica and browse and transfer ActiveCampaign.

• Create Reports with Zenefits in SAP Crystal Reports

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

• Connect to Outreach.io in DBArtisan

  Use wizards in DBArtisan to configure Outreach.io as a data source.

• Feed Procore into FineReport

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

• Connect to and Query Zoho Books in QlikView over ODBC

  Create data visualizations with Zoho Books in QlikView.

• Bridge Cosmos DB Connectivity with Apache NiFi

  Access and process Azure Cosmos DB in Apache NiFi using the CData JDBC Driver.

• Author and Share Power BI Reports on Real-Time Oracle Eloqua

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

• Natively Connect to MariaDB in PHP

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

• Use the CData ODBC Driver for Excel in SAS JMP

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

• How to connect PolyBase to Hive

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

• Connect to SAP SuccessFactors from HeidiSQL

  Use CData Connect Cloud to connect to and query live SAP SuccessFactors from HeidiSQL.

• Automated Continuous Typeform Replication to Amazon Redshift

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

• How to import Sage 200 into Apache Solr

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

• Connect to Dropbox in JRuby

  Create a simple JRuby app with access to live Dropbox.

• Build Charts with Oracle in Clear Analytics

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

• Automated Continuous HCL Domino Replication to Amazon Redshift

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

• Automate Sage Cloud Accounting Integration Tasks from PowerShell

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

• Bidirectional Access to Adobe Commerce from FileMaker Pro

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

• Visualize Dropbox in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for Dropbox in CData Software Connect (or Connect Server) and build visualizations from live Dropbox in Tableau Desktop.

• Natively Connect to Oracle SCM in PHP

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

• Natively Connect to Bullhorn CRM in PHP

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

• Visualize Freshdesk in TIBCO Spotfire through ADO.NET

  Integrate Freshdesk into dashboards in TIBCO Spotfire.

• Automated Continuous Cloudant Replication to Amazon S3

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

• Replicate Multiple Twitter Ads Accounts

  Replicate multiple Twitter Ads accounts to one or many databases.

• PowerShell Scripting to Replicate Dynamics 365 to MySQL

  Write a simple PowerShell script to replicate Microsoft Dynamics 365 to a MySQL database.

• Import Box into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for Box and create custom reports in the Power BI Service.

• Query Cosmos DB as a SQL Server Database in Node.js

  Execute SQL Server queries against Azure Cosmos DB from Node.js.

• Build an MVC Application with Connectivity to QuickBooks

  CData ADO.NET Providers can be used from many tools and IDEs. In this article we show how to connect to QuickBooks from an MVC project using the CData ADO.NET Provider for QuickBooks. Although this article uses the QuickBooks Data Provider, the same process can be used with any of the CData ADO.NET Providers.

• Process & Analyze Parquet in Databricks (AWS)

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

• Publish Reports with LDAP Objects in SAP Crystal Reports

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

• Connect to Sage Intacct in Jaspersoft Studio

  Execute SQL to remote Sage Intacct in Jaspersoft Studio.

• Connect to Veeva in RunMyProcess through Connect Cloud

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

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

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

• Build Charts with SAP HANA in Clear Analytics

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

• Explore Geographical Relationships in Redshift with Power Map

  Create data visualizations with Amazon Redshift in Power Map.

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

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

• Integrate Neo4J into Automated Tasks with Power Automate

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

• Create Spark-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Spark from Klipfolio and build custom visualizations using live Apache Spark SQL.

• Connect to Google Campaign Manager 360 in RazorSQL

  Connect to Google Campaign Manager 360 from wizards and query Google Campaign Manager 360 from the GUI in the RazorSQL database management tool.

• Analyze SAP Fieldglass in SAP Analytics Cloud

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

• Build Semantic Layer Views for Snapchat Ads in APOS Live Data Gateway

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

• How to load Act CRM data into Elasticsearch via Logstash

  Introducing a simple method to load Act CRM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Using AngularJS to Build Dynamic Web Pages with SuiteCRM

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

• Use Biml to Build SSIS Tasks to Replicate SAP HANA XS Advanced to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP HANA XS Advanced to SQL Server.

• Use the CData Software ODBC Driver for Amazon Athena in MicroStrategy Desktop

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

• How to Query Marketo in MySQL Workbench

  Execute MySQL queries against live Marketo from MySQL Workbench.

• Build Apps with Live Oracle Eloqua in Adalo using CData Connect Cloud

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

• Replicate Facebook to Multiple Databases

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

• How to Visualize NetSuite Data in Python with pandas

  Use pandas and other modules to analyze and visualize live NetSuite CRM & ERP in Python.

• Automated Continuous Jira Replication to MySQL

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

• Access SAP Ariba Source from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live SAP Ariba Source from HeidiSQL.

• Publish Raisers Edge NXT-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Raisers Edge NXT.

• Access Live Smartsheet in AWS Lambda (with IntelliJ IDEA)

  Connect to live Smartsheet in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Using AngularJS to Build Dynamic Web Pages with Salesforce

  Use the CData Connect Server to create Salesforce OData feeds and build single-page applications with live Salesforce & Force.com.

• Create Airtable Reports on JasperReports Server

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

• Viewing Zoho Projects in RAD Studio Data Explorer

  How to view Zoho Projects in RAD Studio Data Explorer using the CData ODBC Driver for Zoho Projects.

• Create LinkedIn Ads Dataflows on PowerBI.com

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

• Explore Geographical Relationships in Confluence with Power Map

  Create data visualizations with Atlassian Confluence in Power Map.

• DataBind Cloudant to the DevExpress Data Grid

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

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

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

• Viewing MongoDB in RAD Studio Data Explorer

  How to view MongoDB in RAD Studio Data Explorer using the CData ODBC Driver for MongoDB.

• Integrate Amazon S3 with External Services using SnapLogic

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

• Integrate AlloyDB into Power Automate Desktop using CData Connect

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

• Export Data from SQL Server to OneNote through SSIS

  Easily push SQL Server data to OneNote using the CData SSIS Tasks for OneNote.

• Replicate Sybase to Multiple Databases

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

• Automated Continuous Klipfolio Replication to Amazon Redshift

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

• Visualize MySQL in Tableau

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

• LINQ to JotForm

  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 JotForm Data Provider.

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

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

• Publish Crystal Reports on Google Data Catalog

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Data Catalog.

• Working with OData Services in LINQPad

  Execute LINQ queries to OData in LINQPad.

• Import and Visualize Monday.com in Power View

  Create data visualizations based on Monday.com in Excel.

• «
• 306
• 307
• 308
• 309
• 310
• 311
• 312
• 313
• 314
• 315
• »