How to import data from views?

[benelot]

We are currently evaluating neo4j to export our RDBMS and then export the data into RDF through the RDF extension.

Using the desktop ETL tools I can easily import tables, which is also properly documented through the three mapping logics:

A table with a foreign key is treated as a join and imported as a node with a relationship

A table with 2 foreign keys is treated as a join table and imported as a relationship

A table with >2 foreign keys is treated as n intermediate node and imported as a node with multiple relationships

However, it does not mention how to import views of the same database. Our data warehouse has a general relational representation with untransformed column tables (e.g. birthdate as a full sql date). For this neo4j-etl import, we wanted to transform the data using views (e.g. birthdate as a preformatted string), which could be imported as nodes, then linked through queries to the rest of the graph. We would like to do the transformation on the RDBMS side as they are already implemented there and work well.

Is there any way to import views?

Thanks for your help!

[vga91]

@benelot Unfortunately it is not currently possible to import views using neo4j-etl.
As a provisional workaround, I would suggest you create support tables starting from the views.

[shayneoneill]

Any updates on this one?