locked
Can I visit Azure Table Storage by using JDBC or ADO.NET? RRS feed

  • Question

  • I want to use JDBC or ADO.NET to visit Table Storage, but I didn't found any guide of this. Does JDBC and ADO.NET only can connect to SQL Database Service? If not, how to do that?

    Thanks

    Monday, August 12, 2013 9:43 AM

Answers

  • Hi Gideon,

    Table storage from Azure is exposed over REST endpoint. Note that Storage library from Azure SDK is wrapper over these REST calls. As of now I don't see a way of directly using ADO.NET with table storage.

    More so Table storage is not a RDBMS. It just stores data in tabular format.


    Regards,
    Ojas Maru ( My blog )

    Monday, August 12, 2013 10:30 PM
  • HI

    As far as I know, we can't use ado.net or JDBC directly, but we can use Azure table storage class libary, it use ADO.net Data service .

    Because ADO.NET Data Services is REST-based, any stack that is able to issue an HTTP request can consume these services.  In order to do so, you need to know the URI addressing scheme, which HTTP verbs to use and what the representation format of the response is. 

    If you want you can use that services by your own.

    Please refer to this article:

    http://www.robbagby.com/azure/azure-table-storage-the-rest-and-ado-net-data-services-story/


    Please mark post as answered if it helped!

    Tuesday, August 13, 2013 2:01 AM
  • Hi,

    Table storage is not a relational database engine. It doesn't stand by JDBC or ADO.NET. Please use OData, or a lower level technology, such as REST and xml, to work with table storage. Both .NET and Java also provide client libraries to simplify the work. The downside of client libraries is that they require strong types. So it is needed to define model classes before using the libraries. I would like to suggest you to check http://www.windowsazure.com/en-us/develop/net/how-to-guides/table-services/ for a C# tutorial on table storage, and refer to http://www.windowsazure.com/en-us/develop/java/how-to-guides/table-service/ for a Java tutorial.

    Best Regards,

    Ming Xu


    Ming Xu
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Tuesday, August 13, 2013 5:39 AM

All replies

  • Hi Gideon,

    Table storage from Azure is exposed over REST endpoint. Note that Storage library from Azure SDK is wrapper over these REST calls. As of now I don't see a way of directly using ADO.NET with table storage.

    More so Table storage is not a RDBMS. It just stores data in tabular format.


    Regards,
    Ojas Maru ( My blog )

    Monday, August 12, 2013 10:30 PM
  • HI

    As far as I know, we can't use ado.net or JDBC directly, but we can use Azure table storage class libary, it use ADO.net Data service .

    Because ADO.NET Data Services is REST-based, any stack that is able to issue an HTTP request can consume these services.  In order to do so, you need to know the URI addressing scheme, which HTTP verbs to use and what the representation format of the response is. 

    If you want you can use that services by your own.

    Please refer to this article:

    http://www.robbagby.com/azure/azure-table-storage-the-rest-and-ado-net-data-services-story/


    Please mark post as answered if it helped!

    Tuesday, August 13, 2013 2:01 AM
  • Hi,

    Table storage is not a relational database engine. It doesn't stand by JDBC or ADO.NET. Please use OData, or a lower level technology, such as REST and xml, to work with table storage. Both .NET and Java also provide client libraries to simplify the work. The downside of client libraries is that they require strong types. So it is needed to define model classes before using the libraries. I would like to suggest you to check http://www.windowsazure.com/en-us/develop/net/how-to-guides/table-services/ for a C# tutorial on table storage, and refer to http://www.windowsazure.com/en-us/develop/java/how-to-guides/table-service/ for a Java tutorial.

    Best Regards,

    Ming Xu


    Ming Xu
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Tuesday, August 13, 2013 5:39 AM