Zykrr platform can automatically save survey responses in your mariadb and postgres database directly.

The database should have a table created with following DDL. In the DDL we have assumed that the table is named “responses”. You can change it as requried and provide the table in above “Table name” field.

create table responses
(
id              char(36) primary key                 not null,
campaignId      char(36)                             null,
answers         longtext collate utf8mb4_bin         not null,
participantInfo longtext collate utf8mb4_bin         null,
submittedAt     datetime                             not null,
createdAt       datetime default current_timestamp() null,
constraint answers check (json_valid(`answers`)),
constraint participantInfo check (json_valid(`participantInfo`))
);

Provide username, password, database name, database host and table name in DIY > campaign > setting > integration > Database. Periodically zykrr platform will save the survey responses to your database.