CartoDB Writer Parameters
This parameter must contain the name of the destination CartoDB account. The account name is the same as the username that is used to log into the account on the CartoDB website.
Note: For CartoDB Multiuser Enterprise accounts, note that this is not the same as the organization name.
CartoDB accounts are protected by API keys, which can be found in Your API keys in the CartoDB web interface. By default, the API key parameter is left blank.
- If the API key is left blank, FME can read public tables associated with the CartoDB account.
- If the API key is specified, FME can read both public and private tables associated with the CartoDB account.
When using CartoDB Multiuser Enterprise, multiple users can be associated with one account.
If you are Multiuser Account user, enter your username here. FME will access the associated CartoDB Multiuser Account.
Note: To create tables in a Multiuser Account, you must select this parameter and supply a valid username.
Advanced
This parameter specifies the number of features to be placed in each transaction before a transaction is committed to the database.
If not specified, the default value is 500.
CartoDB has a SQL API, which allows FME to read and write data to CartoDB tables. This API is normally located at https://[account_name].cartodb.com/api/v2/sql.
However, if you are running your own instance of the open source CartoDB software, this API location may be different. If you are not running your own instance of CartoDB, leave this parameter blank.
- If the API URL is left blank, then FME will use the default API URL to access your CartoDB account.
- If the API URL is specified, then FME will use a URL in the form of:
https://[account_name].[API_URL_value]