Sql server 2008 etl työt

Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.

Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). -------...

Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.

Eminent Minds Technologies Pvt Ltd,( ISO 9001-2008 Certified Company)

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS

server optimisation

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ŠŠ ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

...and analysis, within a short timeframe. - Entity-Relationship Modeling: Develop and finalize a comprehensive ER diagram that illustrates the database structure and supports urgent marketing analytics requirements. - Efficient Data Export and ETL Processes: Set up and manage the rapid export of data from various platforms using APIs. Develop and implement ETL (Extract, Transform, Load) processes to clean, transform, and load data into the database swiftly. - Documentation: Produce concise and clear documentation on the data architecture, ER diagrams, and ETL processes to support ongoing maintenance and scalability. - Collaborative and Rapid Execution: Work closely with the project manager and other team members to ensure alignment of the database design with business...

Hello! I'm looking for an experienced Person who can build the mobile device management (MDM) Server for iPhone device. Specifically, I need someone with expertise who can create a custom MDM solution. This solution must be capable of advanced user access control, including full control of devices, remote wipe capabilities, and more. The MDM functionality I need is for iPhone device enrollment and management. I do not have an existing solution that needs to be integrated, so will require a new solution to be built from scratch. Before showing interest on this job, Please read the below link and then you can bid for this job FYI: The ideal candidate has extensive experience developing mobile device management

I'm currently experiencing a peculiar issue on my CentOS server. The process /usr/sbin/mariadbd is showing 109% CPU usage in the WHM task manager, although the server load is stable and I haven't made any recent changes. Your primary task would be to diagnose and resolve this problem. No error messages or warning signs have appeared, making the source of the issue somewhat inscrutable. Access will be provided via AnyDesk or a remote desktop connection for swift and efficient troubleshooting. Your expertise in the following areas would be invaluable: - Proficiency in CentOS server administration - Expertise in WHM and server task management - Experience in identifying and resolving high CPU usage issues - Strong communication skills to work collab...

I'm seeking an experienced .NET developer with over 4 years of expertise in C# programming and SQL databases. Key Responsibilities: - Enhancing existing software application - Adding new functionalities The ideal candidate should possess: - Strong experience in C# programming - Solid knowledge and practical experience with SQL databases Be ready to dive into the project and help us bring significant functionality enhancements to our existing software. Your experience and skills in C# and SQL will be invaluable in this task.

I need a talented VB.net developer with a strong background in SQL Server. Key Responsibilities: - Develop software applications using VB.net - Efficiently manage databases - Designing, coding, testing, and debugging software applications using VB.NET. - Calling third-party API - Payment gateway integration - Stored Procedure Ideal Candidate: - Proven experience in VB.net development - Strong familiarity with SQL Server - Good problem-solving skills - Ability to work independently and meet deadlines. Please provide relevant work samples in VB.net development and describe your experience with SQL Server.

I'm looking for an experienced server administrator to optimize my dedicated server running Almalinux 9.3 + Plesk. The server is currently performing poorly with slow website loading times and database slowdowns, which is unacceptable as I regularly have more than 500 concurrent visitors. The primary focus of this project will be optimizing the server's Plesk settings, Postgres and MariaDB databases, and PHP 8.2 configuration. Key tasks will include, but are not limited to: - Configuring Plesk for optimal performance, including adjusting server pool size - Identifying and implementing improvements to Postgres and MariaDB settings to reduce slowdowns - Tuning PHP 8.2 to enhance website speed and performance Ideal candidates for this project will ha...

I'm searching urgently for an experienced PHP architect who can const...items. - Integrating an 'Add to cart and checkout' feature ensuring a simple and smooth transaction process. - Developing order management and inventory tracking system within the admin panel to help me keep track of orders and product stocks. Skills and Experience Required: - Proficient in PHP programming - Experience in developing e-commerce websites - Solid understanding of databases and SQL - Familiarity with different payment solutions Although there is no specific requirement for payment method integration at the moment, the ability to seamlessly add these in the future is essential. My project requires immediate attention and the chosen freelancer needs to be able to commit and delive...

I was utilizing a server running Alamlinux9.3 with Virtualizor for my virtualization needs. However, after a recent reboot, the server failed to start up properly. Despite troubleshooting attempts, the system remains inaccessible. The datacenter has provided access to the server via sysrcd (SystemRescueCd), but I lack the expertise to efficiently recover the system and get it operational again. I am seeking assistance from experienced system administrators or IT professionals who have expertise in Alamlinux, Virtualizor, and system recovery. The goal is to diagnose the issue, recover the system, and ensure it is functioning correctly. Tasks: Diagnose the cause of the server failure after reboot. Implement necessary steps to recover the Alamlinux9.3 system. E...

I am seeking an expert in AWS servers, particularly in the problem-solving aspect of EC2 instances. Key tasks to be performed: - Diagnose the specific issues of the server - Suggest and implement suitable solutions to rectify the problems - Maintain and improve server performance Ideal Expertise and Skills: - Strong technical skills and deep understanding of AWS, specifically EC2 instances - Proven track record in handling server emergencies and solving server issues - Competence in developing and maintaining customer-focused, high-performance AWS infrastructure - Proficient with best practices in ensuring server security

I urgently need an expert in Linux and Nginx who can help me: - Configure my Nginx server - Optimize server The ideal candidate should have: - Extensive experience with Nginx and Linux - Excellent troubleshooting and problem-solving Time is of the essence, so please get in touch if you can jump straight into action. Ubuntu Nginx

...VPN/Internet gateway solution. This project involves building server software capable of authenticating client connections and providing access to the internet. Requirements: Master's degree or PhD in Computer Science, Cybersecurity, or a related field Extensive experience in internet security, privacy, and VPN technologies Strong proficiency in server-side software development Familiarity with OpenWrt and router firmware development (preferred) Passion for internet security and privacy Responsibilities: Develop robust Wireguard exit nodes and VPN server software Ensure seamless integration with existing client software and VPN router firmware Implement secure authentication mechanisms for client connections Design scalable server architecture for hos...

I am looking for an expert in RFID technology and .NET programming to integrate the RFID into our current weighbridge system. Key Details: - 3rd Party System was developed using .NET and it does support API or external interface connections. - The task will involve programming to fully integrate the system with RFID technology. Skills and Experience: - Proficiency in .NET programming & SQL Database - Previous experience with RFID technology - Knowledge of API integration - Experience with weighbridge systems would be a huge advantage. Your role will be to ensure the smooth functioning of the weighbridge system post-integration and provide us with a user-friendly, effective RFID solution.

...*** I'm facing significant challenges with my WooCommerce website's performance. Here's what I'm experiencing: - Slow page loading - High server load - Database query delays Although I’m already employing caching plugins and techniques for performance optimization, the difficulties persist. My WooCommerce site is hosted on a VPS/Dedicated hosting package. I'm in need of a WooCommerce expert who has significant experience in performance optimization, handling high server loads, and reducing database query delays. The ideal candidate should have: - Proven experience in troubleshooting and improving WooCommerce site performance - Strong knowledge of server management, particularly VPS/Dedicated hosting - Expertise in database managem...

• Experience with Testing tools Experienced using SQL Advanced experience developing test metrics and reports Experience with Automated Testing Five (5) • years of Testing experience in a Software Development Lifecycle environment Five (5) • SQL and PLSQL Programming in SQL Server ETL and Data warehouse process Informatica 10 • 20 Informatica Data Quality Profiles , Score Cards SQL Server RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication Skills and Quick Lea...

...js application. These include improper error handling, server banner disclosure, and misconfigured CORS. Requirements: - Identify and rectify improper error handling, ensuring that user-friendly error messages are displayed and errors are logged for debugging purposes. - Address server banner disclosure, to enhance the security of the application. - Modify CORS configuration to prevent misconfigurations and enhance security measures. I am looking for an expert who is well-versed in AWS, particularly in working with applications. The ideal freelancer for this job should have: - A thorough understanding of AWS services and its integration with Next.js. - Proficiency in addressing security vulnerabilities, in particular server banner disclosure and CORS misconfig...

I am looking for an experienced developer that have worked on the signal messenger app to rebrand the app change icons and colours. We need installation on our amazon instance signal server and included all required backed services database etc. and publish application with custom icon colours and icons markets google and apple. you can look signal application

We are currently struggling with our WordPress site which is plagued by slow loading times, frequent server crashes and persistent error messages. Given the criticality of the platform, We need an expert who is adept in Internet Information Services (IIS) server management running WordPress environment and troubleshooting it at server level. To be successful in this role, you should demonstrate the following: - In-depth knowledge of IIS servers and WordPress operations - Proven experience in diagnosing and resolving server and website errors - Proficiency in optimizing WordPress sites for enhanced performance Please note, no recent changes or updates have been made to the website or server configuration that could be contributing to these issue. I...

I'm in need of an expert who can help in developing a relational database using SQL and Python. The project will primarily revolve around database management. Consequently, I would appreciate assistance in the following tasks: - Designing a new relational database, ensuring it's optimized for efficiency and performance. - Implementing data import and export capabilities for seamless data movement. - Developing queries to support the database's functionality and ease of use. The ideal candidate for this project should have a strong background in both SQL and Python, with a specific focus on database development. Experience with optimizing databases for performance and some knowledge of data import/export mechanisms would be advantageous. Moreover, an understan...

I'm in need of an expert developer with a keen understanding of PHP, Heroku, and Shopify. This project entails the deployment of a Heroku server where my API key will be secure and stored in an environment variable. You'll also need to utilize this Heroku-based API key on my Shopify platform to access and display user data through API calls. Ideal Skillset and Experience Required: - Proficiency in PHP - Expertise in deploying and managing Heroku servers - Understands how to secure API keys on Heroku - Experience with Shopify API integration and displaying data.

Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.

...Predictive Analytics functionalities. Key Requirements: - Proven experience in implementing AI features in Power BI is a must. - Strong background in Natural Language Processing, Machine Learning Models, and Predictive Analytics. - Proficient in working with SQL databases and Online APIs for data integration. - Ability to deliver a dashboard with basic filtering and sorting capabilities. Your main tasks will include: - Integrating the AI functionalities into the Power BI project. - Ensuring seamless communication between Power BI and the SQL databases, Online APIs. - Implementing a user-friendly interface with basic filtering and sorting options. If you are confident in your Power BI and AI skills, and have the technical expertise to deliver such a project, I would love...

More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Past work How soon do you need your project completed? ASAP

...Current website is very slow and couldn't take a back up using updraftplus plugin I need all files and Database copying to new server and testing that it function OK I am in need of a specialist with broad experience in WordPress platform to move my website from its current location to a Virtual Private Server (VPS). Requirements: - Comprehensive knowledge of WordPress site architecture and components. - Extensive experience in website server migration, particularly to VPS hosting. - Ability to ensure that no data is lost during the migration process. - Skilled in backup creation and restoration. - Familiarity with DNS and IP configurations for the new server. The task must be completed with minimal downtime and no loss of data/functionality. Please...

...bring Arthwise to life! This isn't your typical job post – it's more of a collaborative side hustle. We'll be building something together that has the potential to change the game in the finance world. What I'm Looking For: Someone who's passionate about building scalable applications. Experience with backend development, RESTful APIs, and microservices. Familiarity with database management (SQL/NOSQL) and cloud services. A creative problem solver with a knack for turning ideas into reality. What You'll Do: Set up the backend architecture. Implement core and advance functionalities. Database Management Monitoring and Performance Optimization and much more If you're up for the challenge and want to be part of something special, let&#...

...JavaScript, and PL-SQL, as well as familiar with Oracle Database, PL-SQL Developer, Oracle SQL Developer, Eclipse. The project involves writing comprehensive tests for a range of technologies including: - Java and JavaScript. - Spring Framework. - Oracle Database. - XML and JSON. - Junit. - Eclipse/Intellij. - PL-SQL Developer. - Utilizing Github and other version control tools. The ideal candidate must have a deep understanding and practical experience with these technologies. The project has an urgent timeline, so the selected candidate must be able to work under pressure and deliver high-quality results quickly. Ideal Skills: - Proficient in Java, Spring Framework, Oracle, XML, JSON, Junit, and JavaScript. - Experienced with Eclipse/Intellij, PL-SQL...

I need an experienced server administrator to assist me in setting up a domain remotely. he should have some experience with Digital Ocean and Linux server setups The ideal freelancer for this project should have experience in: - Setting up Linux servers, particularly on Digital Ocean - Proficiency in configuring and managing Ubuntu - Experience with Nginx web server software - Understanding of web hosting best practices and security measures - Strong troubleshooting skills in case of any issues. Please note that the server will be used for hosting a website, so it should be optimized for performance and security.

I want a Linux Ubuntu 24.02 expert who knows multiple domain handling on the server. I already created a .conf file but respective subdomain is redirecting to another website than required.

I am in need of a well-versed Python expert to assist in managing a Linux server. This project is task oriented and requires specific skills including: • Working with server data analysis • Implementing web scraping techniques • Establishing automation processes The role also demands a comprehensive understanding of Linux operations and the ability to print headers. A background in server security, setting up database servers and performance optimization would be ideal, but the focus is primarily on Linux server management via Python. Proficiency in Python, Linux, server data analysis and web scraping are must-haves. Experience in automation and server management will highly be appreciated. Looking forward to your knowledgeable a...

I'm currently seeking a skilled backend developer who has proven expertise in Python, Java, and Ruby. I need someone who can guide me through whether to use the current source code or start from scratch, a decision that we can make together as the project evolves. As our project's main responsibility is to handle authentication and server configuration, the perfect candidate should be experienced in: - Setting up, managing, and sustaining server configurations - Handling various authentication tasks - Expertise in Python, Java, and Ruby - Decision-making skills concerning source code development This project will be rewarding for someone who enjoys tackling unique challenges and has a flair for problem-solving. If you're up to the task, please don’t ...

I am currently ...currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completion. I need this...

...for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies...

I'm looking to set up a Minecraft 1.16 server focused on mini-games. Initially, I'd need 4-6 mini-games to be developed. Key Responsibilities: - Configure and set up a Minecraft 1.16 server - Design and implement 4-6 engaging mini-games - Ensure the server's smooth running and performance Ideal Skills: - Proficiency in Minecraft server setup - Proven experience in mini-games development - Strong understanding of Minecraft 1.16 mechanics - Ability to manage and maintain server performance - Creative problem-solving skills to enhance player experience Looking for a dedicated and experienced Minecraft developer who can not only set up the server but also create fun and unique mini-games within it. The goal is to attract and retain a strong ...

I am in need of a competent data engineer for a small-scale data analysis task. - The project primarily revolves around performing data analysis. - The ideal candidate should be proficient in data analysis techniques. - Previous experience wi...The project primarily revolves around performing data analysis. - The ideal candidate should be proficient in data analysis techniques. - Previous experience with data engineering will be a significant advantage. Your role will mainly involve performing data analysis tasks, so a deep understanding of data engineering and analysis is essential for this project. A strong background in Python, R, or SQL is highly preferred, though not mandatory. Please note that the project timeline is quite flexible, so you will have ample time to complete ...

I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project requires strong c...

I need a skilled professional to help me creating email servers to send bulk emails and managing. - **Email Marketing**: I have been using the server for bulk mailing and email marketing. I need an expert who can optimize these operations, ensuring that the emails are being delivered effectively and not marked as spam. - **Troubleshooting and Support**: Although I did not select this as a specific task, I might need help with troubleshooting and support in the future. It would be great if the individual could provide this assistance as needed. The ideal candidate for this project is someone with extensive experience in managing email servers, particularly with SMTP, bulk mailing, and email marketing. A deep understanding of email deliverability and anti-spam measures is crucial...

I have a file uploading system installed in my localhost server that's working perfectly. But when I tried to move it to an IIS server, it's not working.

Hello to all talented SQL freelancers! We are seeking an advanced SQL specialist with proven experience in handling multi-level marketing (MLM) databases, as well as knowledge of Dolibarr ERP. We need someone who can understand the complex terms associated with MLM compensation plans and create effective SQL queries to extract the necessary data, as well as integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience i...

I'm currently facing some integration problems with my CI runner on GitHub. I'm looking for an experienced freelancer who can help me resolve this issue. Github Repository Push --> target is that runner push code to cloud linde automatically Key requirements: - Previous experience with GitHub CI runners and Linde Cloud Server. - Strong problem-solving skills in identifying and resolving integration issues. - Good understanding of continuous integration and deployment processes. - Ability to communicate effectively on the progress and steps taken towards resolving the issue. Please include similar project experiences in your application. Looking forward to working with a competent professional who can get this resolved quickly.