Setting Up a Source Connector in Multiwoven
To integrate PostgreSQL with Multiwoven, you need to establish a source connector. This connector will enable Multiwoven to extract data from your PostgreSQL database efficiently. Below are the steps to set up the source connector in Multiwoven:Step 1: Access Multiwoven
- Log in to your Multiwoven account.
- Navigate to the
Sourcessection where you can manage your data sources.
Step 2: Create a New Source Connector
- Click on the
Add Sourcebutton. - Select
PostgreSQLfrom the list of available source types.
Step 3: Configure Connection Settings
You’ll need to provide the following details to establish a connection between Multiwoven and your PostgreSQL database:Host The hostname or IP address of the server where your PostgreSQL database is hosted.
Port The port number on which your PostgreSQL server is listening (default is 5432).
Database The name of the database you want to connect to.
Schema The schema within your PostgreSQL database you wish to access.
Username The username used to access the database.
Password The password associated with the username.
Enter these details in the respective fields on the connector configuration page and press continue.
Step 4: Test the Connection
- Once you’ve entered the necessary information. The next step is automated Test Connection feature to ensure that Multiwoven can successfully connect to your PostgreSQL database.
- If the test is successful, you’ll receive a confirmation message. If not, double-check your entered details for any errors.
Step 4: Finalize the Source Connector Setup
- After a successful connection test, provide any additional settings or configurations required by Multiwoven to tailor the data extraction process to your needs.
- Save the connector settings to establish the source connection.