Servlets jsp sql sdlcdela
- poslovna inteligenca na Microsoft tehnologij tako on-premise kot v Cloudu - Programski jeziki: DAX, MDX, C#, TSQL, SQL, python, spark
Potrebujemo programerja za občasne dodelave v okolju Microsoft dynamics CRM, office 365 z bazo Microsoft SQL. Plačamo po urnih postavkah.
Izdelava aplikacija (za začetek working verzija - brez avtomatskih in EndToEnd testov) za prikaz: -Drevesnih struktur iz sql tabel -Logiranje -Shranjevanje aktivnosti na drevesnih strukturah -Poročila -Komunikacija med uporabniki Več v priloženem PDFju. Gre za osebni projekt - ne predstavljam podjetja.
...plan as per the agreed concept with timelines Technical Expertise: Strong experience with Microsoft Azure components, including Azure Data Factory, Azure Synapse, Azure SQL Database, Azure Key Vault, MS Fabric, Azure DevOps (ADO), and Virtual Networks (VNets). Expertise in Medallion Architecture for Lakehouses and data modeling in the Gold layer. Solid understanding of Data Warehouse design principles, including star schema, snowflake schema, and data partitioning. Rich Experience with MS SQL Database Packages, Stored procedure, Functions, procedures, Triggers and data transformation activities using SQL Good knowledge in SQL loader, Data pump and Import/Export utilities Knowledge on Performance Tuning Experience with any data visualization or BI tools such a...
I need a Windows Service that synchronizes my complete local SQL database with a remote SQL database in real-time. This should be a two-way synchronization, meaning changes in either database should be reflected in the other.
Those interested in the project must have experience with dolibarr modules, API connections, PHP, SQL. Those who meet the requirements are asked to contact me via chat. We are seeking experienced developers specializing in Dolibarr module creation and ERP system integration to build a custom module that connects Dolibarr with Nexus ERP via API. The goal is to synchronize critical data and streamline collaboration between the two platforms, focusing on efficient management of financial and operational documents. Functional Requirements: Types of Data to be Synchronized: Customer and Supplier Invoices: Retrieve issued and received invoices from Nexus ERP and store them in Dolibarr. Generate invoices in Dolibarr and send them to Nexus ERP. Consumption Vouchers: Import consumption vo...
I'm looking for a seasoned backend developer skilled in , PostgreSQL, MySQL and SQL to collaborate with my frontend developer on a application. Your main task will be working on custom backend services. Experience in building and managing databases is crucial, as is the ability to seamlessly integrate with third-party APIs. Ideal Skills: - Proficient in - Experienced with PostgreSQL, MySQL and SQL - Able to develop custom backend services - Familiar with integrating third-party APIs - Great team player for collaborating with frontend developer
...mobile-first enhancements, or any value-adding capabilities drawn from their experience with similar platforms. Our goal is to create a robust, user-friendly platform that can compete with established P2P exchange services." you can use the following site as example I have other project which we use the following relation between the data in Postgres SQL these projects should be harmonized with the same procedures and structure as following.
...database data, specifically on SQL Server. - The primary goal is to reduce the execution time of this method. - You will be required to assess the load via concurrent requests. Additional Notes: - This is a remote job. No code sharing will occur. Therefore, you must be comfortable working via a remote connection and using any necessary tool. - The task is a quick fix and shouldn't take more than an hour. Please don't overquote, as I will pay per hour within the range of $10-15. - Only individual freelancers will be considered, agencies will not be entertained. Ideal Skills: - Extensive experience with C#, ASP.NET MVC, IIS, and Entity Framework - Strong knowledge of LINQ query generation - Proficient in assessing and handling concurrency - Familiar with SQL Serv...
I'm looking for a programmer with high knowledge of SQL, Access, and ChatGPT to automate our document management processes using n8n. This involves organizing all of our company's documentation into folders automatically based on labels. Key Requirements: - Proficient in n8n for process automation - High level of expertise in SQL and Access - Familiarity with ChatGPT for potential integration - Experience in document management systems - Capable of creating a system for organizing documents by department (Sales and Marketing, HR and Administration, IT and Operations)
I have an existing ERP system utilizing MS SQL as the database engine and Microsoft Access as the frontend. We're looking to transition this to a web application built on ASP.NET. This will be a phased migration, implementing functionalities from the old frontend to the new one step by step. The first task in this migration is to rebuild the picking system, which is responsible for preparing orders from the warehouse. The current picking system includes: - Inventory Management: Keeping track of stock levels and warehouse layout. - Barcode Scanning: Utilizing barcodes for tracking items and improving efficiency. In terms of user authentication, we prefer a standard Username and Password system for the new application. As for user roles and permissions, we will require: - Cus...
...programs on Microsoft Azure data services, including Azure Data Factory, Azure Databricks, Azure SQL Database, and Azure Synapse Analytics. Develop course materials, hands-on labs, and tutorials tailored to various skill levels. Stay updated with the latest Azure data engineering developments to keep training content current. Assess learners' knowledge and provide constructive feedback to facilitate improvement. Offer individualized mentorship to address learners' specific needs. Prepare learners for certifications, such as Microsoft Azure Data Engineer Associate. Candidate Qualifications: Proven experience as an Azure Data Engineer or in a similar role. Proficiency in Azure data services like Azure SQL Data Warehouse, Data Factory, Data Lakes, HDInsight, and St...
I am looking for an expert in Elastic Search or TypeSense to improve the search functionality within my database. The primary goal of this project is to enhance the way we search through our dat...goal of this project is to enhance the way we search through our database records. Key Requirements: - Deep knowledge and experience with Elastic Search or TypeSense. - Proven track record of improving search functionality within databases. - Ability to understand and work with database records. - Strong problem-solving skills and attention to detail. Ideal Skills: - Elastic Search - TypeSense - SQL - Database Management - Search Functionality Improvement Your expertise will play a key role in making our database search more efficient and effective. Looking forward to your insightful ...
Hello, I am seeking a skilled freelancer to assist with the repair and import of a corrupted SQL Server file. Here's the situation: I accidentally deleted both the MDF and BAK files from our disk, and unfortunately, the file structure cannot be recreated. Using a hexadecimal editor, I managed to locate four MDF files, but I am uncertain which one contains the correct data. After some repairs, I believe one file might have the data I need. My primary interest is in recovering data from a specific period, which I couldn't retrieve using automated repair methods. Due to the size of the file, I require you to work directly on our system remotely.
...page-id=84%3A1486&node-id=149-2579&node-type=canvas&viewport=238%2C173%2C0.02&t=rYA2znUGosArvFcq-1&scaling=scale-down&content-scaling=fixed&starting-point-node-id=149%3A2579&show-proto-sidebar=1 Key Requirements: - All components from the old site must be retained and linked to the same DB, but with a new identity. - The design must be compatible with the Figma design and implemented using .NET framework 8, SQL server DB, JavaScript, and AJAX (in search). - Two language versions are required: Arabic and English. - All website functionalities need to remain unchanged, including user authentication, data reporting, real-time updates, and all existing links and data. Some links should be editable from the control panel to open external links ; So you...
I'm seeking a skilled SQL developer with a deep understanding of manufacturing business logic, specifically in production scheduling within the chip industry. Your role will involve: - Assisting in the creation of a production scheduling system aimed at optimizing resource usage, primarily raw materials and machinery. - Providing guidance based on your knowledge of the chip manufacturing business. Ideal candidates will have substantial experience in SQL development and a strong background in the manufacturing sector, particularly with chip production. Your expertise will be pivotal in enhancing the efficiency of our operations.
I'm in need of a Power BI dashboard designed specifically for monitoring operational efficiency, with a focus on resource utilization. The dashboard needs to connect to a SQL database for data retrieval and analysis. Key Requirements: - Design a Power BI dashboard tailored for operational efficiency monitoring - Focus on tracking resource utilization metrics - Connect and retrieve data from a SQL database Ideal Skills and Experience: - Proficient in Power BI - Experience in designing operational efficiency dashboards - Familiarity with SQL database Please provide examples of similar projects you've completed, along with your proposed timeline for delivering this dashboard.
I'm in need of a seasoned SQL DBA to help with my MySQL database. The primary focus will be on optimizing the database for efficient queries, ensuring top-notch security measures are in place, and overseeing data backup and restoration processes. Ideal Skills: - Extensive experience with MySQL - Strong understanding of database optimization techniques - Expertise in database security protocols - Proficiency in data backup and restoration procedures - Excellent skills in query optimization
Write code to retreive data from SQL Server and other apps
...S3. • SQL databases for financial transactions. 3. Backups: • Daily and weekly data backups. Integration and Flexibility: 1. Integration with Platforms: • WooCommerce, Shopify, Magento. And all online stores • Connecting using API and Keys. 2. User Interface: • Comprehensive analytics interface to monitor sales. • Display data on web and mobile applications. • Dark Mode. Additional features: • Classification of transactions according to risk levels. 2. Alerts and notifications: • Instant mobile notifications. • Login alerts from new locations with display of connected devices. 3. Innovative features: • Payment using NFC. • Support for virtual currencies for payment. • OCR for document verification. Target groups...
I'm in need of a database. Specifics have not been finalized, and I'm open to suggestions. Your expertise in the field will be invaluable in determining the best approach. Skills and Experience Required: - Proficient in various database management systems (DBMS) - Strong understanding of both relational (SQL) and NoSQL databases - Experience in creating databases for diverse applications - Excellent problem-solving skills to determine optimal database structure - Able to communicate complex technical concepts in simple terms
I'm seeking a seasoned Power BI professional to craft a thorough sales performance report. Key Responsibilities: - Extract data from SQL databases to analyze sales performance - Create a variety of visual representations of the sales data - Compile detailed tables for in-depth data breakdowns Ideal Candidate: - Proficient in Power BI and SQL - Skilled in creating comprehensive and insightful reports - Strong background in data analysis and visualization, particularly in sales Please note, specific sales metrics and types of visualizations will be discussed in detail with the selected freelancer. The frequency of report updates will also be determined at that time.
I'm looking for a freelancer who can export my SQL database to an Excel file. The project involves exporting all tables from the database. Ideal Skills: - Proficient in SQL - Experienced in data export and manipulation - Skilled in Excel Please ensure that the data is accurately transferred and well-organized within the Excel file.
I am looking for an experienced Power BI professional to develop a comprehensive report for me. The report will primarily focus on analyzing sales performance. Key Requirements: - Proficient in Power BI - Experience with SQL databases - Ability to create detailed and insightful reports The report will source data from SQL databases and will include: - Various visualizations to represent sales data - Tables for detailed breakdowns of the data If you have a strong background in data analysis and visualization, particularly in relation to sales performance, I would love to hear from you.
I'm looking for a skilled developer to create a hybrid customer database on my website. This will include a secure login system, payment options, and a user-friendly interface. Key Requirements: - Design and implement a hybrid (SQL & NoSQL) customer database - Incorporate a secure 'Email and Password' login system - Implement payment options: Credit/Debit Card and PayPal - Ensure the system is user-friendly and secure Ideal skills for the job: - Proficiency in SQL and NoSQL databases - Experience in website security and payment integration - Strong understanding of user interface design - Ability to deliver a project on time and within budget I uploaded the photo underneath. look forward to your bids.
I'm looking for a talented full-stack developer to help with my website project. Ideal Skills: - Proficiency in both front-end (HTML, CSS, JavaScript) and back-end (Node.js, Ruby, Python, PHP) technologies. - Experience with responsive design and mobile-first approach. - Familiarity with database management (SQL, MongoDB). Experience: - Previous work on website development. - Proven track record of delivering quality work on time. Please note, the purpose and design style of the website have not been determined yet, so flexibility and creativity are key.
Customized Form in PHP with Secure SQL Database including online deployment We are seeking to develop a aesthetically pleasing, and secure web-based form integrated with a SQL database. This form will facilitate and receive applications for a monthly token draw for 10,000 lucky users, each winning 1,000 tokens(Max application per month 1 Million). Selection of winners will be taken care separately and is not part of the project. The project requirements are as follows: User Authentication and Entry Implement Telegram API integration for user login, ensuring unique entries. Display the current draw month prominently after login, e.g. Heading, " Draw for the month of January 2025." Prevent multiple entries: Check if the user has already submitted an entry for th...
Full Stack Developer (PHP Reskin & Customization) Project Overview: We are seeking a skilled and experienced Full Stack Develop...Assist with any future updates or modifications. Required Skills: * Strong proficiency in PHP: Extensive experience with PHP frameworks: Php curl (e.g., Laravel, CodeIgniter, Symfony) is highly preferred. * Frontend Development: In-depth knowledge of HTML, CSS, and JavaScript. Experience with front-end frameworks (e.g., React, Angular, Vue.js) is a plus. * Database Management: Proficiency in SQL and experience with relational databases (e.g., MySQL, PostgreSQL). * UI/UX Design: Understanding of design principles and ability to create visually appealing and user-friendly interfaces. * Version Control: Experience with Git and collaborative developm...
I'm in need of an experienced web developer who can create a dynamic website powered by an SQL database. The frontend of the website is to be built using Angular, so proficiency in this technology is crucial. Key aspects of the project: - Develop a website with a robust SQL database - Utilize Angular for the frontend - Implement secure user authentication Ideal skills for this job would include extensive knowledge of SQL, Angular, and web security protocols. Previous experience in developing database-driven websites and implementing user authentication systems is highly valued.
I need a seasoned Python developer who can modify an existing script for me. The script currently updates a MySQL database and needs to be changed to update a Microsoft SQL Server (MSSQL) database instead. The challenge is that the column names in these two databases are different, so the freelancer will need to implement data transformation as part of this task. Key Requirements: - Update the database connection in the script to point to an MSSQL server - Implement necessary data transformations to accommodate different column names - Ensure that the script can handle potential errors during the data transfer process - fix one or 2 existing updating error Ideal Skills: - Proficiency in Python - Strong understanding of MySQL and MSSQL - Experience with data transformation and erro...
I'm looking for an experienced developer to create a robust CRM backend. The successful candidate should have a strong background in Golang, working with PostgreSQL, and be adept at CI/CD processes and Github branch merging. Key features: - Comprehensive...and Github branch merging. Key features: - Comprehensive user management system - Detailed sales tracking - Advanced reporting and analytics capabilities The reporting and analytics component will need to track: - Sales performance - Customer behavior - Operational efficiency - User engagements These reports will need to be generated daily. Ideal candidates should be proficient in: - Postgres SQL - CI/CD - Github Experience with CRM development is a significant advantage. Please include any relevant examples of your wo...
I'm looking for an experienced Laravel developer to assist with a web application project. The ideal candidate will have a strong understanding of PHP and SQL, given that we're working with an existing database schema. Key Requirements: - Proficient in Laravel - Strong PHP and SQL skills - Experience with web application development Nice to Have: - Knowledge of data visualization techniques - Experience with user authentication systems - Familiarity with file upload/download functionality
...extension enabled. The tooltip data will be stored in a SQL remote database and you'll be responsible for writing the code for the extension and connecting the database. Key Requirements: - Develop a Chrome extension that can display tooltips on a website. - Create functionality for an admin to generate tooltips. - Connect the extension to a SQL remote database to store the tooltip data. - Implement user authentication for admins using Email and Password. - Ensure the extension is accessible for all visitors to the site with it enabled. The UI design for the extension will be provided. The ideal candidate for this project will have: - Proven experience in developing Chrome extensions. - Strong skills in database management, particularly SQL. - Experience wit...
...conferencing integrations (e.g., Zoom, , or Jitsi) for live and recorded sessions. Third-party API integrations for career platforms (e.g., LinkedIn) and learning module providers. Features such as real-time messaging, scheduling tools, user authentication, multi-language support, and analytics dashboards. We expect the development process to adhere to standard Software Development Life Cycle (SDLC) practices, delivering a secure, scalable, and GDPR-compliant platform. The deliverables should include comprehensive documentation for the codebase, workflows, and API integrations, along with testing and debugging to ensure a high-quality product. Since we already have the base code, the initial engagement will focus on enhancing it with the required features. We request a one-time ...
...middleware API in PHP or a similar technology to facilitate data entry and retrieval from a locally installed SQL Server Database via an Android app. Key Requirements: - API Development: You will be responsible for creating approximately 4 APIs, including one for user login and authentication. - Database Interaction: The Android app will require seamless interaction with the SQL Server Database for data entry and retrieval. - Database Schema: Some tables for user authentication are already designed, but you will need to assist in completing the database schema. Ideal Candidate: - Proficient in PHP or similar technologies. - Extensive experience in API development. - Familiarity with SQL Server Database. - Able to assist in database schema design. Your understandi...
...budgets. - Assign tasks, track progress, and ensure project goals are met. - Coordinate with team members and oversee development tasks. 4. Quality Assurance: - Conduct thorough testing of the website, identifying and documenting bugs and issues. - Collaborate with the development team to resolve and test bug fixes and improvements. 5. Database Management (SQL): - Design, optimize, and manage the website's SQL database system (e.g., MySQL). - Ensure data security, backups, and efficient data retrieval. 6. Security Implementation: - Implement security measures to protect user data and ensure a safe user experience. - Stay updated on security best practices and address vulnerabilities proactively. 7. AWS Services: - Utilize AWS (Amazon Web...
I need a proof of concept (PoC) on Microsoft Fabric data ingestion/engineering. The PoC should be visually represented through slides and Visio diagrams. The project involves ingesting data from Snowflake and Azure SQL Server into MS Fabric, performing transformations, and provisioning data for end users. Key Aspects to Cover: - Data Ingestion: Demonstrating how data is sourced and imported into the system. - Data Transformation: Illustrating the processes and techniques used to manipulate the data. - Data Provisioning: Showcasing how the processed data is made available to end users. Visual Elements: The proof of concept slides should include: - Data Flow Diagrams: Depicting the journey of data throughout the system. - Process Flowcharts: Outlining the sequence of processes invol...
I'm looking for a seasoned developer to create a simple and clean web application using C# and Blazor, integrated with an existing Azure SQL database via ASP.NET and Entity Framework. Key Requirements: - The web application should primarily handle data entry and management. - A straightforward user interface that is simple and clean. Essential Skills: - Proficiency in C#, Blazor, ASP.NET, and Entity Framework. - Experience with Azure SQL databases. - Ability to create simple and clean user interfaces. The project does not require advanced data validation or error handling, just basic validation. We have a working design (rough) to use as a design brief.
...Azure data services, including Azure Data Factory, Azure Databricks, Azure SQL Database, and Azure Synapse Analytics. Develop course materials, hands-on labs, and tutorials tailored to various skill levels. Stay updated with the latest developments in Azure data engineering to ensure training content is current. Assess learners' knowledge and provide constructive feedback to facilitate improvement. Offer individualized instruction and mentorship based on learners' specific needs. Prepare learners for Microsoft Azure certifications, such as the Azure Data Engineer Associate. Qualifications: Proven experience as an Azure Data Engineer or similar role. Proficiency in Azure data services and platforms, including Azure SQL Data Warehouse, Data Factory, Data Lakes, HD...
Looking for a Developer We are seeking a skilled programmer with expertise in Ionic, Node.js, and SQL to help us enhance our existing application. The app is already developed and fully functional, but we need to implement the following features: 1. Multi-language support: Add the ability to switch between different languages throughout the app. 2. Chat translation: Integrate a system to automatically translate chat messages into multiple languages in real time. If you have experience in these technologies and are ready to contribute to a growing project, please reach out to us with your portfolio or previous work.
I'm in need of a reliable freelancer skilled in Excel and SQL database management. Key Responsibilities: - Regular data entry and updating in Excel. - Managing and maintaining a SQL database. Ideal Skills: - Proficiency in Excel for data entry and updating. - Experience with SQL database management. - Attention to detail for accurate data handling.
...Development =============================================== I'm looking to build a comprehensive, highly interactive responsive dashboard that reflects approximately 350 main indicators (with about 1000 sub indicators), along with their associated details like name, definition, source, and comparative values over multiple years. Key features of the project include: - Building the dashboard on a SQL server DB, with provided design and data. - Using DONT net framework 8, JavaScript, AJAX, and , without the use of BI tools. - We need use free GIS tools to show indicators on the map - Ensuring high performance and an excellent interface focused on superior UI/UX. - Creating multiple models based on available indicator data. - Allowing user interaction to select sectors, indica...
... users. 3.4 Technical Requirements: - Platform: Web application developed using modern technologies (e.g. React.js for frontend, Node.js for backend). - Database: A relational DBMS (e.g. PostgreSQL) to store user, product, and transaction information. - Hosting: Scalable cloud server (e.g. AWS, DigitalOcean). - Security: SSL certificate for data protection, measures to prevent SQL injection, XSS attacks and other vulnerabilities. - Performance: Optimize page loading, use CDN for static content, cache frequently requested data. 4. Examples: - Source: - Sample pages: - Home page with current auctions. - Product Category Page. - Product page with detailed description and the ability to bid. - Registration/Authorization page. -
I need a Code Igniter 1.1 application, currently on Windows 10 with IIS, to be migrated to a cPanel with Linux. The application is using PHP v7.0 with Microsoft SQL Server. We need to switch it over a Linux VM (will be provided from our side) and configured to run with SQL Server. The application uses a load balancer which will remain as it is and should be able to work with Linux without any changes.
...de una persona crítica, atenta al detalle, con gran habilidad de comunicación y muchas ganas de aprender. No importa si nunca ha trabajado como tester. Habilidades Técnicas 1. *Conocimientos Básicos de Testing*: - Conocimiento de los conceptos fundamentales de pruebas de software (unitarias, funcionales, regresión, etc.). - Familiaridad con el ciclo de vida del desarrollo de software (SDLC) y el ciclo de vida de pruebas (STLC). 2. *Herramientas de Gestión de Pruebas*: - Experiencia básica en herramientas como JIRA, TestRail, o cualquier otra herramienta de gestión de casos de prueba. 3. *Entendimiento de Documentación*: - Capacidad para entender y crear documentación de pruebas, como planes de...
I'm seeking a T-SQL specialist with a deep understanding of SQL Server. Your role will primarily involve optimizing and tuning an existing database. Key Responsibilities: - Performance tuning and optimization of the current database. - Manipulating and transforming data, leveraging your expertise in SQL, XML, and JSON. Ideal Skills: - Extensive experience with SQL Server and T-SQL. - Extensive experience with XML and JSON data. - SQL DBA skills are a plus. - MySQL knowledge could be useful at a later date but not for this task. Please note, if your primary response includes web development, web design, or full stack development, your response will be deleted.
Project Objective: The goal is to develop a comprehensive Azure-based infrastructure that processes and visualizes data using our existing Python and SQL assets. The system must ensure automation, security, scalability, and stability while seamlessly integrating with the our website. Current Status Existing Resources: - SQL Database is created and mapped; all datatypes were harmonized. - All required Python and SQL scripts have been developed and tested locally. - An Azure workspace has been created to host the infrastructure. Infrastructure Capabilities Required: 1. Data Ingestion The infrastructure must support both scheduled and event-driven batch data ingestion from multiple APIs and other external sources. The ingested data is supposed to be parsed and transfo...
I'm looking for a Windows program that can download data from the 'Individuals' sheet of the provided ODS file link and replace this data in a SQL Server 2019 table with compatible fields. The program should execute this process daily at 06:00 am. Key Requirements: - Windows based program - Data download from the specified ODS file - Data replacement in SQL Server 2019 - Daily automation at 06:00 am - No notifications after data processing - No logging required
...skilled developer well-versed in React, Node JS, and SQL to assist in finalizing a project that's mostly complete. The primary tasks will include integrating some missing functionality, conducting thorough testing, and constructing a few additional pages. Key Responsibilities: - Incorporate missing elements into the project, with a focus on enhancing filters and overall usability. - Implement specific filters: Date range filters, Category filters, and Custom keyword filters. - Test existing features to ensure optimal performance and reliability. - Build new pages as per project specifications. We'll discuss the entire project specification in detail over Teams or Zoom. Ideal candidates should have: - Proven experience in React, Node JS, and SQL - Ability to in...
...authentication and restricted access. Scrape data from three specified websites, utilizing anticaptcha to bypass CAPTCHA requirements. Integrate uploaded files from an online consultation system. Enable the generation and downloading of PDF reports directly from the dashboard. Perform data processing and analysis, displaying insights and trends in an intuitive format. 2. Required Skills: Proficiency in SQL for database management and queries. Expertise in web development (front-end and back-end). Strong experience with web scraping tools and techniques, including handling CAPTCHA systems (e.g., anticaptcha). Knowledge of data analysis and visualization. 3. Preferred Qualifications: Familiarity with Python, Selenium, or similar tools for web scraping. Experience in creating da...