CData Software - Knowledge Base

Recent Articles

• «
• 369
• 370
• 371
• 372
• 373
• 374
• 375
• 376
• 377
• 378
• »

• Bind Live Monday.com Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Monday.com data

• Create Airtable-Connected Business Apps in AppSheet

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

• Connect to Google Search from Asprova with CData Software ODBC Driver for Google Search

  This article shows how to connect faster to Google Search data from Asprova.

• Easily Integrate Paylocity in Lazarus Pascal IDE

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

• How to Query GitHub in MySQL Workbench

  Execute MySQL queries against live GitHub from MySQL Workbench.

• Connect LinkedIn to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your LinkedIn using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Visualize Splunk in Tableau

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

• Zoho CRM: "Invalid_Client" Error After Successful OAuth Authorization

  In this entry, you will find the resolution to the most common cause of the "Invalid_Client" error, despite seeing a successful OAuth authorization in the browser.

• Automated Continuous Zoho CRM Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Zoho CRM replication to Apache Cassandra.

• How to connect SharePoint with BigCommerce through external lists

  Provide BigCommerce to SharePoint users as an external list.

• SAP Ariba Source Reporting in OBIEE with the SAP Ariba Source JDBC Driver

  Deploy the SAP Ariba Source JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Connect to CouchDB in CloverDX (formerly CloverETL)

  Transfer Apache CouchDB using the visual workflow in the CloverDX data integration tool.

• Connect to Oracle Sales in Ruby

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

• Connect to Bitbucket as a Linked Server via SQL Gateway

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

• Access Oracle Sales from MySQL in PHP

  Connect to Oracle Sales through the standard MySQL libraries in PHP.

• Create Redshift-Connected Nintex Workflows

  Use CData Connect Cloud to connect to Redshift from Nintex Workflow Cloud and build custom workflows using live Amazon Redshift.

• Enable the XML JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with XML Files.

• Connect to Slack from PowerBuilder via ODBC

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

• How to Connect to Calendly in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Calendly. Leverage the pyodbc module for ODBC in Python.

• Bind Live Klipfolio Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Klipfolio data

• PowerShell Scripting to Replicate Dropbox to MySQL

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

• Feed Greenplum into FineReport

  How to set Pivotal GreenPlum as a JDBC data source in FineReport.

• How to create Epicor Kinetic federated tables in MySQL

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

• Build Microsoft OneDrive-Connected Web Apps in Servoy

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

• Enable the Elasticsearch JDBC Driver in KNIME

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

• Automated Continuous Act-On Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Act-On replication to SQL Server.

• Connect to Sugar CRM in DBArtisan

  Use wizards in DBArtisan to configure Sugar CRM as a data source.

• Create Reports with Wave Financial in SAP Crystal Reports

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

• Build Pipelines with Live Azure Table in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Azure Table from Google Cloud Data Fusion, enabling the integration of live Azure Table Storage into the building and management of effective data pipelines.

• Integrate with live Zuora in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Zuora in Jitterbit.

• Build Data Flows from Microsoft OneDrive to SQL Server using SSIS

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

• Connect to SAP Ariba Procurement in JRuby

  Create a simple JRuby app with access to live SAP Ariba Procurement.

• Automated Continuous Amazon Athena Replication to SQLite

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

• Natively Connect to Phoenix in PHP

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

• Google Search Reporting and Star Schemas in OBIEE

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

• Replicate DB2 to Multiple Databases via the CData Sync CLI

  Replicate IBM DB2 to disparate databases with a single configuration.

• ETL SharePoint in Oracle Data Integrator

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

• Automated Continuous Google Sheets Replication to Amazon S3

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

• Use the CData ODBC Driver for Avro in Microsoft Power Query

  You can use the CData Avro ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apache Avro into Microsoft Power Query.

• Automated Continuous Authorize.Net Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Authorize.Net replication to SQL Server.

• Prepare, Blend, and Analyze FTP in Alteryx Designer (ODBC)

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

• Create a Data Access Object for JDBC-ODBC Bridge using JDBI

  A brief overview of creating a SQL Object API for JDBC-ODBC Bridge in JDBI.

• Use the CData Software ODBC Driver for Bing Ads in MicroStrategy Web

  Connect to Bing Ads in MicroStrategy Web using the CData Software ODBC Driver for Bing Ads.

• Automated Continuous SingleStore Replication to Amazon Redshift

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

• How to Access EventBrite Using Entity Framework

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

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

  Use CData JDBC drivers to import and use QuickBooks Online in ColdFusion.

• Extract, Transform, and Load Raisers Edge NXT in Informatica PowerCenter

  Create a simple Workflow for Raisers Edge NXT in Informatica PowerCenter.

• LINQ to Jira Service Management

  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 Jira Service Management Data Provider.

• Connect to Certinia in CloverDX (formerly CloverETL)

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

• Connect to Coinbase from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Coinbase using standard SQL.

• ETL Avalara AvaTax in Oracle Data Integrator

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

• Connect to OneNote in RazorSQL

  Connect to OneNote from wizards and query Microsoft OneNote from the GUI in the RazorSQL database management tool.

• Extract, Transform, and Load OneNote in Informatica PowerCenter

  Create a simple Workflow for Microsoft OneNote in Informatica PowerCenter.

• Connect to PostgreSQL in the Denodo Platform

  Use CData driver technologies to create a virtual data source for PostgreSQL in the Denodo Virtual DataPort Administrator.

• Integrate Real-Time Access to Printify in SAPUI5 MVC Apps

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

• Integrate with Live Exact Online in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Exact Online from the MuleSoft Anypoint Platform to integrate live Exact Online into custom reports and dashboards.

• Access Microsoft Project from MySQL in HeidiSQL

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

• How to Seamlessly Import Acumatica Data into IBM SPSS Modeler

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

• Automated Continuous Procore Replication to Google BigQuery

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

• How to connect to Google Ads in DBVisualizer

  Integrate Google Ads with visual data analysis tools and data connection wizards in DBVisualizer

• How to Connect to Zoho Creator in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Zoho Creator. Leverage the pyodbc module for ODBC in Python.

• Import and Visualize SAP HANA in Power View

  Create data visualizations based on SAP HANA in Excel.

• Create Power BI Reports on Real-Time Dropbox

  Use the CData ODBC Driver for Dropbox to visualize Dropbox in Power BI Desktop.

• Build Amazon Marketplace-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Amazon Marketplace.

• Bidirectional Access to Confluence from FileMaker Pro

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

• Create Redis 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 pipe Harvest to CSV in PowerShell

  Use standard PowerShell cmdlets to access Harvest tables.

• How to Connect the Power BI Service to AlloyDB: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Stream Sugar CRM into Apache Kafka Topics

  Access and stream Sugar CRM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Enable the Azure Synapse JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Azure Synapse.

• Automated Continuous Amazon DynamoDB Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to SingleStore.

• Query SharePoint Excel Services in DataGrip

  Create a Data Source for SharePoint Excel Services in DataGrip and use SQL to query live SharePoint Excel Services.

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

  Connect to Databricks in MicroStrategy Desktop using the CData Software JDBC Driver for Databricks.

• Integrate with Live Snapchat Ads in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Snapchat Ads from the MuleSoft Anypoint Platform to integrate live Snapchat Ads into custom reports and dashboards.

• Automated Continuous Impala Replication to Amazon S3

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

• Work with Tally in FoxPro

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

• Use the CData SSIS Components to Insert New or Update Existing Bitbucket Records from SQL Server

  Easily push SQL Server data to Bitbucket using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Bitbucket or update existing records with data from a SQL Server database.

• Use the CData SSIS Components to Insert New or Update Existing Azure Table Records from SQL Server

  Easily push SQL Server data to Azure Table using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Azure Table or update existing records with data from a SQL Server database.

• Connect to Raisers Edge NXT as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Raisers Edge NXT.

• Connect to Azure Table 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 Azure Table Storage.

• Integrate Live WordPress into Blue Prism for Intelligent Robotic Process Automation (RPA)

• «
• 369
• 370
• 371
• 372
• 373
• 374
• 375
• 376
• 377
• 378
• »