I am in need of a professional with experience in SQL Server, ODBC and Quickbase pipeline to assist me with data integration. Job Duties: - Connect my SQL server via ODBC - Utilize Quickbase Pipeline and on-prem gateway for seamless integration Preferable Skills and Experience: - Strong understanding of SQL Server and ODBC - Experience with Quickbase pipeline and on-prem gateway - A history of successful data integration projects, particularly with transaction data Credentials: -I have all the necessary access rights and credentials to my SQL server. I require your expertise to navigate the technical process. Your responsibility would be solely the technical integration. No data management or further SQL Server maintenance would be required. I am only looking fo...
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 req...
I recently attempted to upgrade my SSIS to the 2019 version, on my Windows Server 2019. However, I am encountering problematic error messages relating to the odbc 64 bit issue. Specific Qualifications and Tasks: - Extensive knowledge and experience with SSIS 2008, 2012, 2016 and most importantly 2019 - Proficient in troubleshooting and upgrading processes on Windows Server 2019 - Ability to pinpoint and rectify the odbc 64 bit issue on SSIS upgrade - Efficiently resolve the emerging error messages Your past experiences with similar issues will be highly beneficial in this project. Your role is to figure out the root cause of these errors, fix the problem and ensure a successful upgrade to SSIS 2019.
I am looking a Laravel 11 expert who also have hands on experience working with Microsoft ODBC connection to connect to MSSQL using something similar to bulk copy to update You need to help me acheive this single task via anydesk/teamviewer
I'm looking for a skilled professional who can create a VBA solution in Excel that can interact with a MySQL database. The system should be able to perform the following CRUD operations: Insert, Select, Update, and Delete. This will be a continuous requirement. Key requirements: - Proficiency in MySQL and Excel VBA - Strong understanding of SQL ODBC connections from Excel VBA - Ability to deliver the project within timelines. Your main task would be to create a reliable, easy-to-use, and efficient system to automate the specified database operations from Excel. In addition, the final solution should be well-documented for future reference. If you have experience in similar projects and can commit to the timeline, I'd love to hear from you.
For days I have been trying to migrate a database (MSSQL to MySQL) using ODBC Datasource Administrator unfortunately this is not successful I get error 1822 "Missing index for constraint". I'm just doing it as an exercise, it's not a business project. I wanted to know if anyone here could help me with this. I also tried with AWS the problem is the same (constraints), it doesn't work.
I'm in need of an AS400 expert to provide all-around support to my small-sized environment. Requirements - Comprehensive AS400 support including programming, database, and system administration. - Able to manage a user base of fewer than 50. - Advanced expertise in AS400 programming support. Skills and Experience - Proficient in AS400 system. - Past experience in configuring and troubleshooting AS400 systems. - Strong understanding of AS400 database structures. - Proven experience in AS400 Programming with advanced expertise.
• Strong Hands-on experience in IBM AS400 iSeries platform and RPGLE programming is a must. • Experience on one of the IBM I Supply chain management/ERP applications is a must(PKMS or Infor LX/BPCS). • Experience on migration projects ( From IBM I applications to SAP migration by writing the effective interfaces) • Sound technical knowledge in Integrated Language Environment (ILE), free-format RPG, SQLRPGLE, Subfiles. • Experienced in Creating and debugging RPG/CL programs. • Ability to handle Client requirement, creating design document and walk them with client. • Experience in Designing, Development and Support of Software Products/ Applications in the AS400/ iSeries environment • Technical proficiency in relevant languages and deve...
I need a freelance professional with a strong background in AS400 administration to bring me up to speed with managing this system. Key Tasks include: - Providing detailed steps to navigate and operate the AS400 system - Explaining the functionality and features of the AS400 - Teaching me how to perform routine troubleshooting and error handling. The suitable candidate should possess: - Deep understanding of AS400 system administration - Solid experience in imparting technical skills - Strong communication and tutoring skills. Your bid should include a brief overview of your experience with AS400 system administration and how you can effectively convey this knowledge to me.
...matching our unique HR requirements. Knowledge in effective configuration and implementation of the Core HR module is critical for this project. - Data Migration: We currently are using AS400 and aim to migrate existing data to Oracle Cloud HCM. The chosen freelancer must demonstrate profound knowledge and experience in successful data migration from AS400 to Oracle Cloud HCM without loss of crucial information. Suitable candidates should have a strong background in Oracle Cloud HCM, particularly Core HR, and have prior experience with both system implementation and data migration. Familiarity with AS400 will also be desirable. This project requires attention to detail, successful problem-solving abilities, and a clear understanding of our HR needs and challenges...
...trouble lies in a specific table that is not working despite its counterparts functioning aptly on the same SQL Server domain (myphp). The error message I receive relates closely to : ODBC: ERROR [22018]. As far as I am able to verify: - I have checked the connection settings for the problematic table - The error I encounter appears to be a DataSource error related to ODBC - This issue arises mostly when importing into Power BI The ideal freelancer for this project should have: - An in-depth understanding of SQL Server and database management - Experience dealing with ODBC errors [22018] - Proficiency in Power BI and its correlation with SQL Server - Skill in troubleshooting and resolving data mismatch problems Your task will be to identify the source of the...
...an issue I'm experiencing with connecting a SQL view to my Access database using ODBC. Despite successfully linking tables, I'm unable to establish a connection to the view. The core of this project involves diagnosing and fixing why this connection isn't happening, ensuring that data can seamlessly flow into Access from the SQL view. **Key Requirements:** - **Diagnose Connection Issues:** Identify why the ODBC connection to the SQL view isn't established. Investigate if it's related to the view itself, the ODBC setup, or another underlying issue. - **ODBC Expertise:** Deep understanding of ODBC (Open Database Connectivity), including setup, troubleshooting, and configuration. Familiarity with the latest ODBC driver...
Part 1 of the project suggest creation SQL data base that will collect online streaming data from our app for FORTEX market. Steps of the project: 1) Install and configure Database 2) Set up connection to ODBC 3) Connecting QUIK via ODBC to Database 4) Save historical data in the SQL including division data based on the instruments 5) At the end of each data create txt file located on folder FORTEX for each instrument in following format (data is aggregated for all historical data points) For tikers: <TICKER>,<PER>,<DATE>,<TIME>,<LAST>,<VOL> Si_T_1,0,20231226,085944,92351.000000000,2 Si_T_1,0,20231226,085944,92351.000000000,5 Si_T_1,0,20231226,085944,92351.000000000,1 ticker, 0, YYYYMMDD, HHMMSS, price, contract volume For time frame: ...
I'm currently experiencing some challenges with my PHP website. Here are the issues: - Errors being displayed throughout the site - Dysfunctionality of several pages and features - Total inaccess...entirely offline Website is very simple appointment display and book. It was working on a host But they upgrade the platform and as the page queries an external MS SQL database for a list of available appointments, this no longer works. It used PDO (PDO_dblib) to connect but its not work. Tried a test connection and it doesnt work. Changed to PDO_sqlsrv but its not supported as it needs ODBC on server and 123reg will not allow. I have set up a VPS which they say will work but I do not understand. Looking for someone to fix, and then add a bit more functionality but that is lat...
I have a Windows application connected to a Microsoft SQL Server where the server and database names in the VB.NET connection string need to be altered. Currently, application connects to SQL Server using SQL Server Native Client 11.0 that cannot be installed on Windows 11 due to compatibility issues. So I need to replace it either with : - Microsoft OLE DB Driver for SQL Server OR - Microsoft ODBC Driver for SQL Server I am not sure which way would be better. I need to replace connection string. Code can be reused and I would not change except where is needed. I have form where I choose to connect to database. This connection string is saved to XML file. This part I would not change except whats needed. Their task would involve: - Changing both the server and database names wi...
...(cubecart, oscommerce) database. I have a python script done by previous contractor who dropped the project for the personal reason, so there is no issues with source and target db structures, mapping of the fields. etc. Need an to refresh and do an extra polish. My specific requirements are as follows: 1) Learn the structure of AW 2000 database (old Paradox format, but work fine via Windows ODBC) - download here setup exe file, install it, run trial, restore inventory database from the link I will provide and use this data for the export-import. Paradox DB files are in database folder. 2) Learn the structure of DB of opencart (or cubecart, or oscommerse) and ensure you understand it 3) review the mapping of the data fields between source
...(cubecart, oscommerce) database. I have a python script done by previous contractor who dropped the project for the personal reason, so there is no issues with source and target db structures, mapping of the fields. etc. Need an to refresh and do an extra polish. My specific requirements are as follows: 1) Learn the structure of AW 2000 database (old Paradox format, but work fine via Windows ODBC) - download here setup exe file, install it, run trial, restore inventory database from the link I will provide and use this data for the export-import. Paradox DB files are in database folder. 2) Learn the structure of DB of opencart (or cubecart, or oscommerse) and ensure you understand it 3) review the mapping of the data fields between source
I am looking for a freelancer who can help me connect my MySQL database to my Excel spreadsheet on my MacBook Air. Operating System: Mac ODBC Driver: MySQL Connector/ODBC Excel Version: 16.8 Skills and Experience: - Strong knowledge of MySQL and Excel - Experience with ODBC connectors and drivers - Familiarity with Mac operating system - Ability to troubleshoot and resolve any connectivity issues between MySQL and Excel on a Mac - Attention to detail to ensure accurate data transfer between the database and spreadsheet
Installing ODBC on Windows for a beginner Skills and experience needed: - Proficient in installing programs on Windows - Knowledge of ODBC installation process - Familiarity with troubleshooting installation issues Project details: - The client is seeking assistance with installing ODBC on their Windows operating system. - The client has a beginner level of experience with installing programs. - They already have the necessary installation files and documentation. - The freelancer will be responsible for guiding the client through the installation process and troubleshooting any issues that may arise.
...(cubecart, oscommerce) database. I have a python script done by previous contractor who dropped the project for the personal reason, so there is no issues with source and target db structures, mapping of the fields. etc. Need an to refresh and do an extra polish. My specific requirements are as follows: 1) Learn the structure of AW 2000 database (old Paradox format, but work fine via Windows ODBC) - download here setup exe file, install it, run trial, restore inventory database from the attached file (restore in AW interface) and use this data for the export-import. Paradox DB files are in database folder. 2) Learn the structure of DB of opencart (or cubecart, or oscommerse) and ensure you understand it 3) review the mapping
I am looking for an experienced programmer who is proficient in RPG III programming language for an existing and new project. The project should take no longer than a week and the programmer should have knowledge in creating and modifying projects. If you are an experienced programmer with necessary qualifications and have the required skill-set, please reach out. Thanks!
More details: Is this project for business or personal use? This question was skipped What information should successful freelancers include in their application? Experience What is your deadline for completing this project? Within a week
Professional with 10 years of experience in Food process, laundry, bakery, supermarket equipment’s, oil & gas industry design service, heavy truck body CAD detailed design & drafting activities, vehicle integration, BOM, AS400 ERP activities, Reverse engineering, CAD Software: Certified SOLIDWORKS Professional.
Tenemos una conexión a tablas por medio de ODBC a bases de tipo DBX En POwerBi Desktop nde repente da porblemas de actualización manual y me obliga a entrar a POwerQuery y refrescar las tablas que tienen un signo de interrogación "'?" Al refrescar la vista estas se normalizan, guardo los cambios y ya me permite actuailzar las tablas. Este fenomeno lo genera de forma irregular y con diferenites tablas.(no siempre son las mismas ) Eso seguramente genera problemas cuando quiero actualizar PowerBi desde plataforma WEB dando el siguiente error: Error del origen de datos: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError&qu...
My project requires a professional to import a CSV file in Standard CSV format into an AS400 system. No data manipulation or transformation is needed, as the data can simply be imported as is and used for Database Update purposes. Expertise in AS400 and CSV files is a must for this project. I expect the freelancer to be able to effectively and efficiently import the CSV file into the AS400 system for Database Update purposes with minimal assistance from myself. The project should also include any further instructions on how to best work within the AS400 system for optimal results.
...individual or a business • Business Seller Information (if on the page) Order Details Page: • Est Delivery Date (if provided by seller) • Tracking Number (if provided by seller) • Price Per Unit • Total Price • QUANTITY • Postage Cost (or total cost - unit cost*quantity) 3. Data Storage: Develop an interface or script to push the extracted data into our FileMaker Pro database. Maybe install FileMaker ODBC drivers - configure a DSN for DB - Script Connection - Use say pyodbc - Insert scraped data into tables 4. Execution: Run locally from our own IP address. Scheduled to run at predetermined times or intervals. 5. Error Handling: Notification by email/other means should any errors occur during the scraping process. Required Skills: •...
I'm looking for a talented programmer who is knowledgeable in IBM AS400 and RPG coding. Specifically, I'm on the lookout for someone with experience in version V7R3 of IBM AS400. The project would be moderate in complexity, and I'm looking to complete it within 1-3 months. I'm looking for a professional programmer who can dedicate their undivided attention to the project and help me achieve the desired results in a timely manner. Your knowledge and skills in the IBM AS400 platform, along with your dedication to the project, will be greatly appreciated.
...Version: 8.0.1) for Data Integration to an AS400 database (version V5R4M0). The work is to be completed by tomorrow using Anydesk directly in a client in the same network with AS400 and where Talend is already installed. The ideal candidate should have the following skills and experience: - Proficiency in Talend Open Studio for Data Integration - Experience in connecting to AS400 databases - Familiarity with the connection protocol The main objective of the project is to establish a connection between Talend and the AS400 database. The freelancer will be responsible for configuring the connection and ensuring a smooth and reliable data transfer process. Key requirements for the project include: - Setting up the connection between Talend and the AS400...
I have a project that needs to integrate a (SFDC) platform with an AS400 database using SOAP. The purpose of the integration is to provide real-time data updates. A SOAP interface is needed, and the specific database I'll be integrating with is an AS400 database. This setup will ensure that the data from our SFDC platform is synced with the database quickly and reliably. The successful freelancer will be comfortable with integration projects as well as using SOAP and AS400 databases.
I am in need of an AS400 developer who has intermediate technical knowledge and can provide web-based application development services. The tasks will involve designing, developing, and maintaining applications on an AS400 platform. A detailed understanding of systems analysis, programming, and coding is necessary in order to understand the requirements quickly and deliver the product with accuracy and quality. The ideal candidate would be familiar with web-based development using the latest tools to ensure the customer gets the best service. Responsibilities include designing user interfaces, ensuring code accuracy and functionality, and making necessary modifications to existing applications. The right individual should also be able to test the finished product and analyze ...
I am looking for a freelancer to develop a shipment tracking CMS agnostic UI widget for my WordPress website. Design: - I have a specific design in mind for the UI widget that I would like the freelancer to follow. Integration: - I would like the widget to consume from an already developed SOAP SERVICE for shipment tracking. Skills and Expe...UI widget for my WordPress website. Design: - I have a specific design in mind for the UI widget that I would like the freelancer to follow. Integration: - I would like the widget to consume from an already developed SOAP SERVICE for shipment tracking. Skills and Experience: - Experience in developing UI widgets for CMS platforms: Vue.js, Angular or similar. - Proficiency in working with AS400 SOAP SERVICES for integrating shipment...
I'm looking for an experienced freelancer to install IBM v7r1 AS400 iSeries - The purpose of the installation is for a scratch installation. BR1-PT1-QU2-WDS-ST1-M&S-QU1-JS1, XW1-HAS - I need someone who is knowledgeable about IBM AS400 iSeries systems and has experience in completing such projects. This is a time sensitive project with a strict deadline, so please only apply if you are confident in your ability to provide exceptional results in the set timeframe. If you think you have what it takes to help with this project, I would love to hear from you. System is connected by HMC either anydesk will be provided or HMC
I am looking for a VBA expert to help me upload a text file to an online server location. The text file is in TXT format and I have credentials to access the server location. The ideal candidate should have experience with VBA for E...experience with VBA for Excel and be familiar with uploading files to an online server. The project involves the following: - Writing VBA code to upload the text file to the online server location - Ensuring that the upload process is secure and reliable - Troubleshooting any issues that may arise during the upload process I need to be able to do this with Excel 19 and no downloads of ANY KIND. (So no ODBC or other connector downloads). The code must copy a textfile from my local machine (C:User) to a folder on my server (htpp://).
I am looking for a freelancer who can help me connect my MySQL Workbench local database to MS Access via local ODBC. I already have the necessary drivers installed for the ODBC connection. The specific versions of MySQL Workbench and MS Access I am using are MySQL Workbench 8.0+ and MS Access 2019. I need to transfer tables only between the MySQL database and MS Access. Ideal skills and experience: - Experience in setting up ODBC connections between MySQL and MS Access - Knowledge of MySQL Workbench and MS Access versions specified - Ability to transfer tables between the two databases
I am in need of a remote AS400 System Administrator who can provide ongoing support for my business. Specifically, I require assistance with system administration tasks such as maintenance, updates, and security monitoring. Ideal skills and experience for this job would include: - Strong knowledge of AS400 systems and related technologies - Experience with system administration tasks such as user management, backup and recovery, and performance monitoring - Ability to troubleshoot and resolve technical issues in a timely manner - Strong communication skills to effectively work with remote teams As for availability, I am flexible with timelines and can work with the chosen freelancer to determine a suitable schedule.
...of a troubleshooting project and maybe some evaluation of the current databases to see why it has stopped functioning. <% = false = 1200 Const ForReading = 1 Const ForWriting = 2 Const ForAppending = 8 %> <% 'Open and read a text file. On error resume next Set OBJdbConnectionMem = ("") "DRIVER=MySQL ODBC 3.51 Driver;SERVER=localhost;DATABASE=p26330_PNI;UID=p2633_pni;PASSWORD=“password removed”;OPTION=3" tmpOut = "" Filename = "/" Dim Filepath Filepath = (Filename) set fs = CreateObject("") set file = (Filepath, ForReading) SQLStrMem = "DELETE FROM ntodata1;" ( SQLStrMem ) do while not
...trying to "npm i odbc", I get an error concerning Microsoft Visual Studio and that it "does not match this Visual Studio Command Prompt". The odbc package is partly built in C++ explaining the need for Visual Studio. However, I did install the "Visual Studio Community 2022" with the "Desktop development with C++" and still get the error. I tried many things I saw in stackoverflow and github discussions, but still can't make it work. Can someone help me resolve this issue? Here are the logs from my last attempt. npm ERR! code 1 npm ERR! path C:UsersODBCDocumentsodbcnode_modulesodbc npm ERR! command failed npm ERR! command C:WINDOWSsystem32 /d /s /c node-pre-gyp install --fallback-to-build npm ERR! F...
I am looking for a skilled developer to help me link my SQL Server 2022 to Oracle Database 12c for a data migration project. The ideal candidate should have experience in: - SQL Server administration - Oracle Database Administration - Set up Oracle ODBC connection The goal of this project is to create a link between sql server and oracle so I can select data from a oracle database in SQL Management Studio.
I am in need of a remote AS400 System Administrator who can provide ongoing support for my business. Specifically, I require assistance with system administration tasks such as maintenance, updates, and security monitoring. Ideal skills and experience for this job would include: - Strong knowledge of AS400 systems and related technologies - Experience with system administration tasks such as user management, backup and recovery, and performance monitoring - Ability to troubleshoot and resolve technical issues in a timely manner - Strong communication skills to effectively work with remote teams As for availability, I am flexible with timelines and can work with the chosen freelancer to determine a suitable schedule.
I need a skilled developer to create a set of scripts that will synchronize data between my AuctionWizard2000 database and my Opencart (cubecart, oscommerce) database. My specific requirements are as follows: 1) Learn the structure of AW 2000 database (old Paradox format, but work fine via Windows ODBC) - download here setup exe file, install it, run trial, restore inventory database from the attached file (restore in AW interface) and use this data for the export-import. Paradox DB files are in database folder. 2) Learn the structure of DB of opencart (or cubecart, or oscommerse) and ensure you understand it 3) map the data fields between source and target databases. 4) Make script which will update products on the server
I need a freelancer with experience in setting up ODBC SQL drivers on CentOS, specifically for integration with Avaya IP Office - Voicemail Pro. The ideal candidate should have knowledge of Avaya systems. The main purpose of the ODBC SQL driver setup is to enable seamless integration with Avaya IP Office Voicemail Pro. The project will involve configuring and installing the necessary drivers, as well as testing and troubleshooting any issues that may arise. The successful candidate should have the following skills and experience: - Knowledge of Avaya IP Office Voicemail Pro (V11.1) - Experience with ODBC SQL driver setup on CentOS and 3rd party applications - Strong troubleshooting and problem-solving skills - Excellent communication and collaboration skills to work w...
We have a new project where we are looking for AS 400 specialist
i want to convert information from several ODBC connections and display it on a shareable website with some basic column header filter choices. This data would need to refresh itself every 5-10 minutes and have some field include some background calculations on some of them.
보다 자세한 내용을 확인하시려면, 회원 가입 또는 로그인 절차가 필요합니다.
Looking for professionals who have experience supporting AS400 and migrating applications of AS400 and AS400 decommissioning
Temos dezenas de mapas financeiros e de indicadores feitos em MS Excel usando power query e power BI com SQL e ODBC´s e precisamos de contratar por uns dias por mês um Analista de dados que consiga gerir e criar novos preferencialmente que resida na zona de Leiria ou Arredores.
...opportunity for you! We are looking for a skilled freelancer to connect an existing Oracle source database to three different remote databases, including DB2 installed on an IBM AS400 server, MySQL, and MS-SQL Server. The Oracle source database has been installed using Oracle 18c Express Edition - 64bit Docker container on Linux, and the network settings and routings are already in place to allow for seamless connectivity between the source and destination databases. As the successful candidate, you will use your expertise to connect the remote databases to the Oracle database in the Docker container using ODBC or CLI, and create a database link within Oracle. This will enable easy placement of SQL queries to the remote database content, such as "select * from @...
I need a skilled developer to create a set of scripts that will synchronize data between my AuctionWizard2000 database and my Opencart (cubecart, oscommerce) database. My specific requirements are as follows: 1) Learn the structure of AW 2000 database (old Paradox format, but work fine via Windows ODBC) - download here setup exe file, install it, run trial, restore inventory database from the attached file (restore in AW interface) and use this data for the export-import. Paradox DB files are in database folder. 2) Make script which will update products on the server from source database on my desktop. Main tables for the import: inventory, invimages, invcategory. I need the data about the products in "inventory" and related
We are replacing an IBM AS400-based ERP with Oracle NetSuite Platform. Seeking a Consultant with NetSuite ERP Implementation Experience in manufacturing/financial/distribution. Hybrid onsite/virtual support is needed. Support the Director of It in the planning, execution, monitoring, and controlling of the implementation project. Ensure the necessary integration points are identified and managed with the third-party systems. Exp. RFSmart, blend, and PAceJet are desirable. Work with IT to ensure a seamless transition from the legacy system. Excellent verbal and written communication skills are required.
Per un'azienda molto nota del settore, con sede a Treviso Nord, si cerca uno sviluppatore AS400 da inserire in organico o con partita IVA dedicato fulll time allo sviluppo dell'ERP aziendale (già in essere ma che necessita di sviluppo e manutenzione).
