Transitioning to a new data source​

One of the data sources that I use in my data models is from Netsuite ERP. To access the data I am using SQL Server Integration Services with an ODBC driver going through the SuiteAnalytics Connect service. Netsuite has deprecated the current data source that I am using - Netsuite.com. I am in the process of transitioning everything to the newer analytics data source named NetSuite2.com. Some tables have been pretty straight forward but with different column names. One of the instances where it became more complex is with the General Ledger tables which require joining 3 or more tables whereas in the older data source it may have only required 2 tables. The table that I thought would have been straight forward but ended up requiring some investigation was the Accounting Period table.

A feature that I love about docusaurus is that it uses Prism for syntax highlighting. With Prism, there is support for almost every language you can name. There is support for Power Query (M) and DAX thanks to Peter Budai. My current code samples are mainly in Javascript but I will be writing samples in DAX and Power Query so this is an important feature. Here is how I configured Docusaurus to support the additional languages and how to change themes.

Using environment variables allows us to to store configuration values outside of the source files. During the build, the reference to the environment variable will be replaced with the values specified. The configuration data is the part of the project that can vary between test and production. Storing the configuration values in one place it makes it easy to update the values outside of the source code. As dotenv points out this is based on The Twelve-Factor methodology of storing configuration data separate from the code. I will show how I added environment variables to Docusaurus.

Static site generators like Hugo and Docusaurus have different levels of support for comment systems. The current version of Docusaurus does not have a built-in commenting system. With Hugo, it depends on whether the theme you are using has added support for additional commenting systems. It could have Disqus, Giscus, or Utterances to name a few. With any of the static site generators, you can customize and add your favorite comment system to it. This involves adding some code and specifying in the front matter that you want comments enabled. Here is how I added comments to Docusaurus for my blog.