#postgresql Connector on #webmethods.io Integration #wm onPremise | #SharpTech #IntegrationUsers

Here I can guide you through the process of creating a PostgreSQL instance through ElephantSQL, installing DBeaver to connect to it, and using the DB connector in webMethods.io Integration to insert records into PostgreSQL. 1. Create a PostgreSQL Instance on ElephantSQL: Visit the ElephantSQL website: https://www.elephantsql.com/. Sign up for an account or log in if you already have one. Once logged in, click on "Create New Instance" to create a new PostgreSQL instance. Follow the prompts to configure your instance. You can choose a plan (e.g., Tiny Turtle, Little Lemur, etc.), region, and other settings. After configuration, click "Create New Instance." 2. Install DBeaver: Download and install DBeaver, a popular database management tool: https://dbeaver.io/download/. Launch DBeaver after installation. 3. Connect DBeaver to Your ElephantSQL PostgreSQL Instance: Open DBeaver. Go to "Database" then "New Database Connection." Select "PostgreSQL" as the database type. Fill in the following details: Host: The hostname or IP address of your ElephantSQL instance (you can find this in your ElephantSQL dashboard). Port: 5432 (default PostgreSQL port). Database: The name of the PostgreSQL database you created on ElephantSQL. Username and Password: Your ElephantSQL database credentials. Click "Test Connection" to ensure that it's working. If the test is successful, click "Finish." 4. Create a Table in Your PostgreSQL Database: In DBeaver, connect to your ElephantSQL PostgreSQL instance. Open a SQL editor and execute SQL commands to create a table that you want to use in your webMethods.io Integration. 5. Set Up webMethods.io Integration: Log in to webMethods.io Integration: https://webmethods.io/integration/. Create a new project or use an existing one. Inside your project, create a new flow or use an existing one. 6. Add a DB Connector Step to Insert Records: In your webMethods.io Integration flow, add a "DB Connector" step. Configure the DB Connector step with the following details: Connection: Create a new connection or use an existing one. Operation: Select "Insert" or "Insert or Update" depending on your needs. Table Name: Specify the name of the table you created in your PostgreSQL database. Data: Map the data you want to insert into the PostgreSQL table. 7. Test and Deploy the Integration: Test your webMethods.io Integration flow to ensure that records are being inserted into the PostgreSQL database correctly. Once you are satisfied with the testing, deploy the integration so that it runs automatically based on your defined triggers or schedules. That's it! You have created a PostgreSQL instance using ElephantSQL, connected to it using DBeaver, and integrated it with webMethods.io Integration to insert records into the database.