csv to odata

[Vj l]

hey ,
am new to the whole OData thingy.over the last 2 days i have got a fairly good idea as to how to consume the OData.
But i am not having a clear idea as to how to convert my data which is present in a csv format to OData format that can be accessed as a url from anywhere.
It would be very helpful if some one could guide me through this.

[AllieCat]

Hi,

I just recently converted my MySQL data to OData. If I'm not mistaken it is possible to convert csv to sql. This might be a rather round-about way but I figured some direction is better than none. 

Feel free to ask me about the MySQL to OData process - I've spent quite a lot of time doing it. 

Allie

[Ramesh Reddy]

VJ,

Take look at Teiid http://teiid.org, with our 8.3 or greater releases, it produces data in odata format and consumes data from odata source. Teiid uses odata4j as the odata framework. It can support odata on CSV, fixed files, databases, web services and whole lot more. See http://teiid.blogspot.com/2013/02/odata-support-in-teiid.html

 https://docs.jboss.org/author/display/TEIID/OData+Support

[Vj l]

hey,

First things first thanx a lot for the reply :)

As u said its quite a round about way and also my csv file keeps changing so i dont think converting into sql might be the best way...

--
You received this message because you are subscribed to a topic in the Google Groups "odata4j-discuss" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/odata4j-discuss/xfAjgfalFls/unsubscribe.
To unsubscribe from this group and all its topics, send an email to odata4j-discu...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--

Regards,

Vijayalakshmi L

[Vj l]

Hey,

I did try a teidd before ... it took me so long to install and stuff... but then i realised it would b better to accomplish this without the help  of  another tool.

--
You received this message because you are subscribed to a topic in the Google Groups "odata4j-discuss" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/odata4j-discuss/xfAjgfalFls/unsubscribe.
To unsubscribe from this group and all its topics, send an email to odata4j-discu...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--

Regards,

Vijayalakshmi L

[Ramesh Reddy]

Vijayalakshmi,

No matter what tool you use or the write code yourself, you need to extract the metadata about your CSV files before you can expose through odata. Then you have to provide querying capabilities. Know that CSV files do not define any query capabilities like JPA or JDBC interfaces do. So, when you write the code you need to fill the gap of query capabilities for odata when use plain odata4j framework.

Teiid fills all the above gaps, Teiid provides *a* way to structurally arrange the data the way you want to expose to the client applications, and then provides complete querying capabilities on top that data either using SQL or OData. You do not need to write single line of Java code or generate any web apps. Now compare time spent and managing the above to this option.

As per your installation comments, how long does it take to unzip two zip files? As per the learning curve that comes with any software -:)  Look at quick start it shows you how to access CSV files

https://docs.jboss.org/author/display/teiidexamples/Data+Federation+Example

https://github.com/teiid/teiid-quickstarts/tree/master/dynamicvdb-datafederation

But if your CSV format is changing often, then there may be some advanced ways you can accomplish that in Teiid through automatic metadata detection and re-deployment, that are beyond scope of this thread, that need good knowledge of Teiid workings. 

HTH

Ramesh..