Data Share gives your company a read-only copy of its Assignar data that you can load into Microsoft Excel and refresh. To connect Data Share to Excel, you install a database driver on a Windows computer, enter the connection details Assignar gives you, and then load the tables you want into a spreadsheet. Anyone with Data Share login details from Assignar can do this.
Data Share is set up by Assignar, not from a page on the Assignar dashboard. There is no Data Share menu on the dashboard.
Before you start
Your company needs Data Share set up by Assignar. If you don't have connection details, see What data and relationships are in Data Share? for how to ask for it.
You need a server address, a user name and a password from the Assignar Data Team. The database name is always assignar.
Connecting Data Share to Excel works only on Windows computers.
Your login gives you access to particular data feeds (tables). If a table you need is missing, ask Assignar to give you access to that feed.
Step 1: Set up the ODBC connection for Data Share on Windows
To connect Data Share to Excel, you first set up an ODBC connection on your Windows computer. ODBC is the standard Windows way for programs like Excel to read from a database.
Download and install the Amazon Redshift ODBC driver (64-bit). The Assignar Data Team can send you the download link.
In the Windows search box, type ODBC and open ODBC Data Sources (64-bit).
Click Add.
Pick Amazon Redshift ODBC Driver (x64) and click Finish.
Fill in the connection details:
Data Source Name: a name you'll recognise later in Excel, for example "Assignar Data Share".
Server: the server address from the Assignar Data Team.
Database: assignar.
User: the user name from the Assignar Data Team.
Password: the password from the Assignar Data Team.
Click Test. A success message means Windows can reach Data Share.
Click OK to save the connection.
Step 2: Load Data Share tables into Excel
To load Data Share data into Excel once the ODBC connection is set up:
In Excel, go to Data > Get Data > From Other Sources > From ODBC.
Pick the data source name you created in Step 1.
If Excel asks for credentials, enter the user name and password from the Assignar Data Team, then click Connect.
Excel lists the Data Share tables your login can see, such as allocations, timesheets and forms. Select a table. To load more than one, tick Select multiple items first.
Choose how to load the data:
Click Load to bring in every row. Some tables, such as timesheets, can be very large.
Click Transform Data to filter the rows or remove columns before loading.
The data appears in your spreadsheet as an Excel table.
Refresh Data Share data in Excel
To get the latest Data Share data in Excel, go to the Data tab and click Refresh.
To refresh on a schedule, click the query, open Properties and set the refresh interval. Assignar asks that you don't refresh Data Share more often than once every hour.
Why can't I connect Data Share to Excel?
These are the common reasons a Data Share connection to Excel fails.
The ODBC test fails. Check the server address, user name and password exactly as the Assignar Data Team sent them, and that the database is assignar. If your company network blocks outside database connections, ask your IT team to allow the Data Share server.
You can't find ODBC Data Sources. You are not on Windows, or you opened the 32-bit tool. Use ODBC Data Sources (64-bit) on a Windows computer.
A table you need isn't listed. Your login only shows the feeds you have been given access to. Ask Assignar for access to that feed.
The load is very slow or Excel stops responding. You are loading a whole large table. Use Transform Data to filter it, for example to recent dates, before loading.
Related articles
Getting started with Insights
