Connectors for Analytics and RPA

Unimate robots can be connected to various data sources and systems through multiple integration technologies. The available options are listed below:

Databases

Unimate can interact with various databases using different Python libraries:

  • PostgreSQL: psycopg2, asyncpg

  • MySQL/MariaDB: mysql-connector-python, PyMySQL

  • SQL Server: pyodbc, pymssql

  • Oracle: cx_Oracle

  • SQLite: sqlite3

  • MongoDB (NoSQL): pymongo

APIs and Web Services

To interact with web applications and REST/SOAP services, you can use:

  • REST API: requests, httpx

  • GraphQL: gql

  • SOAP Web Services: soap

  • WebSockets: websockets

Windows Applications

Robots can automate processes in Windows environments by:

  • UI automation: pywinauto, pyautogui

  • PowerShell: subprocess to execute scripts

  • Excel/Word: openpyxl, win32com.client

Enterprise Systems

To integrate with large-scale corporate systems:

  • SAP: PyRFC, SAPNWRFC

  • SAP Business One: python-sapb1, sapy

  • AS/400 (IBM i): pyodbc, jt400

  • ERP and CRM: OData, pyodbc, requests

Web Page Automation

Robots can interact with web pages and browser-based applications using:

  • Selenium: selenium (for interaction with browsers)

  • Playwright: playwright (for quick testing and automation)

  • BeautifulSoup: beautifulsoup4 (for HTML data extraction)

  • Scrapy: scrapy (para scraping avanzado)

Files and Documents

Structured and unstructured file handling:

  • Excel: pandas, openpyxl, xlrd

  • CSV: pandas, csv

  • PDF: PyPDF2, pdfplumber

  • TXT/JSON/XML: json, xml.etree.ElementTree

Cloud Services

Connection with cloud providers for storage and processing:

  • Azure: azure-storage-blob, azure-mgmt-compute

  • AWS: boto3

  • Google Cloud: google-cloud-storage, google-cloud-bigquery

Email Connectors

For sending and receiving e-mails, Unimate can use:

  • SMTP (standard outgoing mail): smtplib

  • IMAP (standard incoming mail): imaplib

  • Gmail API: google-auth, google-api-python-client

  • Microsoft Exchange y Office 365: exchangelib

  • Outlook (local y online): win32com.client

These connectors allow Unimate to automate processes in multiple environments, optimizing data integration and manipulation.