You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Raluca Marcu <ra...@yahoo.com> on 2015/09/14 17:37:42 UTC
Re: Importing data from SQL Server
Kevin Burton <rkevinburton <at> charter.net> writes:
>
> I have seen numerous posts on transferring data from MySql to Cassandra
but have yet to find a good way to
> transfer directly from a Microsoft SQL Server table to a Cassandra CF.
Even better would be a method to take
> as input the output of an arbitrary SQL query. Ideas?
>
Hello,
I realize this post is pretty old, but I was wondering if you found an
answer to this question and if you've used it.
I have to load data from SQL Server into Cassandra and I am completely new
to Cassandra and all of the posts I seem to be able to find are demos
about loading from MySQL into Cassandra.
Any, any help would be extremely appreciated!
Thank you very much!
Raluca
Re: Importing data from SQL Server
Posted by karim duran <ka...@gmail.com>.
Hello Raluca, Hello Kevin.
To do what you want, you need an ETL software. I recommand "TALEND for Big
Data" as it has a free open-source community version.
This software is very intuitive and easy to learn and very well documented.
You have components tMSSQLInput specialized in extracting date from SQL
Server with SQL Queries, and on the other side tCassandraOutput specialized
in inserting or updating data.
I do that every days :-)
I put a screenshot of a job ( done with MySQL extract, but it's exactly the
same principe with MS SQL Server).
I hope it helps.
Regards.
Karim Duran
2015-09-14 17:37 GMT+02:00 Raluca Marcu <ra...@yahoo.com>:
>
> Kevin Burton <rkevinburton <at> charter.net> writes:
>
> >
> > I have seen numerous posts on transferring data from MySql to Cassandra
> but have yet to find a good way to
> > transfer directly from a Microsoft SQL Server table to a Cassandra CF.
> Even better would be a method to take
> > as input the output of an arbitrary SQL query. Ideas?
> >
>
>
> Hello,
>
> I realize this post is pretty old, but I was wondering if you found an
> answer to this question and if you've used it.
> I have to load data from SQL Server into Cassandra and I am completely new
> to Cassandra and all of the posts I seem to be able to find are demos
> about loading from MySQL into Cassandra.
> Any, any help would be extremely appreciated!
> Thank you very much!
> Raluca
>
>
>
>
>
>
Re: Importing data from SQL Server
Posted by Sebastian Estevez <se...@datastax.com>.
If you have a csv, try Brian's cassandra-loader. It is a full featured c*
java import program built with all the best practices for data loading and
writes.
https://github.com/brianmhess/cassandra-loader
All the best,
[image: datastax_logo.png] <http://www.datastax.com/>
Sebastián Estévez
Solutions Architect | 954 905 8615 | sebastian.estevez@datastax.com
[image: linkedin.png] <https://www.linkedin.com/company/datastax> [image:
facebook.png] <https://www.facebook.com/datastax> [image: twitter.png]
<https://twitter.com/datastax> [image: g+.png]
<https://plus.google.com/+Datastax/about>
<http://feeds.feedburner.com/datastax>
<http://cassandrasummit-datastax.com/?utm_campaign=summit15&utm_medium=summiticon&utm_source=emailsignature>
DataStax is the fastest, most scalable distributed database technology,
delivering Apache Cassandra to the world’s most innovative enterprises.
Datastax is built to be agile, always-on, and predictably scalable to any
size. With more than 500 customers in 45 countries, DataStax is the
database technology and transactional backbone of choice for the worlds
most innovative companies such as Netflix, Adobe, Intuit, and eBay.
On Mon, Sep 14, 2015 at 11:55 AM, Jason Kushmaul <
jkushmaul@rocketfuelinc.com> wrote:
> I had to write my own, but not due to lack of support. I found I needed
> to preprocess the data before I put it into cassandra, you might find that
> beneficial. I only had 3 massive tables to worry about so it wasn't that
> much extra work to code it out - your case might be different if you have
> 50 tables, or if this needs to recur.
>
> If you don't need to preprocess the data, what you could probably do is
> export your data from MSSQL to CSV (built into sql mgmt studio)
> and use CQL to import the CSV -
> http://www.datastax.com/dev/blog/simple-data-importing-and-exporting-with-cassandra
>
>
> On Mon, Sep 14, 2015 at 11:37 AM, Raluca Marcu <ra...@yahoo.com>
> wrote:
>
>>
>> Kevin Burton <rkevinburton <at> charter.net> writes:
>>
>> >
>> > I have seen numerous posts on transferring data from MySql to Cassandra
>> but have yet to find a good way to
>> > transfer directly from a Microsoft SQL Server table to a Cassandra CF.
>> Even better would be a method to take
>> > as input the output of an arbitrary SQL query. Ideas?
>> >
>>
>>
>> Hello,
>>
>> I realize this post is pretty old, but I was wondering if you found an
>> answer to this question and if you've used it.
>> I have to load data from SQL Server into Cassandra and I am completely new
>> to Cassandra and all of the posts I seem to be able to find are demos
>> about loading from MySQL into Cassandra.
>> Any, any help would be extremely appreciated!
>> Thank you very much!
>> Raluca
>>
>>
>>
>>
>>
>>
>
>
> --
> Jason Kushmaul | 517.899.7852
> Engineering Manager
>
Re: Importing data from SQL Server
Posted by Jason Kushmaul <jk...@rocketfuelinc.com>.
I had to write my own, but not due to lack of support. I found I needed to
preprocess the data before I put it into cassandra, you might find that
beneficial. I only had 3 massive tables to worry about so it wasn't that
much extra work to code it out - your case might be different if you have
50 tables, or if this needs to recur.
If you don't need to preprocess the data, what you could probably do is
export your data from MSSQL to CSV (built into sql mgmt studio)
and use CQL to import the CSV -
http://www.datastax.com/dev/blog/simple-data-importing-and-exporting-with-cassandra
On Mon, Sep 14, 2015 at 11:37 AM, Raluca Marcu <ra...@yahoo.com> wrote:
>
> Kevin Burton <rkevinburton <at> charter.net> writes:
>
> >
> > I have seen numerous posts on transferring data from MySql to Cassandra
> but have yet to find a good way to
> > transfer directly from a Microsoft SQL Server table to a Cassandra CF.
> Even better would be a method to take
> > as input the output of an arbitrary SQL query. Ideas?
> >
>
>
> Hello,
>
> I realize this post is pretty old, but I was wondering if you found an
> answer to this question and if you've used it.
> I have to load data from SQL Server into Cassandra and I am completely new
> to Cassandra and all of the posts I seem to be able to find are demos
> about loading from MySQL into Cassandra.
> Any, any help would be extremely appreciated!
> Thank you very much!
> Raluca
>
>
>
>
>
>
--
Jason Kushmaul | 517.899.7852
Engineering Manager