Remote Connection to internal servers!

[#1]

Hi,

If I have one server located in San Francisco having puchase data, another in New York having Sales data.

1. How would I make a connection in QlikView the way we do with Excel, MS Access or any other data source. As in this case I have to mention the ip address of the servers I want to connect remotely. What option do I have to select while making a connetion? ODBC, OLE DB etc....

Look forward for your response!

Thanks

Mandy

[#2 · Accepted solution]

Hi Mandy,

You can use either of the two. You need first to create a Data Source pointed to each of your servers.

1. Go to Control Panel > Administrative tools > data sources. then go to System DSN tab. Click Add then choose SQL server for example. Then just specify the IP address at the server address field.

just explore or experiment from the field boxes....

2. Make use of the created Data source in qlikview using either ODBC or OLE DB connection.

Good Luck!

[#3]

Thanks Bernardine...this works! Appreciate your reply.

Mandy