What data import and export capabilities do you have?


Response: Data can be imported into the EDW using traditional methods from flat-files (such as Excel) or other databases using import wizards, which are typically part of the relational database system. The Catalyst EDW includes a flat-file ETL interface for importing formatted files on a daily or on-demand basis. Data can also be exported to Excel files or other databases via secure, standard ODBC-style database drivers and connection strings.