How to access a remote database via the Internet?-CodePudding

How original concept through the public network access to remote data?

CodePudding user response:

For example: install VPN devices

CodePudding user response:

To access the web service

CodePudding user response:

The

refer to the original poster weihai987789 response:

original concept how to through the public network access to remote data?

1. Can the database ports open to the Internet, can realize public access to the database, but the risk is higher

2. Webservice is used to realize, in the deployment of web services, by IIS, one of our project is so to achieve

3. The Rest service based on Http, PB used to send and receive Http service (posturl or XMLHTTP), that's what our current several projects implementation, security is higher, Rest services can be deployed in Tomcat, Jboss, anyone or weblogic, websphere application server such as

We can discuss, QQ number through text messages sent to you within the station

CodePudding user response:

Can pass port mapping, this is a network problem, not a software problem

CodePudding user response:

Look at your server is in the public or in a subnet, if on the public not to mention, direct access, if there are two ways in the subnet, 1: the VPN, 2: the router port mapping, I also use VCN is a third party before the virtual network adapter software will all the virtual into a local area network (LAN) access to the end, operators,
The hope can help you,

CodePudding user response:

The moderator and the third way, the efficiency? If you want to query larger amount of data, whether can quickly reach the dw displayed?

The

reference 3 floor lzp_lrp response:

Quote: refer to the original poster weihai987789 response:

How original concept through the public network access to remote data?

1. Can the database ports open to the Internet, can realize public access to the database, but the risk is higher

2. Webservice is used to realize, in the deployment of web services, by IIS, one of our project is so to achieve

3. The Rest service based on Http, PB used to send and receive Http service (posturl or XMLHTTP), that's what our current several projects implementation, security is higher, Rest services can be deployed in Tomcat, Jboss, anyone or weblogic, websphere application server such as

We can discuss, QQ number via text messages within the station to you

CodePudding user response:

refer to 6th floor Beijing big balls reply:

moderators and the third way, the efficiency? If you want to query larger amount of data, whether can quickly reach the dw displayed?

Quote: refer to the third floor lzp_lrp response:

The
Quote: refer to the original poster weihai987789 response:

How original concept through the public network access to remote data?

1. Can the database ports open to the Internet, can realize public access to the database, but the risk is higher

2. Webservice is used to realize, in the deployment of web services, by IIS, one of our project is so to achieve

3. The Rest service based on Http, PB used to send and receive Http service (posturl or XMLHTTP), that's what our current several projects implementation, security is higher, Rest services can be deployed in Tomcat, Jboss, anyone or weblogic, websphere application server such as

We can discuss, QQ number via text messages within the station to you

I am using the import, the efficiency can also

CodePudding user response:

refer to 7th floor lzp_lrp response:

Quote: refer to the sixth floor of Beijing big balls reply:
moderators and the third way, the efficiency? If you want to query larger amount of data, whether can quickly reach the dw displayed?

Quote: refer to the third floor lzp_lrp response:

The
Quote: refer to the original poster weihai987789 response:

How original concept through the public network access to remote data?

1. Can the database ports open to the Internet, can realize public access to the database, but the risk is higher

2. Webservice is used to realize, in the deployment of web services, by IIS, one of our project is so to achieve

3. The Rest service based on Http, PB used to send and receive Http service (posturl or XMLHTTP), that's what our current several projects implementation, security is higher, Rest services can be deployed in Tomcat, Jboss, anyone or weblogic, websphere application server such as

We can discuss, QQ number via text messages within the station to you

I am using the import, the efficiency can also

Do you have any case can refer to?
I personally feel that use HTTP + json interact with no problem, but if it is a query, I am afraid of efficiency, don't know if the moderators have good optimization

CodePudding user response:

If use PB, can directly use OLE DB link, the server IP address, login user name, and password to connect,

CodePudding user response:

OLE DB link, in the nearly 10 m VPN environment, I measured efficiency is not ideal, the card stops from time to time,

CodePudding user response:

references 9 f fm20027 response:

, if use PB can use OLE DB directly link to the server IP address, login user name and password to connect,

Hello, if is the mysql database, how ole db configuration? There are examples?