How to import Oracle Table Into MapD


#1

Hi: ¿Does anyone have a step by step guide in order to import an Oracle table into MapD? I’m just starting to use MapD and wish to know how to write data from Oracle into MapD.
Thanks in advance if anyone has a guide for this.


#2

Hi,

It depends a little on your volume and whether it is a one off transfer or an ongoing extraction.

Assuming not a huge volume and a one time thing the easiest way is to use the SQLImporter Utility.

See https://www.mapd.com/docs/latest/mapd-core-guide/loading-data/#sql-importer for documentation

regards