Skip to Content

Previous blog The Full Monty – Part 16 – NetWeaver Business Client Install & Configure.

Now branching away from the SDN Free Trial Offerings, to some further interesting products.

In this blog I downloaded and installed the BObj Data Services (DS) from the SAP Support Portal www.service.sap.com/support.

I navigated to the BObj Portfolio page

Download

image

 

and then, to the download page (see the breadcrumb path). I downloaded and unzipped both objects to a location on my machine.

image

 

The documentation “xi32_ds_install_win_en.pdf” also came in handy, found on the “Info Page”

mySQL

FYI: The Data Services (DS) requires a database to operate over. In my “The Full Monty” scenario, we already have a “mySQL” database we can use (installed during BObj Edge).  Of course, you do not have to choose this option, and use the “mySQL” db that comes with the installation.

In reading the documentation, I found I must create an empty db on my “mySQL” for the DS, prior to the installation, so I needed to find a program that can help me create an empty database in my “mySQL” database.

I downloaded and installed “mySQL Workbench 5.2”. There are many places from which you can download “mySQL Workbench”. I  used the installation file “mysql-workbench-gpl-5.2.26-win32.msi” at 23MB.

I also need to create the corresponding ODBC connection in Windows 7.

The only issue worth mentioning was an error I received about, not being able to connect to a firewall.

image

 

I chose to “Ignore” this message, and the installation completed soon after, with a Windows Program Group “MySQL” and the “MySQL Workbench” program

 

image

 

 

I started the “Workbench”

image

 

 

and was presented with an initial Workbench Central screen

image

 

I decided to use this tool, and take a look at the installed BObj Edge databases.

To look at the databases in “mySQL”, they needed to be up and running, and as I had set the “BOE120MySQL” to “Manual”

image

 

 

I had to open the Windows Services and press the “Start” button, so the Workbench will be able to see it.

I also needed to perform a little configuration.

I double clicked on the “New Connection” to connect to my BOE Edge dbs

image

 

 

I gave the “Connection” a name “BOBj mySQL installation”, I pressed the “Store in Vault…” button to add my password

image

 

 

Then I pressed the “Test Connection”. All good there, then  I “OK” to exit

image

 

 

My connection was now setup

image

 

 

I double clicked the new connection

image

 

 

and could see my two BOE schemas( boe120 & boe120_audit), with various tables.

Next I double clicked the “Server Administration”, so I can manage the machine hosting the databases. i.e. my pc

image

 

 

I chose “Take Parameters from Existing Database Connection”, the connection previously setup, “Next”

image

 

 

All was good on the next “Testing the Database Connection” screen, so “Next”

image

 

 

When specifying the OS, I was not really sure what I was doing, so I chose the highest version available to me “Windows (MySQL 5.5 x86 Installer Package)”, then “Next”

image

 

 

When the “Testing Host Machine Settings” screen appeared, I received some sort of an error. In looking into it, I found it was looking for a file called “my.ini”. There was nothing I could do, other than click “Next”

image

 

 

Now, at the “Information about MySQL configuration” screen, the “Path to Configuration File” field was open to edit, I could do something about that error message

image

 

 

I hunted down the file “my.ini” which was located in the “C:Program FilesBusiness ObjectsMySQL5” directory

image

 

 

And set the “Path to Configuration File:” parameter accordingly. I “Check Path” & “Check Name” which returned valid, then “Next”

image

  

 

At the next screen, “Specify commands to be used …” I took note of the line “If you are unsure what these values mean …” So I left them untouched, then “Next”

image 

 

 

I kept the defaulted “Server Instance Name”, and “Finish”

image

 

 

with my new “Server Administration” configuration

image 

 

 

I double clicked the “Server Administration” and was presented with a dashboard

image

 

 

I closed it, and had my “Workbench Central” screen with my two configuration settings, presented to me

image 

 

I was now able to create an empty database in for my DS installation.

I made sure the “BOE120MySQL” Windows Services was up and running, then I double clicked my “BObj mySQL installation” connection, and entered the “SQL Editor” for my connection, to add a new database.

Note, I am going to use the term “schema” and “database” synonymously, depending on the context and usage.

I selected the “Create a New Schema” button

image

 

I gave my Schema the name “dataserv”, and pressed the “Apply” button

image

 

on the next screen, simply pressed the “Apply SQL” button

image

 

then the “Finish” button

image

 

my changes were applied, and so I pressed “Close” to exit

image

 

and my new “dataserv” Schema was present, along side the other two BObj Edge Schemas

image

 

Note: that I used the user “root” with my appropriate password that was setup originally when the BObj Edge installation commenced.

I exited the Workbench.

The final preparation for my “dataserv” schema, was to create an ODBC connection to it.

I navigated to Windows->Control Panel->Administration Tools

image

 

then “Data Sources (ODBC)”

image

 

I chose “Add…”

image

 

I selected the “MySQL ODBC 3.51 Driver” driver

image

 

I then added some details. I lifted the “User” and “Server” parameters, from one of the other Business Objects ODBC connections that existed.

For the “Database” I made sure I chose my “dataserv” database, and for the “Data Source Name” I chose, “BusinessObjectsDS”

Important: Make sure the Data Source Name, does not have any spaces in it

image

 

and entered the port 3306, then “OK” to exit

image

 

my new connection was configured and ready to use

image

 

Installation

With my “BOE120MySQL” Windows Service running, I navigated to the location where I unzipped the Data Services files I downloaded, and ran the “setup.exe”

image

 

After a minute or so of nothing, the Installation Wizard began, I clicked “Next”

image

 

accepted the License Agreement

image

 

entered the License Key associated to “Data Services” XI3.x

image

 

kept the default installation directory

image

 

chose to install the entire features

image

 

at the “Repository selection” screen, I was hoping to use the database “dataserv” that I have previously read, I needed to create.

I chose “Reuse and existing BOE MySQL instance” 

image

 

Then I entered the appropriate parameters to point to my “dataserv” database

image

I pressed the “Get Version” button, to see what that would do, and I received the following error

image

 

So I then pressed the “< Back” button and changed my option to “Use and existing database server”, and again, after pressing the “Get Version” button, I received the same error message

image

 

I thought, I would just plough through the screen without pressing the “Get Version” only the same error message kept popping up

The only way I could progress was to choose the “Skip configuration”

image

 

at the next screen “Reuse configuration information”, I kept the default “Yes, reuse the configuration” option

image

 

at the “Login information” screen, it prompted for my nspadm username’s password

image

 

I kept the option “Reuse existing Access server, if any”

image

 

kept the “Reuse a Tomcat instance installed …”

image

 

passed through through the “Start Installation” screen

image

image

 

and the installation began

image

 

I got an error, looking for a file, so I navigated to where it said it was, and found it was there, so I clicked “Retry” and the installation continued.

image

 

15mins later, the installation ended

image

 

and I clicked “Yes” to a reboot

image

 

After rebooting, I checked the Windows Services and noticed two new Services

  • BusinessObejcts Address Server
  • BusinessObjects Data Services

 

image

 

I changed the “BusinessObjects Data Services” Service, Start up type to “Manual”

image

 

and modified my “start.bat” and “stop.bat” files accordingly (see The Full Monty – Part 15 – Tuning)

  • net start DI_JOBSERVICE
  • net stop DI_JOBSERVICE

 

The installation created a Windows Program Group “SAP BusinessObjects XI 3.2” with programs within.

 

image

 

Configure

I manually started the following Windows Services

  • BusinessObejcts Address Server
  • BusinessObjects Data Services

I then opened “Data Services Management Console”, user “admin”, password “admin”

image 

 

Not suprisingly it gave me a message. “No Repository found. Please go to Administrator and register the repository you are interested in.”

image 

 

I am guessing that, because I could not connect to my “dataserv” database created earlier, and I skipped the “Repository selection” setup, and consequent “Job Server” and “Metadata Integrator” setup, this is why I have no repository.

Repository

I double clicked the “Administrator” and was presented with the main console, from which I navigated to Repositories->Add

image 

 

but when I tried to add a Repository this way, I still could not. I was now getting an error about “dataserv.al_version”.

This appeared to be a common error when creating Repositories. I found an article stating that I needed to create the Repository with the “Data Services Repository Manager”

So, under the Windows Program Group “SAP BusinessObjects XI 3.2″->”SAP BusinessObjects Data Services”, I opened the “Data Services Repository Manager” program.

I entered appropriate values

image

 

and performed a “Test”

image

 

after successully recognizing my database, I chose “Create”, and the database Repository was underway

image

 

to finally check something happened, I opened up “MySQL Workbench” and took a look at the “dataserv” Schema, to reveal many tables

image

 

I then added the Repository to my “Data Services Managment Console”

I logged on with user “admin”, and navigated to “Repositories” and “Add”. I entered the appropriate values, and performed a test, which returned successfully

image

 

I then simply clicked the “Apply” button

image

 

finally my Repository was present

Job Server

I next, had to add and configure the Job Server, that was skipped during the installation. 

I began by running  the “Data Services Server Manager”

image

 

and “Edit Job Server Config”, to add a new Job Server

image

 

then I chose “Add”

image

 

I entered a “Job Server name”, and pressed the “Add” button

image

 

this opened up, the right hand side, for me to enter my “Database type” and “ODBC data source”, after the “Username” & “Password”, I pressed the “Apply” button

image

 

and my Repository was now associated. I pressed the “OK” button, to exit

image

 

and “OK”, again

image

 

I was curious what the “Restart” button, did, so I opened up my Windows Services to see the “BusinessObject Data Services” Service, I noted I had not started it

image

 

I pressed the “Restart” button

image

 

“OK” to the prompt

my main “SAP BusinessObjects Data Services Server Manager” screen disappeared, and my “BusinessObject Data Services” Service had started

image

 

so now, I can assume my “Job Server” is up and running, for my “dataserv” database

 

Metadata Integrator

I next, had to add and configure the Metadata Integerator, that, again, was skipped during the installation. 

I ran the “Data Services Metadator Integrator”

image

 

a short moment, and I was presented with the “Metadata Integrator Configuration” screen, along with a DOS box behind, for log output, etc …

image

 

I kept the default “Add Metadata Integrator”, and chose “Next >”. At the “SAP BusinessObjects Enterprise” screen, I gave it the necessary parameters, for the BObj Edge “administrator” user logon, as well as a “Configuration Name”. I left the “CMS Folder Name” as is, as it will create this for me.

image

 

I left the default, not to “Enable SSL” for the “Communications Protocol”

image

 

I entered the necessary parameters for access to my BObj Edge database. I found these via the Windows ODBC Config. See below

image

 

I continued to the next screen

image

 

only to receive an error

image

 

I thought about what I was configuring and navigated to the BObj Edge CCM, and started the “Server Intelligence Agent” Service

image

 

I tried again

image

 

and “Finish”

I logged on to the BObj Edge, and took a look to see, if indeed, the folder “Data Services” was created, and it certainly was

image

 

so that concludes the “Metadata Integrator” and “Data Services” configuration

Testing

To test my scenario, I am going to suck in some data from my NSP system, then use the Data Service(DS) Template mechanism to simply load it into a DS repository.

So to begin with, I ran the “Data Services Designer”

image

 

over the License key message and gave my user “sa” it’s password and checked “Remember”, to begin

image

 

I was presented with the start page

image

 

I chose to create a “Datastore” for my SOURCE, which will be my NSP Application System. So I selected the “Datastores” tab, at the bottom of the screen, right clicked and selected “New”

image

 

I entered the appropriate parameters, paying special attention to the “Datastore type”, and, under the “Advanced” button, the “Client number”

image

 

I then created my TARGET Datastore, which will contain the target data in this example. As I used the “Data Services Template” mechanism in my example, I needed my Target Datastore to be a simple “Database” type, so I could now use the “BusinessObjectsDS” Data Source, that I had created earlier.

image

 

I expanded my newly created Source Datastore “DS_NSP_001”, right clicked on “Tables” and selected the “Import By Name…”

image

 

I entered the table “SFLIGHT”

image

 

Next, I chose the “Data Flows” tab

image

 

I right clicked the “Data Flows” node, and selected “New”

image

 

I kept the default name, and double clicked it to open up the blank design area on the right hand side

image

 

I navigated back to my “Datastores”, and dragged my table “SFLIGHT”  from my Source Datastore “DS_NSP_001”, into the design area

image

 

On the right hand side of the design area, there is a “Template”, button,

image

 

which I pressed and dropped the object onto the design area, and I gave it a name “sflight”. I noticed the “In datastore” and “Owner name” were defaulted correctly. There were no other entries under the “In datastore” field.

image

 

I joined the two objects together

image

 

Now, I had to create a “Job”, so I chose the “Jobs” tab, right clicked on “Batch Jobs”, and “New”, leaving the default name

image

 

I then double clicked my “New_Job”, to open the Job design area

image

 

I navigated to my “Data Flows”, and dragged my previously created “New_DataFlow” object into the design area 

 image

 

I executed the Job

image

 

“Yes” to “Save all changes and execute” prompt

image

 

I was “OK” with the “Execution Properties”

image

 

5 seconds later, upon completion, the log looked good

image

 

I returned to my “Data Flow”, and pressed the small Spy Glass icons next to the objects, to view the data in both, Source table, and the Target template, and there it was, all 397 records in my Template.

image

 

This concluded my testing. If I were to actually use the data in the Template for anything, that becomes another story …

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Anthony Sutcliffe
    This is actually something that we want to make use of – previously have used BO to great effect.
    However, when I try to follow your breadcrumb, it doesn’t give access to the relevant download files (3.0, 3.1 but not 3.2) – and SAP support say that the files that you indicate are not available for general realease.
    (0) 
    1. glen spalding Post author
      hi tony, this can happen if you do not have certain privilages associated to your “s” user. however, i will stick my head out and say the steps documented here should be very similar if not the same.
      (0) 
    1. Puneet Singh
      Hello,

      I am also getting the same error. we have tried multiple solutions to this..But none of them works..It would be great if someone can provide us a solution to this.

      Thanks & Regards
      Puneet

      (0) 
    2. glen spalding Post author
      hello, it sounds like there is no ODBC connection to the database. I would advise check if you have the same setup as in this blog, if so, maybe post to SDN, where more users will see your issue. sorry i cannot help you further

      g

      (0) 

Leave a Reply