CData Software - Knowledge Base

Recent Articles

• «
• 615
• 616
• 617
• 618
• 619
• 620
• 621
• 622
• 623
• 624
• »

• Query Elasticsearch through ODBC in Node.js

  Use node-odbc to execute SQL queries against Elasticsearch from Node.js.

• How to Seamlessly Import Workday Data into IBM SPSS Modeler

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

• Automated Continuous Xero Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Xero replication to delimited files (CSV/TSV).

• Automated Continuous Splunk Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Splunk replication to Snowflake.

• Automated Continuous Trello Replication to Amazon S3

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

• Work with SAP Fieldglass in FoxPro

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

• How to Import Data from Epicor Kinetic into Google Sheets

  Import Epicor Kinetic into a Google spreadsheet that is automatically refreshed.

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

• Automate MySQL Replication to SAP HANA

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

• Integrate Zendesk in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zendesk from Informatica Cloud.

• Publish Crystal Reports on SAP HANA

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP HANA.

• Access ADP from MySQL in HeidiSQL

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

• Build a Singer.io Tap for SendGrid With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live SendGrid data using

• Automated Continuous Tally Replication to PostgreSQL

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

• Connect to Adobe Target in HULFT Integrate

  Connect to Adobe Target as a JDBC data source in HULFT Integrate

• DataBind Controls to Oracle HCM Cloud in Delphi

  DataBind to Oracle HCM Cloud in Delphi with standard data access components and controls.

• Visualize SAP Netweaver Gateway in Sisense

  Create an ElastiCube in Sisense app with access to SAP Netweaver Gateway.

• Connect to Amazon Athena in RazorSQL

  Connect to Amazon Athena from wizards and query Amazon Athena from the GUI in the RazorSQL database management tool.

• Use the CData Software ODBC Driver for FHIR in MicroStrategy

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

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

  Connect to MongoDB 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.

• Build a Singer.io Tap for WooCommerce With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live WooCommerce data using

• Easily Integrate Avalara AvaTax in Lazarus Pascal IDE

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

• Automated Continuous Microsoft OneLake Replication to Oracle

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

• Replicate CData Connect Cloud in Heroku for Use in Salesforce Connect

  Replicate CData Connect Cloud to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Connect to Zendesk as a Linked Server via SQL Gateway

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

• Consume SharePoint Excel Services OData Feeds in PowerBuilder

  This article demonstrates how to consume SharePoint Excel Services as OData feeds from PowerBuilder using the API Server.

• Create Microsoft Planner-Connected Business Apps in AppSheet

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

• Connect to SAP HANA in CloverDX (formerly CloverETL)

  Transfer SAP HANA using the visual workflow in the CloverDX data integration tool.

• Connect to Bullhorn CRM from HeidiSQL

  Use CData Connect Cloud to connect to and query live Bullhorn CRM from HeidiSQL.

• Connect to SAP Hybris C4C in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for SAP Hybris C4C and connect to SAP Hybris C4C in Akorbi Digital RunMyProcess.

• Analyze Airtable in R via JDBC

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

• Integrate Real-Time Access to Microsoft Project in SAPUI5 MVC Apps

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

• Create SSAS Tabular Models from Sage 50 UK

  How to build a SQL Server Analysis Service Tabular Model from Sage 50 UK using CData drivers.

• Visualize SAP BusinessObjects BI from Tableau

  Use the Tableau Desktop business intelligence tool to connect to SAP BusinessObjects BI.

• Create CockroachDB-Connected Dashboards in Grafana

  Connect to CockroachDB via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to CockroachDB.

• Connect to DocuSign in Ruby

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

• Query JotForm from Node.js

  Use the OData endpoint of the CData API Server to connect to your JotForm and perform CRUD operations on JotForm from Node.js.

• Using the CData Software ODBC Driver for Oracle in PyCharm

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

• How to Connect to & Open Dynamics 365 in Microsoft Excel

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

• Access Live Amazon S3 in AWS Lambda (with IntelliJ IDEA)

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

• Automate Shippo Integration Tasks from PowerShell

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

• How to connect to Dynamics NAV with Squirrel SQL client

  Connect to Microsoft Dynamics NAV and execute queries in the Squirrel SQL Client.

• Connect to DocuSign in NetBeans

  Connect to DocuSign in NetBeans with the data source configuration wizard.

• Use the CData SSIS Lookup Component to Insert New or Update Existing Salesforce Records from SQL Server

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

• Query SAP HANA XS Advanced using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume SAP HANA XS Advanced entities in PHP by modeling them as objects.

• Automated Continuous Vault CRM Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Vault CRM replication to Azure SQL Database.

• Write a Simple Go Application to work with Microsoft Planner on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Planner.

• Connect to Dynamics 365 in HULFT Integrate

  Connect to Dynamics 365 as a JDBC data source in HULFT Integrate

• Create a Data Access Object for Salesloft using JDBI

  A brief overview of creating a SQL Object API for Salesloft in JDBI.

• Process & Analyze Sugar CRM in Databricks (AWS)

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

• Model Amazon S3 Using Azure Analysis Services

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

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

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

• Connect to Wave Financial as an External Source in Dremio

  Use the CData JDBC Driver to connect to Wave Financial as an External Source in Dremio.

• Query MarkLogic through ODBC in Node.js

  Use node-odbc to execute SQL queries against MarkLogic from Node.js.

• Publish Avalara AvaTax-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Avalara AvaTax.

• How to Connect to & Open Workday in Microsoft Excel

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

• Access SQL Analysis Services from MySQL in PHP

  Connect to SQL Analysis Services through the standard MySQL libraries in PHP.

• Create ActiveCampaign-Connected Nintex Workflows

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

• Import Real-Time Jira Service Management via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Atlassian Jira Service Management in ColdFusion.

• How to Easily Query HubDB in OpenOffice Base

• «
• 615
• 616
• 617
• 618
• 619
• 620
• 621
• 622
• 623
• 624
• »