The Connection Strings feature is used to connect third party databases to banterone database. In such scenarios, Custom Connections feature on banterone allows users to build connectors that securely feed data from third party databases to the banterone API.
A connection string is a string that specifies information about a data source and the means of connecting to it. A connection string contains Data Source name i.e., server name, i.e., database name, user id i.e., login user id of the database, password i.e., the login password of the database.
Create Connection Strings
- Login to banterone
- Click on Developer Options
- Click on ‘Connection Strings’ from the backend menu
- Click on ‘Add Custom Connection’
- Update Name and Description for the Connection String
- Use the toggle button to activate the Connection String
- Select the data source
- Click on ‘Configure DB Connection’
- Based on the Data Source selection, configuring data source connection will require updating certain ‘Connection Properties’ in the system
- For AWS Redshift - AWSAccessKey, AWSSecretAccessKey, ClusterIdentifier, DbUser, Database, Username, Password, HostName, and PortNumber.
- For Mongo - User ID, Password, Server, DB Name
- For MY SQL Server - Server, Database, User Id, Password
- Click on ‘Test Connection’ once connection properties have been updated to verify connection working properly.
- Click on ‘Save’
The data updated in ‘Custom Objects’ will be updated onto external databases by ‘Connection Strings’ capability.
Note: The connection String will be configured and can be edited at a later time when required by following the same method.