0

I have a large dataset, say 1,000,000,000 rows, that lives on a server. I need a user to be able to consume (i.e. "run queries upon") that data seamlessly, over the web, from within Access and/or Excel. Additionally, I need to filter the data on the server-side according to the user connected to it.

My current approach is to create a webservice that looks like an ODBC data source and connect to it from Excel.

Questions:

  1. Is this the best way?
  2. If so, what's the best way to create a custom ODBC data source?
Mike
  • 7,500
  • 8
  • 44
  • 62
  • In what format is the data set stored (I assume we're talking about a file, not a database, right)? Also, what type of server? – John M Gant Apr 28 '09 at 17:21
  • My actual dataset is in a sql server, but I need to filter it according to the user that's connected to it (and other properties), so I can't allow the client direct access to the database in this case. – Mike Apr 29 '09 at 03:59

1 Answers1

1

  1. I really thing that it is not the best way. I don't know your scenario, but I really would prefer another approach.

  2. There is a discussion about that: Creating a custom ODBC driver One of the suggestions was using BI approach.

Community
  • 1
  • 1
razenha
  • 7,660
  • 6
  • 37
  • 53