DI Repository Creation Errors
Hello, I am new to PDI and I am running into problems creating a DI Repository. 1) Does PDI has any plans to support MS SQL Server as a repository? 2) I installed MySQL and was able to create and test a DB connection. The Repository Connection Wizard defaults "admin" as the username and prompts me to enter a password. Is there a default password I need to type in? 3) When upgrading the repository it prompted me to type the password for admin. I even created a DB user called admin in MySQL and used that password and it didn't work. How can we make the wizard take other user? 4) I also got an error creating the repository - R_USER table. How can I manually create the repository tables? Where do I find the scripts and the documentation? Thanks.
Pentaho DI 5.4 / Win / RHEL