SQL to HPCC
My data is quickly out growing its current SQL based implementation (SQL Server / MySQL / Oracle etc). Is there any facilitation available to migrate to HPCC?
- Helen
- Posts: 3
- Joined: Wed Jun 29, 2011 2:54 pm
Hi Helen,
In the HPCC, you have the option to input data in one of three ways:
Fixed Length
Variable length (known as CSV)
XML
So the first step would be to export your SQL data into one of the supported formats. I think that most platforms support the CSV format, so that would be my first choice. After that, you simply copy the exported data to the Landing Zone and then spray from there. The Data Tutorial PDF has more information regarding this process.
Hope this helps!
Regards,
Bob Foreman
LexisNexis
In the HPCC, you have the option to input data in one of three ways:
Fixed Length
Variable length (known as CSV)
XML
So the first step would be to export your SQL data into one of the supported formats. I think that most platforms support the CSV format, so that would be my first choice. After that, you simply copy the exported data to the Landing Zone and then spray from there. The Data Tutorial PDF has more information regarding this process.
Hope this helps!
Regards,
Bob Foreman
LexisNexis
- [email protected]
- Posts: 5
- Joined: Thu Mar 31, 2011 4:39 pm
Bob:
I think the question has more to do with migrating the data definitions, and querries etc that support the data than how do you simply move the data.
If so, It is interesting to note that the earliest versions of HPCC did support at least a subset of SQL, and wonder if any of that old code could be 'awoken' and given to the community?
I think the question has more to do with migrating the data definitions, and querries etc that support the data than how do you simply move the data.
If so, It is interesting to note that the earliest versions of HPCC did support at least a subset of SQL, and wonder if any of that old code could be 'awoken' and given to the community?
- SkipSnow
- Posts: 9
- Joined: Fri Jun 17, 2011 5:25 pm
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest