To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.
Course Of The Month
6 days, 23 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
WebSphere Host On-Demand data to a microsoft access table?
Posted on 2011-03-07
Can anyone provide me with a solution on how to transfer WebSphere Host On-Demand data to a microsoft access table? I have been looking for a tutorial to extract data from this Java-run program into an Access table. I heard from sources that this was being done via Foxpro, but I wish to use Access as the host,
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
2
5 Comments
Active today
Not sure I understand what you want to do. Can you explain your requirements in a little more detail?
Do you need to move your HOD configuration to another server?
If so, then you just need to follow the appropriate migration process for your HOD version and platform. If you'll post your HOD platform and version, I can point you to the right manual that documents the migration process.
- Gary Patterson
Do you need to move your HOD configuration to another server?
If so, then you just need to follow the appropriate migration process for your HOD version and platform. If you'll post your HOD platform and version, I can point you to the right manual that documents the migration process.
- Gary Patterson
Gary,
First of all, kudos on your accomplishments. The IBM system that we currently have in place is used in a secure-server environment to schedule employees. I'm working on automating our schedule in Access to include more features such as locations. The IBM program is straight shift times with no locations. I'm not sure whether I need to establish some type of ODBC connection to Access, but the scheduling program seems to have a transfer option that I'm not familiar with. I'm sending you a snapshot of the toolbar with the transfer options. What I would like to do is select a pay period with employee schedules and transfer the list to an Access table for further processing. I hope this makes sense.
screen.jpg
First of all, kudos on your accomplishments. The IBM system that we currently have in place is used in a secure-server environment to schedule employees. I'm working on automating our schedule in Access to include more features such as locations. The IBM program is straight shift times with no locations. I'm not sure whether I need to establish some type of ODBC connection to Access, but the scheduling program seems to have a transfer option that I'm not familiar with. I'm sending you a snapshot of the toolbar with the transfer options. What I would like to do is select a pay period with employee schedules and transfer the list to an Access table for further processing. I hope this makes sense.
screen.jpg
Active today
OK, I think I get it.
So this is application data that you are after, and really has nothing to do with HOD, other than the fact that is the tool that you are using to attach to the system hosting the scheduling application.
The "Transfer Files" function that you see is a function that is built into the HOD tool, and is designed to let HOD users transfer files to and from the host that they are connected to though HOD.
It is certainly possible that you can use this function to download the scheduling system files, process them, and then upload them, but please be aware that this Transfer function is not part of your scheduling system software, it is just a general-purpose file transfer utility.
In order to use it, you need to know enough about your scheduling system to know where it keeps the data you want to upload and download. Of course, you need to know this to use is from any other tool, as well. This is a general-purpose file download tool that is intended to allow you to download any file that you have access to from the host. You need to know the location of the file, the name of the file, etc.
So, first, a few questions:
1) Why type of host system is this that hosts the scheduling application? What OS is it running?
2) Is the scheduling system's database hosted on the same server, or a different server? What DBMS, if any, is it running?
3) What is the name of the table (or file) in the scheduling system that you want to download?
Assuming you know all of this, or can find it out, then you probably have lots of options for accessing the data:
You can use the Transfer Function feature of HOD to upload and download files.
If you have direct access to the host server, you can probably use ODBC/JDBC/ADO, etc to access the data if it us stored in a RDBMS, or FTP or a similar file transfer mechanism to access non-database files.
Hope that helps.
- Gary Patterson
So this is application data that you are after, and really has nothing to do with HOD, other than the fact that is the tool that you are using to attach to the system hosting the scheduling application.
The "Transfer Files" function that you see is a function that is built into the HOD tool, and is designed to let HOD users transfer files to and from the host that they are connected to though HOD.
It is certainly possible that you can use this function to download the scheduling system files, process them, and then upload them, but please be aware that this Transfer function is not part of your scheduling system software, it is just a general-purpose file transfer utility.
In order to use it, you need to know enough about your scheduling system to know where it keeps the data you want to upload and download. Of course, you need to know this to use is from any other tool, as well. This is a general-purpose file download tool that is intended to allow you to download any file that you have access to from the host. You need to know the location of the file, the name of the file, etc.
So, first, a few questions:
1) Why type of host system is this that hosts the scheduling application? What OS is it running?
2) Is the scheduling system's database hosted on the same server, or a different server? What DBMS, if any, is it running?
3) What is the name of the table (or file) in the scheduling system that you want to download?
Assuming you know all of this, or can find it out, then you probably have lots of options for accessing the data:
You can use the Transfer Function feature of HOD to upload and download files.
If you have direct access to the host server, you can probably use ODBC/JDBC/ADO, etc to access the data if it us stored in a RDBMS, or FTP or a similar file transfer mechanism to access non-database files.
Hope that helps.
- Gary Patterson
I'm familiar with ODBC, as I've used it in the past to connect Infopath forms to Access. I may have to get with my local IT to get more info. XP is the OS. Do you have a tutorial using ODBC in this context? This operation seems like it requires quite a bit of info, but hopefully you can provide me with with a sense of direction. It program resides in the same server, and I'm not too sure about the file name for the data i wish to extract. Perhaps we can use a generic name for this scenario.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette.
This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Suggested Courses
Course of the Month6 days, 23 hours left to enroll
726 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.