CODEWITHSUNDEEP
azuregoogle-cloud-platformazure-data-factory
user3328887
user3328887

Reputation: 11

Azure DataFactory in GCP

I have a scenario where I need to synchronize multiple "on premise" Microsoft SQL server databases from business datacenters to cloud storage (let's call it blob storage).

In the past, I've used the Azure Data Factory on-premise client to bypass firewall considerations, not require a VPN, and delivery data directly to Azure Blob storage.

I need to do the same thing using Google tools (destination Google Cloud Storage). Is there an equivalent GCP tool that does not require a VPN? If not, any lowish-priced tool recommendations?

Upvotes: 0

Views: 1563

Answers (1)

guillaume blaquiere
guillaume blaquiere

Reputation: 75810

To send file from on prem to Google Cloud Storage (GCS) your need 2 things

Then, follow these steps

  • Authenticate your service account in gcloud sdk gcloud auth activate-service-account <Service Account email> --key-file=<Service Account File>
  • Extract your data locally
  • Use gsutil to send the file to the cloud

The connexion is authenticated and don't required VPN.

Upvotes: 1

Related Questions