Wrike Datahub Database Setup

I have built an ERD (entity relationship diagram shown below) to help me define a relational database structure in MS Access. I would rather use Wrike Datahub, but need to build the business case to justify the expenditure. I am looking for other Wrike admins/users that are using Wrike Datahub that have suggestions on how to structure databases in a given space. Do you simply create the core tables as separate databases, or do you load all fields into the same database? Would this limit the way common fields can be referenced across entries?

I recognize I am not suggesting a best practice here, yet I hope the conversation that is generated will become the best practice. Thank you anyone and everyone that chooses to participate in this discussion!

Find more posts tagged with

Comments

Trevor Tollefsbol

Hi Wrike Community, I have an update. After working with our Wrike CSM, I've come to understand that multiple databases are necessary to prevent duplicate entries. The best aspect is that there are not nearly as many "tables" (aka databases) needed as there is in a relational DBMS. Here is my new list of databases/tables:

However, a new question has come up about the use of "Link multiple records" checkbox when adding fields to one DB that is linked from another DB. The best example I can give is the following scenario:

We have a database with a list of materials.
We have another database with a list of products.
Multiple materials can be assigned to a single product.

Where I need help is the following:

Can reports be generated that list all materials associated with a single product when the using the "Link multiple records" check box?
Is this reporting best done in a Dashboard, Report, or Table view in Wrike?
Is it better to create a junction database that has unique entries for every material associated with a single product?

You can see an example of a product below that has multiple materials assigned to a single product entry in the products database.

Mat Ward

Hi Trevor,

I suspect what you're hoping to do is beyond the capabilities of Wrike Databases.
From my understanding they're not much more than elaborate drop down lists from which you can select an item in order to retrieve additional data from the specific record for that item.

e.g. You could select a specific Material Type, and it could bring along any other fields in the record that contains that Material Type such as Category, Brand, etc.
This data goes into an item type - which you would then report on the same as if someone had entered the data manually.

There's no option for relations between databases, or the ability to run reports using information from a database.
In fact calling them Databases at all is a poor choice as it implies capability that simply isn't there - they really should be called Lists.

Elizaveta Bogdanova

Hi @Trevor Tollefsbol, would you like to discuss this with our Support team?

Also, I wanted to mention it's possible to like databases in Wrike, please find more info on it here.

Trevor Tollefsbol

Thanks, @Elizaveta Bogdanova! I'm sure you can see from what I posted above that I already have my databases linked. I've been working with my CSM and Wrike support together. Unfortunately the solution to my woes is not quite what I need. If I come up with a clever way to achieve what I'm after, I will post it here as an update. Thanks for your help, though!