ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Igor Sapego <isap...@gridgain.com>
Subject Re: Connect sql database through Apache Ignite ODBC driver
Date Wed, 22 Mar 2017 13:15:19 GMT
Hi,

You can take a look
at platforms\cpp\examples\odbc-example\src\odbc_example.cpp
for the reference. You may also want to read documentation [1].

To be short, you need to write a program in C or C++, or any other language
that
supports ODBC, connect to Ignite node as if it was a database and run the
query
like you do with any other database.

[1] - https://apacheignite.readme.io/docs/quering-data


Best Regards,
Igor

On Wed, Mar 22, 2017 at 2:31 PM, kavitha <kavithamrgsn@gmail.com> wrote:

> Hi,
>
> I installed Apache Ignite 64 bit ODBC driver. I have NORTHWIND sql database
> in my machine. I need to connect sql database through Apache Ignite ODBC
> driver. How can I implement this?
>
> Spring XML file configuration:
>
> <?xml version="1.0" encoding="UTF-8"?>
>
> <beans xmlns="http://www.springframework.org/schema/beans"
>        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>        xsi:schemaLocation="http://www.springframework.org/schema/beans
>         http://www.springframework.org/schema/beans/spring-beans.xsd">
> <bean id="ignite.cfg"
> class="org.apache.ignite.configuration.IgniteConfiguration">
>   <property name="odbcConfiguration">
>     <bean class="org.apache.ignite.configuration.OdbcConfiguration"/>
>   </property>
> </bean>
> </beans>
>
> My use case: If I execute following command in cmd, I want to display
> Customers table from NORTHWIND database.
>
> F:\Apache\apache-ignite-fabric-1.9.0-bin\apache-
> ignite-fabric-1.9.0-bin\bin>ignite.bat
> my-file.xml
>
>
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Connect-sql-database-through-Apache-
> Ignite-ODBC-driver-tp11361.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>

Mime
View raw message