Import Resources

This document explains how to import multiple resources into StrongDM using the sdm admin resources CLI command. It also explains how to update resources.

Get the JSON Template

StrongDM supports many resource types, and each has its own import format. To get a JSON import template for a specific resource type, follow these steps.

1. First view all resource types supported by StrongDM and note the name of your resource:

   sdm admin resources add

2. After finding the name of your resource type, you can then use the --template option to get a JSON import template for the resource type specified. Using the following command saves the import.json template file to your machine:

   sdm admin resources add <RESOURCE_TYPE> --template > import.json

   If you wish to view the template file in the terminal instead, run the same command but without import.json, as in the following example:

   sdm admin resources add postgres --template

   Running that example returns the following JSON:

   [
       {
    	   "bindInterface": "127.0.0.1",
    	   "database": "",
    	   "hostname": "",
    	   "name": "datasource name",
    	   "overrideDatabase": "true",
    	   "password": "",
    	   "port": "",
    	   "portOverride": "",
    	   "subdomain": "",
    	   "tags": {
    	   	"key": "value"
    	   },
    	   "type": "postgres",
    	   "username": ""
       }
   ]                                

3. Open the import.json file in a text editor to edit the values before importing the file back into StrongDM.

Example Import JSON

You can have multiple resource entries when importing. For example, the following JSON adds both a PostgreSQL and a MySQL resource. Notice that each resource type has different fields.

The name field must be unique for each resource.

[
    {
        "type": "postgres",
        "name": "postgres datasource",
        "hostname": "",
        "port": "",
        "username": "",
        "password": "",
        "database": "",
        "schema": "",
        "overrideDatabase": "true",
        "portOverride": ""
    },
    {
        "type": "mysql",
        "name": "mysql datasource",
        "hostname": "",
        "port": "",
        "username": "",
        "password": "",
        "database": "",
        "portOverride": ""
    }
]

The portOverride field is only required if you are using port overrides. You can also find out more information about each field by running the sdm admin resources add <TYPE> or sdm admin resources add <TYPE> --help.

Run the Import

Once you have created your JSON file, you can easily import it into StrongDM.

sdm admin resources add --file import.json

Update Resources

To get the current resource state in JSON format, run sdm admin resources list -j -e > export.json. Once you have the state, you can modify the JSON and update the resources by running sdm admin resources update --file export.json.