Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

...

Summary

...

Authentication on Manager

The Write-Back Manager requires an administrator account to access it. To log in, use the credentials defined through the email that the administrator received to register the administrator account.

Advanced Configuration

Configure Site

...

This configuration allows you to choose what is going to be the database repository that Write-Back is going to use to store its datasets. You can choose across a wide set of database technologies that include: PostgreSQL, SQL Server, Oracle, MySQL, SAP Hana, Vertica, Redshift, Snowflake, Exasol, and Google Big Query and this means you can store Wite-Back data side by side with your existing data. 


Info
titleDatabase access

Write-Back has a fixed IP that will establish communication with your database, to ensure that you have to allow external to access to the database from IP address 13.82.49.25.

It is highly recommended to create a specific database user for Write-Back to use. It should only have full access to the Write-Back schema where the datasets will be created.


Info
titleSupported Databases

It is mandatory recommended to use a cloud database or ensure a compatible version.

DatabaseVersion
MySQLMySQL Server versions 8.0 and 5.7
PostgreSqlPostgreSql 8.2 and higher
Oracle21c, 19c, 18c and 12.2 - TNS variable cannot be used
SnowflakeNo limitations
ExasolNo limitations
RedshiftNo limitations
BigQueryNo limitations
VerticaNo limitations
SAP HANASAP HANA 2.0 SPS 04 and later versions
SQL ServerSQL Server 2019, SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000


...

Expand
titleSnowflake

In some cases, when using Snowflake, an error may indicate that there is an unsafe memory allocation or an out-of-bounds index. To fix this, please add JDBC_QUERY_RESULT_FORMAT=JSON in the JDBC Advanced Options.


Expand
titleBigQuery

In the case of BigQuery due to a lack of support for some operations on the database, there are the following limitations:
   - Transactions are not supported at SQL level, so we cannot guarantee the integrity of the BigQuery database if some error happens during the action.
   - Being an analytics database bear in mind the operations can take longer to be executed.

Authentication

Here you can configure the authentication methods that include:

...