Wiki

Scale Your Enterprise

User Tools

Site Tools


bizweaver:connections

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
bizweaver:connections [2024/05/15 13:58]
dlee created
bizweaver:connections [2025/06/10 14:26] (current)
afernandes [SMTP Connections]
Line 8: Line 8:
   * The name cannot have spaces or special characters other than an underscore (_).   * The name cannot have spaces or special characters other than an underscore (_).
         * **This value cannot be changed once a connection has been created**.         * **This value cannot be changed once a connection has been created**.
-       +  * Access the Connection Manager window by clicking on the menu bar Tools>Connection Manager.
-====== Creating Connections ====== +
- +
-The Connection Manager menu is started by clicking on the menu bar then connection manager, as shown below.+
  
 {{ :bw2:bizweaverconnectionmanager1.png |}} {{ :bw2:bizweaverconnectionmanager1.png |}}
 +
 +  - **[[bizweaver:connections#SQL Connections|SQL]]**
 +  - **[[bizweaver:connections#HANA Connections|HANA]]**
 +  - **[[bizweaver:connections#DI Server Connections|DI Server]]**
 +  - **[[bizweaver:connections#DI API Connections|DI API]]**
 +  - **[[bizweaver:connections#SMTP Connections|SMTP]]**
 +  - **[[bizweaver:connections#Exchange Connections|Exchange]]**
 +  - **[[bizweaver:connections#REST Connections|REST]]**
 +  - **[[bizweaver:connections#SAP Service Layer Connections|SAP Service Layer]]**
 +  - **[[bizweaver:connections#GraphQL Connections|GraphQL]]**
 +
  
 ===== Connection Listing ===== ===== Connection Listing =====
  
-{{ :bw2:bizweaverconnectionmanager2.png |}}+{{ :bizweaver:connections01.png |}} 
 + 
 +  * Click on the dropdown menu **New Connections** to define a new connection. 
 +  * Double-click on a connection to open it for **editing**. 
 +    * The existing configuration information is displayed. 
 +    * You will need to re-enter user/password information when making a change. 
 +    * Click **Save** to save new/updated information. 
 +    * The application will validate things like server, database, and authentication information by completing the connection. 
 +    * If any errors are reported, the connection will not be saved. 
 +  * Select connections and click the **Export** button to export connections to a file. 
 +    * The export file can be password protected 
  
-  - The grid centrally on the page lists all connections that are currently defined. 
-      - The “Type” column indicates the type of connection. 
-  - Click on the dropdown menu “New Connections” to **define a new** connection from the list. 
-      - The connection configuration area changes to show the selected type fields and all information is cleared. 
-  - Double-click on an item to open it for **editing**. 
-      - The existing configuration information is displayed. 
-      - You will need to re-enter user/password information when making a change. 
-      - {{ :bw2:bizweaverconnectionmanager3.png |}} 
-  - See **//[[bw2:global_connections#delete_a_global_configuration|Delete a Global Connection]]//** for more information on **removing** a global connection. 
-  - Click [**Validate & Save**] to save new/updated information. 
-      - The application will validate things like server, database, and authentication information by completing the connection. 
-      - If any errors are reported, the connection will not be saved. 
-  - Click [**Close**] to close the entry without saving changes. 
 ===== SQL Connections ===== ===== SQL Connections =====
  
Line 144: Line 149:
 ===== SMTP Connections ===== ===== SMTP Connections =====
  
-SMTP connections are used to provide connection information for the server(s) that handle email. Most installations will only have one SMTP connection. However, there is no technical restriction on the number of connections that are defined.+SMTP connections are used to provide connection information for the server(s) that handle email. Most installations will only have one SMTP connection. However, there is no technical restriction on the number of connections that are defined. You can now create SMTP connections using either basic authentication or Oauth2 authentication 
 + 
 +**Basic Authentication**
  
 {{ :bw2:bizweaverconnectionmanager8.png |}} {{ :bw2:bizweaverconnectionmanager8.png |}}
Line 152: Line 159:
   * **Enable SMTP Credentials** (Username & password) \\ <WRAP info round center> Your installation may not require SMTP credentials to send mail from Bizweaver. However, identifying a valid user in this step is required to use the error handling functions of Bizweaver. </WRAP>   * **Enable SMTP Credentials** (Username & password) \\ <WRAP info round center> Your installation may not require SMTP credentials to send mail from Bizweaver. However, identifying a valid user in this step is required to use the error handling functions of Bizweaver. </WRAP>
   * The connection information is saved but is not validated. Any connection errors will only be shown when the connection is used in a workflow.   * The connection information is saved but is not validated. Any connection errors will only be shown when the connection is used in a workflow.
 +
 +**Oauth2 Authentication**
 +
 +{{ :bizweaver:oauthsmtp.png |}}
 +
 +  * **Tenant ID** is a unique identifier (GUID) for your Microsoft 365 organization (Azure Active Directory tenant).
 +  * **Client ID** is a GUID that uniquely identifies the OAuth app registered in your Azure AD.
 +  * **Client Secret** is a confidential string (like a password) generated for the registered app in Azure AD.
 +  * The connection information is saved but is not validated. Any connection errors will only be shown when the connection is used in a workflow.
 +<WRAP info round center> Go to the //**[[versago3:oauthsetup|Oauth Setup Instructions]]**// for instructions on how to configure SMTP Oauth with Microsoft Exchange Online
 + </WRAP>
  
 ==== Email Setup for Microsoft Office365 ==== ==== Email Setup for Microsoft Office365 ====
Line 181: Line 199:
  
 {{ :bw2:bizweaverconnectionmanager8.png |}} {{ :bw2:bizweaverconnectionmanager8.png |}}
 +
 ===== Exchange Connections ===== ===== Exchange Connections =====
 Exchange connections are used to access a Microsoft Exchange server directly.  This is different from the SMTP connection, even if you use Exchange as your SMTP server.  This allows you to read incoming emails and create appointments (meetings) for other users.  Defining this type of connection does not apply if you do not use an Exchange server. Exchange connections are used to access a Microsoft Exchange server directly.  This is different from the SMTP connection, even if you use Exchange as your SMTP server.  This allows you to read incoming emails and create appointments (meetings) for other users.  Defining this type of connection does not apply if you do not use an Exchange server.
Line 242: Line 261:
   - **Username** and **Password** are the credentials that will be used to "login" to SAP Business One.  This user should be identified as a "superuser" and should have either a Professional or Indirect Access user license. <WRAP info round center> If  single sign-on user is used to sign in to the service layer an extra backslash is needed to pass it through the Service Layer ex: domain\\user </WRAP>   - **Username** and **Password** are the credentials that will be used to "login" to SAP Business One.  This user should be identified as a "superuser" and should have either a Professional or Indirect Access user license. <WRAP info round center> If  single sign-on user is used to sign in to the service layer an extra backslash is needed to pass it through the Service Layer ex: domain\\user </WRAP>
   - The connection information is saved but is not validated. Any connection errors will only be shown when the connection is used in a workflow.   - The connection information is saved but is not validated. Any connection errors will only be shown when the connection is used in a workflow.
 +
 +===== GraphQL Connections =====
 +A GraphQL connection lets your application communicate with a GraphQL server through a single HTTP endpoint. Instead of multiple REST routes (e.g., /customers, /orders, /orders/{id}), the client sends a single, self‑describing query that specifies exactly which fields it needs and how they should be nested. The server resolves that query and returns a JSON payload with only the requested data.
 +{{ :bw2:graphql.jpg |}}
 +
 +* Enter the following fields:
 +    * Connection Name: provide a unique name (e.g., CountryGraphQLConn).
 +    * Description: an optional short description (e.g., GraphQL Connection for country data).
 +    * EndPoint URI: the full URL endpoint for your GraphQL API (e.g., https://countries.trevorbladed.com).
 +* Add headers (optional).
 +    * Enter the header key (e.g., Authorization)
 +    * Enter the header value (e.g., Bearer<token value>).
 +    * Click Add Header to populate the header in the list
 +    * Repeat for additional headers as needed 
 +* Save your connection.
 +    * Click Save in the Connection Details tab
 +    * Your new GraphQL connection will now appear in the Connections list.
  
 ====== Delete A Global Configuration ====== ====== Delete A Global Configuration ======
Line 262: Line 298:
   - Click [**Close**] to exit without saving any changes.   - Click [**Close**] to exit without saving any changes.
  
 +---- 
 +**[[bizweaver:Home|Home]]**
  
bizweaver/connections.1715795880.txt.gz · Last modified: 2024/05/15 13:58 by dlee