Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Info

Roadrunner Beta 1 is now available!

  • Data Standard 3.1
    • (warning) Data Standard 3.2 will be the goal for the full release.
  • Support for both SQL Server and PostgreSQL.
  • Deliver is via NuGet package.
  • Admin App is not ready.
  • Backdoor SQL script for creating key & secret .attached below.
  • There are known bugs.

Testers needed! Especially those who can point an application at the Roadrunner API instance and see what happens with a realistic sequence of API calls.

Table of Contents

...

Initialize-Environment.ps1

Installs the Admin, ODS, and Security databases into either PostgreSQL or SQL Server. It then reconfigures the web.config files for Swagger and Web API (both optional) to include the correct configuration for the environment. Finally, loads the bulk console into a destination dir. 

The $useTemplates  flag is currently only available for PostgreSQL. When used, you must have psql  executable in the execution path.

Syntax

Code Block
Initialize-Environment [[-swaggerIisFolder] <String>] [[-webApiBaseUrl] <String>] [[-webApiIisFolder] <String>] [[-apiBulkFolder] <String>] [-engine] <String> [-databaseServer] <String> [[-databasePort] <String>] [[-databaseUser] <String>] [[-databasePassword] <String>] [-useIntegratedSecurity] [[-adminDatabaseName] <String>] [[-odsDatabaseName] <String>] [[-securityDatabaseName] <String>] [-useTemplates] [[-odsTemplate] <String>] [-noDuration] [-dropDatabases] [<CommonParameters>]

...

NameAliasDescriptionRequired?Default Value
-swaggerIisFolder
Destination folder for Swagger web application. Files will be overwritten.
Default value of $null prevents Swagger web application from being
configured and deployed.
false
-webApiBaseUrl
Base URL that Swagger should use when connecting to the Web API. Defaults
to "http://localhost:54746".
falsehttp://localhost:54746
-webApiIisFolder
Destination folder for Web API web application. Files will be overwritten.
Default value of $null prevents Swagger Web API web application from being
configured and deployed.
false
-apiBulkFolder
Destination folder for installing the API bulk loader program.false
-engine
The database engine that will be used: SqlServer or PostgreSQL.true
-databaseServer
The network name or IP address of the database server.true
-databasePort
Database port number. For PostgreSQL, defaults to 5432. For SQL Server,
defaults to 1433.
false
-databaseUser
Username for connection to the database instance, both during installation
and during runtime. User must have permission to drop and create databases.
false
-databasePassword
Optionally provide a database password for non integrated-security.
Alternately, can provide via environment variable $env:SqlServerPassword.
Note that this is only supported for SQL Server, not PostgreSQL.
false$env:SqlServerPassword
-useIntegratedSecurity
Switch to enable use of Windows Integrated Security instead of a database
username and password. When true, any values provided for user name and
password are ignored.
falseFalse
-adminDatabaseName
Name of the Admin database. Defaults to EdFi_Admin.falseEdFi_Admin
-odsDatabaseName
Name of the ODS database. Defaults to EdFi_ODS.falseEdFi_ODS
-securityDatabaseName
Name of the Security database. Defaults to EdFi_Security.falseEdFi_Security
-useTemplates
Switch to install from template databases instead of the original SQL
scripts used by the EdFi.Db.Deploy executable. Currently only available
for PostgreSQL.
falseFalse
-odsTemplate
Template to use when $useTemplates is true. Allowed values: empty,
minimal, populated. Defaults to empty.
falseempty
-noDuration
When true, does not report task duration.falseFalse
-dropDatabases
When true, drops databases if they already exist. Defaults to false.
If databases exists and $dropDatabases is false, then deploy from
templates will fail, but deploy from Db Deploy will succeed.
falseFalse

...