StrataFrame and WebService?


Author
Message
Gerhard Jaros
Gerhard Jaros
StrataFrame Beginner (24 reputation)StrataFrame Beginner (24 reputation)StrataFrame Beginner (24 reputation)StrataFrame Beginner (24 reputation)StrataFrame Beginner (24 reputation)StrataFrame Beginner (24 reputation)StrataFrame Beginner (24 reputation)StrataFrame Beginner (24 reputation)StrataFrame Beginner (24 reputation)
Group: Forum Members
Posts: 18, Visits: 22
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...
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
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.

Attachments
Larry Caylor
Larry Caylor
StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)
Group: Awaiting Activation
Posts: 592, Visits: 3.7K

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

Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Is the new data EnterpriseserverDataItem class limited to establishing connections to the StrataFrame Enterprise Server or will it allow connections to other web services?

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. 

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search