Connection between Powerplay and SQL

[alfmx]

Hi, can someone tell me how I get data from SQL Server 7.0 to construct cubes in Powerplay?
Thank you

 

[Kaiaualad]

I would build an Impromptu catalogue to access the SQL Server tables,create some Impromptu reports and save them as .iqd then import them into the transformer model.

Otherwise you can use DTS to extract flat files or Export SQL server data into Excel and use Flat files or Excel as transformer Data sources

 

[CanadianTechie]

I would recommend you create a Database Definition in Impromptu for SQL, and then build a catalog using that database, which as already indicated, you can create a Imp. report over that catalog for the desired data and save it as an IQD for use in PowerPlay. When you are defining the database connection in Impromptu, some suggested definition paramaters are:

Provider: sqloledb
Data Source: Server name or ip address of sql box
Provider String: Inital Catalog = xxDBNamexx;User ID = xxuserxx;Password = xxpasswordxx;

You can also uncheck the user box if you want to use the user id/password encoded within the connection string specified....also something I recommend if it fits your security profile -- in my environment, all report consumers that need to hit the db go through a gateway/interface user id specified in the connection string. No need to have the users re-key a user id password, and no need for them to even have a user id or password that get's them access to the database...



Pedro Cardoso
A.K.A CanadianTechie