Create datasource from scratch

[msaguin]

Hi,

It's not an issue but more a question :).
I would like to create a datasource from scratch using python TSC, with only the following information:

• table name of the database
• server name
• host
• username
• password

Do you have any idea?

I would like to avoid the creation of a tds/tdsx file first. Then I have not issue to publish.

new_datasource = TSC.DatasourceItem(project_id,name=datasource_name)
server.datasources.publish(new_datasource, file_path, 'CreateNew',connection_credentials=None)

Thank you,

Mathilde

[erathinam]

Hi,
i do not think there is a way to create a data source with connection information programmatically atleast using the python library as of now from my experience. You can update an existing datasource connection provided that datasource was published with connection at first. Which means your first publish should be either using tableau desktop or downloading tdsx/tds file from tableau desktop and using TSC publish method.

[yzukerman]

You can use the Tableau Server REST API to create/append/overwrite/delete data sources.

[sagarjhaa]

Did not find a way to create datasource through REST API, it only points to Publish, update metadata, delete, or refresh the extract of a data source of a site

[jacalata]

TSC is a client written for the REST API.

I don't think this is possible right now, but I'm not certain.

[jacalata]

This isn't currently supported in any way, but it is an interesting idea. I'm not sure this would be the place we would implement it.