cancel
Showing results for 
Search instead for 
Did you mean: 

XML - SQL data retrieving

Former Member
0 Kudos

Hi,

i want to get the data from SQL via XML file. is it posible? ie i want to connect to SQL database by using XML connector? please help me

- senthil

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi senthil,

You can connecct the database through sql connectors.

1. In data servers add your sql server settings.( Data services)

2. Using sql query in query templates get the data.

3. When you call this query template in BLS, it will give you the XML structure.

Regards,

Kishore

Former Member
0 Kudos

hi,

i already connected my SQL database. now i want to connect SQL via XML file. how can we connect it?

- senthil

Former Member
0 Kudos

Can u be a little more clear on what u want to do. As far as i understood u want to call a SQL query using XML Query . is that right???

Former Member
0 Kudos

HI,

s correct. i want to access SQL query useing XML query

Former Member
0 Kudos

Why?

Former Member
0 Kudos

Hi,

You can do with Xml Connector.

whenever the mode is set to "XMLQuery".then

In XmlQuery Tab

Give sourceurl is your query template of type sqlquery.

In Transform url :

All incoming XML documents that are not in SAP xMII format must be converted to this format using a stylesheet. The value of this property can be a link to an HTTP/Web server or to a file on disk. For example, a file URL would look like:

C:\MyXMLDocuments\CurrentOrders.XML

-Vijaya