JBossDeveloper

Daniel,

I took your KML file, and simplicity sake I only used the Dynamic VDB feature. So, here are my results

1) Step one I copied your KML file to a folder "/home/rareddy/testing", and ran the following CLI script to create resource-adaptor connection to access the file. You can also edit the standalone-teiid.xml file to do this. See "docs/teiid/datasources/file" for more info. The below I executed in the "jboss-cli.sh" console.

/subsystem=resource-adapters/resource-adapter=fileDS:add(archive=teiid-connector-file.rar, transaction-support=NoTransaction)
/subsystem=resource-adapters/resource-adapter=fileDS/connection-definitions=fileDS:add(jndi-name=java:/fileDS, class-name=org.teiid.resource.adapter.file.FileManagedConnectionFactory, enabled=true, use-java-context=true)
/subsystem=resource-adapters/resource-adapter=fileDS/connection-definitions=fileDS/config-properties=ParentDirectory:add(value=/home/rareddy/testing/)
/subsystem=resource-adapters/resource-adapter=fileDS/connection-definitions=fileDS/config-properties=AllowParentPaths:add(value=true)
/subsystem=resource-adapters/resource-adapter=fileDS:activate

2) Next I defined the following Dynamic  VDB. I called it as "kml-vdb.xml"

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<vdb name="kml" version="1">
    <model name="geodata">
         <source name="connector" translator-name="file" connection-jndi-name="java:/fileDS"/>
    </model>
    <model name="lines" visible = "true" type = "VIRTUAL">
       <metadata type="DDL"><![CDATA[
            CREATE VIEW coordinates (description varchar(50),  styleUrl varchar(50), coordinates varchar(256)) AS
            SELECT
                    description, styleUrl, coordinates
                FROM
                    (EXEC geodata.getTextFiles('linea_bus.xml')) AS f, XMLTABLE(XMLNAMESPACES(DEFAULT 'http://www.opengis.net/kml/2.2', 'http://www.w3.org/2005/Atom' AS atom, 'http://www.google.com/kml/ext/2.2' AS gx, 'http://www.opengis.net/kml/2.2' AS kml), '/kml/Document/Folder/Placemark' PASSING XMLPARSE(DOCUMENT file) COLUMNS description string PATH 'description/text()', styleUrl string PATH 'styleUrl/text()', coordinates string PATH 'LineString/coordinates/text()') AS A;
            ]]> </metadata>
    </model>
</vdb>

again using the above CLI console, I executed

deploy ~/testing/kml-vdb.xml

this does nothing but deploys the VDB. There are various ways to deploy a VDB, however this is very handy (to me atleast). Then I made sure the VDB is deployed in ACTIVE state.

3) Now using SquirreL, a JDBC client tool, I executed following statements and retrived results

SELECT description,styleUrl,coordinates FROM "lines"."coordinates";

Results:

SELECT x.* FROM "lines"."coordinates" as t, TEXTTABLE(t.coordinates COLUMNS first string, "second" string, third string, forth string, fifth string) x

Let me know if this satisfies your question about support of the KML with Teiid? I did find a bug with Designer, when I was trying to use it, I logged it here https://issues.jboss.org/browse/TEIIDDES-1606

Thanks. Please do share your end application results in blog with us.

Ramesh..

Daniel,

Even with above you would need a translator for unzip process. However I did not understand your extra VDBs comment, even with your translator, you still would need to define a VDB, albeit lot more simple one than above.

One question I have is that, is KML has any schema?

Ramesh..

Daniel,

Have you tried with the Designer, but using invokeHttp instead of gettextfiles?

In my case I had the file locally on the drive so I used file translator along with file-resource-adaptor, if your KML is served from a web-service,  then you can use invokeHttp which would do same functionality of getting the contents from remote service. No, I have not tried with Designer after I found the bug. However, the transformation can be manually altered to make it work in Designer. It is the wizard issue.

You're right about the additional VDB, was not thinking clear here. Have you tried with the Designer, but using invokeHttp instead of gettextfiles? Also I see you renamed the extension from .kml to .xml, any reason for that? That reminds me that the Designer's xml wizard cannot be used in this case for the simple reason that extension must be literally '.xml'. I think that it should be more flexible and offer also the option to select any extension.

Yes, that is correct. Initially I was trying to use Designer, and it would not let me select a .KML extension file, so I had renamed it. However, in my example shown above there is no such restriction. You should log enhancement request in Designer JIRA for this, as this is a valid case.

Thanks for the KML schema link.

Ramesh..