Do Virtual Tables support ST_POINT or ST_GEOMETRY

[ozmike]

Hi 

I have a Virtual Tables connection from one hana data base to another. I am getting the error ST_POINT or ST_GEOMETRY is not supported when I use the the create virtual table statement. Are these types supported in Virtual Tables ? If not what is the work around . I am trying to migrate some data form one hana database to another using virtual tables. 

Thanks

[ozmike]

There are a number of functions which might be of use.

select ll.ST_AsText() as back2text , ll, toText from (
select ST_GeomFromText( totext ) as ll , toText from (
SELECT NEW ST_Point( 1.0, 2.0 ).ST_AsText() as toText FROM dummy));

Not sure of whether accuracy is maintained during the conversion.

So in the source system maybe set up a view (or table ) of the transformed data to text and then connect a VT to this view and then convert back to GEO.

I'll give it a go - answering my own question yet again.