CData Software - Knowledge Base

Recent Articles

• «
• 246
• 247
• 248
• 249
• 250
• 251
• 252
• 253
• 254
• 255
• »

• Using AngularJS to Build Dynamic Web Pages with Elasticsearch

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

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

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

• Access Live ConstantContact in TIBCO Data Virtualization

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

• Import SAP ByDesign into FileMaker Pro

  Create reports that integrate SAP Business ByDesign in Filemaker Pro.

• Automated Continuous MongoDB Replication to Amazon Redshift

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

• Build Automated Paylocity-Connected Workflows in Zapier

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

• How to Query BigQuery in MySQL Workbench

  Execute MySQL queries against live Google BigQuery from MySQL Workbench.

• How to publish and share HubDB dashboards with Tableau Server

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

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

  Create ETL applications and real-time data pipelines for CSV/TSV Files in Python with petl.

• Easily Integrate Amazon DynamoDB in Lazarus Pascal IDE

  Learn how to easily integrate live Amazon DynamoDB in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Back Up Oracle Service Cloud to SQL Server through SSIS

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

• Excel Spreadsheet Automation on Jira with the QUERY Formula

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

• Access Live Google Analytics in Google Sheets via Connect Cloud

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

• Analyze MailChimp in SAP Analytics Cloud

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

• How to Access Klipfolio Using Entity Framework

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

• Publish Odoo-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Odoo ERP.

• How to Build Dynamic React Apps with ConstantContact

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

• Integrate with Google Data Catalog using Apache Camel2

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

• Connect to Elasticsearch from a Connection Pool in Jetty

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

• Build Dashboards with Printify in DBxtra

  Create dynamic dashboards and perform analytics based on Printify in DBxtra.

• Create Jira-Connected Business Apps in AppSheet

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

• Automated Continuous SAP Hybris C4C Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Amazon Redshift.

• How to Use a Microsoft Access Database to Update Freshdesk in Real Time

  Update Freshdesk data by creating a linked table in Microsoft Access with the CData Freshdesk ODBC Driver.

• Connect to Epicor Kinetic from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Epicor Kinetic to connect to Epicor Kinetic from Web applications running on WebLogic.

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

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

• Integrate SAP SuccessFactors with External Services using SnapLogic

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

• Build Workday-Connected Visualizations in datapine

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

• Access Zuora from MySQL in HeidiSQL

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

• Connect to Salesforce Pardot in NetBeans

  Connect to Salesforce Pardot in NetBeans with the data source configuration wizard.

• Use CData Connect Cloud to Access ActiveCampaign in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live ActiveCampaign in the Power Pivot business intelligence tool.

• Automated Continuous ConstantContact Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable ConstantContact replication to Microsoft Access.

• Use JayDeBeApi to access Cassandra in Python

  Use standard Python scripting and the development environment of your choice to access live Apache Cassandra.

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

  Use CData JDBC drivers to import and use Amazon DynamoDB in ColdFusion.

• Create Data Visualizations in Cognos BI with Act-On

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

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

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

• How to integrate Zoho Inventory with Apache Airflow

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

• Automated Continuous Marketo Replication to Vertica

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

• Provide OData Services of Zendesk from a WCF Application

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

• Access Live ActiveCampaign in SAS JMP via ODBC

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

• Automated Continuous IBM Cloud Object Storage Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Amazon S3.

• Import AlloyDB Using Azure Data Factory

  Use CData Connect Cloud to connect to AlloyDB from Azure Data Factory and import live Google AlloyDB.

• Build a Simple VCL Application for Avalara AvaTax

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

• Visualize Live Azure Data Lake Storage in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Azure Data Lake Storage.

• Build Visualizations of Live TaxJar in Power BI (through CData Connect)

  Use CData Connect to create a virtual database for TaxJar and build custom reports in Power BI.

• Connect to WordPress from PowerBuilder via ODBC

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

• Create Marketo Reports on JasperReports Server

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

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

• Connect to Excel Online through External Services in Salesforce

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

• Connect to Tableau CRM Analytics in DBeaver

  Use the CData ODBC Driver to connect to Tableau CRM Analytics in DBeaver.

• Integrate Microsoft OneDrive into Automated Tasks with Power Automate

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

• How to Work with SharePoint Excel Services in AWS Glue Jobs Using JDBC

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

• LINQ to Hive

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

• Connect to Microsoft Teams as an External Source in Dremio

  Use the CData JDBC Driver to connect to Microsoft Teams as an External Source in Dremio.

• How to create an RPA flow for Oracle HCM Cloud in UiPath Studio

  Use the Oracle HCM Cloud ODBC Driver to create workflows that access real-time Oracle HCM Cloud without any coding.

• Create Sugar CRM Dataflows on PowerBI.com

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

• How to Build Dynamic React Apps with Jira Service Management

  Use the CData Connect and React to Build Dynamic Web Apps with Live Jira Service Management .

• Create Data Visualizations in Cognos BI with eBay Analytics

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

• Visualize SAP HANA XS Advanced from Tableau

  Use the Tableau Desktop business intelligence tool to connect to SAP HANA XS Advanced.

• Create Dynamics 365 Dataflows on PowerBI.com

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

• Enable the Sage 200 JDBC Driver in KNIME

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

• Rapidly Develop Phoenix-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.

• How to create an RPA flow for TaxJar in UiPath Studio

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

• Connect to WordPress from Crystal Reports

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

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

  Create an ODBC connection to Highrise in Informatica and browse and transfer Highrise CRM.

• Manage Splunk in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Splunk.

• Import REST into FileMaker Pro

  Create reports that integrate REST in Filemaker Pro.

• Connect to and Query Google Calendar in QlikView over ODBC

  Create data visualizations with Google Calendar in QlikView.

• Automated Continuous Facebook Ads Replication to Microsoft Access

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

• Using the CData Software ODBC Driver for XML in PyCharm

  Connect to XML as an ODBC data source in PyCharm using the CData Software ODBC Driver for XML.

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

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

• How to Visualize eBay Data in Python with pandas

  Use pandas and other modules to analyze and visualize live eBay in Python.

• Natively Connect to SAP Fieldglass in PHP via ODBC (Linux)

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

• Automated Continuous Cosmos DB Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Cosmos DB replication to Apache Kafka.

• How to pipe Reckon to CSV in PowerShell

  Use standard PowerShell cmdlets to access Reckon tables.

• Use CData Connect Cloud to Access Azure Analysis Services in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Azure Analysis Services in the Power Pivot business intelligence tool.

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

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

• How to Connect to & Open QuickBooks Time in Microsoft Excel

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

• Connect to eBay from PowerBuilder via ODBC

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

• Build Facebook-Connected Apps in Mendix

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

• Natively Connect to WooCommerce in PHP via ODBC (Linux)

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

• Connect to Azure Table from Filemaker Pro (Mac)

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

• Perform API Operations Using the CData SharePoint Task

  The CData SharePoint Task allows you to easily call stored procedures to perform SharePoint API operations.

• Use the Connect Server to Access IBM Cloud Data Engine in Microsoft Power Pivot

  Use the Connect Server to connect to live IBM Cloud Data Engine in the Power Pivot business intelligence tool.

• ETL Oracle SCM in Oracle Data Integrator

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

• Bridge Google Calendar Connectivity with Apache NiFi

  Access and process Google Calendar in Apache NiFi using the CData JDBC Driver.

• How to connect PolyBase to Sage 200

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

• Replicate MYOB AccountRight to Multiple Databases via the CData Sync CLI

  Replicate MYOB AccountRight to disparate databases with a single configuration.

• Build Automated Workflows with Live Zoho Creator in Workato

  Use CData Connect Cloud to connect to live Zoho Creator and build automated workflows in Workato.

• Edit and Search External OneNote Objects in Salesforce Connect

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

• Query Asana in DataGrip

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

• Automate Azure DevOps Replication to Azure Synapse

  Use CData Sync to customize and automate Azure DevOps replication to Azure Synapse.

• Automated Continuous SAP BusinessObjects BI Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to AlloyDB.

• Connect to Sage Intacct from PowerBuilder via ADO.NET

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

• Replicate DocuSign to Multiple Databases via the CData Sync CLI

  Replicate DocuSign to disparate databases with a single configuration.

• Create Reports from Reckon in Looker Studio

  Use CData Connect Cloud to gain access to live Reckon and create custom reports in Looker Studio.

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

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

• How to pipe Zoom to CSV in PowerShell

  Use standard PowerShell cmdlets to access Zoom tables.

• Integrate Oracle Eloqua into Power Automate Desktop using CData Connect

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

• Design BIRT Reports on AlloyDB

  Provide current Google AlloyDB to your embedded analytics.

• Replicate Multiple TaxJar Accounts

  Replicate multiple TaxJar accounts to one or many databases.

• «
• 246
• 247
• 248
• 249
• 250
• 251
• 252
• 253
• 254
• 255
• »