Skip to content

Datawarehouse

BizzStream to SQL allows you to use your own data warehouse solution. The module has been developed, and was tested, using a PostgresQL connection. If you would like to use a different database configuration, please contact your account manager at Van Meijel Automatisering.

The connection between the BizzStream environment and the (external) datawarehouse is always over a SSL connection.
Because we are going over the internet, IP Whitelist the incoming connection to the PostgreSQL. We are connecting via TCP (Transmission Control Protocol), where the default port is 5432 (for Postgres). However, a different port can be used.
Do not forget to also mention the right port for the database connection!

Passwords

Strong passwords are essential for security. While password length is a significant factor, complexity is equally important. We recommend using passwords that meet the following criteria:

  • Minimum Length
  • Character Types: Include a mix of uppercase and lowercase letters, numbers, and symbols.
  • Avoid Common Patterns: Do not use easily guessable patterns like sequential numbers, repeated characters, or dictionary words.

While long passwords are generally more secure, the system supports passwords up to 32 characters in length. However, it's crucial to prioritize complexity over simply increasing length. For optimal security, use a password manager to generate and store strong, unique passwords for each application.

PostgreSQL

When using the PostgreSQL database, two main steps are required:

  1. Defining connection variables: These variables configure the connection to the database.
  2. Database initialization: Use initdb to initialize the database cluster. All subsequent table creation and schema setup is handled automatically by the bs2sql logic.

Four variables are essential for setting up the connection and transmitting data. If PostgreSQL was installed with default settings, the port will be 5432. You'll also need a user and their corresponding password to connect to the specified database. For the connection, the host is needed.

Testing the connection

Using the PGAdmin tool it's possible to test both the connection, the user and the availability of the database.