Firebird

Firebird is an open-source relational database management system (RDBMS) that supports SQL and runs on multiple operating systems, including Windows, Linux, and macOS. It is derived from Borland's InterBase and offers robust features like multi-generational architecture, triggers, and stored procedures while maintaining a small footprint.

Prerequisites

Authorize the Connection to Firebird

In Firebird

Please keep in mind that this guide provides general instructions, and your individual setup might need a different approach or some extra steps. Always take your organization's security guidelines into account when you're making these changes. Additionally, it's a good idea to seek assistance from a database administrator or an IT professional to make sure everything is set up correctly.

Create User

1. Open the command prompt or terminal and connect to your Firebird server using isql.
2. In isql, create a new service user for Dataddo and set a strong password.

   CREATE USER dataddo_user PASSWORD 'password';
   

Set Permissions

Create a new role for Dataddo. We will later grant it permissions to create and modify data in your database.
sql CREATE ROLE dataddo_role;

You can allow Dataddo access to your data based on your security preferences:

1. Grant Dataddo permission to specific tables.

   GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE table1, table2 TO dataddo_role;
   GRANT CREATE TABLE TO dataddo_role;
   

2. Grant Dataddo permission to all tables:

   GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES TO dataddo_role;
   GRANT CREATE TABLE TO dataddo_role;
   

3. Grant Dataddo permission to the whole database.

   GRANT SELECT_ANY_OBJECT_IN_DATABASE TO dataddo_role;
   GRANT ACCESS_ANY_OBJECT_IN_DATABASE TO dataddo_role;
   GRANT MODIFY_ANY_OBJECT_IN_DATABASE TO dataddo_role;
   GRANT CREATE TABLE TO dataddo_role;
   

Once created, grant the role to the user.

GRANT dataddo_role TO dataddo_user;

Allow Network Connection

For this destination, whitelisting IP addresses is not available in the database system. Instead, you can configure the network access at the firewall level. Here are the general steps:

1. Identify the firewall that's protecting your service. This could be a Windows or Linux firewall running on the server itself, or it could be a network firewall.
2. Open the firewall's configuration settings. This process will vary depending on the type of your firewall.
3. Look for the setting that allows you to define inbound rules or policies.
4. Create a new rule or policy that allows inbound traffic on the port that the service is using (the default is 3050) from the Dataddo IP addresses.
5. Save your changes and test the connection from Dataddo to make sure everything is working as intended.

In Dataddo

1. On the Authorizers page, click on Authorize New Service and select Firebird.
2. You will be asked to fill the following fields
   1. Server IP or Hostname: Public IP or Hostname of your Firebird server.
   2. Database: Path to the database you will use for writing or reading the data.
   3. Username: Username for your Firebird user.
   4. Password: Password associated with the username.
   5. Port: Dataddo uses native connection with default port 3050.
3. [Optional] Configure the connection via SSH tunnel. To do so, please follow these steps.
4. Click on Save.

Create a New Firebird Destination

Create a Flow to Firebird

Troubleshooting