CData Software - Knowledge Base

Recent Articles

• «
• 351
• 352
• 353
• 354
• 355
• 356
• 357
• 358
• 359
• 360
• »

• PowerShell Scripting to Replicate Workday to MySQL

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

• Use the CData Software ODBC Driver for Authorize.Net in MicroStrategy Desktop

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

• Create Dynamic Impala Grids Using the Infragistics XamDataGrid

  Learn how you can connect Impala to Infragistics XamDataGrid to build dynamic grids.

• Access Live SAP Business One in Google Sheets via Connect Cloud

  Use CData Connect Cloud to gain access to live SAP Business One from your Google Sheets.

• Import Real-Time Twilio via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Twilio in ColdFusion.

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

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

• How to Access Live Twitter Ads in Power Automate Desktop via ODBC

  The CData ODBC Driver for Twitter Ads enables you to integrate Twitter Ads into workflows built using Microsoft Power Automate Desktop.

• Connect to Microsoft Project in DBArtisan

  Use wizards in DBArtisan to configure Microsoft Project as a data source.

• How to Work with XML in ETL Validator JDBC

  Connect to XML from ETL Validator jobs using the CData Software JDBC Driver.

• Validate Blackbaud FE NXT with QuerySurge

  Access and validate Blackbaud FE NXT in QuerySurge using the CData JDBC Driver.

• Rapidly Develop Outreach.io-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 Query Live Dynamics 365 Business Central Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Dynamics 365 Business Central data in natural language using Python.

• Edit and Search External Unbounce Objects in Salesforce Connect

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

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

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

• Connect to DocuSign in CloverDX (formerly CloverETL)

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

• Access HubSpot from MySQL in Amazon QuickSight

  Connect to HubSpot and build visualizations of HubSpot using a MySQL Connection in Amazon QuickSight.

• Connect to Sugar CRM from HeidiSQL

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

• Use the CData ODBC Driver for Excel Online in Microsoft Power Query

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

• Connect to QuickBooks from a Connection Pool in Jetty

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

• Create a Data Access Object for Greenplum using JDBI

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

• Create SSAS Tabular Models from Kintone

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

• Build Automated Workflows with Live MongoDB in Workato

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

• Excel Spreadsheet Automation on LinkedIn with the QUERY Formula

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

• Build Neo4J-Connected ETL Processes in Google Data Fusion

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

• Using AngularJS to Build Dynamic Web Pages with Oracle HCM Cloud

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

• Integrate Live Bing Search Results into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Bing Search and integrate live Bing Search into apps built in Microsoft Power Apps.

• Create Reports with Monday.com in SAP Crystal Reports

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

• Connect to Facebook from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Facebook from Filemaker Pro on Mac.

• Validate PostgreSQL with QuerySurge

  Access and validate PostgreSQL in QuerySurge using the CData JDBC Driver.

• Use JayDeBeApi to access MongoDB in Python

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

• Analyze HarperDB with Power Pivot

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

• Extract, Transform, and Load Coinbase in Informatica PowerCenter

  Create a simple Workflow for Coinbase in Informatica PowerCenter.

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

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

• ETL Hive in Oracle Data Integrator

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

• Replicate ServiceNow to Multiple Databases

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

• Analyze Live Sugar CRM in SAS Viya

  Use CData Connect Cloud to connect to Sugar CRM from SAS Viya and deploy self-service analytics using live Sugar CRM.

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

• How to publish and share CSV dashboards with Tableau Server

  The CData ODBC driver for CSV enables you integrate CSV/TSV Files into Tableau dashboards.

• Use the CData Software JDBC Driver for Google Sheets in MicroStrategy

  Connect to Google Sheets in MicroStrategy Developer using the CData Software JDBC Driver for Google Sheets.

• Connect to BigCommerce in SpagoBI

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

• Create Data Visualizations Based On Outreach.io in Mode

  Use CData Connect Cloud to connect to Outreach.io from Mode and build visualizations using live

• Connect to SAP in NetBeans

  Connect to SAP ERP/NetWeaver in NetBeans with the data source configuration wizard.

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

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

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

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

• Connect and Visualize Live Jira Data in Databricks Lakehouse Federation with CData Connect Cloud

  Use CData Connect Cloud to integrate live Atlassian Jira into the Databricks platform and create visualization dashboards with real-time Atlassian Jira.

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

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

• Integrate Veeva Vault into Power Automate Desktop using CData Connect

  CData Connect for Veeva Vault enables you to integrate Veeva Vault & Vault CRM into workflows built using Microsoft Power Automate Desktop.

• DataBind Controls to Sage 200 in C++Builder

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

• How to connect Amazon QuickSight to Oracle HCM Cloud

  Create a connection to Oracle HCM Cloud in CData Connect Cloud and insert Oracle HCM Cloud into Amazon QuickSight SPICE to build interactive dashboards.

• How to publish and share IBM Informix dashboards with Tableau Server

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

• Build BCart Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live BCart and build visualizations in Tableau.

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

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

• How to create SendGrid federated tables in MySQL

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

• Query Zuora in MySQL Workbench

  Create a virtual MySQL database for Zuora in CData Software Connect (or Connect Server) and work with live Zuora in MySQL Workbench.

• How to connect to Microsoft Exchange from MS Excel on Mac OS X

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

• Integrate Azure DevOps into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Azure DevOps and integrate live Azure DevOps into your Power Automate tasks.

• Build AI/ML Models with Live Sage Intacct Data using Dataiku

• «
• 351
• 352
• 353
• 354
• 355
• 356
• 357
• 358
• 359
• 360
• »