StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » StrataFrame and WebService?

StrataFrame and WebService?

Gerhard Jaros — Fri, 01 Sep 2006 11:30:20 GMT

Hello,

it would be a nice feature if I could connect my StrataFrame WinApp to a WebService and use a foreign SQL server database. Can I do this and if yes, how can I do this? In my view it could be a part of the ConnectionManager.

...gerhard...

RE: StrataFrame and WebService?

Trent L. Taylor — Fri, 01 Sep 2006 11:30:20 GMT

[quote]Is the new data EnterpriseserverDataItem class limited to establishing connections to the StrataFrame Enterprise Server or will it allow connections to other web services?[/quote]

The EnterpriseServerDataSourceItem is exclusive to StrataFrame's Middle Tier Enterprise Server. There is a lot of logic specific to the Middle Tier Enterprise server just as there would be in SqlDataSourceItem or VFPDataSourceItem. In fact, there is actually more because there is logic for encryption and custom serialization to make things as fast as possible.

If you want to talk to a disparate web services not related to StrataFrame, you will want to create your own data source item. Basically you will inherit the DbDataSourceItem and start adding your functionality. Obviously this is a bit of a simple explanation. Here is the problem with us just creating a "one class does it all" data source to talk to a web service....every connection is different. It depends on how it has been exposed and developed as to what is required by the data acces layer.

RE: StrataFrame and WebService?

Larry Caylor — Fri, 01 Sep 2006 11:04:04 GMT

I’d like to expand on Gehard’s question and ask if there is a way or plans to provide a way to connect a StrataFrame WinApp to web services provided by others. This could be a mainframe app. Is the new data EnterpriseserverDataItem class limited to establishing connections to the StrataFrame Enterprise Server or will it allow connections to other web services?

-Larry

RE: StrataFrame and WebService?

Trent L. Taylor — Fri, 01 Sep 2006 08:52:17 GMT

This is what our Middle Tier Enterprise server ultimately does. It does much more than just expose SQL Server through a web service though. Attached is a white paper on the Middle Tier Enterprise Server. As for exposing SQL Server, you do not need a web service for this. You can just make your SQL Server accessible externally and then turn on encryption. Obviously this is not as optimized as the Middle Tier Server so it will not be as fast and it does not protect the SQL Server from the outside world.

There is a new data access class called EnterpriseServerDataItem which allows a connection to be established to the Middle Tier Enterprise server. Obviously none of this has been released as of yet. But connecting to the server is literally as easy as connecting to a SQL Server connection.