on 05-15-2007 8:04 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.