Skip to main content

Connecting to Databases and APIs

Connecting to Databases and APIs in AutomatR Studio is essential for accessing, retrieving, updating, and manipulating data from external sources. Here's a brief overview of how to connect to databases and APIs in AutomatR Studio:

Connecting to Databases​

  • Database Activities:

    • AutomatR Studio provides a set of database activities that allow you to connect to relational databases such as SQL Server, Oracle, MySQL, and more.

    • Use activities like "Connect," "Execute Function," "Execute Reader," "Execute Non-Query," and "Disconnect" to interact with databases.

  • Connection Strings:

    • To establish a database connection, you'll need to provide a connection string containing details like the database server, credentials, and database name.

    • Store sensitive information securely using AutomatR Orchestrator assets or the Windows Credential Manager.

  • Querying Data:

    • Execute SQL queries to retrieve data from the database. You can use the "Execute Stored Procedure" activity to fetch records and store them in data tables for further processing.

  • Updating Data:

    • Modify data in the database using the "Execute Non-Query" activity. You can execute INSERT, UPDATE, DELETE, and other SQL statements to make changes.

  • Transactions:

    • Implement database transactions to ensure data consistency and integrity. Use the "Start Transaction," "Commit Transaction," and "Roll Back Transaction" activities to manage transactions.

  • Error Handling:

    • Implement error handling mechanisms to address database connection issues, query failures, or constraint violations. Use Try-Catch blocks to manage exceptions.

Connecting to APIs:

  • HTTP Request Activity:

    • Use the HTTP Request activity to make RESTful API calls. This activity allows you to send HTTP requests (POST, GET, DELETE) and retrieve responses.

  • API Authentication:

    • Most APIs require authentication through API keys, OAuth tokens, or username/password combinations. Include authentication details in the request headers or parameters.

  • Data Parsing:

    • Parse API responses, which are usually in JSON or XML format, to extract the relevant data. Use JSON or XML manipulation activities to work with the data.

  • Error Handling:

    • Implement error handling to deal with potential issues when making API calls, such as network errors or authentication failures.

  • Pagination and Rate Limiting:

    • Some APIs employ pagination for large datasets or have rate limits to prevent excessive usage. Implement logic to handle pagination and respect rate limits.

  • API Documentation:

    • Refer to the API's documentation to understand its endpoints, parameters, and response formats. Documentation provides essential information for successful integration.

Connecting to databases and APIs in AutomatR Studio allows you to leverage data from external sources, automate data-driven tasks, and interact with a wide range of software systems and services. This capability enhances the functionality and flexibility of your automation solutions.