Import/Export

One of the easiest ways to populate your model is to use the import and export tools. You can import one or more tables at a time from a variety of data sources. During import, you have the ability to map columns from the source to the appropriate target columns in your model. For detailed information, refer to Import data.

The export tools let you output data from one or more model tables to an external file, such as an Excel spreadsheet. You can then manipulate the data as needed and re-import it to your model. For detailed information, refer to Export data.

For both import and export, the data must be limited to 1,048,576 rows and 16,384 columns (the limit for Microsoft Excel).

Data Guru provides a powerful tool to collect, aggregate and otherwise manipulate data from most commonly used data formats. You can use Data Guru to support data sets in excess of the 1,048,576 limit. For detailed information, refer to Data Guru.