To connect to Cirium Sky Data Warehouse, Cirium will provide an address and port for the interface endpoint, as well as the user and password credentials for the users or functional accounts you need. We will also ask you for IP address ranges that should be given access, for the named users in your organisation.
Please refer to the full guide on connecting to Cirium Sky here (requires a signed in user with appropriate permissions to view the guide on connecting to Cirium Sky).
If you need additional user accounts for other members of your organisation, please contact our support team via the Cirium Help Desk or by sending an email to firstname.lastname@example.org.
Once you have this information, as Cirium Sky is built upon AWS Redshift you will need to select a Redshift driver and configure it with the provided information. Access to the data should then be seamless.
For more information on your specific tooling, please see:
Power BI: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-redshift
Connecting using common tools or directly from code: https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-via-client-tools.html
Beekeeper Studio Open Source Database Client: https://www.beekeeperstudio.io/get
Article is closed for comments.