Page Comparison

...

• The list of tables/views: https://api.beta.dataself.com/dw6/entities/abccorp/extract?source=dw&token=xx

• A table/view from the erp schema: https://api.beta.dataself.com/dw6/entities/abccorp/extract?source=dw&token=xx&schema=erp&object=ITMMVT

• A table/view from the dbo schema: https://api.beta.dataself.com/dw6/entities/abccorp/extract?source=dw&token=xx&object=ITMMVT

• Some columns from a table/view: https://api.beta.dataself.com/dw6/entities/abccorp/extract?source=dw&token=xx&object=ITMMVT&fields=AVC_0,ITMREF_0,ROWID

• A filtered table/view: https://api.beta.dataself.com/dw6/entities/abccorp/extract?source=dw&token=xx&object=ITMMVT&filters[ITMref_0]=Fin063

Output options

• CSV download: use the endpoint on an incognito web browser’s tab

• Excel: go to the Data ribbon → From Web → paste the endpoint:

  • Click Ok.

  • Set the Delimiter to Comma.

  • If the table has undergone structural changes since the last extraction on this Excel install (cache), click the Refresh icon.

  • Click Load.

  • If you see errors on the Queries & Connections panel

    after the data load:

    , mouse over the errors section and click on it to open the Power Query Editor. Scan through the shown tables for “Error”, click on them to get a description on the bottom panel. The most common fix to these errors is by going to the main query in Power Query → select Changed Type on the right panel → edit the Table.TransformColumnType expression (drop down at the top of the table), for instance, a column set to Inte64.Type must be changed to type text.

Security

• ETL+ User: The ETL+ API user token ties users to their ETL+ entities and data warehouses.

• IP Whitelisting: This feature only works behind DataSelf VPN or via IP whitelisting on dw6. In the future, the plan is to use Azure Entra to secure the extraction without IP Whitelisting.

• SSL enabled.

...

• Extract the list of views: https://api.beta.dataself.com/dw6/entities/abccorp/extract?token=xx&source=tableau-view

• To extract a view: https://api.beta.dataself.com/dw6/entities/abccorp/extract?token=xx&source=tableau-view&view=viewid

Output options

• CSV download: use the endpoint on an incognito web browser’s tab

• Excel: go to the Data ribbon → From Web → paste the endpoint:

  • Click Ok.

  • Set the Delimiter to Comma.

  • If the table has undergone structural changes since the last extraction on this Excel install (cache), click the Refresh icon.

  • Click Load.

  • If you see errors on the Queries & Connections panel

    after the data load:

    , mouse over the errors section and click on it to open the Power Query Editor. Scan through the shown tables for “Error”, click on them to get a description on the bottom panel. The most common fix to these errors is by going to the main query in Power Query → select Changed Type on the right panel → edit the Table.TransformColumnType expression (drop down at the top of the table), for instance, a column set to Inte64.Type must be changed to type text.

  • You might need to pivot/unpivot the table to view it like the Tableau view.

...