Introduction The web is a vast source of information, but it is not always easy to access and use for natural language applications. In this blog post, we will show you how to crawl and scrape the target URL, extract and clean the content, and store it in Azure Blob Storage. We will use Python […]
Posts Tagged ‘Data Extraction’
Using Physical SQL (PVOs) to Extract ERP Cloud Data from OTBI
Physical SQLs are essentially the same as Logical SQLs. Behind the scenes, Logical SQLs are converted back to physical SQLs by BI server using the OTBI Fusion public view objects (PVOs) defined in the RPD physical layer. Physical SQLs leverage the same Data Sync built-in Oracle BI Connector used by logical SQLs for extracting ERP Cloud data from OTBI. The process […]
Using Logical SQL to Extract ERP Cloud Data from OTBI
This approach is officially recommended by Oracle. Data Sync comes with a built-in Oracle BI Content connector, which can be used to extract ERP Cloud data from OTBI. The connector supports three data extraction modes. SQL – used to extract data from logical SQL queries Report – used to extract data from BI analyses reports Subject Area.Table – used for extracting […]