Have can I query other websites and display the results on mine?

I would like to know have I can query other websites and display the results on another site.  For example price comparision sites compare prices from various sources, how do then do that?  Do they need permission and access from the company to access the data?

The project I would like to do is query my supplier sites for up to date prices then display them on my site.
LVL 9
djpazzaAsked:
Who is Participating?
 
cmhuntyCommented:
Another option is to take a feed from your suppliers. You can upload to your database on a regular basis and query that yourself.

Obviuosly this wouldn't supply "live" data as a webservice at the supplier could.
0
 
answer_meCommented:
Web Service is one option. But this has to be done at supplier sites.
0
 
djpazzaAuthor Commented:
When you say 'web service' is this like an API ?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
cmhuntyCommented:
Yep
0
 
answer_meCommented:
Web service is similar to a library exposed through the web server. For making a web service call certain standards need to be followed as per web service documentation...
0
 
GawaiCommented:
you can also access supplier database from you site. ofcourse you need their permission ie, username,password, ip. I dont think they will deny to provide you (as a query user)
0
 
djpazzaAuthor Commented:
ok say they do how would i connect ?  Can you have a connection string with a remote database in it ?
0
 
cmhuntyCommented:
Yep, that's all you would need.

Security their side would need to be sorted but I guess that wouldn't be your concern. Their firewall would need to allow access to the port you'd connect over. The user that you use on their server would have to be allowed remote access and I believe the server itself would require remote access set up.

If you can connect over VPN, you could probably connect as if you were on the network. They may find setting you up with a VPN connection being less hassle!
0
 
cmhuntyCommented:
I guess all of the above would depend on the relationship that you have with them.
0
 
GawaiCommented:
once they allow you to access their database. you can connect to db

' connecting asp with mysql
Dim username, userpwd, userdb, sqlhost
username = "username_here"
userpwd ="password_here"
userdb="database_name_here"
sqlhost = "mysql_or_mssql_or_ip_address_here"

                                Set objCon = Server.CreateObject ("ADODB.Connection")
                                strDbCon = "Driver={MySQL ODBC 3.51 Driver};Server=" & sqlhost & ";uid=" & username & ";pwd=" & userpwd & ";database=" & userdb & ";"
                                objCon.Open(strDbCon)
                                Set objRs = Server.CreateObject ("ADODB.Recordset")


So next step will be easy

0
 
swinslowCommented:
If your supplier has an HTMl page or an XML page or RSS page with the content you want, you can use and XMLHttp request to import the data you want. Then parse the information to gether the data you need. You would not need permissions to access that as long as the data is accessible bu URL.

0
 
Computer101Commented:
Forced accept.

Computer101
Community Support Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.