Database and user

Database and user

Before the database input component can be used, you need to create a database and also create a user that can connect to the database. InterFormNG can create the necessary tables for you, or you can create them yourself.

The user that you use to connect with, needs the following grants as a minimum: SELECT, INSERT, UPDATE.

If you want InterFormNG to create the tables on the database, then the user also needs the following grants: create table, alter table, create foreign key constraint, create index. The exact names of these are different depending on what database you use, On MySQL it would be CREATE, ALTER, REFERENCES, INDEX. These grants should be removed from the user once the tables have been successfully created.

    • Related Articles

    • Enrich spooled file from database

      Enrich spooled file from database It is possible to change the contents of a spooled file (as known on the IBM i platform) and to add data from an external database with the advanced special workflow component: Enrich spooled file from database. You ...

    • From database

      A workflow can be initiated by a job record in a database table. Only relational databases are supported. Please notice, that this input only supports the very specific table layout as described in the section, Database configuration, where in input ...

    • Database configuration

      The section below describes the database configuration for the From database workflow input, which is very seldomly used. For most you should consider the alternative: From database with custom SQL. To use the database input component, database ...

    • Database connections

      If you want InterFormNG2 to connect to a database in order to get input files for processing, then you need to configure the database as below. This section contains these topics: 1.Prerequisite 2.Configuration 3.Connection 4.Setup SQL via library ...

    • Database SQL update

      The advanced, utilities workflow component, Database SQL update can be used in order to update or insert data in a table in a database. Enabling custom SQL Custom SQL needs to be enabled in the global System settings. It is divided into two sections: ...