Portal Engine Questions on portal engine and web parts.
Version 7.x > Portal Engine > SQL Datasource - external database - creating the transformation View modes: 
User avatar
Member
Member
neil-myfitfund - 8/2/2013 4:52:16 PM
   
SQL Datasource - external database - creating the transformation
Web.config has two connection strings, one for kentico cms, one for customer data.

create page in kentico - use sql datasource, use windows authentication, point query to customer data database.

next create a repeater that connects via the webpartid to the sql datasource.

question: how do i select a transformation when they are only assigned to document types within kentico (the kentico cms database).

I think I'm missing something.

User avatar
Kentico Legend
Kentico Legend
Brenden Kehren - 8/2/2013 5:56:31 PM
   
RE:SQL Datasource - external database - creating the transformation
You would create a custom document type that would simply be a place holder for your transformations. Do this in the CMSSiteManager by creating a new document type and selecting "The document type is only a container without custom fields".

Your transformations in that new document type will need to have the field names in them based on the data source utilizing the transformation. For instance if your one data source has 3 columns (FirstName, LastName, UserName) you use those in one transformation. If your second data source has 4 columns (EventID, EventName, EventLocation, EventDate) you can use those in another transformation but they would both reside in that custom document type you created. You'd then assign the transformation code name to the repeater and you should have your data displayed!