Unable to import the relation from database into frame work manager

[karthik12345]

Hi all,
   In Framework Manger while importing data from database i am unable to import the relations from the data base(data base is OLTP).
   i checked Use Primary Key and Foreign key relations.
   Please advise how to import the default relations from database.

Thanks,
Karthee

[MFGF]

Hi all,
   In Framework Manger while importing data from database i am unable to import the relations from the data base(data base is OLTP).
   i checked Use Primary Key and Foreign key relations.
   Please advise how to import the default relations from database.

Thanks,
Karthee

Hi,

What database are you using? How are you connecting to it? Do the tables you are importing have primary/foreign keys defined?

MF.

[karthik12345]

Hi,
   Data base is MS SQL Server,
   I Created DSN connection for connect the data source 
   tables which are in the data base are defined Primary and foreign relation.
 
Thanks,
Karthee

[MFGF]

Hi,
   Data base is MS SQL Server,
   I Created DSN connection for connect the data source 
   tables which are in the data base are defined Primary and foreign relation.
 
Thanks,
Karthee

Hi,

What do you mean by "DSN connection"? Are you connecting via ODBC, via the SQL Server native client or via JDBC? If you are using ODBC, I'd suspect the ODBC driver isn't intelligent enough to surface the key definitions. Try either Native Client or JDBC...

Cheers!

MF.

[karthik12345]

Thanks MFGF,
 
    Yes, i am using ODBC driver, actually when i imported sample IBM data source(go sales) , i can see the relation here, but when i imported 
   some other OLTP data source i couldn't find the relations.

Thanks,
Karthee

[MFGF]

Thanks MFGF,
 
    Yes, i am using ODBC driver, actually when i imported sample IBM data source(go sales) , i can see the relation here, but when i imported 
   some other OLTP data source i couldn't find the relations.

Thanks,
Karthee

Are the keys defined in the same way in both data sources? How are you connecting to the sample go sales data source? ODBC or via native client?

MF.

[karthik12345]

thanks MFGF,
   
   I used ODBC to connect sample Go sales data source, i followed same procedure for both data sources.
 

Regards,
Karthee

[MFGF]

thanks MFGF,
   
   I used ODBC to connect sample Go sales data source, i followed same procedure for both data sources.
 

Regards,
Karthee

Ok. Are the keys defined in the same way in your database as in the sample gosales database?

MF.

[Ricardo Julio "Ricky" Villa]

If you are connecting to an OLTP and not a Datawarehouse (with a cuddly star schema structure) I would not recommend importing the relationships.  You will need to do some metadata modelling in FM otherwise you are likely to end up with unnecessary, not desirable or ambiguous joins...