Re: Read Data using apache ignite

2017-03-14 Thread Pavel Tupitsyn
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  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

2017-03-14 Thread kavitha
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

2017-03-14 Thread Pavel Tupitsyn
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  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

2017-03-14 Thread kavitha
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

2017-03-14 Thread Nikolai Tikhonov
Honest I don't understand your question. Would you describe your point more?

On Tue, Mar 14, 2017 at 2:21 PM, kavitha  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

2017-03-14 Thread kavitha
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

2017-03-13 Thread Nikolai Tikhonov
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 
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
>
>


Read Data using apache ignite

2017-03-12 Thread Kavitha Murugesan
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