Wiki MaCa

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).