Stephen Russell wrote: > How many tables and what volume of rows do you think that need to be > sent? What level of frequency, daily to monthly?
Usually monthly, but could be several times monthly. On-demand report is trigger to run this upload-to-corporate. > > You need a loader app for the retail sites, and a webpage makes the > most sense. They log in and that defines who they are. the web page > can pull the local vfp data? mmmm I wonder how I would do that? I > know that I can pull images so it is just a have to do it kind of > thing. Nope...requiring them to do anything beyond the normal pushing the "Generate Report" button (the same one they push today without upload-to-corporate) is unacceptable. > > Maybe it might be better if this were a Winform app that does have > good roots in getting local vfp data easier??? Hmmm...ya think? ;-) That's my original thought too. > > anyway the app will pick up the data and pass it to the WCF. The code > in the wcf knows what the Data miners what to do and just does it. No...the data miners will do their ad-hoc querying beyond me. To include anything for what they'll do with data-mining makes this project much larger and more complex. Judging by most of your responses, you must be a consultant and get paid by the hour. ;-) > I bet that will be real dicey, because rules are rules! could yo ust > insert into a loader SQL table and they write their own SSIS scripts > to put into the DW? That woudl be the best bet from my limited > knowledge so far. Again, no offense intended, but you've raised the complexity level to something way beyond simple. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
