Business Integration Technology has just released SQL ICE, the Internet Computing Environment for SQL Experts. Although SQL ICE can do a lot of things that may not be of interest to this group, SQL ICE makes it extremely easy to expose data in relational databases as a Web service for integration purposes. All you need to do is add a Connection to the target database and write a query in SQL. The data is exposed as an XML document accessed by a REST Web service. For example, a simple query like:
Select * from Person where name like :name || '%'; is accessed from a URL like: http://demo.sqlice.com/sqlice/app/query/GetPerson/output/XML?name=Domke (note: this URL actually works. This query is live and runs on our demo Web site. The (non-privileged) user login is username:notadmin, password Notadmin1) It returns an XML doc like: <?xml version="1.0" encoding="UTF-8" ?> - <query name="GET PERSON" resultSize="5"> - <row number="1"> <column name="FIRST_NAME" value="Fred M." type="String" /> <column name="ID" value="1" type="Integer" /> <column name="LAST_NAME" value="Domke" type="String" /> <column name="LAST_UPDATED" value="2010-12-20 14:05:49.73" type="Timestamp" /> <column name="PHONE" value="3142269368" type="String" /> </row> - <row number="2"> <column name="FIRST_NAME" value="Justin" type="String" /> <column name="ID" value="7" type="Integer" /> <column name="LAST_NAME" value="Domke" type="String" /> <column name="LAST_UPDATED" value="2010-12-23 10:40:55.412" type="Timestamp" /> <column name="PHONE" type="String" /> </row> ... </row> </query> Hook up your favorite EDI translator or BIT's EME, and you can get data from enterprise databases very easily. SQL ICE is available at http://SQLICE.com. There is no charge and no restrictions on usage. A very simple name/email registration is required. ------------------------------------ ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix.Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
