Hello all.

It's been a while since I've worked in Lasso, but I am stuck finding a solution=85 and think that Lasso might have an answer. I posted what I have below to a FM forum=85 but I'm not clear I'm going to get an answer that will help me.

Basically, I'm working on a University campus running FM Server 11 and they need to integrate Oracle's 3.8 million records (several hundred new ones added nightly) into the solution. Can lasso be leveraged from within a client copy of FileMaker to perform a query on a Oracle table (select and insert) so that the client copy will see the result of the query within FM if FM Server has an ESS occurrence of the table that had the insert performed on it? I know FM can call a Lasso page to do this within a web browser window, but didn't want to wait for the window to load=85 afraid it won't be responsive enough.

What I posted in the FM forum:


We need to make 3.8 Million records from an Oracle DB available to FileMaker. We tried with ESS... way too slow. Importing that many records into FM as a text file import is also too time consuming. So I thought that perhaps if I issue a SQL query to the Oracle DB from FM Server to do a select and insert into a oracle holding table then FM client could have the holding table via ESS and see the results of the SQL query.

So, anyone know of a clean and reliable way to get FM client to trigger a SQL command from FM server to my external database? Our server is FM Server 11 (not advanced)

Our individual client machines cannot have plugins installed=85 only the server.

Any ideas of how to make this work?

Any better ideas on how to integrate 3.8 million records with FM 11?

--Rick


#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso
Lasso@lists.lassosoft.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>