I am looking for recommendations for a suitable wiki/knowledge base/platform to produce documentation on a variety of business intelligence projects such as:
- Database documentation – documentation on all database objects, technical documentation internally for team.
- ETL documentation – detailed documentation on ETL processes, schedules etc. internally for the team.
- Procedural documentation – step by step notes on production of reports, data extracts and internal processes.
- Report documentation – supporting documentation to existing reports, less technical for a wider audience outside of team to consume but not contribute. At present none of this exists and the majority is in my head and whilst I am more than comfortable using any particularly piece of software other members in the team are not so ease of use is critical. These are the things which I believe to be essential:
- WYISWYG editor based on some form of markdown to produce clean and consistent documents – no rich text editors for users to create their own styles
- Code blocks/syntax highlighting
- Templating – able to create page/document templates that require fields to be input and prompt the user on what to include depending on the type of thing they are documenting.
- Integration with existing Active Directory
- Simple workflow management for marking pages as out of date/requiring updates
- Easy to embed and edit screenshots/images into pages
- Method of grouping and structuring content either through tags, macros to provide navigation
- Version control of documents
- Granular permissions
- Workflow management for content approval
- Export documents into PDF/Word
We currently have SharePoint Online in our organisation and I am expecting to consider that but I personally feel that this does not meet the essential criteria out of the box.
Confluence looks ideal though I am interested to hear of other alternatives to compare it with, perhaps XWiki.