CData Software - Knowledge Base

Recent Articles

• «
• 206
• 207
• 208
• 209
• 210
• 211
• 212
• 213
• 214
• 215
• »

• Create a Data Access Object for Google Ad Manager using JDBI

  A brief overview of creating a SQL Object API for Google Ad Manager in JDBI.

• DataBind Charts to Azure Analysis Services

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Azure Analysis Services from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Connect to OneNote through External Services in Salesforce

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

• Use Dash to Build to Web Apps on Salesforce Pardot

  Create Python applications that use pandas and Dash to build Salesforce Pardot-connected web apps.

• How to Access HDFS Using Entity Framework

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

• Connect to Google Ad Manager as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Ad Manager.

• Create Reports with FHIR in SAP Crystal Reports

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

• Create Reports from Zoho Creator in Looker Studio

  Use CData Connect Cloud to gain access to live Zoho Creator and create custom reports in Looker Studio.

• How to Work with SAS Data Sets in ETL Validator JDBC

  Connect to SAS Data Sets from ETL Validator jobs using the CData Software JDBC Driver.

• Bridge Stripe Connectivity with Apache NiFi

  Access and process Stripe in Apache NiFi using the CData JDBC Driver.

• Operational Reporting on ClickUp from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote ClickUp.

• How to connect Amazon QuickSight to Sage Intacct

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

• Amazon DynamoDB Reporting in OBIEE with the Amazon DynamoDB JDBC Driver

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

• Analyze Microsoft Exchange with Power Pivot

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

• Connect to Google Directory in Google Apps Script

  Use the ODBC Driver for Google Directory and the SQL Gateway to access Google Directory from Google Apps Script.

• Build Semantic Layer Views for Google Contacts in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Google Contacts.

• Connect to Microsoft Planner in JRuby

  Create a simple JRuby app with access to live Microsoft Planner.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Integrate SAP in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP ERP/NetWeaver from Informatica Cloud.

• Connect to Trello from PowerBuilder

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

• Publish Reports with HBase in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Apache HBase.

• Connect to LDAP Objects in as an External Source in Dremio

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

• Use the CData Software JDBC Driver for SharePoint Excel Services in MicroStrategy Web

  Connect to SharePoint Excel Services in MicroStrategy Web using the CData Software JDBC Driver for SharePoint Excel Services.

• Access Live Workday in Coginiti Pro

  Connect to and query live Workday from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Oracle Service Cloud Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Oracle Service Cloud through CData Connect Cloud using different applications and tools.

• Manage Shippo in DBArtisan as a JDBC Source

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

• Bidirectional Access to Certinia from FileMaker Pro

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

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

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

• Visualize Hive in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Apache Hive into TIBCO Spotfire.

• How to create an RPA flow for Cosmos DB in UiPath Studio

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

• Connect to AlloyDB in RapidMiner

  Integrate Google AlloyDB with standard components and data source configuration wizards in RapidMiner Studio.

• DataBind Wijmo Grid to Databricks

  Provide real-time Databricks to interactive controls.

• Connect to and Visualize Live QuickBooks Online in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live QuickBooks Online.

• Visualize Live eBay Analytics of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live eBay Analytics using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Create SSAS Tabular Models from HarperDB

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

• Query Excel Online in ColdFusion

  Write standard ColdFusion data access code to connect to Microsoft Excel Online.

• Visualize Cosmos DB in Tableau

  The CData ODBC driver for Cosmos DB enables you integrate Azure Cosmos DB into Tableau dashboards.

• Automated Continuous Sybase Replication to IBM DB2

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

• DataBind Wijmo Grid to Dynamics CRM

  Provide real-time Microsoft Dynamics CRM to interactive controls.

• DataBind Controls to Elasticsearch in C++Builder

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

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

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

• Bidirectional Access to AlloyDB from FileMaker Pro

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

• How to Access Live Dynamics 365 in Power Automate Desktop via ODBC

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

• Edit and Search External GraphQL Objects in Salesforce Connect

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

• Add Presto to Informatica Enterprise Data Catalog

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

• How to update Jira Assets from Excel

  This article explains how to transfer data from Excel to Jira Assets using the Excel Add-In for Jira Assets.

• How to pipe Todoist to CSV in PowerShell

  Use standard PowerShell cmdlets to access Todoist tables.

• Automate Microsoft Project Integration Tasks from PowerShell

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

• Access Oracle Eloqua in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Oracle Eloqua.

• Create Reports with Twitter Ads in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Twitter Ads.

• Import and Visualize Drift in Power View

  Create data visualizations based on Drift in Excel.

• Query Twitter Ads in MySQL Workbench

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

• Access Procore from MySQL in PHP

  Connect to Procore through the standard MySQL libraries in PHP.

• How to Build Dynamic React Apps with OneNote

  Use the CData Connect and React to Build Dynamic Web Apps with Live OneNote .

• How to Connect the Power BI Service to Google Calendar: Complete Guide

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

• Work with PayPal in FoxPro

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

• How to Query Printify in MySQL Workbench

  Execute MySQL queries against live Printify from MySQL Workbench.

• Connect to Oracle in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Build MVC Applications with Connectivity to MarkLogic

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access MarkLogic from an ASP.NET MVC application.

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

  Create an ODBC connection to Zoho Projects in Informatica and browse and transfer Zoho Projects.

• How to Connect to & Open Impala in Microsoft Excel

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

• Automated Continuous SAP Netweaver Gateway Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to PostgreSQL.

• Create Data Visualizations Based On Oracle Service Cloud in Mode

  Use CData Connect Cloud to connect to Oracle Service Cloud from Mode and build visualizations using live

• Automated Continuous Amazon Marketplace Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to SQL Server.

• Connect to Acumatica from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Acumatica ERP from Crystal Reports.

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

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

• Automated Shippo Replication to Teradata

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

• SQL Gateway: Superior SQL Linked Server Integration through SQL TDS

  Using a TDS remoting service is superior to the OLE DB Provider when working with ODBC data in SQL Server.

• Author and Share Power BI Reports on Real-Time SAP BusinessObjects BI

  Use the CData ODBC Driver for SAP BusinessObjects BI to visualize SAP BusinessObjects BI in Power BI Desktop and then upload to the Power BI service.

• Creating TaxJar-Connected Applications in Unqork

  You can use CData Connect to feed TaxJar to Unqork and build custom business apps.

• Connect to Oracle Service Cloud from AWS Glue

  Use CData Connect Cloud to gain access to live Oracle Service Cloud from your AWS Glue jobs.

• Prepare, Blend, and Analyze Redis in Alteryx Designer

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

• How to create Visio diagrams from Dynamics NAV

  Automatically update Microsoft Dynamics NAV with the changes you make to Visio master shapes.

• Connect to Dynamics 365 from Asprova with CData Software ODBC Driver for Dynamics 365

  This article shows how to connect faster to Dynamics 365 data from Asprova.

• Use the CData Software ODBC Driver for Bitbucket in MicroStrategy Desktop

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

• How to Build an ETL App for Azure Active Directory in Python with CData

  Create ETL applications and real-time data pipelines for Azure Active Directory in Python with petl.

• Access Amazon S3 from MySQL in PHP

  Connect to Amazon S3 through the standard MySQL libraries in PHP.

• Replicate Multiple Monday.com Accounts

  Replicate multiple Monday.com accounts to one or many databases.

• Automated Continuous Harvest Replication to SQLite

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

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

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

• Build Dashboards with REST in DBxtra

  Create dynamic dashboards and perform analytics based on REST in DBxtra.

• Connect to Power BI XMLA as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Power BI XMLA.

• Build a Simple VCL Application for Azure Analysis Services

  How to build a simple VCL Application to view Azure Analysis Services in RAD Studio using the CData ODBC Driver for Azure Analysis Services.

• Build a Simple VCL Application for Adobe Commerce

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

• Automated Continuous Adobe Commerce Replication to Databricks

  Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Databricks.

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

  Use CData Power BI Connectors to visualize Okta in Power BI.

• Create Reports with Microsoft OneDrive in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Microsoft OneDrive.

• Validate Microsoft OneDrive with QuerySurge

  Access and validate Microsoft OneDrive in QuerySurge using the CData JDBC Driver.

• Import and Visualize MySQL in Power View

  Create data visualizations based on MySQL in Excel.

• Create SSAS Tabular Models from MariaDB

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

• Connect to Cosmos DB in as an External Source in Dremio

  Use the CData JDBC Driver to connect to Cosmos DB as an External Source in Dremio.

• Connect to EventBrite from PowerBuilder

  This article demonstrates how to access Eventbrite from PowerBuilder using the EventBrite JDBC Driver.

• Connect to Azure Data Catalog in as an External Source in Dremio

  Use the CData JDBC Driver to connect to Azure Data Catalog as an External Source in Dremio.

• Automate Klipfolio Replication to Azure Data Lake

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

• Connect to Sage 200 in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Sage 200 in Airbyte.

• Replicate Multiple Excel Accounts

  Replicate multiple Excel accounts to one or many databases.

• Automated Continuous SAP Ariba Source Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Microsoft Access.

• Using the CData Software ODBC Driver for Todoist in PyCharm

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

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

  Use CData Power BI Connectors to visualize GraphQL in Power BI.

• How to Import Twitter into SQL Server using SSIS

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

• «
• 206
• 207
• 208
• 209
• 210
• 211
• 212
• 213
• 214
• 215
• »