NoSQL databases

Connection settings Apache Cassandra

▪    Server URL: Server[:Port]

▪    Keyspace

Connection settings CouchDB

▪    Server URL: Server[:Port]

▪    Username and Password

▪    Database Name

▪    View Name

▪    Prefix

Connection settings MongoDB

▪    Server URL: Server[:Port]

▪    Username and Password

▪    Database Name

Tip: The REST API must be enabled for a MongoDB data source. This is started with - - rest. This API currently does not support authentication, meaning that it has full read access after activation.

Connection settings Redis

▪    Connection String: Server[:Port]

Note: Options and connection string are described e.g. here: https://stackexchange.github.io/StackExchange.Redis/Configuration#configuration-options

▪    Separator-separated list of hash tables to be registered (separator: '|')

▪    Compare-function for hash tables: Starts with / Ends with / Contains.

Note: Since no real tables with multiple columns are available, multiple hashtables are created with a specific pattern to allow multiple rows. For example, there is no table "user" with record 1, 2 and 3, but 3 hash tables with the names user:1, user:2 and user:3. So that the Report Server recognizes which hash tables belong together, they must be defined separately with a "|" and the comparison function must also be used to specify how this name is to be checked.