7 Low Code Connector

User Manual: Using Low-Code Connectors with Dynamics, SAP, ServiceNow, and Oracle ERP

Introduction

This user manual provides detailed instructions on how to use low-code connectors to integrate with enterprise applications such as Microsoft Dynamics, SAP, ServiceNow, and Oracle ERP. The guide covers setting up connectors, configuring data exchange, and using these integrations within your low-code platform.

Table of Contents

  1. Overview of Low-Code Connectors
  2. Setting Up Connectors
  3. 2.1 Microsoft Dynamics Connector
  4. 2.2 SAP Connector
  5. 2.3 ServiceNow Connector
  6. 2.4 Oracle ERP Connector
  7. Configuring Data Exchange
  8. 3.1 Mapping Data Fields
  9. 3.2 Handling Authentication
  10. 3.3 Error Handling
  11. Using Connectors in Workflows
  12. Best Practices for Integration
  13. Conclusion

1. Overview of Low-Code Connectors

Low-code connectors enable seamless integration between your low-code platform and external enterprise systems like Dynamics, SAP, ServiceNow, and Oracle ERP. These connectors allow you to perform CRUD (Create, Read, Update, Delete) operations, trigger workflows, and automate business processes without the need for extensive coding.

Benefits of Using Low-Code Connectors

  • Rapid Integration: Quickly connect to enterprise systems without custom development.
  • Scalability: Easily scale integrations as your business processes evolve.
  • Consistency: Maintain data consistency across systems through real-time synchronization.
  • Flexibility: Adapt to changing business needs by configuring connectors as required.

2. Setting Up Connectors

2.1 Microsoft Dynamics Connector

Step 1: Install the Connector

  1. Access the Connector Library:
  2. Navigate to the connector library in your low-code platform.

  3. Search for the "Microsoft Dynamics" connector.

  4. Install the Connector:

  5. Click on "Install" or "Add to Project" to include the Dynamics connector in your application.

Step 2: Configure the Connector

  1. Enter Connection Details:

  2. Provide the required connection details, such as the Dynamics instance URL, Client ID, Client Secret, and Tenant ID.

  3. Test the Connection:

  4. Use the "Test Connection" button to verify that the connection to Dynamics is successful.

  5. Save Configuration:

  6. Save the configuration to finalize the setup.

2.2 SAP Connector

Step 1: Install the Connector

  1. Access the Connector Library:

  2. Go to the connector library and search for the "SAP" connector.

  3. Install the Connector:

  4. Add the SAP connector to your project by clicking "Install" or "Add."

Step 2: Configure the Connector

  1. Provide Connection Parameters:

  2. Enter the SAP system URL, Client Number, Username, Password, and any additional required fields.

  3. Set Up Authentication:

  4. Choose the appropriate authentication method (e.g., Basic Authentication, OAuth).

  5. Test the Connection:

  6. Test the connection to ensure it can successfully communicate with your SAP system.

  7. Save the Configuration:

  8. Save the connector settings.

2.3 ServiceNow Connector

Step 1: Install the Connector

  1. Navigate to the Connector Library:

  2. Find the "ServiceNow" connector in the library.

  3. Install the Connector:

  4. Add the ServiceNow connector to your application.

Step 2: Configure the Connector

  1. Enter ServiceNow Instance Details:

  2. Provide the ServiceNow instance URL, Username, and Password or OAuth credentials.

  3. Set Up API Access:

  4. Ensure that API access is enabled in your ServiceNow instance for the provided credentials.

  5. Test and Save:

  6. Test the connection and save the configuration.

2.4 Oracle ERP Connector

Step 1: Install the Connector

  1. Access the Connector Library:

  2. Search for the "Oracle ERP" connector in the library.

  3. Install the Connector:

  4. Click "Install" to add the connector to your project.

Step 2: Configure the Connector

  1. Enter Connection Information:

  2. Provide the Oracle ERP URL, User ID, and Password.

  3. Set Up Authentication:

  4. Choose the relevant authentication method (e.g., Basic Authentication, SSO).

  5. Test and Save:

  6. Test the connection to verify it works correctly, then save the configuration.

3. Configuring Data Exchange

3.1 Mapping Data Fields

  1. Access Data Mapping Tools:

  2. After setting up the connector, open the data mapping tool within your low-code platform.

  3. Select Source and Target Fields:

  4. Choose the source fields from your low-code application and map them to the corresponding target fields in the external system (e.g., Dynamics, SAP).

  5. Set Transformation Rules:

  6. Apply any necessary data transformations (e.g., date formatting, value conversions) to ensure compatibility between systems.

  7. Save Mapping Configuration:

  8. Save the data mapping configuration for future use.

3.2 Handling Authentication

  1. OAuth Setup:

  2. If using OAuth, ensure the authentication flow is correctly configured by registering the application with the external system.

  3. Token Management:

  4. Set up token refresh mechanisms to handle OAuth token expiration automatically.

  5. User Credentials:

  6. Securely store user credentials or API keys, ensuring they are encrypted and managed according to best practices.

3.3 Error Handling

  1. Set Up Error Logging:

  2. Configure logging for any errors that occur during data exchange, such as failed API calls or data validation issues.

  3. Implement Retry Logic:

  4. Define retry policies for transient errors, ensuring the system can recover from temporary issues.

  5. User Notifications:

  6. Set up alerts or notifications to inform users or administrators of any integration errors.

4. Using Connectors in Workflows

  1. Add Connector Actions:

  2. In your workflow designer, add actions that utilize the installed connectors (e.g., Create Record in Dynamics, Update Status in ServiceNow).

  3. Configure Workflow Steps:

  4. Set up each step in the workflow to interact with the external system as needed, such as triggering a data sync or executing a business process.

  5. Conditional Logic:

  6. Implement conditional logic to determine when and how each connector action should be executed based on workflow inputs or external data.

  7. Test the Workflow:

  8. Run the workflow in a test environment to ensure all connector actions are executed correctly and that data flows seamlessly between systems.

5. Best Practices for Integration

  • Use Standardized APIs: Whenever possible, use standardized APIs provided by the external systems to ensure compatibility and future-proofing.
  • Monitor Integration Performance: Regularly monitor the performance of your integrations to identify bottlenecks or failures.
  • Maintain Data Security: Ensure all data exchanged between systems is encrypted, especially when dealing with sensitive or personally identifiable information (PII).
  • Document Integrations: Keep thorough documentation of all connector configurations and data mappings for future reference and troubleshooting.

6. Conclusion

Low-code connectors provide a powerful way to integrate your low-code applications with enterprise systems like Dynamics, SAP, ServiceNow, and Oracle ERP. By following the steps outlined in this manual, you can configure and use these connectors effectively to streamline your business processes, automate tasks, and maintain data consistency across platforms.