CData Software - Knowledge Base

Recent Articles

• «
• 282
• 283
• 284
• 285
• 286
• 287
• 288
• 289
• 290
• 291
• »

• Using AngularJS to Build Dynamic Web Pages with RSS Feeds

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

• Viewing Act-On in RAD Studio Data Explorer

  How to view Act-On in RAD Studio Data Explorer using the CData ODBC Driver for Act-On.

• Use the Connect Server to Access Kafka in Microsoft Power Pivot

  Use the Connect Server to connect to live Apache Kafka in the Power Pivot business intelligence tool.

• How to connect to Exact Online from MS Excel on Mac OS X

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

• A PostgreSQL Interface for Azure Table using the CData ODBC Driver

  Use the SQL Gateway and Azure Table ODBC Driver to create a PostgreSQL entry-point for data access.

• Use the CData Software ODBC Driver for Jira in MicroStrategy

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

• Connect to Cosmos DB in JRuby

  Create a simple JRuby app with access to live Azure Cosmos DB.

• Automate Pinterest Replication to Azure Data Lake

  Use CData Sync to customize and automate Pinterest replication to Azure Data Lake.

• View Reports on Real-Time SFTP in Power BI Report Server

  Use the CData ODBC Driver for SFTP to visualize SFTP in Power BI Desktop and then publish them to Power BI Report Server.

• Replicate Google Campaign Manager 360 for Use in Salesforce Connect

  Replicate Google Campaign Manager 360 to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Process & Analyze Excel in Databricks (AWS)

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

• Access Live Monday.com in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Monday.com from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

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

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

• Connect to Microsoft Project in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Microsoft Project in Google Apps Script.

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

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

• Natively Connect to Azure Analysis Services in PHP

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

• Use Dash to Build to Web Apps on Monday.com

  Create Python applications that use pandas and Dash to build Monday.com-connected web apps.

• Build Veeva Vault-Connected Apps in Mendix

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

• Work with Klaviyo in FoxPro

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

• Connect to Unbounce in HULFT Integrate

  Connect to Unbounce as a JDBC data source in HULFT Integrate

• Connect to Google Campaign Manager 360 in HULFT Integrate

  Connect to Google Campaign Manager 360 as a JDBC data source in HULFT Integrate

• PowerShell Scripting to Replicate Avalara AvaTax to MySQL

  Write a simple PowerShell script to replicate Avalara AvaTax to a MySQL database.

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

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

• Integrate with live Freshdesk in Jitterbit

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

• Query Facebook Ads in MySQL Workbench

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

• Power BI Connector Getting Started Guide

  A basic guide to connecting Power BI to data from anywhere using the CData Power BI Connector.

• Automated Continuous CouchDB Replication to Snowflake

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

• Validate MarkLogic with QuerySurge

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

• Working with NetSuite in LINQPad

  Execute LINQ queries to NetSuite CRM & ERP in LINQPad.

• Import Coinbase into FileMaker Pro

  Create reports that integrate Coinbase in Filemaker Pro.

• Perform Batch Operations with Dynamics NAV in Apache NiFi

  Connect to Microsoft Dynamics NAV and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Build Semantic Layer Views for SAP Concur in APOS Live Data Gateway

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

• Connect to Salesforce Data Cloud from Asprova with CData Software ODBC Driver for Salesforce Data Cloud

  This article shows how to connect faster to Salesforce Data Cloud data from Asprova.

• Automated Continuous Dynamics NAV Replication to MySQL

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

• Build an OLAP Cube in SSAS from Oracle Sales

  Establish a connection to Oracle Sales data from SQL Server Analysis Services, and use the Oracle Sales Data Provider to build OLAP cubes for use in analytics and reporting.

• How to use SQLAlchemy ORM to access Greenplum in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Pivotal GreenPlum.

• Build an OLAP Cube in SSAS from QuickBooks

  Establish a connection to QuickBooks Desktop data from SQL Server Analysis Services, and use the QuickBooks Data Provider to build OLAP cubes for use in analytics and reporting.

• Automate Azure Data Lake Storage Replication to SAP HANA

  Use CData Sync to customize and automate Azure Data Lake Storage replication to SAP HANA.

• Automated Continuous SAP HANA Replication to SingleStore

  Use CData Sync for automated, continuous, customizable SAP HANA replication to SingleStore.

• Stream Gmail into Apache Kafka Topics

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

• Import Marketo into FileMaker Pro

  Create reports that integrate Marketo in Filemaker Pro.

• Import Google Campaign Manager 360 Using Azure Data Factory

  Use CData Connect Cloud to connect to Google Campaign Manager 360 from Azure Data Factory and import live Google Campaign Manager 360.

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

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

• DataBind Oracle Eloqua to the DevExpress Data Grid

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

• Automated Continuous Highrise Replication to Vertica

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

• Automate Sybase IQ Replication to Azure Data Lake

  Use CData Sync to customize and automate Sybase IQ replication to Azure Data Lake.

• Build Charts with HDFS in Clear Analytics

  Create dynamic charts and perform analytics based on Apache HDFS in Clear Analytics.

• Integrate PayPal in the Pentaho Report Designer

  Publish reports based on PayPal in the Pentaho BI tool.

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

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

• Automated Continuous Salesloft Replication to Amazon S3

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

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

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

• Build Azure Data Lake Storage-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for Azure Data Lake Storage and create custom apps in Bubble.

• Add Amazon Marketplace to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Amazon Marketplace with the Informatica Enterprise Data Catalog to classify and organize data.

• Create SFTP-Connected Nintex Workflows

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

• Import Adobe Analytics into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Adobe Analytics and provide access to live Adobe Analytics for custom reports in the Power BI Service.

• MySQL Reporting in OBIEE with the MySQL JDBC Driver

  Deploy the MySQL JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• How to integrate Databricks with Apache Airflow

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

• Automated Continuous Zoho Projects Replication to MySQL

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

• Stream SAP Ariba Procurement into Apache Kafka Topics

  Access and stream SAP Ariba Procurement in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Replicate GitHub to Multiple Databases

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

• Publish Reports with Reckon Accounts Hosted in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Reckon Accounts Hosted.

• LINQ to SAP HANA XS Advanced

  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 SAP HANA XS Advanced Data Provider.

• Work with HCL Domino in FoxPro

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

• Automated Typeform Replication to Teradata

  Use CData Sync to Customize and automate Typeform replication to Teradata.

• Connect to SharePoint from PowerBuilder via JDBC

  This article demonstrates how to access Microsoft SharePoint from PowerBuilder using the SharePoint JDBC Driver.

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

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

• Connect to LinkedIn Ads from PowerBuilder via JDBC

  This article demonstrates how to access LinkedIn Ads from PowerBuilder using the LinkedIn Ads JDBC Driver.

• How to Connect DBeaver to MYOB AccountRight via a JDBC Driver

  Manage MYOB AccountRight with visual tools in DBeaver like the query browser.

• Import Klipfolio into the Power BI Service for Visualizations

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

• Create Apps from Google Data Catalog in Qlik Sense Cloud

  Use the CData Connect Server to create an OData API for Google Data Catalog and build apps from live Google Data Catalog in Qlik Sense Cloud.

• Manage SAP ByDesign in DBArtisan as a JDBC Source

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

• Create Data Visualizations in Cognos BI with MYOB AccountRight

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

• Replicate SendGrid for Use in Salesforce Connect

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

• How to use SQLAlchemy ORM to access Avro in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Apache Avro.

• Access Live Airtable in TIBCO Data Virtualization

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

• How to Seamlessly Import SAP Business One Data into IBM SPSS Modeler

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

• Visualize QuickBooks from Tableau

  Use the Tableau Desktop business intelligence tool to connect to QuickBooks Desktop.

• Connect to SharePoint Excel Services in RazorSQL

  Connect to SharePoint Excel Services from wizards and query SharePoint Excel Services from the GUI in the RazorSQL database management tool.

• Visualize NetSuite in Tableau

  The CData ODBC driver for NetSuite enables you integrate NetSuite CRM & ERP into Tableau dashboards.

• Feed Email into FineReport

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

• Automated Continuous Salesloft Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Salesloft replication to IBM DB2.

• Integrate Google Contacts into Power Automate Desktop using CData Connect

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

• Create GitHub-Connected Nintex Workflows

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

• Excel Spreadsheet Automation on Klaviyo with the QUERY Formula

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

• Integrate with live Excel Online in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Microsoft Excel Online in Jitterbit.

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

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

• How to Query Live Trello Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Trello data in natural language using Python.

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

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

• Automated Continuous Splunk Replication to Amazon Redshift

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

• How to publish and share SAP Ariba Source dashboards with Tableau Server

  The CData ODBC driver for SAP Ariba Source enables you integrate SAP Ariba Source into Tableau dashboards.

• SAS xpt Reporting in OBIEE with the SAS xpt JDBC Driver

  Deploy the SAS xpt JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Bidirectional Access to MongoDB from FileMaker Pro

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

• How to Access Shopify Using Entity Framework

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

• Build AI/ML Models with Live Avalara AvaTax Data using Dataiku

• «
• 282
• 283
• 284
• 285
• 286
• 287
• 288
• 289
• 290
• 291
• »