I was wondering if there's a way to create additional connectors using Python?
We are able to create custom code Python scripts that can for example retrieve data from an API. This works great, but using the custom code approach has some problems:
1. Errors with the arguments passed to the script only appear when the cube is being build, instead of when adding the table to the cube.
2. There's no preview of the data being returned by the Python script.
3. We can pass passwords through as arguments, but the passwords are then visible to other users.
4. Only one table can be returned, instead of all the possible tables for a base endpoint.
Of course we can use the Generic JDBC connector and the CData REST connector as well, however it would be nice to create connectors for the specific APIs we want to connect to, so that all the required input fields needed to set up the connection can be defined and seen right away, without having to put together a connection string for which the user has to download the CData driver. (Like we did in the attached image)
Is there a way of creating a connector with Python? Or is it only possible by creating a JDBC driver?
