To use the various Data Connectors in Sliderule, you'll need to have Credentials set up first. Head to the Credentials tab in the side bar, and click Add New Credential to get started.
You'll need some basic info about your database, as well as a username and password to set up your Credential. We currently only support Postgres databases.
You can check out a sample data source at Sample Data Sources if you want to play around.
Fill out the fields and click next. Enter a test SQL query here, to make sure the connection works properly. Try something like
SELECT * FROM table_name LIMIT 1;
Follow the same steps above, but select API Call. Pick an Authentication Type (e.g. Basic Auth) and enter your credentials.
Click next and set up a test API Call to make sure your credentials work properly. Select GET or POST, and if POST then feel free to add a sample request body. Click Test to confirm your credentials are working, then click Save.
Updated 4 months ago