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 <ka...@gmail.com> on 2017/03/22 11:31:35 UTC

Connect sql database through Apache Ignite ODBC driver

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.

Re: Connect sql database through Apache Ignite ODBC driver

Posted by Igor Sapego <is...@gridgain.com>.

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 <ka...@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.
>