MII 12.0 Data Source

[Former Member]

Hi,

After login in Netweaver Administrator going to System Managament->configuration->Application Resources

click on All Resources. I got the following details

ResourceName ResourceType OwnerName OwnerType

SAPMIDDB JDBCdataSource JDBC service

SAP/BC_UME " SAPMIDDB Datasourc

XMIIDatasource " Applicatio

I tried using in data server type Datasource as XMIIDATASOURCE its throwing exception.Can i configure any of the above mentioned data sources with MII 12.0 to write my customizes tables .Can we use the netweaver database instead of configuring external oracle or sql server with MII 12.0

Thanks & Regards

Namita

[Former Member · Accepted solution]

Hi.

Which DB are you using for NW? I am using MaxDB, and it will require installation of a driver, please look at this one.

And please remenber that this DB is installed with a special collation settings which might cause you problems.

Br

Poul.

[Former Member · Accepted solution]

Hi Poul

We are using SQL 2005 for N/W

Thanks

Namita

[Former Member · Accepted solution]

Hi.

You need to get and upload this file "sqljdbc.jar", done via System Management -> JDBC drivers. Then you need to create a data connection which looks like the following

Connector IDBC

ConnectorID

ConnectorType SQL

DatePrefix '

DateSuffix '

DaysRetention 7

Description MSSQL Database

Enabled T

InitCommand

InternalDateFormat yyyy-MM-dd HH:mm:ss

JDBCDriver com.microsoft.sqlserver.jdbc.SQLServerDriver

MaxRetryCount 5

Name PS_ProdDB

PoolMax 100

PoolSize 1

RetryInterval 60000

ServerPackage com.sap.xmii.Illuminator.connectors.IDBC

ServerURL jdbc:sqlserver://localhost:1433;database=ProdDB

Timeout 2

UseCount 256

UserName xMII

ValidationQuery SELECT GETDATE()

WaitTime 30

BR

Poul.

[agentry_src]

Namita,

You can use the NetWeaver database to save your data. But you do not need to configure a connector to do so.

There are a couple action blocks that you can use depending upon the data and format you are using. The ones that I have used successfuly are XML_Saver, Image_Saver, and File_Saver. The Path you define should be of the format:

db://<projectname>/WEB/<folder>/<filename.xml>

This will place the file in the NewWeaver database. You will see it displayed on the Web folder in the MII workbench and can open it up or otherwise manipulate it there.

Hope this helps,

Mike

[Former Member]

Hi Michael

I wanted to use this N/W database to create my customized tables

instead of configuring new SQL or Oracle database in MII I wanted to use already existing N/W database.

I was asking how to hit this database from Query templates

Thanks

Namita