CData Software - Knowledge Base

Recent Articles

• «
• 87
• 88
• 89
• 90
• 91
• 92
• 93
• 94
• 95
• 96
• »

• A PostgreSQL Interface for IBM Informix

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

• Replicate MariaDB from PowerShell

  Write a quick PowerShell script to query MariaDB. Use connectivity to the live data to replicate MariaDB to SQL Server.

• Build a Simple VCL Application for Sugar CRM

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

• Analyze SharePoint Excel Services with Power Pivot

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

• Access Live Instagram in AWS Lambda (with IntelliJ IDEA)

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

• Configure the CData JDBC Driver for Gmail in a Connection Pool in Tomcat

  Connect to Gmail from a connection pool in Tomcat.

• Connect to Databricks from PowerBuilder

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

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

  Connect to NetSuite CRM & ERP in MicroStrategy Desktop using the CData Software JDBC Driver for NetSuite.

• Automated Continuous WordPress Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable WordPress replication to Azure SQL.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Build an OLAP Cube in SSAS from Procore

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

• Prepare, Blend, and Analyze Freshdesk in Alteryx Designer

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

• Process & Analyze Veeva in Databricks (AWS)

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

• Connect to and Query Confluence in QlikView over ODBC

  Create data visualizations with Atlassian Confluence in QlikView.

• Import Amazon Athena into FileMaker Pro

  Create reports that integrate Amazon Athena in Filemaker Pro.

• Perform Batch Operations with Act CRM in Apache NiFi

  Connect to Act CRM and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• How to Create Power BI Visual Reports with Real-Time Excel Online

  Use CData Power BI Connectors to visualize Microsoft Excel Online in Power BI.

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

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

• Feed QuickBooks Online into FineReport

  How to set QuickBooks Online as a JDBC data source in FineReport.

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

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

• Create Todoist-Connected Business Apps in AppSheet

  Use CData Software Connect Server to connect to Todoist from AppSheet and build custom business apps using live Todoist.

• Access Live Paylocity in Excel (Desktop)

  Use CData Connect Cloud to gain access to live Paylocity from your Excel spreadsheets.

• Build Dashboards with SAP Ariba Procurement in DBxtra

  Create dynamic dashboards and perform analytics based on SAP Ariba Procurement in DBxtra.

• How to Import MariaDB into SQL Server using SSIS

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

• Automate REST Integration Tasks from PowerShell

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

• Automated Continuous Pinterest Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Pinterest replication to Azure SQL.

• Publish HarperDB-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live HarperDB.

• Create Jira Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for Atlassian Jira to build custom dashboards in Bold BI.

• Automated Continuous Klaviyo Replication to Amazon Redshift

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

• How to publish and share Amazon S3 dashboards with Tableau Server

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

• Build AI/ML Models with Live SAP SuccessFactors Data using Dataiku

• «
• 87
• 88
• 89
• 90
• 91
• 92
• 93
• 94
• 95
• 96
• »