Warm tip: This article is reproduced from stackoverflow.com, please click
google-cloud-data-fusion google-cloud-platform jdbc

How to configure JDBC for Cloud Fusion to connect MySQL installed on localhost:3306

发布于 2020-05-05 11:09:58

I'm trying to connect my local standalone MySQL with Cloud Fusion to create and test a data pipeline. I have deployed the driver successfully. Also, I have configured the pipeline properties with correct values of jdbc string, user name and password but connectivity isn't getting established.

Connection String: jdbc:mysql://localhost:3306/test_database

I have also tried to test the connectivity via data wrangling option but that is also not getting succeeded.

Do I need to bring both the environments under same network by setting up some VPC and tunneling?

Questioner
Balajee Venkatesh
Viewed
32
mk_sta 2020-02-20 17:20

I think that your question is more related to the way how to connect some on-premise environments to GCP networking system that gathering Google cloud instances or resources throughout VPC connection model.

Admitting the fact that GCP is actually leveraging different approaches for connection methods within a Hybrid cloud concepts, I would encourage you to learn some fundamental principles of Cloud VPN as a essential part of performing secure connection between particular VPN Peer Gateway and Cloud VPN Gateway and further creating a VPN tunnel between parties.

I guess there is even dedicated chapter in GCP documentation about Data Fusion VPC peering implementation that might be helpful in your user case.