Sikka Software Corporation
800-94-SIKKA
info@sikka.ai

Verifying data Path of the Practice Management Systems

Dental Vision


Version: See the title bar



Data Path: Control Panel >> Administrative Tools>>Data Sources >> System DSN - Tab

Dentrix


Version: To check the Dentrix login to Dentrix. On the main screen of Dentrix select the “Help” tab and point to “About Dentrix” as shown below.



The screen displaying Dentrix version will come up as shown below.



Data Path: Click Start > Programs >Dentrix> Office Manager on client’s computer whichyou access through Team Viewer (TV).



Dentrix will then ask for its User ID and Password. There you have to enter the user id and password of the Dentrix system. For the specific customer you will get Dentrix user id and password in REMOTE ACCESS section of our SikkaCrm . Enter user id and password and click OK. Then you will see a screen with name Dentrix Office Manager. On the Menu bar click Maintenance >Practice Setup > Preferences.



Now you will be able to see the PREFERENCES screen. On the Preferences screen you will see a tab with name PATHS.



Click the PATHS tab. On this screen you will be able to see the correct database PATH of Dentrix.



Dentrix Ascend


1. Practice Management System: Select “Dentrix Ascend” as shown in the above screen.
2. Version: Select version as “Web”. If the client belongs to Zentist then we will have to select Web 2.0 and for the client’s needing huge data will have select Web 3.0.
3. Host: Confirm the Host URL from the client. It may vary from client to client.
4. Organization: Also get the Organization name from the client.






5. PMS Login Credentials: PMS User Name and PMS Password we will have to gain from the client.
6. Once all this information is configured we can try performing refresh.

Dentrix Enterprise


Version: Select the Dentrix as a Practice Management System. Select the Enterprise as a Version. For the Data Path of Dentrix Enterprise PMS, click the button that shown in below screenshot it will opens the window to select the server of Dentrix Enterprise PMS.



Data Path: Click on the Drop Down option shown in below screenshot to select the Dentrix Enterprise PMS database server name.



Select one appropriate server name from the list.



Set the working PMS User Login details who has admin level PMS access or PMS Database access in the PMS User Name and PMS Password textbox.
Also, set the PMS database username and PMS database password in the PMS database user and PMS database password textbox who has admin rights but it is optional.


Click on the Apply button to Save all the settings as I shown in below screenshot.


Practice Works


Version: To check Practice works version you just have to open the Practice works software. On the login screen itself the version is displayed.



Data Path: Click Start > Programs > Practice Works > Utilities.



You will see a screen with name Practice Works Utilities.



On the above screen you have to select tab with name DICTIONARY LOCATION. Then you will be able to see a small window with name WHERE DICTIONARY POINTS TO. On this page you will be able to view the data path.   




Practice Web


Version: To check Practice web version you have to open the Practice web software. Click on Help menu and then click on About.



The below pop-up window will come which will show the version



Data Path: Right click on the Practice web icon as shown below.



Click on open file location



It will open the path location where Practice web is installed. Just copy that full path. It will be the data path for Practice web.  




SoftDent


Version: To check Softdent version you just have to open the Softdent software. On the login screen itself the version is displayed as shown in the following screen.
 


Data Path: Go to help >> and select about.And check data base directory.



Suzy Dental

Data Path: Right Click on PMS icon and click on open file location



Find data folder and open it.



Select this path and set it in SPC like F://11SuzyDental4/data



Note: If data path location is on network computer. Then select full data path from particular machine rather than from mapping drive.

If parser shows all connection failed then we need to install Fox pro driver. Refer document: Suzy Dental FoxPro OLEDB Driver Installation Guide

Easy Dental


Version: To check Easy Dental version login to Easy Dental. Then click on Help button icon and select “About Documents” as shown in the following screen.



When you click te “About Document” button the window displaying version will come up as shown below.



Data Path: Go into the Easy Dental program and into the "Reports" module. Click on the 'Maintenance' icon (the hammer) and go to 'Preferences'. Click on the 'Paths' tab and look at the "Database Path".




Eclipse


PMS:



Data Path and PMS Version: Login to Eclipse PMS and go to help >> About As per the below PMS Screenshot set PMS version and data path in the SPU. Enter pms username and password in SPU.







Endovision


Version: To verify the data path for Cleardent PMS right click on


Data Path: Control Panel >> Administrative Tools>>Data Sources >> System DSN – Tab
In the following screen we can see two DSN names. One is “dv” for 64-bit and the other is “DV” for 32-bit. We must consider the name that is for 32-bit.



Then configure the details in the SPC as shown below.




Genesis


Version: While try to open PMS you will get version details below


Data Path: Right click on Genesis.exe open file location



After this find for DATA folder that is your data path




Gold


Open Gold Dental Management PMS

Version: Open Help menu and see the About Gold



Here is the Gold Dental Management System version – 12.2.1



Data Path: For the data path, we need to communicate with David (david@gold-dent.com) the CEO of Gold, after that he will create the SikkaSoftware folder in C drive (C:\SikkaSoftware) on the Client machine and he will also provide files Transactions.json(year wise), Patients.json, Appointments.json, and ClinicData.json, etc. Once David extracts the data and places the encrypted files in the C:\SikkaSoftware folder, then we can set C:\SikkaSoftware as a data path in Sikka Platform Utility (SPU) and start SPU refresh.




HVMS


Version: While try to open PMS you will get version details below


Data Path: Go to SPC >> Setting >> Data path







IdentalSoft


PMS: IdentalSoft is a Web base.



Data Path:
1. Practice Management System: Select “Identalsoft”as shown in the below screen.
2. Version: Select version as "Web".
3. Host: Configure the PMS URL in the host field.
4. Customer Id: We can configure it from PMS .
5. PMS Login Credentials: PMS User Name and PMS Password we will have to gain from the client.





Mogo

Version: If the PMS icon has ‘Azure’, the PMS database is cloud. The PMS version is shown on the icon itself. Kindly refer to the screenshot below.


In this case, need to set ‘V23Cloud’ in SPU. For the cloud version datapath is managed in the ETL so anything that can be added to the data path only needs to set the correct PMS version.

For rest of the versions

Version: To get both “Data Path” as well as “Version” do the following steps.
>> Help >> About Mogo



When you click te “About Document” button the window displaying version will come up as shown below.

Data Path: You will get both versions as well as data path under “About Mogo” window as shown in the above screen.


AbelDent


Version: To get the AbelDent version login to AbleDent. Then on the Help tab click “About AbelDent” tab.



The AbelDent version will be displayed as shown below.



Data Path: For 9 version
To get the path for Abeldent open Abeldent software. Then in the file menu select “System Status”. Then System status window will popup where you will get the location of “working directory”. Data folder will be present in this directory.



For PMS Version 10 to 14(MSSQL):
Go to SPC >> Settings >> Data Path and Click on the data path button.
Select SQL Server Instance and click on the apply button.




OpenDental


Version: Login to OpenDental. On the main screen select the Help option and click “Update” tab as shown in the following screen.



When you click the Update tab window showing version will come up as shown in the following screen.



Data Path: For OpenDental we have to select the folder that contains the file “FreeDentalConfig.xml”. This path is mostly “C:/Program Files/Open Dental”.




Opes


PMS:



Data Path: For data path, go to SPU.
Click on the data path button as shown in the screenshot below.
Select SQL instance from drop down list and “TSI” as a database name.
Add PMS username and password in username and password field respectively and click the OK button.





WinDent SQL


Version: When you will double click the Windent SQL icon login screen will come up which will show the version as shown below.



Data Path: 1. Login into WinDentSQL 2. Go to Utility menu>> Set Preferences. This will show System Properties window



3. From the bottompanel click on button “Drive and Path settings”
4. As shown in followingscreen shot you can locate WinDent data path.




Winoms


Version: To get the Winoms version login to Winoms. Then on the help tab and click "About"



The Winoms version will be displayed as shown below.



Data Path:
For data path, go to SPU.
Click on the data path button as shown in the screenshot below.



Select “mdcs” database instance and click on the OK button.





DSN

Data Path and Version: Go to Help >> About Dental-Exec.

If Data Path is on network server as shown in following screenshot (\\server1\dentexec) then need to add "\data" at the end of existing data path. So for following screenshot the data path will be "\\server1\dentexec\data"
Note: Database location is on local machine OR server the data path should upto "data" folder locations,which contains database files.



PMS: If there is a new version, we get the PMS logo as below.



Data Path: To find the path and version information you can go to help >> about as specified in below screenshot.



In the Database section, there is path and version as specified in below screenshot. Set Name as data path and Version as version.



Set the above path in the SPU. Also set the PMS user details as specified in the below screenshot.



ImproMed Infinity


Version: Go to Help >> About



Data Path: Open ImproMed Infinity by clicking on short cut. It will show server selection window as shown below:




Intravet


PMS:



Version: To get the version login to Intravet PMS. Then click on the help tab and click on "About".



Data Path:
For data path, go to SPU.
Click on the data path button as shown in the screenshot below.
Select SQL instance from drop down list and database name as "intravet" and click the OK button.






AVIMark


Data Path and Version: Login to AVIMark and go to Help >>About





Cornerstone


Version: Log into Cornerstone. Go to Help >> About



Data Path: For data path, go to SPU.



Click on data path button. Select Cornerstone and click on OK button.




DVMAX


PMS:


Version: To get the version login to Dvmax PMS. Then click on the help tab and click on "About".



Data Path:
For data path, go to SPU. Click on the data path button as shown in the screenshot below.
Select the data source and click the OK button.







OMS Vision


Version: Log into OMS Vision Go to Help >> About



Data Path: For data path, go to SPU.



Click on data path button. Select dv and click on OK button.




PerioVision


Version: Log into PerioVision>> Go To Help >> About



Data Path: For data path, go to SPU.



Click on data path button. Select dv and click on OK button.





Power Practice Pro


Data Path and Version: Go To Help >> About






DentiMax


Data Path and Version: SPU version in used = DentiMax major version (11 in this case) + SP version (1.41). So the version is 11.1.41.



For data path, consult with Practice.



Dolphin Management


Version: For version go to Help >> About



Data Path: For Data Path right click on PMS icon and open file location



Open Dolphin.ini file.



Go to SPU. Click on data path button and select SQL Server Instance matching to the highlighted server instance in Dolphin.ini file and click on apply button.




Orthotrac


Version: For version go to Help >> About



For data path go to SPU. Click on data path button.



Select SQL Server Instance and click on apply button.

 


Curve Hero


Data Path and Version: It is cloud based software. Select version as Web. Enter Curve Hero URL provided by practice into data path. PMS User Name and Password are mandatory.




Cleardent


Data Path: To verify the data path for Cleardent PMS right click on Cleardent icon and open the file location.

At this location open the file with name Cleardent.exe.config.


3) Once we open this file, we have to review the tag with name Cleardent.SQLConnection whose value of “data source” attribute is the data path and value of “initial catalog” attribute is the database that we have to set in SPC as shown below. If there are multi practices you will find entries one below the other as shown here in the screen.



Note: In any condition do not save any change or update this file named “Cleardent.exe.config”.




XLDent


Version: For version and SQL Instance go to About.




SQL Server username and password is mandatory and should be entered as PMS User Name and PMS Password respectively.




EagleSoft


Version: For Version go to Help >> About



For data path go to SPU. Click on data path button.



Select Dental data source as shown above.



Ortho 2


Version: For Version go to Help >> About



Follow above mentioned sequence 1,2 and 3 as shown below:



For database name, click on dropdown list and select database.



Database name should be from System info as shown above.



Advantage


Version: For Version go to Home Screen



Follow above mentioned sequence 1,2 and 3 as shown below:





Dentech


Version: For Version go to Home Screen

On Title bar you can see company file details. In the Following screen it shows that Version is 9.2 and Company is “1”



Then go to Application folder. Navigate to DTWIN folder as shown in following screen:



Locate and go into DAT Folder. Go into company folder which is “C01” in this case as title bar showed C1. This is data path.



Dentitek


PMS:


Version: Click on the PMS logo, On the main screen PMS version will come up as shown below.



Data Path:
Click on the data path button as shown in the screenshot below and type DSN in the provided text box.
Add Database username and password in username and password field respectively and click OK button.





ClientTrax


PMS: ClientTax PMS as shown in the desktop screen and open the ClienTrax PMS


Version: To check the ClienTrax version login to ClienTrax PMS. Then click on the Help button icon and select “About ClienTrax” then you will see the screen below. Use this as the PMS version in SPU.



We can find Database DSN in: Control Panel >> Administrative Tools>>ODBC Data source(32-bit)
When you click on ‘ODBC Data source(32-bit)’, the following window will display. Then select ‘System DSN’, and here you can find the DSN name that is created. We can use this DSN name to configure as datapath in SPU.



Then configure the details in the SPU as shown below.




DoxPedo


Version: To check the version of DOX login to DOX. On the main screen of DOX click on “Help” tab and select “About ” as shown below.



When you click “About” button the window displaying version will pop up as shown below.



Data Path:TTo check Data Path login to DOX and follow the path,

1) START >> Right Click on DOX>>Properties >> Open File Location>>DOX.ini



2) After that click on a “Open File Location” from the pop up window



3) Select and open “DOX.Ini” configration file.



4) Screen will pop up with a data path of PMS.




Domtrak


Version: Most probably data base folder for Domtrak is “C:\VB6DDesigns”. If this folder is not found on C drive then we will have to search for this folder in other drives on the PC. Second condition is that, we have to open this folder and check if the following 3 mentioned access datbases are present at this location. These three databases are
1)Domtrak.mdb
2)Schedule.mdb
3)tempdb.mdb

Note: Please note extension for the above mentioned databases might be .accdb rather than mdb depending on Microsoft Access database version.

Once we get the location for this folder we have to set this location’s path in SPU as database path. A screenshot is provided below for reference.



LiveDDM


Version: When you double click the LiveDDM icon in order to open the PMS, it shows the version on the initial screen as shown below.


Data Path: Data path is the instance name of the SQL Server for this PMS. In order to view it, click on User >> Terminal Settings as shown below.


Now the following screen will come up. Server name shown here is the data path and also after selecting the data path you will need to select the database name as shown in the screen below.



PBS-Endo


Version: For Version go to Help >> About



Data Path: Locate “PBS Endo” icon on desktop. See below screenshot


Right click on “PBS ENDO” icon and click on “Open File Location”. It will show this screen


Copy this location path and enter it into SPC


Onces data path entered click on Apply and perfrom Refresh.


Tracker


Version: You will get the PMS version on the home screen of the PMS as shown in the following screen.




To verify data path right click on the Tracker icon and select “Open File Location” as shown below.


At this location there is a file with name Settings.Config.



Open this file with Notepad. Then it will look as shown below. Select the ServerName tag as data path. Once you select the data path then select the database name.



At this location there is a file with name Settings.Config.

Data Path: Data path section of SPC for the above file will look as shown below.




TDO


Version: We get the version on the login screen as shown below.


On this screen we get the PMS version as shown below.

Data Path: TDO Configuration for API Link & API Key in SPU:
Set the following API Link in SPU (Which is Static always)
API Link: - https://tdoclouddataapi.azurewebsites.net/
Set API Key provided by TDO: - (Change for every client and it provided by TDO)




Ortho2Edge


PMS: Ortho2Edge PMS as shown in the desktop screen and open the Ortho2Edge PMS.




Data Path: Data path shown below > Data Center.


Insert valid PMS username and PMS password. After that, SPC will automatically detect ortho2Edge configuration information from the service. Data center and database name are detected from this. No need to add manually.

Data Path: Data path section of SPC for the above file will look as shown below.




Oryx


Data Path and Version: It is a cloud-based PMS. Select version as Web. Enter the Oryx URL provided by practice into the data path. PMS User Name and Password are mandatory. These details will be provided by the clinic/practice.





Progident


PMS: Progident PMS as shown in the desktop screen and open the Progident PMS.



PMS version: Double click on PMS icon.Login window will open. PMS version is shown in the screenshot below:



Data Path: Right click on PMS icon and go to the file location. Select data folder in that. This is the Data Path.



Select PMS name as Progident and version from the list. After inserting all the details, apply settings and then save.




Paradigm


PMS: Paradigm PMS as shown in the desktop screen and open the Paradigm PMS.



Look for paradigm desktop logo. Right click on the paradigm desktop logo and look for Target. PMS version is shown in the screenshot below:



Data Path: Here the server name is "SVR-01" Open Windows Explorer --> Network --> SVR-01 There you will find a shared folder "Sic". In this shared network folder you will find Access DB.



Set up to SIC folder path as a data path in SPU and PMS Version as V8


QSI Dental


PMS: For PMS login of QSI dental WEB, you can use the following URL:
https://app.qsidentalweb.com/
Mandatory fields needed to be configured in SPC for QSI PMS name, PMS User name, password, and version.
SPC will look like the following screenshot upon the configuration of the details.



StringSoft


PMS: StringSoft PMS as shown in the desktop screen and open the StringSoft PMS.



PMS version: Double click on PMS icon. Login window will open with PMS details. As shown below:



Data Path: Right click on PMS icon and go to the file location. This is the Data Path.



Select PMS name as StringSoft and version from the list. Add PMS file location as the data path. After inserting all the details, apply settings and then save.




VIA


PMS: Click on the icon, as shown in the screenshot, and open the VIA PMS.



Version: To check the VIA version, log in to VIA PMS. Then click on the Help button icon and select "About VIA". You will see the screen below. Use this as the PMS version in SPU.



Data Path:
To add a data path we need to follow below steps:
We have to select the Data path, as shown below, Click on the Icon mentioned in the below image, then select the SQL server Instance.



Then configure the details in the SPU as shown below, and also set the VIA user Details, in that set the User Name as PMS User Name and Password as PMS Password.





Autopia


PMS: Autopia PMS as shown in the desktop screen and open the Autopia PMS.



PMS version: Click on Help option for view PMS version.

Data Path: On machine directory found Dental folder in that found DWW_svr.ini File. Open in notepad. In DWW_svr.ini file has data path.



Data Path



Select PMS name as Autopia and version set as given in PMS help section. Need to set data path manually. Select directory folders as per given path in DWW_svr.ini file. Apply settings and then save.



PlanetDDS


PMS: Planet DDS is Web base.

PMS Login URL Link: https://www.planetdds.com/denticon-login



PMS version: Select PMS name as Planetdds and version set as Web.

Data Path: This PMS has daily basis database file downloading and next day scheduling functionality. Downloaded DB files are placed in DATA folder. Data folder has practice wise separate folders. Datapath for data folder-> Right click on SPU icon and click on open file location. In that folder present DATA folder and Set this path as Datapath in SPU.



Select PMS name as Planetdds and version set as Web. Need to set data path manually. Select directory folders as per given path in above screenshot (up to DATA folder). PMS login details are mandatory. Set PMS login details as PMS user name and PMS password in SPU. Apply settings and then save.



PlanetDDS web 2.0
Step1 : Login to PMS and goto below option:
Click on setup option->goto offices option-> click on vendor API settings

Step2: Vendor API setting will open and search Sikka vendor or vendor associated with sikka. After that click the Generate Email template option as shown in below screenshot.


Step 3: As per below screenshot set the PGID, Client key as Authentication key, OID. Here 2 offices assigned offices for Sikka then oid field values separated by comma. Ex: oid = 208, 214


SPU Configuration:
Using above PMS setting set SPU configuration. SPU looks like the below screenshot.
1) Offices id list set as OID
2) Client key set as a Auth Key
3) PGID set as a PGID


ChiroTouch


PMS: ChiroTouch PMS as shown in the desktop screen and open the ChiroTouch PMS.



PMS version:Front page of PMS.



It will show you following screen (Path like “C:\Program Files\PSChiro”. Please note path may be different but the folder should be “PSChiro”). Find a Config /XML file called chirotouch. (File Name may look like “chirotouch” or “chirotouch.config” or “chirotouch.xml”) Open file with notepad as shown below.

Note: If you not found installation path, then please try to find in other drives also.



Data Path:Now find DataSouce in opened notepad as shown below. In this case you can see “Server1” is the source for database.



Copy this DataSource value and Paste it into SPC Data Path Input box and select “PSChiro” Database Name and Save changes. See below Screen.





Lytech


Data Path: For data path, go to SPC.



Click on data path button. Select SQL Server Instance and click on apply button.





MacPractice


Version: About MacPractice


Data Path: Showing Data path and version. See below screenshot


Copy this data path, version and enter it into SPC


Maxident


Version: For the PMS version Login to the PMS > Help > About Maxident.


On this screen we get the PMS version as shown below.


Data Path: Data path for Maxident is the instance name of SQL server as shown in the following image.



Therefore in order to get the data path we have to select the browse button of “Data Path” in SPC.


Select SQL server box will come up from where we must select the SQL server instance. If we are not sure about the instance name select the one that contains the name “Maxident”. As per the following image the option number one.


Then from the database dropdown select the database with name “Maxidata”. Data path and database name will look like shown below.



Medisoft


Version: For the PMS version Login to the PMS > Help > About Medisoft.


On this screen we get the PMS version as shown below.


Data Path: For setting data path of Medisoft we need to find the Medidata folder. This folder should contains files with type .adt and .adi files as shown in the following screen.



After selecting the data path select the database with name “Medisoft”. It will look as shown in the following screen.



Officemate


PMS: Officemate PMS as shown in the desktop screen and open the Officemate PMS.



PMS version:Double click on PMS icon.Login window will open.Enter PMS credentials and click ok.Locations will be displayed below then select the location.As shown below:



PMS version will be available on the top of the PMS.



Data Path: Help Menu >> About Administration and click on see the below screen



Add this data source info in the SPC. See below Screen.





AllScripts


Allscripts API services are currently available from 7:00 a.m. to 7:00 p.m. Eastern Time, Monday through Friday. So data refresh time must depend on this.
Before installing the SPC, confirm from the project manager about whether the client is activated by the Allscripts and we have following details:
Ubiquity URL , Ubiquity id, Client ID and Tenant ID

After installing Sikka Platform Utility,
PMS Data Path: https://ubiquityunity.azurewebsites.net/UnityService.svc/unityservice
Select PMS name as Allscripts.
Select PMS version as Web.
To get the Database name, PMS Database username and Password, follow below steps.
Login to the Allscripts portal https://developer.allscripts.com/Account/Login







Get the Database name, PMS Database username and Password from here.

Database name: It is Allscripts Sikka Application name.SPC will not detect it. Add it manually. PMS Database User name and Password: Sikka’s application credentials

Generate SPC PMS database user shown as below:
PMS Database User = Ubiquityid:Clientid^Tenantid^PMSUserName
Example: AB123:PQ456^1^xyz25abc


Sikka Password will expire after 6 months. Need to generate and collect it from the Allscripts developer portal. By the SPC command, we can update it for all the customers

Scheduling section: As this is a web version parser, for some customers depends on data, refresh may take more than 3 hours. Because of this, by default, parser will set data refresh wait time up to 7 hours ( 420 minutes ) after the data refresh starts.

Apply settings and then save.

© 2021 Sikka Software Corporation, The Practice Optimizer Company®. All Rights Reserved.