Once someone puts files in an object storage as an intermediary repository to interchange data, afterthat you have to move or copy those files to the final destination. There are several mechanisms to copy those files such as API’s or the Command Line Interface (CLI), but one very easy to use is by creating pre-authenticated-requests […]
MoreFollowing up the posts here and here, we are explaining today how to make same thing using Oracle OCI Object Storage. The procedure and steps are quite similar so, let’s go and try! Steps Create a bucket Upload file to bucket Create an Auth Token for your user as follows: In a sql editor, execute […]
MoreFollowing up the previous post, we are explaining today how to make same thing using Amazon S3. The procedure and steps are quite similar, let’s go and try! Amazon side setup Create a S3 bucket with no public access: Upload datafile: Grab the object URL for later: Create a user in IAM: Grant access to […]
MoreOracle autonomous database (ADW/ATP) offers several approaches for storing the data: data online stored in the database internal storage data nearline as external tables in object storage data offline in object storage The autonomous database supports object storage provided by Oracle OCI, Amazon S3 and Azure, with them you can create external tables, external partitioned […]
MoreIn this post we are setting up a tunnel between OCI and AWS following the steps explained here and similar to what we did here. Step 1 Follow this post to set up a VPN headend in OCI. Step 2 Create a VPC in AWS with one public and one private subnet. Step 3 Create […]
MoreIn previous post we explained the mechanisms to extract data from ERP and put in an Object Storage repository that can be accessed privately from other places in a secure manner. To demonstrate the use case we are creating a VPN tunnel between Google Cloud and OCI as explained here. Google Side Once we have […]
MoreIn this episode we are crating a tunnel between OCI and Google Cloud using the solution posted here Step 1 Follow this post for the OCI side and grab the value of the public IP endpoint and network encryption domain configured. Step 2 Create a vpn tunnel in google cloud, put the values of public […]
MoreShall you need to tune the bits of a VPN connection because the complexities of the left, right or both sides of the tunnel, one cheap option is to build a software solution. In this particular case we are utilising Libreswan. Terraform The current construct has been done with terraform, which provides automation and reduces […]
MoreBI Cloud Extract is a standard tool for extracting data from SaaS (ERP, …) either incremental or fully approaches. Data is exported to Object Storage as zipped files. Files stored in object storage are encrypted by a key provided by OCI Object Storage administrator role o keys managed by Oracle. Additionally Oracle encrypts data at […]
More
approaching off the bow 