Anaplan Connect SQL - Cannot Connect to Database

jonathan.edwards
jonathan.edwards
in Integrations and extensibility

We receive the below error when trying to connect to the SQL database.

Anaplan API: Could not connect to database! (SQL server: Login failed for user)

However, our test odbc connection on the server connects successfully, so the credentials are valid.

What do we need to do to resolve this and connect successfully?

Below is our .bat file.

@echo off

set AnaplanUser="ANPLANUSERNAME:ANAPLANPASSWORD"
set WorkspaceId="ID"
set ModelId="ID"
set ServiceUrl="https://ca1a.api.anaplan.com"
set AuthUrl="https://ca1a.auth.anaplan.com"
set FileName="Anaplan_Test.csv"
set FilePath="C:\Automation\Anaplan_Test.csv"
set ProcessName="Import SQL SAGE GLAFS"
set jdbcProperties="C:\Automation\Anaplan-Connect\jdbc-query.properties"
set DumpName="C:\Automation"
set Chunksize=1

set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -chunksize %Chunksize% -file %FileName% -jdbcproperties %jdbcProperties% -put %FilePath% -process %ProcessName% -execute -output %DumpName%

rem *** End of settings - Do not edit below this line ***

setlocal enableextensions enabledelayedexpansion || exit /b 1
cd %~dp0
if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser%
set Command=.\AnaplanClient.bat %Credentials% %Operation%
@echo %Command%
cmd /c %Command%
pause

Below is our jdbc properties file.


jdbc.connect.url=jdbc:sqlserver://SERVERNAME:PORTNUMBER;database=DATABASENAME;encrypt=true;trustServerCertificate=true;

jdbc.username=USERNAME
jdbc.password=PASSWORD

jdbc.fetch.size=2500

jdbc.isStoredProcedure=false

jdbc.query=SELECT GLAFS.ACCTID, GLAFS.FSCSYR, GLAFS.FSCSDSG, GLAFS.FSCSCURN, GLAFS.CURNTYPE, GLAFS.AUDTDATE, GLAFS.AUDTTIME, GLAFS.AUDTUSER, GLAFS.AUDTORG, GLAFS.SWRVL, GLAFS.CODERVL, GLAFS.SCURNDEC, GLAFS.OPENBAL, GLAFS.NETPERD1, GLAFS.NETPERD2, GLAFS.NETPERD3, GLAFS.NETPERD4, GLAFS.NETPERD5, GLAFS.NETPERD6, GLAFS.NETPERD7, GLAFS.NETPERD8, GLAFS.NETPERD9, GLAFS.NETPERD10, GLAFS.NETPERD11, GLAFS.NETPERD12, GLAFS.NETPERD13, GLAFS.NETPERD14, GLAFS.NETPERD15, GLAFS.ACTIVITYSW, GLAMF.ACCTID, GLAMF.ACCTDESC, GLAMF.ACCTTYPE, GLAMF.ACSEGVAL01, GLAMF.ACSEGVAL02, GLAMF.ACSEGVAL03, GLAMF.ACSEGVAL04 FROM ALOPGP.dbo.GLAFS GLAFS, ALOPGP.dbo.GLAMF GLAMF WHERE GLAFS.ACCTID = GLAMF.ACCTID AND ((GLAFS.FSCSYR>'2016') AND LAFS.ACTIVITYSW<>0))

Thank you!

Tagged:

Answers

Categories