Send Schema Editor Extension for Oracle Adapter

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

Information Online

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

Send Schema Editor Extension for Oracle Adapter

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> Send Schema Editor Extension for Oracle Adapter

Page: [1]

Message

<< Older Topic Newer Topic >>

Send Schema Editor Extension for Oracle Adapter - 5 January 2007

shamir.ali

Posts: 17
Score: 0
Joined: 28 December 2006
Status: offline

Hello All,

Refering to a text in one of the PDF's named: 'BizTalk Utilities Adapter for Databases Overview.pdf' below in pic, wanted to know where can i find this feature of changing the tables, connection string and dataprovider.

Thanks,

Attachment (1)

Post #: 1

RE: Send Schema Editor Extension for Oracle Adapter - 6 January 2007

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

This is actually done inside Visual Studio when editing the schema.

Is yours not appearing there?

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to shamir.ali)

Post #: 2

RE: Send Schema Editor Extension for Oracle Adapter - 7 January 2007

shamir.ali

Posts: 17
Score: 0
Joined: 28 December 2006
Status: offline

Could you please tell me where exactly could i find it !!!
I have checked all the properties for the <schema> node including that "Schema Editor Extension", It just opens up a new window with 3 extensions including :
1.BizTalk Utilities Adapter for Databases Transmit Schema Editor Extension
2.Flat File
3.Hws

On selecting 1st one it doesn't do any thing, i need to get that wizard going again which i went through when i first added a new adapter into the project through "Add Generated Items"

Thanks,

(in reply to Pieter)

Post #: 3

RE: Send Schema Editor Extension for Oracle Adapter - 8 January 2007

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

Once you select the BizTalk Utilities Adapter for Databases Transmit Schema Editor Extension, and you look at the properties for the root schema and request/response element there will be more properties with which you can edit the DB Schema.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to shamir.ali)

Post #: 4

RE: Send Schema Editor Extension for Oracle Adapter - 8 January 2007

shamir.ali

Posts: 17
Score: 0
Joined: 28 December 2006
Status: offline

thanks Pieter for a quick reply,

well as you said i can infact see a few properties that helps me in changing the connection string and provider as well, but my concern was to change the table, i mean what if i need to add a table to that newly generated schema.

Thanks.

(in reply to Pieter)

Post #: 5

RE: Send Schema Editor Extension for Oracle Adapter - 8 January 2007

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

This is unfortuantely a limirtation in the Adapter Framework and not the Adapter itself.

When you add a table you would have to edit the schema by hand or regenerate the schema.

I would recommend that you regenerate the schema.

As long as the Namespace and Root Nodes are correct your maps will be preserved.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to shamir.ali)

Post #: 6