You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Kavitha Murugesan <ka...@gmail.com> on 2017/03/12 10:41:47 UTC
Read Data using apache ignite
hi All,
I have sql database in my machine. Is it possible to read sql database data
using apache ignite? If is it possible means how can I achieve this? and
what is the purpose of starting node?
Thanks,
Kavitha M
Re: Read Data using apache ignite
Posted by Pavel Tupitsyn <pt...@apache.org>.
You have two options:
1) Implement cache store that works with your SQL database
Docs: https://apacheignite-net.readme.io/docs/persistent-store
Example: https://ptupitsyn.github.io/Entity-Framework-Cache-Store/
2) Use Entity Framework to work with your DB and configure Ignite 2nd level
cache:
https://apacheignite-net.readme.io/docs/entity-framework-second-level-cache
On Wed, Mar 15, 2017 at 7:59 AM, kavitha <ka...@gmail.com> wrote:
> Yes I am using C#.
> How can I use ignite as a caching layer?
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Read-Data-using-apache-ignite-tp11150p11174.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
Re: Read Data using apache ignite
Posted by kavitha <ka...@gmail.com>.
Yes I am using C#.
How can I use ignite as a caching layer?
--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Read-Data-using-apache-ignite-tp11150p11174.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: Read Data using apache ignite
Posted by Pavel Tupitsyn <pt...@apache.org>.
Which platform/language do you use? Java, C++, C#, anything else?
Can you please describe your use case in more detail?
Do you want to use Ignite as a caching layer in front of SQL server?
On Tue, Mar 14, 2017 at 3:59 PM, kavitha <ka...@gmail.com> wrote:
> I have NORTHWIND database in my local sql server. I need to read NORTHWIND
> data using apache ignite through ODBC driver.
> How can I write code for sql server configuration and read data? Here I am
> using VS2015.
> Can you please explain me?
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Read-Data-using-apache-ignite-tp11150p11166.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
Re: Read Data using apache ignite
Posted by kavitha <ka...@gmail.com>.
I have NORTHWIND database in my local sql server. I need to read NORTHWIND
data using apache ignite through ODBC driver.
How can I write code for sql server configuration and read data? Here I am
using VS2015.
Can you please explain me?
--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Read-Data-using-apache-ignite-tp11150p11166.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: Read Data using apache ignite
Posted by Nikolai Tikhonov <nt...@apache.org>.
Honest I don't understand your question. Would you describe your point more?
On Tue, Mar 14, 2017 at 2:21 PM, kavitha <ka...@gmail.com> wrote:
> Hi Nikolai,
>
> Thanks for your reply. Can I connect using any database in cloud instead of
> creating cluster? Is it possible?
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Read-Data-using-apache-ignite-tp11150p11163.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
Re: Read Data using apache ignite
Posted by kavitha <ka...@gmail.com>.
Hi Nikolai,
Thanks for your reply. Can I connect using any database in cloud instead of
creating cluster? Is it possible?
--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Read-Data-using-apache-ignite-tp11150p11163.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: Read Data using apache ignite
Posted by Nikolai Tikhonov <nt...@apache.org>.
Hi,
Yes, it's possible. You can configure "Write-Through & Read-Through"
functionality. See there [1],[2]. Also Ignite provides "web-console" which
allows to easily import db schema to Ignite. [3]
1. https://ignite.apache.org/use-cases/caching/database-caching.html
2. https://apacheignite.readme.io/docs/persistent-store
3. https://youtu.be/gd6ZCahEr0o
On Sun, Mar 12, 2017 at 1:41 PM, Kavitha Murugesan <ka...@gmail.com>
wrote:
> hi All,
>
> I have sql database in my machine. Is it possible to read sql database
> data using apache ignite? If is it possible means how can I achieve this?
> and what is the purpose of starting node?
>
> Thanks,
> Kavitha M
>
>