Forum Discussion

MCORTI3's avatar
MCORTI3
New Member
3 years ago
Solved

Combine Restricted Database with Additional data sources

Hi everyone. I am currently working on a database that has been given to me with some restrictions (i.e., I can only see the fields to build my visual but I don't have the access to that database). I...
  • v-zhangti's avatar
    3 years ago

    Hi, MCORTI3 

     

    It sounds like you may need to perform a data integration process to combine the restricted and non-restricted datasets. One way to do this is to export the restricted dataset to a file format that can be read by other software tools, such as a CSV or Excel file. Then, you can use a data integration tool or programming language, such as Python or R, to combine the exported dataset with the non-restricted dataset.

     

    Another option is to use a cloud-based data integration platform, such as Talend or Informatica, which can connect to both datasets and perform the integration process.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.