Follow

Convert From API to ODBC

Getting Started

  • Go to https://client.demandcaster.com and login
  • Click the "Enter" link next to the desired/assigned PLEX company
  • Navigate to the "Data"-> "Data Hub" -> "Connectors"
  • Verify the company has the needed connectors.
    • Plex API Connector
    • Plex FTP Connector
    • Plex ODBC Connector
  • Navigate to "ETL" -> "Extractions"
    • NOTE: It is possible that some extractions are already converted.
  • For each of the "Plex API Connector" extractions you see you will need to create a similar "Plex ODBC Connector" extraction along with transformations as we need to test and make sure the same amount of data comes in.

Start Working

  • It's best to start with a screen shot or a list of the extractions you will need to work on
  • Just like any integration create the extraction but with "Plex ODBC Connector" as the connector and include "ODBC" within the Extraction name
    • NOTE: Some ODBC extractions are not ready yet (missing extraction type)
    • Currently: Locations, ItemTagsMultilocation
  • When you are done with the extractions it should look similar to below, again currently missing Locations and ItemTagsMultiLocation
  • Navigate to "ETL" -> "Transformations"
  • Do the same with Transformations
  • Navigate to "ETL" -> "Data Management"
  • Click on the "Add New" button and create a new profile
    • Name: API Comparison Test
    • Description: API to ODBC Comparison Test
    • Data Load: NOT CHECKED
    • Transformation: Add all API Connector items (You may need to refer to your list)
    • Leave all options to the right alone and click on the "Save" button
  • After you click the "Save" button start the run
  • Click on the "Add New" button and create a new profile
    • Name: ODBC Comparison Test
    • Description: API to ODBC Comparison Test
    • Data Load: NOT CHECKED
    • Transformation: Add all API Connector items (You may need to refer to your list)
    • Leave all options to the right alone and click on the "Save" button
  • After you click the "Save" button start the run
  • After both extractions are done make sure you record the start and stop date/time
  • Download the total (zip) extraction for each into the same folder
    • Name the API extract: API_extractions.zip
    • Name the ODBC extraction: ODBC_extractions.zip
  • Extract the zip files keeping them in their named directorys (API_extractions, ODBC_extractions)
  • Either open the files and look at the row count or run this script below in PowerShell ISE
    • When you run the script it will ask for the folder path (this is why it's important that each zip is in it's own directory)
  • When you are done you should have something like below, as you will see in this live customer example there is still some testing that the developers will need to look into.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments