Database

From FojiSoft Docs
Revision as of 20:51, 3 January 2024 by Chris.Hansen (talk | contribs) (Created page with "Foji is a powerful data integration platform that allows you to connect and process data from various sources, including databases. This documentation will guide you through the process of configuring a database connection in Foji. Depending on your specific database type, you will need to provide different fields for configuration. This documentation covers four popular database types: Microsoft SQL Server, MySQL/MariaDB, Oracle, and PostgreSQL. === Step 1: Accessing D...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Foji is a powerful data integration platform that allows you to connect and process data from various sources, including databases. This documentation will guide you through the process of configuring a database connection in Foji. Depending on your specific database type, you will need to provide different fields for configuration. This documentation covers four popular database types: Microsoft SQL Server, MySQL/MariaDB, Oracle, and PostgreSQL.

Step 1: Accessing Database Configuration

  1. Log in to your Foji account and navigate to the database connections section.
  2. Click on the "Add Database" button or select the option to create a new database connection.

Step 2: Naming the Database Connection

  1. In the "Name" field, enter a unique name for your database connection. Choose a descriptive name that helps you identify the purpose or characteristics of this database connection.

Step 3: Selecting the Database Driver and Entering Connection Details

  1. Select the appropriate Database Driver based on the type of your database:
  2. Microsoft SQL Server: If you are using Microsoft SQL Server as your database, select "Microsoft SQL Server" as the driver. Proceed to Step 4 for the specific fields.
  3. MySQL/MariaDB: If you are using MySQL or MariaDB as your database, select "MySQL/MariaDB" as the driver. Proceed to Step 4 for the specific fields.
  4. Oracle: If you are using Oracle as your database, select "Oracle" as the driver. Proceed to Step 4 for the specific fields.
  5. PostgreSQL: If you are using PostgreSQL as your database, select "PostgreSQL" as the driver. Proceed to Step 4 for the specific fields.

Step 4: Entering Database Connection Details

For Microsoft SQL Server

  • Server: Enter the hostname or IP address of the SQL Server instance.
  • Port: Enter the port number on which the SQL Server is listening.
  • Connection Mode: Select either "Direct" or "Agents" depending on your preference.
  • Username: Enter the username for the SQL Server connection.
  • Password: Enter the password for the SQL Server connection.
  • Database: Enter the name of the database you want to connect to.
  • Advanced Options: Provide any additional advanced options specific to your SQL Server configuration, if necessary.

For MySQL/MariaDB

  • Server: Enter the hostname or IP address of the MySQL/MariaDB server.
  • Port: Enter the port number on which the MySQL/MariaDB server is listening.
  • Connection Mode: Select either "Direct" or "Agents" depending on your preference.
  • Username: Enter the username for the MySQL/MariaDB connection.
  • Password: Enter the password for the MySQL/MariaDB connection.
  • Database: Enter the name of the database you want to connect to.
  • Advanced Options: Provide any additional advanced options specific to your MySQL/MariaDB configuration, if necessary.

For Oracle

  • Server: Enter the hostname or IP address of the Oracle database server.
  • Port: Enter the port number on which the Oracle database is listening.
  • Connection Mode: Select either "Direct" or "Agents" depending on your preference.
  • Username: Enter the username for the Oracle connection.
  • Password: Enter the password for the Oracle connection.
  • Database: Enter the name of the Oracle service or SID you want to connect to.
  • Connect Data: Click on the "+" button to add key-value pairs for additional connection data, if required. Provide the necessary key-value pairs specific to your Oracle configuration.

For PostgreSQL

  • Server: Enter the hostname or IP address of the PostgreSQL server.
  • Port: Enter the port number on which the PostgreSQL server is listening.
  • Connection Mode: Select either "Direct" or "Agents" depending on your preference.
  • Username: Enter the username for the PostgreSQL connection.
  • Password: Enter the password for the PostgreSQL connection.
  • Database: Enter the name of the database you want to connect to.
  • Advanced Options: Provide any additional advanced options specific to your PostgreSQL configuration, if necessary.

Step 5: Testing the Database Connection

  1. Once you have provided the necessary configuration details, click on the "Save" button to verify the connectivity between Foji and the database.
  2. Foji will attempt to establish a connection using the provided information. If the connection is successful, you will receive a confirmation message. Otherwise, please review the entered information and ensure that they are accurate.

Step 6: Saving and Using the Database Connection

  1. You can now use this database connection in your Foji workflows to interact with the database, such as querying data, executing SQL statements, or performing other database operations.
  2. Refer to the Foji documentation or contact the Foji support team for more information on utilizing the database connection within your workflows.

Conclusion

By following the steps outlined in this documentation, you can configure a database connection in Foji for Microsoft SQL Server, MySQL/MariaDB, Oracle, or PostgreSQL. This allows you to seamlessly integrate with your database and perform various data integration and processing tasks using the Foji platform.