-
Notifications
You must be signed in to change notification settings - Fork 31
README Prerequisites
Setup as needed for following along with the Transformalize ReadMe.
Run Transformalize CLI with Docker. Create a bash function like this:
tfl () {
docker run -it --rm -v "$(pwd)":"$(pwd)" -w "$(pwd)" dalenewman/transformalize.cli:latest "$@"
}☝🏼 Test the above by running tfl --version
Here is the command I used:
docker run --name sqlserver -e ACCEPT_EULA=Y -e SA_PASSWORD=Secret1! -p 1433:1433 -d mcr.microsoft.com/mssql/server:2017-latest
Once it's running, use a client of your choice to create the Northwind database. You can find the script and links to clients here.
The SQL script may be full of GO commands. This is fine if you're using SQL Server Management Studio, but not fine if you're using something like Beekeeper Studio. You may need to replace the GO with semicolon (e.g. ^[Gg][Oo]).
If all goes well, the script will create and populate a database named Northwind.
Here are the commands I used to run PostgreSQL and pgAdmin:
docker run --name postgres -p 5432:5432 -e POSTGRES_PASSWORD=Secret1! -d postgres:latest
docker run --name pgadmin -p 8080:80 -d -e [email protected] -e PGAD
MIN_DEFAULT_PASSWORD=Secret1! dpage/pgadmin4
Use pgAdmin to create a database named TflNorthwind (e.g. CREATE DATABASE TflNorthwind;).
Here's are the commands I used:
docker network create elk
docker run -d --name elasticsearch --net elk -p 9200:9200 -p 9300:9300 -e "discovery.type=single-node" elasticsearch:7.9.3
docker run -d --name kibana --net elk -p 5601:5601 kibana:7.9.3
Once they're running, you should find Elasticsearch at http://localhost:9200 and Kibana at http://localhost:5601.
docker run -d --name orchardcore -p 8081:8080 dalenewman/transformalize.orchard:latest
The should start off at the setup page. To set it up quickly, choose SQLite. Once logged in, enable the Transformalize feature.