New webbased software
Budget: ₹12,500 – ₹37,500 INR
I am looking for a skilled freelancer to develop a new web-based software that will serve as a graphical reporting tool. The main functionality of the software will be to generate detailed graphical reports for data analysis.
Project Summary:
Core Functionalities:
Data Acquisition:
Fetch data from a web portal using SOAP queries
Connect to multiple external databases (Oracle, MSSQL, MySQL)
Store all retrieved data within a PostgreSQL database
Data Visualization:
Create a web portal to display the stored data
Implement role-based access control (RBAC) for user-specific views and permissions
Technical Stack:
Backend: Python (recommended for SOAP handling and database interactions), Flask (potential web framework)
Database: PostgreSQL
Frontend:
Suggestions: React, Vue.js, Angular (for modern and interactive interfaces), or Django templates (for simpler integration with Flask)
Key Considerations:
SOAP Library: Select a suitable library for SOAP interactions (e.g., Zeep for Python)
Database Connectors: Install appropriate drivers for each external database (e.g., psycopg2 for PostgreSQL, cx_Oracle for Oracle)
User Authentication: Implement a secure authentication mechanism (e.g., Flask-Login)
Authorization: Enforce RBAC using a suitable library or custom logic
Data Visualization Tools: Choose libraries or frameworks that align with frontend choices (e.g., Chart.js, D3.js, or built-in features of React/Vue/Angular)
Additional Considerations:
Error Handling: Implement robust error handling for data retrieval and visualization
Performance Optimization: Consider caching strategies and database optimization techniques
Security: Address potential vulnerabilities in data handling and user access
Testing: Write comprehensive unit and integration tests
Project Summary:
Core Functionalities:
Data Acquisition:
Fetch data from a web portal using SOAP queries
Connect to multiple external databases (Oracle, MSSQL, MySQL)
Store all retrieved data within a PostgreSQL database
Data Visualization:
Create a web portal to display the stored data
Implement role-based access control (RBAC) for user-specific views and permissions
Technical Stack:
Backend: Python (recommended for SOAP handling and database interactions), Flask (potential web framework)
Database: PostgreSQL
Frontend:
Suggestions: React, Vue.js, Angular (for modern and interactive interfaces), or Django templates (for simpler integration with Flask)
Key Considerations:
SOAP Library: Select a suitable library for SOAP interactions (e.g., Zeep for Python)
Database Connectors: Install appropriate drivers for each external database (e.g., psycopg2 for PostgreSQL, cx_Oracle for Oracle)
User Authentication: Implement a secure authentication mechanism (e.g., Flask-Login)
Authorization: Enforce RBAC using a suitable library or custom logic
Data Visualization Tools: Choose libraries or frameworks that align with frontend choices (e.g., Chart.js, D3.js, or built-in features of React/Vue/Angular)
Additional Considerations:
Error Handling: Implement robust error handling for data retrieval and visualization
Performance Optimization: Consider caching strategies and database optimization techniques
Security: Address potential vulnerabilities in data handling and user access
Testing: Write comprehensive unit and integration tests