[SOLVED] Procedure to retrieve the data from sharepoint side to WebFocus.
Hi,
This is Yogesh, i need to know the Procedure to retrieve the data from sharepoint side to WebFocus.
can anyone please respond me at the earliest as this is the high priority project.
Thanks in advance! YogiThis message has been edited. Last edited by: Kerry,
WF 7.1.4 Excel,PDF,HTML
October 17, 2008, 02:36 AM
<JG>
Standard consultancy rates are $1,200 per day
October 17, 2008, 02:45 AM
Tony A
JG,
You forgot to mention about expenses, as this could be anywhere in the World!!
T
October 17, 2008, 02:47 AM
Tony A
Yogesh,
quote:
can anyone please respond me at the earliest as this is the high priority project
So what have you done yourself to try and establish how to do this? Anything at all yet?
T
October 17, 2008, 03:02 AM
Ranjan
Hi Tony,
Thanks for your response... we have created MFD's for sharepoint site. if we try to fire a query to sharepoint site it is not allowing us to retrieve the data.
thanks Yogi
Originally posted by Tony A: Yogesh,
quote:
can anyone please respond me at the earliest as this is the high priority project
So what have you done yourself to try and establish how to do this? Anything at all yet?
T[/QUOTE]
WF 7.1.4 Excel,PDF,HTML
October 17, 2008, 03:15 AM
FrankDutch
Ranjan
Find someone from your technical IT department and ask them to give IBI read access to the sharepoint database.
Find also someone from your managent and ask him to give you some basic traning.
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
November 03, 2011, 09:03 AM
roy
Instructing someone to get training is solving the problem? That helps how?? In access 3 mouse clicks and you can import SharePoint tables In web focus it takes administrators, SharePoint gurus, permissions, and Training ??? The problem is WEB FOCUS and its “DATA Adapters” A quote from a web focus marketing PDF "With more than 300 data and application adapters, organizations can access data at every latency level from real-time, zero-latency transactions to staged data in the most summarized data mart."
Apparently SharePoint isn’t one of them Access it takes 3 mouse clicks!!!! So what is the solution
WebFOCUS 7.6 Windows, All Outputs
November 03, 2011, 11:00 AM
njsden
I don't think I understand the reason behing the "tone" of your comment Roy or even the analogy you're trying to make.
Access probably connects easily to SharePoint because they're Microsoft products and they're usually designed to interconnect and interact with each other.
Obviously, when you deal with integrating disparate technologies there's always some initial infrastructure setup (config, security, etc.) that has to be done and that you'll find in many platforms that are truly designed for integration ... that isn't just a "WebFOCUS" thing.
Have you managed to integrate SAS, Cognos, Business Objects or other big BI player with all those many technologies without any configuration setup?
Access is not a BI tool per se but regardless, can it connect to Oracle, DB2, SAP, SAS, MySQL, FOCUS, XFOCUS or any JDBC-compliant database in just 3 clicks? At least you'll need ODBC configurations to make that happen and for that you'll likely have to involve administrators, permissions and in many cases training.
quote:
The problem is WEB FOCUS and its “DATA Adapters”
Quite the contrary. Data Adapters are the solution to bringing together infomation from disparate data sources and platforms and integrating them under one single spot. It would be amazing if WF could connect "natively" to any technology out there but as new of those emerge, they would need to rewrite WF every time to keep it up-to-date. I honestly don't know of any BI tool that can natively connect to *everything* available, that's why adapters are needed, and yes, even Access needs data adapters (that's what ODBC is) if it wants to connect to anything that is not a Microsoft product.
I will Ask Ranjan what was the solution, how did they finally extract the data/mas from SharePoint data. I have not gotten the DATA Adapter to extract a response WSDL URL connected as i can create methods synonym Apparently now I must edit the Mas file strategically The Default getlistandview.mas
Thank you for taking the time to write a clear-headed rebuttal - I couldn't, I was seeing red.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
November 03, 2011, 02:43 PM
Francis Mariani
Roy, did you search this forum for Sharepoint related posts? There are quite a few. At least one of them discuss the required modifications to the Master. Then there's Tech Support - did you open a case, or search for cases related to Sharepoint?
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
November 03, 2011, 03:21 PM
roy
Yes I opened a case and had the pleasure of meeting Walter F Blood. We discussed how difficult the WSDL URL and Methods are to configure... Was hoping others expert or virtuosos user had success and were willing to share the how to.
WebFOCUS 7.6 Windows, All Outputs
November 03, 2011, 03:21 PM
njsden
quote:
I was seeing red
Not only you my friend. I can't tell you how many times I hit the backspace key while typing.
If this is a high priority project and needs an answer quickly, this is the wrong place to ask for it. After doing a doc search,a call to the IBI helpline would have been the appropriate venue.
To help you a bit, we solved the same problem by having the Sharepoint admin push the needed data into a MSSQL table and then we use WebFocus to run against that.
Your other option is to purchase the WebServices connector at extra cost. Of course that also entails training, documentation, meetings, security, testing...I would go with the MSSQL data push.
JG, Tony, Frank, Njsden, Francis ... Right On!
In FOCUS since 1985 - WF 8.009/8.104 Win 8 Outputs: ALL of 'em! Adapters: Sql Server Teradata Oracle
November 03, 2011, 03:28 PM
njsden
quote:
had the pleasure of meeting Walter F Blood.
Same here. Such a gentleman and deep [Web]FOCUS connoisseur. It's really a humbling experience getting to share with some of the folks behind the technology I've been using and enjoying for the past ... er ... many, many months.
I have decided to abandon WEB Focus WSDL connectivity to SharePoint as a method of extracting data into WF reports.
This convoluted configuration and editing of MAS files can be accomplished in 3 mouse clicks via Microsoft Access; furthermore the price of MS Access is free if you compare it to an enterprise Web Focus license fees.
WebFOCUS 7.6 Windows, All Outputs
November 16, 2011, 09:35 AM
Anatess
Roy, yes, MS Access is relatively free and if it works for your installation, then great!
Unfortunately, an international company the size of Siemens cannot use MS Access as the enterprise solution, so we have to try to figure out a more robust method.
I am very interested in this solution. The best way to connect Sharepoint with Webfocus is through Open Portal Services. Unfortunately, as of now, we don't have that technology. So, our administrators, trainers, etc. etc. gave us the MS Access, SQL Server, and ODBC adapters that can be used to connect to Sharepoint.
So, I linked Sharepoint to MS Access and got Webfocus to create a master file through that Access synonym. But, I get the super generic "Could not find installable ISAM" error. Grrr...
So, what I did in the interim is write an Access macro to extract the data from the Sharepoint link to an Access Table that I run on a schedule. We then created the master file off that Access Table instead of the Sharepoint synonym. Ugly. Very ugly. But, it's working right now until we get OPS.
If somebody here can tell me how to solve the "Could not find installable ISAM" error, I'm all ears.
We're on Access 2003, Webfocus 7.6.4.
WF 8.1.05 Windows
November 17, 2011, 08:50 AM
roy
Anatess I’m also with a large multinational financial institution, and all preferred vendor production software is site licensed by the enterprise and only after extensive quality testing are new version released. Needless to say we are never on the most current software revision, and can’t take advantage of new features/adapters.
Disappointed am I with the WSDL URL documentation and claims that Data from SharePoint can be used in reporting. It would be different if the “Gurus” showed all of us how it works instead of offering a blanket statements like
Standard consultancy rates are $1,200 per day Or Find someone from your technical IT department and ask them to give IBI read access to the SharePoint database. (Financial Institution that's not going to happen ) Find also someone from your managent and ask him to give you some basic training. (Basic, If its Basic then show me how) Or Solved the same problem by having the SharePoint admin push the needed data into a MSSQL table and then we use WebFocus to run against that. (That's just the SQL Data Adapter configured to the SQL sever) Or Purchase the WebServices connector at extra cost. (Extra Cost is you kidding me an enterprise license IBI makes the claim that their data adapters are like the bees knees best of breed)
This is not an obscure OS on an obscure software, this is SharePoint and IBI states that WSDL can extract data from it.
Thank You, For your honest response and suggestion a breath of fresh air in this stuffy holier-than-thou form
WebFOCUS 7.6 Windows, All Outputs
November 17, 2011, 09:58 AM
DavSmith
Roy, get ready for the onslaught. And people won't be using their backspace key.
Your childish rant is unprofessional, uncalled for, untrue, and a complete waste of my time (and that includes writing this response).
If you are so immature as to not understand the help that was offerred or old enough to understand some of the humor, you are visting the wrong community help site.
Complaining about the software is one thing, but complaining about the lack of...help getting whatever it is you don't have? There are events going on today where you'd fit right in...
Look, I am one of many who have received thoughtful, inciteful, helpful, and "teach a man to fish"-able advice from the professionals on this board from all over the world and I hope your insults will not keep them from continuing to offer their support and help in the future.
You, sir, are the lucky winner of the 'First poster to be ignored by DavSmith on FocalPoint' award.This message has been edited. Last edited by: DavSmith,
In FOCUS since 1985 - WF 8.009/8.104 Win 8 Outputs: ALL of 'em! Adapters: Sql Server Teradata Oracle
November 17, 2011, 11:34 AM
njsden
quote:
'First poster to be ignored by DavSmith on FocalPoint'
Thanks DavSmith for taking the time to write this. That's exactly the reason I personally had decided not to respond anymore .
I am certainly no "Guru" and just attempt to offer whatever help I can when I can with the best of my intentions as I'm sure most members of this forum do, and in consequence find the attitude of blaming or criticizing any of them for one's limitations to find a solution not only disrespectful but also very offensive.
No matter what level of frustration one's facing I take those comments almost as personal attacks and don't appreciate that at all.
Njsden, well said. Also, I appreciate the posts you have spent you're time crafting. They are well thought out and well written.
As a matter of fact, since it's the season, I want to thank all of the posters who spend their time to help. You help educate the whole community of WebFocus users and by that, help the businesses that rely on our expertise, which in a round-robin way, helps keep us employable!
And thanks to the people who post the questions. Without them, there'd be no answers to learn from. Sometimes, the questions get me to work through solutions on my own which is the best way to learn.
I just gotta say, I love me some FocalPoint.
So for this season and throughout the year, peace and safety to all.
In FOCUS since 1985 - WF 8.009/8.104 Win 8 Outputs: ALL of 'em! Adapters: Sql Server Teradata Oracle
November 17, 2011, 12:24 PM
njsden
quote:
And thanks to the people who post the questions. Without them, there'd be no answers to learn from. Sometimes, the questions get me to work through solutions on my own which is the best way to learn.
Couldn't have said it better myself!
Some questions are really challenging and they push me to investigate and try out new things. Sadly, I don't always have access to the appropriate environment or resources to play with (such as the lack of a SQL Server install or WSDL license, for instance) but when I do, I enjoy trying those cases out.
Man, some of them had really made me scratch my head; the funny part is that just when I'm reaching the point of bleeding someone comes up with a much more elegant and efficient solution than the one I was crafting so I haven't needed band-aids yet but the learning remains nevertheless.
So anybody want to take a shot at trying out the MS Access link to Sharepoint and then trying to use the MS Access Webfocus Adapter to create a master file to that link?
I wanna see if y'all get the same "Could not find installable ISAM" error.
It would be kinda like a... uhm... advanced Christmas gift. I promise I was good all year...
WF 8.1.05 Windows
November 17, 2011, 02:54 PM
roy
So some want truth, some actual will challenge the fact that this SharePoint thing is not solved at all, and some will request accountability from the vendor...
“Give me a lever long enough; a fulcrum strong enough and I'll move the world”
WebFOCUS 7.6 Windows, All Outputs
December 10, 2019, 12:53 PM
vaayu
So I'm exploring options to report off SharePoint lists. Has anyone had any success? If so, please share your wisdom Thanks!