Dear ExactTarget specialists,
I am trying to get a hang of how the ExactTarget Marketing Cloud works, and I am struggling in finding information on a seemingly basic task: Loading data into the platform.
These questions may be awkward and n00b-like, but I hope you don't mind me asking:
- I have gathered that I need to create "Data Extensions" for a customer record which in turn store any kind of data I need to be able to segment my customers; is this correct?
- Our data sources consist of different systems, like SAP, Remedy, and an Oracle database containing various kinds of information I need to be able to use in segmentations; would I design Data Extensions based around the data sources, or in some other way? Would I use multiple Data Extensions if I need to get large amounts of data from a single source?
- How does the import process into the platform work? Would I normally use the "Import Activity" from an "Enhanced FTP directory" in ExactTarget? Or would I invoke the REST API to update the records in batches?
To set the scene a little: I am facing 5-10 million records with a daily change rate of about 1000-5000 (new orders, updates,...).
I know my questions are very general, perhaps there is some kind of documentation (I was not able to find) to give me some pointers?