Import Data into PowerDesigner

[#1]

Hello,

We have received a  proposal to upload four excel sheet data into power designer. I suggested the client to go with BCP instead of powerdesigner as it will used for modelling not for bulk load. My question is is it possible to load the data into PowerDesigner? In Import excel sheet, I can see we can generate the model from the excel sheet table name & column name. But "No Data" can be uploaded into power designer. Right? Please provide your suggestions on this proposal.

As part of Bulk Load, Data quality check, ID generation, ID existance check, Partial data load, archival and all is there. How it is possible to achieve this in PowerDesigner?

[Former Member]

Hi,

You say you received a  proposal to upload four excel sheet data into power designer.

As example, you can upload into PowerDesigner "List of values", min, max, default values associated to columns, domains, informations as it will used for modelling from Excel sheet, Time to time LOV must be updated. As part of "Data Load", you can load also Data Quality check, specific security informations for Governance, etc.

PowerDesigner is the wrong tool if you want load, as example, all rows about customer, product tables, etc.. As say George it all depends on why you were asked to load it?

[Former Member]

yes..i told the same..but looking to go with VB script to do all these validation, DB connectivity, quality check..again I said to go with bulk copy, staging tables, stored procedures for validations, actual table.

LOV?

[Former Member]

VB script to read the excel sheet data and load it in Sybase ASA.

is it feasible approach? Records will be in thousands...

[ChrisBaker]

Looks to me that you are looking for an ETL tool such as SAP Data Services instead, based on your description above.

PD is the wrong tool here.

ASA/SQL Anywhere has some import facilities.  You may want to post your question at:

http://scn.sap.com/community/sql-anywhere

Chris

[Former Member]

LOV = List of Values

[Former Member]

As I say before.

No you can't use PowerDesigner to load thousand records.