BIAccelarator

Readme file edited with Dillinger.

BIAccelator is a web platform that automates BI implementation tasks. Features already implemented include Extraction tasks (built on top of SSIS) from other databases (supporting OLEDB connections).

This features include:

• Manage the flow easily with a web interface
• Collect Source database metadata
• Create all staging database structure as a copy of your sources
• Create SSIS project to Extract data and load to your staging database (Under development)

From this point on you are on your own until new releases to this project

New Features!

• Automated SSIS deploy (in progress)
• Schedule ETL run jobs (in progress)

Tech

BIAccelator uses the following technologies and libraries (all credits included to the authors):

• .NET MVC
• SSIS
• SQL Server
• EzAPI - Automate your SSIS implementation (for SQL Server 2016). Programmatically create SSIS packages and projects.

Todos

• Web Interface
• Automate project deployment to the SQL Server
• Deployed project scheduling
• Data Warehouse creation and implementation of CDC table load types (0, 1, 2)
• SSAS Automated creation and deploy
  • Structure Creation (Tables and Relationships)
  • Deploy to SSAS
  • SSAS partitions processing

License

GNU GENERAL PUBLIC LICENSE Version 3

Free Software. Keep it free to others as well.