Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > ION

User login

Frontpage Sponsor

Main

Poll
What do you expect from your SI Implementation partner for the success of ERP implementation.
Bring best practices - Not to offer more CR's Leveraging standard functions
0%
Need more honesty to work with the Users until their processes are fully mapped & Users are trained
100%
Focus on process automation/ integrations/ Real time data/ BI analytics
0%
Stick to basics
0%
Total votes: 1

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 31st August 2022, 16:58
Gaith1 Gaith1 is offline
Member
 
Join Date: Jun 2004
Posts: 30
Gaith1 is on a distinguished road
Baan: 4.c.4 - DB: informix - OS: unix
Tables extract from LN CE with ION

Hi ,

I'm using Infor LN CE and I want to see if it possible from ION to schedule an extract on a daily basis of any table (all fields or specific fields) in csv format. Can we use File Connection point ? We have to define File template format.
I want to improve the way we can extract data directly from database other than creating LN session/script to generate flat file.

Thanks in advance
Reply With Quote
Sponsored Links
  #2  
Old 1st September 2022, 08:55
ARijke ARijke is offline
Guru
 
Join Date: Sep 2005
Posts: 520
ARijke is on a distinguished road
Baan: Baan IV upto LN - DB: -- - OS: --
HI This is not supported. One option is the one you mentioned, by creating a LN session generating a file. The other option is to use Data Lake. LN publishes data to DL.and with data lake tools you can extract the data to a local database.
Reply With Quote
  #3  
Old 1st September 2022, 14:08
Gaith1 Gaith1 is offline
Member
 
Join Date: Jun 2004
Posts: 30
Gaith1 is on a distinguished road
Baan: 4.c.4 - DB: informix - OS: unix
For the Data Lake option , I have all records published from LN for table tcibd001 into Data Lake and I can verify the total line count when I Run Query in Data Lake/Compass for JSON object LN_tcibd001.

Form there can I extract to a csv file with an execution set up on daily basis ? Or I need to extract the data to a local database and then built a query to generate csv file ?

thanks
Reply With Quote
  #4  
Old 5th September 2022, 12:33
ARijke ARijke is offline
Guru
 
Join Date: Sep 2005
Posts: 520
ARijke is on a distinguished road
Baan: Baan IV upto LN - DB: -- - OS: --
HI, There is an DataLake API which can be used to retrieve data out of DL. Secondly there is a tool, DataLake ETL Tool, or something like that. This tool needs configuration of course, but will synchronize data from DL to an on prem database.
Reply With Quote
  #5  
Old 6th September 2022, 20:04
Gaith1 Gaith1 is offline
Member
 
Join Date: Jun 2004
Posts: 30
Gaith1 is on a distinguished road
Baan: 4.c.4 - DB: informix - OS: unix
Thanks for the reply , I will look for the best option
Reply With Quote
  #6  
Old 8th September 2022, 15:43
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Guru
 
Join Date: Mar 2002
Location: Belgium
Posts: 1,219
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 > 10.7 - DB: MS SQL2017 - OS: VM WindowsServer2016
There is yet another option I suppose, A number of tables do have a BDE available where you can send a LIST or SHOW command with a specific filter to get data from LN on demand.

You will need a deployed C4WS tomcat instance and deployed BDE. It is also possible to develop your own BDE in LN Studio.

In an Interface project you can import any LN table and generate a default implementation and definition. Compile, check-in, deploy and you can request all fields in the table.
__________________
Also read Luke 24:4-8
Reply With Quote
  #7  
Old 8th September 2022, 16:24
Gaith1 Gaith1 is offline
Member
 
Join Date: Jun 2004
Posts: 30
Gaith1 is on a distinguished road
Baan: 4.c.4 - DB: informix - OS: unix
Can you give more details when you say
" In an Interface project you can import any LN table and generate a default implementation and definition. Compile, check-in, deploy and you can request all fields in the table."

Where can you define an Interface project ? directly in LN Studio?
Reply With Quote
  #8  
Old 8th September 2022, 17:03
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Guru
 
Join Date: Mar 2002
Location: Belgium
Posts: 1,219
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 > 10.7 - DB: MS SQL2017 - OS: VM WindowsServer2016
Yes, Check the documentation https://docs.infor.com/ln/2022.x/en-...267817978.html

In the Studio select the Integration Perspective, then Import Table. https://docs.infor.com/ln/2022.x/en-...267819601.html
It will import the table and the used domains. Then on the table select "Create Default Definition and Implementation" It will create a fully functional BDE for you.

Before you can compile you will need to set the identifier, then your BDE can be compiled and deployed...
__________________
Also read Luke 24:4-8
Reply With Quote
  #9  
Old 8th September 2022, 17:26
Gaith1 Gaith1 is offline
Member
 
Join Date: Jun 2004
Posts: 30
Gaith1 is on a distinguished road
Baan: 4.c.4 - DB: informix - OS: unix
thanks a lot , I will try
Reply With Quote
  #10  
Old 8th September 2022, 17:44
ARijke ARijke is offline
Guru
 
Join Date: Sep 2005
Posts: 520
ARijke is on a distinguished road
Baan: Baan IV upto LN - DB: -- - OS: --
A BDE can indeed be used. Please note that it is not always possible to retrieve a delta, changed since the previous extraction.
Reply With Quote
  #11  
Old 19th September 2022, 12:49
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Guru
 
Join Date: Mar 2002
Location: Belgium
Posts: 1,219
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 > 10.7 - DB: MS SQL2017 - OS: VM WindowsServer2016
Quote:
Originally Posted by ARijke View Post
A BDE can indeed be used. Please note that it is not always possible to retrieve a delta, changed since the previous extraction.
What we usually do in that case is also create a BOD for the same table and create an extension on the table in which all (or relevant) fields of the table are declared as keep.<fld> variables.
And we need
Code:
#pragma used dll "otcextbodapi"
	table	    ttdcom902
	domain	    tcmcs.s999m   ErrorSituation
	domain	    tcmcs.long	    ErrorID
	domain	    tcmcs.str12	    keep.keyf      | Key Field
In the functions section we use:
Code:
function keep.some()
{	keep.keyf = tdcom902.keyf      | Key Field
	keep.<...> = tdcom902.<...>
}
function boolean some.change()
{        return(not(     keep.keyf = tdcom902.keyf and
                        keep.<...> = tdcom902.<...>))
}
Then in the Before Save hook:
Code:
function extern long before.save.object(long mode)
{	with.old.object.values.do(keep.some)
	return (0)
}
In the After.Save we trigger the BOD:
Code:
function extern long after.save.object(long mode)
{
	| hook code
if some.change() then
	if mode = DAL_NEW then
	    return(bod.publish("OwnBOD", "tdcom902", "Add", 0,
					"", tdcom902.keyf, "OnlyPublish", 
					ErrorSituation, ErrorID, tdcom902.keyf))
	endif
	return(bod.publish("OwnBOD", "tdcom902", "Change", 0,
					"", tdcom902.keyf, "OnlyPublish", 
					ErrorSituation, ErrorID, tdcom902.keyf))
endif
}
So we only get a BOD when the relevant fields are changed and that BOD can be used to "know" the "delta".
__________________
Also read Luke 24:4-8
Reply With Quote
  #12  
Old 19th September 2022, 21:30
Gaith1 Gaith1 is offline
Member
 
Join Date: Jun 2004
Posts: 30
Gaith1 is on a distinguished road
Baan: 4.c.4 - DB: informix - OS: unix
Thanks , I will do a try
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Reconfigure Tables has no effect florian.battke Tools Administration & Installation 21 30th July 2019 07:58
Webinar: Leverage Infor ION for better integration, workflow & alerts management Vishalbabu General Discussion & Chat 1 29th August 2018 21:33
Webinar: Leverage Infor ION for better integration, workflow & alerts management Vishalbabu ION 0 4th December 2013 12:59
Controlling and Managing output from ION and input into ION Marc Jenkins ION 0 1st August 2013 10:34
Tools Tables which can be created for a company different than 000 i96nds Tools Development 11 13th March 2002 01:07


All times are GMT +2. The time now is 00:38.


©2001-2022 - Baanboard.com - Baanforums.com