Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SHARING] WebFOCUS – Scripting Language Integration
Go
New
Search
Notify
Tools
Reply
  
[SHARING] WebFOCUS – Scripting Language Integration
 Login/Join
 
Master
posted
Hi Focal Pointers!

Information Builders is adding scripting language support to WebFOCUS and we want to hear from you. Do you use or plan to use Python, R, JavaScript, or any other open source scripting language in your business intelligence applications?

Please take a few minutes to complete our brief survey. We appreciate your feedback!

Scripting languages are a gateway to artificial intelligence, data science, statistics, and other knowledge domains for business intelligence. Perfect for prototyping and rapid development, numerous open source scripting languages are featured in the TIOBE Index.


Sincerely,
Kathleen Butler
Senior Customer Care and Communications Manager
Information Builders

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 434 | Location: New York | Registered: September 20, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
This is a great initiative!


Test: WF 8.2
Prod: WF 8.2
DB: Progress, IBM DB2, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Hadoop.
 
Posts: 315 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
Ditto to that


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.01OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 5917 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
This may be the final piece needed to get campus-wide adoption of WebFOCUS. Right now the science side is python and R centric while the finance side is WebFOCUS and PeopleSoft centric. If we can embed python or R into our WebFOCUS reports it would be magic!


WebFOCUS 8.1.05M - Production
WebFOCUS 8.2.03 - Sand Box
Windows 2012 R2 Server
HTML, PDF, Excel
In FOCUS since 1980
 
Posts: 90 | Location: Seattle, WA | Registered: April 07, 2015Reply With QuoteReport This Post
Master
posted Hide Post
just a stupid question...

How?

a hold file a made with Webfocus request and on the hold file scripting can be "unleashed" and the results end up in a new hold file?

something like that?


-********************
-* Code. Black, no sugar.
-********************

** Member of the Benelux Usergroup **

_____________________
WF: 8.0.0.9
 
Posts: 659 | Location: Veghel, The Netherlands | Registered: February 16, 2010Reply With QuoteReport This Post
Member
posted Hide Post
Hi Dave,

There are numerous ways a scripting language can access a hold file and then make the results available in a new hold file. This is why Kathleen Butler and I have posted the survey, so Information Builders can speak with our customers and partners and learn how they would like WebFOCUS to integrate with scripting languages.

There are a few methods we are evaluating. Here is one:
When a WebFOCUS call is made to, say, Python or R, the following information is explicitly included in the call:
- the name of the script file residing in the app folder
- the name of the input app folder and the hold file
- the name of the output app folder and the hold file

The app name/folder name is automatically converted to a physical file path on the Reporting Server. The script reads the file and then writes the results to the physical hold file.
After the output hold file has been written to and closed then an internal CREATE SYNONYM command is executed. The file is now available to the WebFOCUS user.

Another way to access WebFOCUS data does not require a HOLD file at all. I wrote a Python wrapper for the WebFOCUS REST service and execute a report or an ad hoc fex which returns the data in the format I choose to use in Python, e.g., CSV, JSON, or XML. I will be demonstrating this at Summit 2018, How to Build a WebFOCUS for Amazon Alexa app.

Regards,
Ira


WebFOCUS 8.x, Windows 10, Ubuntu Linux
 
Posts: 13 | Location: New York City | Registered: March 01, 2010Reply With QuoteReport This Post
Master
posted Hide Post
Thanks for the Q & A, Dave and Ira.

This sounds like a worthwhile IB initiative, and I've responded to Kathleen's survey accordingly.

Thanks again all.
 
Posts: 730 | Registered: April 23, 2003Reply With QuoteReport This Post
Virtuoso
posted Hide Post
YES! DO THIS!! haha All for it! Would be a very good thing! Taking survey next.


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1055 | Location: USA | Registered: January 27, 2015Reply With QuoteReport This Post
Master
posted Hide Post
Thanks Everyone! Just a reminder that the survey is still open and we appreciate your feedback.

Sincerely,

Kathleen Butler
Information Builders
 
Posts: 434 | Location: New York | Registered: September 20, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
This sounds very interesting! I can always use more tools in my toolbox. . .


WebFocus 8201m on Windows; App Studio 8201; Procedures: WebFocus with SQL; HTML Parameter Pages & Dashboard; Output: Excel, HTML, & PDF.
 
Posts: 82 | Location: MI | Registered: July 23, 2009Reply With QuoteReport This Post
Expert
posted Hide Post
Hoping that out of this we will get something like:

ON TABLE HOLD AS X FORMAT Y EXECUTE SCRIPT Z


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.01OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 5917 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
Dear FocalPoint Community,

David Glick and I appreciate the many views, comments, completed surveys, and follow up conversations. We will give your comments careful consideration.

We have already begun work to integrate R with WebFOCUS and Python is next. I am following this post so please feel free to comment in the future.

See you at Summit 2018.


Regards,

Ira Kaplan
WebFOCUS Product Research
Information Builders


WebFOCUS 8.x, Windows 10, Ubuntu Linux
 
Posts: 13 | Location: New York City | Registered: March 01, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Any progress/update on integrating R and Python into the WebFocus environment?


WebFocus 8.201M, Windows, App Studio
 
Posts: 191 | Location: Lincoln Nebraska | Registered: August 12, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I believe 8.205 will have both a Python as well as an R Serve adapter. The Python adapter will let you create synonym for a Python Script.


WebFOCUS 8203, Unix, Windows
 
Posts: 1328 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Good to know. Thank you BabakNYC.

I wonder if there will be a "SQLOUT" for those languages as well...


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1055 | Location: USA | Registered: January 27, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I doubt it because you're really creating a master file for a script.


WebFOCUS 8203, Unix, Windows
 
Posts: 1328 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I just wasn't sure the breadth and depth of support for Python and R that was coming. Would we be able to use it in ways beyond just connecting to data with? Like using it inline with WebFOCUS for analytical preprocessing, etc. instead of relying on what masters dictate.


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1055 | Location: USA | Registered: January 27, 2015Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Is there a projected date when a Python adapter would be available? Does IBI have any information on how the adapter will work and what capabilities will it give developers?


WebFocus 8.201M, Windows, App Studio
 
Posts: 191 | Location: Lincoln Nebraska | Registered: August 12, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Jfr99

I downloaded a pre-release of the 8.2.05 reporting server and there is a Python adapter available. I'm not sure of the real release date of this version but at least you know it is coming soon. You can contact techsupport to see when it will be released.

Just to be clear you will have to license the adapter in order to use it.

This message has been edited. Last edited by: FP Mod Chuck,


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1204 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Hi. I appreciate our customers' interest in the new WebFOCUS scripting language integration. The adapter for R scripts, the "Rserve adapter", is available beginning with WebFOCUS Reporting Server 8203 and is described in the manual "WebFOCUS Adapter Administration: WebFOCUS Reporting Server Release 8203", available at: https://webfocusinfocenter.inf...adapteradmin7708.pdf

The Rserve and the upcoming Python adapter (in development) are available as part of the "WebFOCUS Data Science and Predictive Analytics Bundle." For licensing information please contact your Information Builders account executive; the feature code is WDSP.

As a manager in the WebFOCUS Product Research group I can answer your technical questions about the adapters. Please post public questions to this message chain and I will respond. For private messages please contact me directly: ira_kaplan at ibi.com

Next week I will post a longer message describing how the adapters work. For a user's perspective the adapter are used in COMPUTEs.


For example, to run the R script below, using a regular expression to extract an email address from a longer sentence, the fex is:

-* consume_regex.fex

TABLE FILE SENTENCES
PRINT
SENTENCE
COMPUTE Email/A100 MISSING ON ALL = RSERVE(regex/regex_run, sentence, email); AS 'Email'
END

--------------------
The R script is:

# regex_run.R

args <- commandArgs[trailingOnly=TRUE)
input_file <- file.path[args[1])
output_file <- file.path[args[2])

sentences <- read.csv[input_file, stringsAsFactors = FALSE)

pattern <- '\\b[A-Z0-9._%+-]+@[A-Z0-9.-]+\\.[A-Z]{2,}\\b'

m <- regexpr[pattern, sentences$sentence, ignore.case = TRUE, perl=TRUE)

# keep non-matches as NA
no_match <- -1

# create a vector of NA's, results, length is the number of sentences
results <- rep[NA, nrow[sentences))
results[m != no_match] <- regmatches[sentences$sentence, m)

sentences_and_emails <- cbind[sentences, results)
names(sentences_and_emails) <- c['sentence','email')

write.csv(sentences_and_emails, output_file, row.names = FALSE)

--------------------

And the input and output appear as (report formatting was lost in the cut and paste):
sentence Email
Lorem ipsum XXXX dolor sit amet, consectetur adipiscing elit. NA
Lorem ipsum JohnNTorres@dayrep.com dolor sit amet, consectetur adipiscing elit. JohnNTorres@dayrep.com
Integer non velit CarlosKSettle@dayrep.com ex. CarlosKSettle@dayrep.com
Nullam viverra mauris ac metus semper CharlesKSolomon@armyspy.com dapibus. CharlesKSolomon@armyspy.com
Donec congue vitae nisi MichaelMBriggs@fleckens.hu convallis maximus. MichaelMBriggs@fleckens.hu
Vestibulum at KristinHJames@dayrep.com ornare nibh. KristinHJames@dayrep.com
Aenean eu ChristinaDSchwartz@gustr.com venenatis justo. ChristinaDSchwartz@gustr.com
Nam porttitor enim sed justo MarieLCausey@einrot.com semper, ac tempor erat aliquam. MarieLCausey@einrot.com
Donec fermentum, eros ut dignissim sollicitudin, ex magna interdum mauris, GeraldineRWilliams@cuvox.de et auctor justo mauris eget metus. GeraldineRWilliams@cuvox.de

---------------

Regards,
Ira


WebFOCUS 8.x, Windows 10, Ubuntu Linux
 
Posts: 13 | Location: New York City | Registered: March 01, 2010Reply With QuoteReport This Post
Member
posted Hide Post
News flash! The Python adapter is now available in WebFOCUS 8205. More information to follow.

Regards,
Ira


WebFOCUS 8.x, Windows 10, Ubuntu Linux
 
Posts: 13 | Location: New York City | Registered: March 01, 2010Reply With QuoteReport This Post
Member
posted Hide Post
Hello Focal Pointers. I want to hear from you. I plan to give the following sessions at Summit 2019 (also to be presented as webinars) and I want to know what you think.

#1: Introduction to Programming with Python (lecture)

#2: What We Can Do with WebFOCUS and Python (lecture)

#3: Hands-on with the Python Adapter (lab)


Regards,

Ira Kaplan
Manager, WebFOCUS Product Research


WebFOCUS 8.x, Windows 10, Ubuntu Linux
 
Posts: 13 | Location: New York City | Registered: March 01, 2010Reply With QuoteReport This Post
Member
posted Hide Post
Those sound great! I'm looking to see in Python in action


WebFOCUS: 8.2.02, OS: Windows 10
 
Posts: 4 | Registered: September 11, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
These would be great Summit presentations and webinars. Always up for language-oriented sessions.


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1055 | Location: USA | Registered: January 27, 2015Reply With QuoteReport This Post
Gold member
posted Hide Post
Ira - Please do present these. I will be at each one for sure!


WebFOCUS 8.1.05M - Production
WebFOCUS 8.2.03 - Sand Box
Windows 2012 R2 Server
HTML, PDF, Excel
In FOCUS since 1980
 
Posts: 90 | Location: Seattle, WA | Registered: April 07, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SHARING] WebFOCUS – Scripting Language Integration

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.