Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Integration / Customization
IPA/ProcessFlow
Querrying External Datasource
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Wayne Willis
Past 24 Hours:
1
Prev. 24 Hours:
1
Overall:
5190
People Online:
Visitors:
342
Members:
0
Total:
342
Online Now:
New Topics
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1351
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
IPA/ProcessFlow
Querrying External Datasource
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Sanford Barton
Basic Member
Posts: 10
4/4/2007 3:20 PM
I know that ProcessFlow Integrator would be the best option to do this, but we don't have it, and aren't likely to get it anytime soon.
What I would like to do is to be able to querry a table in an Oracle database in a flow which manages adding new users to our system.
The table would reside in Lawson database, but I would prefer that use a seperate tablespace for obvious reasons.
Is it possible to set this up so that I can querry it via the querry node in pflow?
If no, any other ideas to get around this like using a javascript routine to get the data or some other form of executible process??
Thanks,
Bart
John Henley
Senior Member
Posts: 3348
4/4/2007 6:34 PM
As long as you have it defined in the Lawson database (i.e. via dbdef, perhaps as a 'view') you can use DME query calls from ProcessFlow against the data.
Sanford Barton
Basic Member
Posts: 10
4/4/2007 9:26 PM
Hi - thats never worked for me. I've tried defining a "database space"(as view) and then a "data area", then blddbdict and a dbreorg, but all I ever see in the dme wizard is product lines and system codes....Do you see anything that I potentially missed? Thanks!
John Henley
Senior Member
Posts: 3348
4/11/2007 2:24 PM
I have tested this and it does work, returning data from database views defined in dbdef--from direct DME calls via the browser, Excel query wizard, and ProcessFlow DME query builder.
Sanford Barton
Basic Member
Posts: 10
4/17/2007 3:03 PM
Can you do updates to the tables as well with this method?
John Henley
Senior Member
Posts: 3348
4/17/2007 8:15 PM
Using ProcessFlow, you would be limited to making AGS calls. AGS calls are made against forms not tables. Therefore you would need to create a form that updated your table. One of advantages of ProcessFlow Integrator is that you can do SQL updates directly to Non-LAWSON tables.
Sanford Barton
Basic Member
Posts: 10
4/19/2007 2:30 PM
The Querry Builder in Processflow has a selector for "Database Tables" and "Application". Wouldn't that imply that one could build either DME (database) and AGS (Application) querries....not just AGS?...Or are you saying that only AGS can be used to make updates where DME is querry only?
John Henley
Senior Member
Posts: 3348
4/19/2007 2:46 PM
I should have said "Using ProcessFlow, you would be limited to making AGS calls in order to UPDATE.
For Updates, you can only use AGS.
For Queries, you can use either AGS (forms) or DME (tables).
Sanford Barton
Basic Member
Posts: 10
4/19/2007 3:31 PM
Ok thanks - so basically AGS/DME is a dead-end for updates (without backend app development to allow AGS).
I have a plan B...it sort of works, but my initial inquiry was to see if anyone has figured out a better way
Bacially, I've develpled an oratcl (TCL Scriptiong Language that Comes with Oracle) that will do querries and updates by calling it from a webrun node. Any language that can talk to Oracle would work. You can either write your own script for each type of querry/update you want to perfrom, or write a generic one that you can pass an entrire sql command to.
Only limitation that I have is that I can only deal with 1 row of data at a time. Haven't figured out a way to pass and parse multiple rows. Still in a pinch it works.
Anyone done anything similar?
John Henley
Senior Member
Posts: 3348
4/19/2007 3:58 PM
As you're already aware, LSF9/ProcessFlow Integrator is an ideal solution for what you're trying to do. The way it works is that when you do a SQL query it returns a JavaScript array of the results. It's not perfect (in fact, large resultsets tend to, ahem, bring the server to a crawl and eventually crash...), but it does work pretty well for simple tasks.
I did something similar awhile back; I created some .NET applications that exposed SQL table/command wrappers as web services. So, in theory similar to what you did with oratcl. The dillema when calling from ProcessFlow WebRun is that you're pretty limited in what you can do with the results that are returned from the WebRun node. In other words, you have to put it into a parsable format, and parse thru the results in ProcessFlow. At some point, you have to ask yourself if you're really using the right tool...
You are not authorized to post a reply.