Adding sources to the data warehouse

If your data will be delivered you can skip the connection checks.

Connection checks

  * Does the user provided for access only have read skills on data or also table structure?
  * During which time periods am I allowed to access data?
  * What kind of connection types are availabe? (ODBC, jDBC, native, etc.)

Database checks

  * Check if primary keys are unique.
  * Check if data lengths are forced.
  * Check what data types are used and if they match the data types in the database of the data warehouse. Create a data mapping if needed.
  * Check the coding (UTF-8, ANSII, etc).
  * Check if source is case (in-)sensitive. Make sure your data warehouse database can cope with case (in-)sensitivity.

Flat file checks

  * What is the separator?
  * Are there any columns that contain line endings?
  * What kind of line endings are used? (Windows, Unix)
  * What is the encoding? (UTF-8, ANSII, etc).