Skip to Content
Author's profile photo Former Member

Announcing the New SAP Web Service Design Tool for Crystal Reports Server

Many existing customers and partners utilize the Flynet utility that comes free with Crystal Reports Server so that they can easily develop web services against relational data sources.  With the release of Crystal Reports Server 2008 SP2, we have also released a new utility that will replace the current Flynet solution, but will allow our customers and partners to achieve the same objective.  The SAP Web Service Design Tool is now available and can be downloaded from here.

The new SAP Web Service Design is very straight forward; however, I have provided a few screenshots below to give you an idea of what the tool looks like. 

If you are interested in or have the requirement to quickly deploy web services on top of your relational data, please take a moment to download the tool and give it a try.  We are very interested in hearing your feedback. So, let us know what you think.

Brief Walkthrough

Upon launching the tool, you will be presented with the following screen:

 

 

In order to start creating your first web service, you will click on the “New Connection” button.  This will bring up a wizard that will walk you through connecting to the myriad of supported data sources.  In my example, I’m connecting to the standard eFashion database.

 

On the next screen, I choose my DSN and click on “Test Connection” to ensure that the connection works okay.

 

The next screen simply provides a summary of my connection details. I click on Finish and am taken to the main screen of the application. From here, you can see that my connection, called eFashion, has been defined and is listed under the Connections portion of the application window.

 

My next step towards creating a web service is to define the query that will provide the data for my web service.  To do this, click on the “New SQL Query” button.  This will bring up a wizard which will walk you through the process of creating your query against your defined connection.

On the first screen of the wizard, you define the name of your query, what type of query you want to define (i.e., Select, Insert, Update, etc…) and the connection that you want to utilize.

 

On the next screen, you can select the table that you want to use to define your query.

After clicking on “Next”, you will be able to choose your fields that you want to include in your query.

 

 

 

The screen after this one allows you to define any filters that you want for the query and the final screen provides options for further editing the query in either Visual Mode or Expert Mode.  Visual Mode allows you to insert a new table for the query and continue refining your query in others ways by using GUI buttons and commands.  Expert Mode allows you to build the SQL Command by typing out SQL syntax.  Once you are done, you can save the query and then execute it to ensure that it returns the proper results.

 

You’ll notice that even though I have saved my query, it is not displayed under the Queries portion of the application.  You can only see queries that have been created against specific connections. So, I will only be able to see this new query I have created after selecting my “eFashion” connection first.

 

Now that I have my query created, I can proceed with creating my web service.  To get started, click on “New Web Service”.  Again, this will bring up a wizard to walk you through the process of creating your web service.

 

After defining my web service name, the query I want to use for creating the web service, and the path where I want to deploy the web service, I click on “Next”.  The final screen shows a summary of my selections and allows me to deploy the web service now or choose to do so later.

At this point your web service has been deployed and you can begin consuming it through whatever application you like – whether it’s Xcelsius or some other tool.

Assigned Tags

      56 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Safari, too?
      Author's profile photo Former Member
      Former Member
      Hi Greg,

      The WSDT is a desktop level tool that allows for the creation of web services against relational or text-based data.  The browser support would only come into play, potentially, when you start talking about how you consume that web service.  If the consumption experience is via a browser-based application, then safari support would be dependent on whether that application supports safari.

      Coy

      Author's profile photo Former Member
      Former Member
      if you need a web based tool that works througha  browser and runs on java/tomcat web service generator we have one available currently free as part of the beta of the Dashboard Launch for Xcelsius

      http://www.xcelsiusdashboardpro.com/

      Author's profile photo Amr Salem
      Amr Salem
      why it always comes under IIS, even the free flynet.
      cant we have the same but under Tomcat and Java based?
      Thanks
      Amr
      Author's profile photo Former Member
      Former Member
      Hi Amr,

      Yes, we are considering when we can make this available for Apache/Tomcat and Linux platforms as well.  I do not have any details now as to when this will be available.

      With the new WSDT we wanted to ensure that we initially provided coverage for the existing customer base - which is all .NET (as that is what Flynet supported).

      Coy

      Author's profile photo Former Member
      Former Member
      if you need a java/tomcat web service generator we have one available currently free as part of the beta of the Dashboard Launch for Xcelsius

      http://www.xcelsiusdashboardpro.com/

      Author's profile photo Former Member
      Former Member
      Hi,

      I have to migrate 6 projects built with Flynet. Does it exist a special method? How long does it take to convert a Flynet service to a SAP Web service?

      Thanks

      Author's profile photo Former Member
      Former Member
      Hi Jo,

      There is not automatic or batch migration from the existing Flynet solution to the new SAP WSDT web services.  The amount of time taken to migrate will be limited to how long it takes you to deploy the new WSDT and map your existing consumption experience to those new web services.

      Coy

      Author's profile photo Sergey Vlasov
      Sergey Vlasov
      Very interesting tool. Is it possible to use it with BOE? Can it use BO universe as data source? Could you please compare it with QaaWS and LiveOffice. Does it have an official support from SAP?
      Author's profile photo Former Member
      Former Member
      Hi Sergey,

      Apologies on the delayed response.

      Technically, this tool may work with BOE; however, it has not been tested. I plan to test this and work with the necessary teams to officially support this deployment.

      Today, it is not possible to consume a BO Universe via the WSDT.

      It does have official support.

      Coy

      Author's profile photo Former Member
      Former Member
      Hello,

      I have licensing issues using SAP Web Service Design Tool and Xcelsius Enterprise 2008. After creating web service with SAP WSDT and using it in Xcelsius Enterprise 2008 Web Service Connection, during the runtime of the generated SWF I get the following error "Number of active connections exceed Xcelsius CALs" and the data is not fetched from the data source. SAP WSDT options / licensing lists one Xcelsius license key but total standalone licenses equals to 0. The Xcelsius 2008 license key is valid and working in Xcelsius 2008. No SAP BusinessObjects or Crystal Reports 2008 server is used in this case.

      Why this issue appears and what license keys should be used in SAP WSDT?

      Donatas

      Author's profile photo Former Member
      Former Member
      Hi Donatas,

      Please give me a day or so to liaise with the development team on this issue and I'll get back to you.

      Coy

      Author's profile photo Former Member
      Former Member
      Did you ever get any word back from the Development Team? I have the same licensing issue.
      Author's profile photo Former Member
      Former Member
      Hi Mark,

      I'm testing the issue now. In the meantime, please ensure that you have one of the following license keys on the system where you are running WSDT:

      •     Xcelsius Engage
      •     Xcelsius Engage Dev
      •     Xcelsius Present
      •     Xcelsius Engage Server
      •     Xcelsius Enterprise

      Also, how many web services have you created and how many connections do you make to a single web service before seeing this issue?

      Coy

      Author's profile photo Former Member
      Former Member
      (This is Mark, but I'm posting under another account - I've mixed up my SAP logins).

      I have a trial of Xcelsius Enterprise installed on the same server as a licensed version of Crystal Reports Server 2008. The Web Services Design Tool is also installed on the same server.

      I have created one web service on this server. I created another web service on another server during initial testing and had the same issue. From what I can tell, this issue appears as soon as I make a single connection.

      Author's profile photo Former Member
      Former Member
      Since my earlier message, I have uninstalled the test Xcelsius Enterprise and replaced it with a licensed copy of Xcelsius Engage. I have created a new web service and tried to access it, with the same results as before.
      Author's profile photo Former Member
      Former Member
      Hey Mark,

      Thanks for the update.  I have replicated the behaviour and am working to determine the cause. I will update this thread before the end of the day tomorrow with another update.

      Coy

      Author's profile photo Former Member
      Former Member
      Hey Mark,

      I just finished writing up the results of my testing in another blog.  You can review it here: http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20089. [original link is broken] [original link is broken]

      Based on the results of my testing, the only license keys accepted by the WSDT are Xcelsius Engage and Crystal Reports Server.  As you have tried an Xcelsius Engage license and are still seeing issues, I would ask that you remove all Xcelsius keys except for the Xcelsius Engage key from the WSDT list of keys.  Then restart the SAPLicenseService and see if you still get the same error.

      Let me know if this works.

      Coy

      Author's profile photo Former Member
      Former Member
      Coy,
      Thanks for continuing to look into this issue. I tried manually entering in the Xcelsius Engage key and the Crystal Reports Server 2008 key, but each key gave me an "Invalid Key" message. However, when I did the Enterprise Server lookup for my CR Server 2008, it pulled up 5 licenses and my test web service started working.

      Now, I have two more questions:
      1. Since I have 5 licenses, does that mean that I can only have 5 connections at a time to each web service, or are the 5 connections at a time shared between all web services created with the tool? Meaning, if I create 10 web services with corresponding Xcelsius dashboards, only 5 of those dashboards can be viewed at one time? Or, can each web service with its corresponding dashboard have 5 viewers at a time independent of how many people are viewing the other dashboards?
      2. How does the SAPLicenseService work? If I pull up a dashboard that is tied to a WSDT-created web service, then close the dashboard, how long does it take for the CAL that was reserved for that connection to be released and made available for other users?

      Thank you again for your continued work and support on this issue.

      Author's profile photo Former Member
      Former Member
      Hi Thomas & Coy,

               I had created one Xcelsius dashbaord using flynet web service. In that dashboard i have used 20 flynet web services. But when i have created 20 web services in SAP WSDT and I am not able refresh that dashboard. When I enter that web service URL into the browser it shows "number of active connections exceed Xcelsius CALs."

      I have installed BusinessObjects Edge 3.1. 10 CAL licenses and not Crystal reports. so will it work or not?

      So please guide me about license of SAP WSDT with Xcelsius.

      regards,
      Saurabh

      Author's profile photo Former Member
      Former Member
      Hi Coy,

      Any answer on this issues????
      I am going nowhere and i need to get this test going....

      Regards,
      Manuel Roman

      Author's profile photo Former Member
      Former Member
      Hi,

      I am having the same issue... the query works fine in the Design Tool but it doesn't pull any data from Xcelsius... getting the same message ""Number of active connections exceed Xcelsius CALs"....
      Any fixes or suggestions yet???

      Regards,
      Manuel Roman

      Author's profile photo Former Member
      Former Member
      Hi Manuel and Donatas,

      I'm currently setting up a test environment to replicate this behaviour.  The development team was not able to replicate the problem. 

      I've already spoken with Donatas about this, but Manuel, can you confirm that you have a license for one of the following products on the machine where you are running the WSDT?

      •     Xcelsius Engage
      •     Xcelsius Engage Dev
      •     Xcelsius Present
      •     Xcelsius Engage Server
      •     Xcelsius Enterprise

      Coy

      Author's profile photo Former Member
      Former Member
      Hi Coy,

      Yes, i do have Xcelsius Enterprise.

      Regards,
      Manuel

      Author's profile photo Former Member
      Former Member
      Hi Manuel,

      I have just replicated the error and am working to determine the cause. I will have another update before the end of the day tomorrow.

      Coy

      Author's profile photo Former Member
      Former Member
      Hi Coy,

      Sounds great,
      Thanks

      Manuel

      Author's profile photo Former Member
      Former Member
      Hi Coy,

      Any update on this issue???

      Regards,
      Manuel

      Author's profile photo Former Member
      Former Member
      Hey Manuel,

      I just finished writing up the results of my testing in another blog.  You can review it here: http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20089. [original link is broken] [original link is broken]

      The key takeaway for you from this exercise is that there was some misunderstandings internally here at SAP with regards to what type of licenses the WSDT would consume.  The only licenses which the WSDT recognizes are Xcelsius Engage and Crystal Reports Server. This is because this initial release of the WSDT is meant to serve those customers which were using the Flynet solution before.  Those customers had access to Xcelsius Engage and Crystal Reports Server.

      Please let me know if you have any questions.

      Regards,

      Coy

      Author's profile photo Former Member
      Former Member
      Hey Donatas,

      Sorry for the delay.  I have just replicated the error and am working to determine the cause. I will have another update soon.

      Coy

      Author's profile photo Former Member
      Former Member
      Hi Donatas,

      I have finished my testing. You can find the results in this blog: http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20089. [original link is broken] [original link is broken]

      The key takeaway for your issue is that the WSDT only recognizes Xcelsius Engage and Crystal Reports Server keys. Please ensure that you are using an Xcelsius Engage key and let me know if you are still having issues.

      Regards,

      Coy

      Author's profile photo Former Member
      Former Member
      Hello,

      thank you very much for the feedback.
      One more question - so it means that if I have Xcelsius Engage only and I am not using Crystal Reports Server (with CAL licenses) I will not be able to use WSDT in Xcelsius Engage? Currently I am using Xcelsius Engage as standalone tool with connection to Crystal Reports Server and still I am facing the same problem.

      Best regards,
      Donatas Budrys

      Author's profile photo Former Member
      Former Member
      Hey Donatas,

      Can you send me a direct email with your Xcelsius Engage license key included? I will test it here to see if I can replicate the same problem with your key.

      My email address is coy.yonce@sap.com.

      Coy

      Author's profile photo Former Member
      Former Member

      Server Error in '/SAPWebserviceGeneratorAdminPage' Application----


      <br/>Version Information: Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2407 <br/><br/>I get the same error (basically) trying to browse the queries that i created...<br/><br/><br/>Any suggestions?<br/><br/>Regards, <br/>Manuel roman<br/>

      Author's profile photo Former Member
      Former Member
      Hi Manuel,

      I see from your post that you are using .NET Framework Version 1.1.  The required version for the WSDT is .NET Framework 3.5.  Can you update to 3.5 and let me know if you continue to have the same problem?

      Coy

      Author's profile photo Former Member
      Former Member
      thanks,

      The default Framework version in IIS was 1.1.
      I changed it to 2.2 and works ok now....

      Regards,
      Manuel

      Author's profile photo Former Member
      Former Member
      hi all,

      when i m clicking on refresh button of 2nd screen i.e. define data source name. at that time my SAP WSDT screen goes hide/close.

      Please suggest other method how i can define my ODBC connection.

      regards,
      Saurabh

      Author's profile photo Former Member
      Former Member
      Hi Saurabh,

      Which version of the .NET Framework are you running?  Can you ensure that you have at least version 3.5 running?

      Coy

      Author's profile photo Former Member
      Former Member
      hi Coy,

      its a 3.5 only which i got along with source of SAP WSDT software.

      regards,
      saurabh

      Author's profile photo Former Member
      Former Member
      Hey Saurabh,

      Are you seeing this issue everytime you click on the refresh button?  I am not able to replicate the problem. Can you ensure that your system meets all of the pre-requisites? You can see those in the installation guide.

      Coy

      Author's profile photo Former Member
      Former Member
      Hi Coy,

      the error comes every time when I clicked on refresh button. i have done this in fresh system after reading installation guide. i have not installed any unwanted software which can cause this error.

      I have to migrate 145 flynet web services in to SAP WSDT. so please suggest any fast method to do it.

      please do the needful.

      regards,
      Saurabh

      Author's profile photo Former Member
      Former Member
      Hi Saurabh,

      Unfortunately, there is no way to migrate the flynet services to WSDT services in batch.  They will need to be recreated one-by-one.

      In terms of the problem you are seeing when refreshing the list of data sources, can you please send me an email so that I will have your email address to include in an email with the development team?  My email is coy.yonce@sap.com.

      Thanks,

      Coy

      Author's profile photo Former Member
      Former Member
      Hi,

      Please guide me how can i view the web services in browser to check the data.

      Also i would like to know that i want to create web service from database view which i am not able to do in SAP webserivce but i was able to do in Flynet.

      Please do the needful.

      thanking in advance,
      saurabh

      Author's profile photo Former Member
      Former Member
      Hi Saurabh,

      I am setting up an environment now which has the WSDT running alongside CRS and Xcelsius Enterprise.  I will send you the details on how to check the web service in a browser and with regards to whether the WSDT can be used against views when I complete my testing (by tomorrow morning at the latest).

      Coy

      Author's profile photo Former Member
      Former Member
      Hi Coy,

      I've tested it with Views and works ok....
      So you know....

      Regards,
      Manuel

      Author's profile photo Former Member
      Former Member
      hi Manuel,

      in select table list box i am only able to see list of tables and store procedures not views.

      So please guide me or send some more information about the same.

      thanking in advance,.
      saurabh
      BOCP-BOE, CR, BODI

      Author's profile photo Former Member
      Former Member
      Hi Saurabh,

      I've done nothing different.
      the list box shows all tables and views....

      Regards,
      Manuel

      Author's profile photo Former Member
      Former Member
      Hey Saurabh,

      You can get the URL for the web service in the WSDT by selecting your web service, right-clicking, and selecting view service summary.  This will show you the URL - along with some other details.

      Coy

      Author's profile photo Former Member
      Former Member
      hi
      thanks for the prompt reply.

      i know it shows in summary, but i am not able to copy that text. every time i have to type that service URL into browser to check.

      regards,
      Saurabh

      BOCP-BOE, CR, BODI

      Author's profile photo Former Member
      Former Member
      Hey Saurabh,

      Unfortunately, this is the only way to get to the web service URL from the WSDT interface.  We can look at adding an improvement in this area to make it easier to copy/paste the URL or just launch the URL from the WSDT.

      Coy

      Author's profile photo Former Member
      Former Member

      Hi Coy & Group Members,Saurabh

      Author's profile photo Former Member
      Former Member
      Hi Saurabh,

      Please check in your list of services to see if the SAPLicenseService is running.

      Coy

      Author's profile photo Former Member
      Former Member
      Hi Coy,

      I have installed Crystal reports designer, Xcelsius 2008 Engage Server, BO Edge 3.1 with SAP integration Kit. I havn't installed Crystal reports server. In my server its not showing any service called SAP LicenseService. I have downloaded SAP WSDT from sdn.sap.com at the time of installation it has not asked for any license keys or any file. So please guide me how to install or activate SAPLicenseService.

      would appreciate your prompt response.

      regards,
      Saurabh

      Author's profile photo Former Member
      Former Member
      Hi Coy,

      This error has been resolved automatically and now i am getting another error. when i am previewing web service in browser it shows "number of active connections exceed Xcelsius CALs."

      I have entered Xcelsius Engage server key in Xcelsius and Xcelsius working fine. When i am checking in SAP WSDT options it shows 0 standalone license with the same key. when I am entering any other key of CRS or Xcelsius it gives an error as invalid key. Also i am not able to write enterprise server path.

      I am not using Crystal Reports server. I am only using Crystal reports designer and BOBJ Edge 3.1 data services.

      regards,
      Saurabh

      Author's profile photo Former Member
      Former Member
      Hi Coy,

      How can you create multiple methods for the same web service (like Flynet).
      In Xcelsius i'd like to be able to connect to one web services and select as many methods i need for the dashboard....

      Regards,
      Manny

      Author's profile photo olumide omolayo
      olumide omolayo
      Hi,
      My question is that I want to migrate the webservice I created on a server A to another server B for editing purpose. I realise that once i create a webservice on a machine, i cannot open it open it on another machine.The only thing I can do is to run the webservice as a url. I want to be able to open the webservice with SAP WSDT so that I can add more queries. Please kindly advise me on how to achieve this. Thanks
      Author's profile photo olumide omolayo
      olumide omolayo
      Hi,
      I am having this error on my webpage in certain part of the webservice I deployed. The message is :

      System.web.services.protocols.soapexception: server did not recognise the value of HHTP Header SOAPAction:

      I have tried to check the query listed, there is no problem with it.It is one of the queries I migrated from flynet.

      I have checked several solutions pertaining to this error(

      Add this attribute on the class

      [SoapDocumentService(RoutingStyle = SoapServiceRoutingStyle.RequestElement)]

      )

      but I cant implement the one that has to do with editing the webservice class because the class is compiled.

      Have you encountered this error before?It's really causing serious problem on my dashboard.

      Please kindly help.

      Thanks