Unable to Create Data Source in Studio

[Nick Peters]

When creating a data source in a scoped application within the Studio IDE, I'm receiving the following error:
"Import set table must be an extension of sys_import_set_row"

It's ultimately going to a JDBC integration, but for the sake of generating the error I just used the default values. The error appears regardless of the type. The Import set table name is the one that is generated automatically based on the label, including the "x_<company_prefix>_<scope_name>".

[Chander Bhusha1]

Hi Nick,

Can you check the import set table value. Whether its extending the sys_import_set_row table or not .

In order to use data source or  import set your import set table must extend sys_import_set_row  table.

so to apply transform it has to extend the sys_import_set_row  table

Mark helpful and correct if it helps.

Thanks,

CB

[Nick Peters]

Hi CB,

The import set table for this data source doesn't exist yet. Creating a data source and defining an import set table label and name will create it automatically. This works just fine in the Global scope (automatically extending sys_import_set_row), but I'm receiving this error only when creating data sources in the Studio IDE.

[Chander Bhusha1]

Ya I understand this and i tried in my PDI as well it working fine for me.

I was just telling to check the table which gets created after the creation of data source. If it has the extend  table  or not.

By default when data source is created it gets extended.